Page 1 of 1

dsntiaul query

PostPosted: Wed Sep 16, 2009 8:22 pm
by MAINFRAMETESTER
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

Re: dsntiaul query

PostPosted: Fri Sep 18, 2009 11:49 pm
by dick scherrer
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.