Does anyone know what the maximum number of items there can be in a list
for the IN predicate.  I have a maintenance script that extracts
information from one dB, builds a list for the IN predicate, connects to
a different dB, and runs a query based on the list generated.  In one
instance the list that was built had ~450 items in the list, which
crashed the server.

Is it a matter of the size of the list in characters and not items in
the list?  The whole list, including the quotes around the items in the
list, commas, etc. was ~5k characters.

Thanks

Dennis

---------------------------------------------------------------------------

Thu, 18 Feb 1999 09:25:24 -0500
Dennis Roesler <Dennis_Roesler@am.exch.hp.com>
list limit for IN predicate?