I have unload control card which has where condition as TABLE_ID = 271.
I want to pass 271 from JCL as it may vary for different job.
How can I pass a value as a parameter so that the load control card can be used for different tables.
WHERE TABLE_ID = &Var
The Var value I will pass in JCL in control card
Edited: Please use BBcode when You post some code, that's rather readable...Anuj
Joined: 22 Apr 2006 Posts: 6258 Location: Mumbai, India
The way question is been posted so far - Expat has suggested the practical soultion which is in use across shops. If you have some other point of view as well for your problem you need to tell us - may be some one will come up with a approach suitable to you.
You are trying to change the table name every time a different JOB inokes the "contorl Card" - so query itself, anyways, is changed. Let the differnt JOBs pick a differrnt member itself - what's the deal then ?