LENGTH OF SQL STATEMENT.

Hi, I have a unique problem with one of my customer. He has some badly written application which is capable of working on Informix, Oracle and SQL Server. His application produces one SQL statement of 56 wordpad pages(A4). One SQL statement with 56 pages. This SQL statement refuses to run on Informix. It gives -460 error. Statement too long. This application runs fine with Oracle. Customer is under threat to change the engine to Oracle. 1. What is the limit on SQL statement in Informix ? 2. Can the above problem be resolved or some work around other than optimising the SQL statement. This statement is like Select cust_name from customer where cust_num in ( big big list ) This "big big list" is of 56 pages. IDS 7.X Regards Vikas _________________________________________________________ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com

>1. What is the limit on SQL statement in Informix ? ODBC in general and CLI in particuar have a limit of 32k. Informix has a higher limit as SQL Editor handles 50k Create Procedure statements with no problem. Not sure about the higher limit. Bashar Chalabi CTL, London