IBM Mainframe Forum

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

Hello,

Suggest you create a member in some pds for each SYSIN. The member name could be a symbolic variable to be resolved at execution.

You can't dynamically replace values in embedded data via jcl.