what is the upper limit for the predicate WHERE IN () db2?

database db2 db2-connect
user3492304 picture user3492304 · Sep 1, 2014 · Viewed 11.7k times · Source

what is the upper limit for predicate WHERE IN in DB2.

For example:

select salary from employee where empid in (1,2,3,4...N)

Answer

nclark picture nclark · Jul 8, 2016

The AS/400 limit is around 1000, based on errors we get when we exceed that. We're splitting up into multiple smaller queries to patch our legacy JEE app.

Related questions

Difference between CLOB and BLOB from DB2 and Oracle Perspective?

I have been pretty much fascinated by these two data types. According to Oracle Docs, they are presented as follows : BLOB : Variable-length binary large object string that can be up to 2GB (2,147,483,647) long. Primarily intended to hold non-traditional data, such …

Read More
How to update multiple columns in single update statement in DB2

I want to update multiple columns of a table in DB2 with single Update statement. Any hint or idea will be appreciable. Thanks.

Read More
Calculating how many days are between two dates in DB2?

I need to get the difference in days between two dates in DB2. I tried a couple of different queries but nothing seems to be working. So basically what i need to get is something like this. SELECT DAYS (CURRENT …

Read More