> With a select that contain a IN statement, I get the following error
> message :
>
> Dynamic SQL Error
> SQL error code = -901
> Implementation limit exceeded
> too many values (more than 1500) in member list to match
>
> In fact my IN statement contain more than 1500 values.

Well, so you must minimize you IN statement result using a WHERE clause. If
it already exists, then you may create a stored procedure with a "FOR
SELECT" and test it into the FOR...
or better, you may compare if the COUNT of your statement is > the 0...

like this:

SELECT * FROM TABLE1
WHERE
(select count(*) from table2) > 0