在论坛上经常看到有坛友问pf能容纳多少个字段，最大长度是多少啊？之类的问题。。现在我稍微总结了一下(os/400版本4.5)
Number of bytes in a record 32,766 bytes
译：记录长度最大32766个字节；
Number of fields in a record format 8,000 fields
译：一个记录中最大能容纳8000个字段；
Number of key fields in a file 120 fields
译：一个pf中最多能容纳120个关键字；
Size of key for physical and logical files 2000 characters1
译：pf和相关联LF关键字的长度不能超过2000个字符；
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
以上的总结有错误的请大家给予指正。。
阅读(1109) | 评论(0) | 转发(0) |
