MVSFORUMS.com

mfnerd · Beginner Joined: 06 Jan 2003 Posts: 8 Topics: 6

Hi,
I'm trying to use a dynamic list in a 'IN' clause.

The only possibility i see is creating a TEMP table with all the values and use them in the IN clause.

Can't use Dynamic SQL.

Any tips appreciated !
_________________
Thanks,
Mfnerd.

dbzTHEdinosauer · Posted: Wed Jan 10, 2007 5:38 pm Post subject:

might want to look at this link:

http://www.mvsforums.com/helpboards/viewtopic.php?t=7721

if the object of your IN clause is x type or date/time setting up working-storage 'table' is no problem, each entry length can easily be established. If you are dealing with numerics, that will be more fun because the size of each entry is determined by DB2.
_________________
Dick Brenholtz
American living in Varel, Germany