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 ?
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..
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