Limitation of "IN" operator in DB2 ..........??

[jatin.popat]

How many expressions does IN operatore supports in DB2.

I am facing an issue when selecting all the values in 'value prompt' with multiple select ..

I have heard abt the same issue in Oracle - IN operator supports 1000 or 5000 ( not sure ).

So is there any such limitation in DB2 also ?

[blom0344]

There must be a limit, but why not make it optional. Bypassing it will act as if the filter does not exist, which is the same as selecting ALL data..

[bloggerman]

There is a limit. But, its not a good practice to select such a large number of values. Try using select and search prompt instead of value prompt