dsntiaul query

IBM's flagship relational database management system

dsntiaul query

Postby MAINFRAMETESTER » Wed Sep 16, 2009 8:22 pm

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
Posts: 2
Joined: Wed Sep 16, 2009 7:52 pm
Has thanked: 0 time
Been thanked: 0 time

Re: dsntiaul query

Postby dick scherrer » Fri Sep 18, 2009 11:49 pm


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.
Hope this helps,
User avatar
dick scherrer
Global moderator
Posts: 6268
Joined: Sat Jun 09, 2007 8:58 am
Has thanked: 3 times
Been thanked: 93 times

Return to DB2


  • Related topics
    Last post