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 32 768 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 1 869 162 846 624 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 3686 files Number of physical file members in a logical file member 32 members Number of members that can be joined 256 members Size of a character or DBCS field 32 766 bytes4 Size of a zoned decimal or packed decimal field 63 digits Maximum number of distinct database files that can be in use at one time ~500 000 Maximum number of members in a physical or logical file 32 767 Maximum number of constraints per physical file 300 constraints Maximum number of triggers per physical file 300 triggers Maximum number of recursive insert and update trigger calls 200
Number of bytes in a record 32 766 bytes
ReplyDeleteNumber 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 32 768 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 1 869 162 846 624 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 3686 files
Number of physical file members in a logical file member 32 members
Number of members that can be joined 256 members
Size of a character or DBCS field 32 766 bytes4
Size of a zoned decimal or packed decimal field 63 digits
Maximum number of distinct database files that can be in use at one time ~500 000
Maximum number of members in a physical or logical file 32 767
Maximum number of constraints per physical file 300 constraints
Maximum number of triggers per physical file 300 triggers
Maximum number of recursive insert and update trigger calls 200