IBM Mainframe Forum

My requirement is Every time I need to pass different value to my sysin card of JCL

Example --
Below is the Query I am passing thru SYSIN CARD( I am executing this query thru DB2BATCH )
Select ,LEDGER_DESCRIPTION
,DEBIT
,CREDIT
FROM T14DBC.BAGG1600

In above example ...
I need to query different tables through JCL. I have four JCLs. Query remains same but only table name gets changes.

Is there any option to pass dynamic value (symbolic variable to SYSIN card of JCL) to avoid multiple control cards?

If you have the very latest version of z/OS then the answer is yes - symbols in in-stream data do get resolved. Otherwise you need to have a program read a parameter defined by a symbolic and generate your query in a previous step.

Thanks Nic for the reply.
I do have the latest Zos but How do I need to pass the parameter to my SQLs.
Below is my JCL to UNLOAD the data.

//STEP01 EXEC DSNPGM,
// VER='TEST',
// SYSTEM='TD0T',
// PRM='SQL',
// PROGRAM='DSNTIAUL'
//SYSIN DD DSN=ABCD.UTTTTTT.CTLCARDS(CABC101A),DISP=SHR
//SYSREC00 DD DSN=ABCD.UNLOAD.DATA,DISP=SHR
//SYSPUNCH DD DUMMY

below is the SQLs I am passing through SYSIN

Select LEDGER_DESCRIPTION
,DEBIT
,CREDIT
FROM T14DBC.BAGG1600

I want to parameter the table name in the SQLs.
Appreciate your reply on the same.

in your SYSIN as per your post


and

NicC wrote:If you have the very latest version of z/OS then the answer is yes - symbols in in-stream data do get resolved. Otherwise you need to have a program read a parameter defined by a symbolic and generate your query in a previous step.

I'm using z/OS 01.13.00 so I guess that's not the latest. I tried and JCL did't like symbolic variables in my SYSIN.

Hi Nic,

Even my JCL too did not support it!!
I have tried the below code,

// SET TAB=1600
//STEP01 EXEC DSNPGM,
// VER='TEST',
// SYSTEM='TD0T',
// PRM='SQL',
// PROGRAM='DSNTIAUL'
//SYSIN DD *
SELECT * FROM T14DBC.BAGG&TAB;
//SYSREC00 DD DSN=ABCD.TEST.SDH,DISP=SHR
//SYSPUNCH DD DUMMY
//*

I have got the below error ,
DSNT502I ERROR IN DSNTIAUL SQL INPUT:
DSNT408I SQLCODE = -104, ERROR: ILLEGAL SYMBOL "&". SOME SYMBOLS THAT MIGHT BE LEGAL ARE: . <IDENTIFIER> JOIN INNER
LEFT RIGHT FULL CROSS , HAVING GROUP
DSNT418I SQLSTATE = 42601 SQLSTATE RETURN CODE
DSNT415I SQLERRP = DSNHPARS SQL PROCEDURE DETECTING ERROR
DSNT416I SQLERRD = 3 0 0 -1 28 502 SQL DIAGNOSTIC INFORMATION
DSNT416I SQLERRD = X'00000003' X'00000000' X'00000000' X'FFFFFFFF' X'0000
INFORMATION

Hello,

I tried and JCL did't like symbolic variables in my SYSIN.

I believe the data to be substituted must be inline, not in a file/member.

We have no current plan to move to 1.13, so i cannot run a test.

My symbolic variable WAS instream data (data following a DD for SYSIN).:

Yes - inline and I think you need z/OS 2.0 but there are references in the forum to the exact level required.

Looks like z/OS 2.1 --
IBM Inside Sales
© 2013 IBM Corporation
International Technical Support Organization Global Content Services
Topic 14: Symbolic substitution in instream data

New SYMBOLS keyword on DD statement
SYMBOLS=[ ( ] JCLONLY | EXECSYS | CNVTSYS [ , DDname ) ]
– SYMBOLS=JCLONLY
Substitute JCL symbols made available by the EXPORT statement and JES symbols
dynamically created via JES Symbol Service (IAZSYMBL)
– SYMBOLS=EXECSYS
Perform substitution as for JCLONLY plus substitute system symbols from the system
where this job is executing.
– SYMBOLS=CNVTSYS
Perform substitution as for JCLONLY plus substitute system symbols from the system
where this job was converted.
– DDname
is an optional DD name (which must be provided by the user) which will receive the symbol

if you google search z/OS V2R1 Technical Updates, you will see all the new functions and features

HTH's