IDS 7.30 Limits on IN condition within SQL Select statement

We are running IDS 7.30.UC7-1 on an AIX platform. Connection to the Informix database is made through ICONNECT 2.01 from Windows NT workstations using the Intersolv DataDirect 2.01 driver. Our Business Objects users say that Informix is limiting them to a maximum of 100 values in a list following an "IN" condition. For example: SELECT .... FROM ... WHERE column_1 IN (<list of values>); Is there such a limit on the IN condition? If so, can it be overridden? Or is there a limit on the size a SELECT statement? I suspect that performance will degrade with such a large list, but I have no been able to find any mention of a limit within Informix documentation. Your assistance in clarifying this issue would be appreciated. Thanks, Rick Rick Bernstein Principal Database Administrator Alaris Medical Systems rbernste@alarismed.com

Hallo Rick, as documented in the machine specific notes there are "statement size limits". This might be the problem. Klaus Nonne nsi001@aol.com