ibmi-brunch-learn

Announcement

Collapse
No announcement yet.

Regd -logical files

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

  • Regd -logical files

    Dear All,



    Let me know maximum how many logical files can be created under one physical file?


    thanks in advance
    ramesh.

  • #2
    Re: Regd -logical files

    from v4r5 manual
    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
    here is a link to v5r1
    Attached Files
    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: Regd -logical files

      Hi, just curious. How many logical files do you currently have? How many records in the file?

      Thanks.
      Hunting down the future ms. Ex DeadManWalks. *certain restrictions apply

      Comment

      Working...
      X