请教，infomrix7.31对于每个表的字段数量有限制吗？

ddfdk

如果有限制，数量是多少！

IFMXDBA

you can find it in the release notes.  you can find it in $INFORMIDIR/release/en_us/0333/ids_unix_relnotes_9.40.txt.  it supports up to 32K columns in a table.

wenlq

Because the maximum row size is 32,767 bytes, no more than approximately 195 columns in the table can be of the data types BYTE, TEXT, ROW, LVARCHAR, NVARCHAR, VARCHAR, and varying-length UDTs. (The upper limit on columns of these data types also depends on other data describing the table that the database server stores in the same partition.) No more than approximately 97 columns can be of COLLECTION data types (SET, LIST, and MULTISET).
建太大的表应该考虑分割。