Have a look at the Appendix on 'SQL Limits' in SQL Reference ...

Your statement heap may need to be increased ...

I would suggest considering alternatives to passing this many values to the
IN Clause ...

Cheers
Sathyaram
http://www.db2click.com <http://www.db2click.com>
<http://www.idug.org/forums/UserForumHome.asp>
http://www.idug.org/forums/UserForumHome.asp

-----Original Message-----
From: amit kamath / Kotak / Securities
[Email address protected]
Sent: Thu 20/05/2004 06:05
To: LazyDBA Discussion
Cc:
Subject: Select query



Hi Experts,

I have a query which is like select * from table_name where col_name in
('','','','',)
I want to know how many values can be passed to this query, I mean in the in

clause.
My program may pass around 5000 values but I want to know the max values.

Thanks in advance,
Amit.


---------------------------------------------------------------------
PLEASE CLICK REPLY-ALL TO SEND A REPLY TO EVERYONE
website: http://www.LazyDBA.com <http://www.LazyDBA.com>
To unsubscribe, e-mail: [Email address protected]
For additional commands, e-mail: [Email address protected]


**********************************************************************
This email and any files transmitted with it are confidential and are
intended solely for the use of the individual or entity to whom they are
addressed. This communication represents the originator's personal views and
opinions, which do not necessarily reflect those of HPI Limited. If you are
not the original recipient or the person responsible for delivering the
email to the intended recipient, be advised that you have received this
email in error, and that any use, dissemination, forwarding, printing, or
copying of this email is strictly prohibited. If you received this email in
error, please immediately notify [Email address protected]

This message has been scanned by Panda Anti-Virus. Recipients are advised to
apply their own virus checks to this message on delivery.
**********************************************************************



DB2 & UDB email list listserv db2-l LazyDBA home page