ibmi-brunch-learn

Announcement

Collapse
No announcement yet.

Maximum number of fields in a physical file

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • Maximum number of fields in a physical file

    What is the maximum number of fields allowed in a physical file? I know the max record length is 32,766 - does that mean I could effectively have 32,766 fields of length 1 char in the file? Or is there a limit on that also?

    (Before anyone asks - no I dont want to create a file with 32,766 1 character fields )

  • #2
    Re: Maximum number of fields in a physical file

    some IBM redbbok V4R5

    Number of bytes in a record 32,766 bytes
    Number of fields in a record format 8,000 fields
    Number of key fields in a file 120 fields
    Size of key for physical and logical files 2000 characters1
    Size of key for ORDER BY (SQL) and KEYFLD (OPNQRYF) 10,000 bytes
    Number of records contained in a file member 4,294,967,294 records2
    Number of bytes in a file member 266,757,734,400 bytes3
    Number of bytes in an access path 1,099,511,627,776 bytes3 5
    Number of keyed logical files built over a physical file member 3,686 files
    Number of physical file members in a logical file member 32 members
    Number of members that can be joined 32 members
    Size of a character or DBCS field 32,766 bytes4
    Size of a zoned decimal or packed decimal field 31 digits
    Maximum number of constraints per physical file 300 constraints
    Maximum number of triggers per physical file 6 triggers
    Maximum number of recursive insert and update trigger calls 200
    All my answers were extracted from the "Big Dummy's Guide to the As400"
    and I take no responsibility for any of them.

    www.code400.com

    Comment


    • #3
      Re: Maximum number of fields in a physical file

      Thanks Jamie!

      Do you ever sleep btw?

      Comment


      • #4
        Re: Maximum number of fields in a physical file

        On occasion .....when im not awake
        All my answers were extracted from the "Big Dummy's Guide to the As400"
        and I take no responsibility for any of them.

        www.code400.com

        Comment


        • #5
          Re: Maximum number of fields in a physical file

          V5R3:

          The maximum number of fields in a record format is 8000. If any of the fields in the record format are date, time, timestamp, variable length, or allows the null value, then the actual maximum number of fields can be less than 8000. The maximum number of fields can vary depending on the number of fields and combinations of fields that occur within the record format. The maximum number of bytes in a record format is 32 766 if variable length fields are not included and 32 740 if variable length fields are included.

          Comment

          Working...
          X