Re: LENGTH OF SQL STATEMENT.

From: Vikas kapare <vkapare@yahoo.com> > >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. Having a badly-written application is by no means unique. :-( >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 ? I'm guessing that it's 32K. But that's just a guess. >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 ) How is the big big list generated? What is the application written in? ______________________________________________________ Get Your Private, Free Email at http://www.hotmail.com