When using DSNTIAUL utility in JCL can we pass a host variable to the unload sql like below
// SET var1= 'ABCD'
//unload pgm=dsntiaul ..
//sysrec00 DD .....
//sysin dd *
Select col1,col2 from table1 where col2=:var1
I have a requirement to execute a single proc from number of jcls that contains statement similar to above except the variable . From each jcl i want to send a different value in var1