RE: LENGTH OF SQL STATEMENT.

Two suggestions come to mind that you might try before monkeying around with stacks, environmental variables or other things that have been suggested. First, run the SQL code through an editor(sed, awk, etc. on Unix) and strip leading and trailing padded blanks, tabs and extraneous characters(nulls?, <CR>?, <LF>?). Second try compiling the code using a 4GL compiler or make it a SPL routine instead of running it interpreted. Paul Storm -----Original Message----- > From: Vikas kapare [mailto:vkapare@yahoo.com] > Sent: Tuesday, June 01, 1999 6:03 AM > To: informix-list@iiug.org > Subject: 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