Page 1 of 1

Difference in REGION values

PostPosted: Sun Dec 16, 2012 1:10 am
by ceekayrocks
Can some one help me or suggest me a way to pass a variable to a query dynamically (i.e) to the where clause of the query. The query is in a parm member (i.e) a PDS member. This should be thrugh JCL step so that the input file can be modified via FTP to change the query with differnt values in the where. Also i need to do this for many members . All members have different queries where the WHERE clause needs to be modified from the input file as mentioned above. Pls suggest a way so that the JOB does not need many steps .