在论坛上经常看到有坛友问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
以上的总结有错误的请大家给予指正。。
阅读(1155) | 评论(0) | 转发(0) |