RE: LENGTH OF SQL STATEMENT.

Hi, I am thankful to all who have quickly replyed to my mail "LENGTH OF SQL STATEMENT". Your information will be very useful for me during my meeting today. Dear Rekaish Bhardwaj, You seem to be a very busy man. I had said > > I have a unique problem with one of my customer. It means my customer has a problem. It is not me who has written SQL. I am to give best service to customer in wiser way than saying "YOUR SQL IS 56 PAGES AND IT IS STUPID" If i do not care for my customer and get him out from his mistakes someone else will care for him and he will opt for Oracle. If we want life of our customer to be smooth than Oracle will not be a best option. Isn't it ? Sorry for talking non-technical. Regards Vikas --- Rekaish Bhardwaj <RekaishB@compans.com> wrote: > What the hell are you doing writing an SQL that is > 56 pages long !! > I know this is not much help but surely even if you > got the thing working, > the performance will be crap, > whether it is an ORACLE, INFORMIX or any other > RDBMS. > > Anyway the error refers to 32000 characters not 'x' > number of lines > If you are preparing/declaring a cursor are you sure > that you haven't > got variables defined as something stupid like > CHAR(100000). > If you have, then are you CLIPPING them as you build > up the string ? > > If this isn't the problem then go with ORACLE and > good luck to you. > > > > -----Original Message----- > > From: Vikas kapare [SMTP:vkapare@yahoo.com] > > Sent: Tuesday, June 01, 1999 1:03 PM > > 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 > _________________________________________________________ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com