DB2 via Clist



IBM's Command List programming language & Restructured Extended Executor

DB2 via Clist

Postby jasper57 » Fri Jan 22, 2010 6:19 pm

When using this Clist I get a condition code 0 but SYSREC00 does not appear in IOF.
Submitting the job directly works fine.
What am I doing wrong?

CONTROL NOMSG NOLIST NOCONLIST NOSYMLIST NOFLUSH

SUBMIT * END($$)

//uidSQL JOB (CPB00000),,CLASS=Y,MSGCLASS=G,
// MSGLEVEL=(1,1),REGION=2048K,NOTIFY=uid
//************************************************** ************
//STEP010 EXEC PGM=IKJEFT01,DYNAMNBR=20
//SYSTSPRT DD SYSOUT=*
//SYSTSIN DD *
DSN SYSTEM(DB2)
RUN PROGRAM(DSNTIAUL) PLAN(DSNTIAUL) PARMS('SQL') -
LIB(level1.DSN.RUNLIB.LOAD')
END
//SYSPUNCH DD SYSOUT=*
//SYSPRINT DD SYSOUT=*
//SYSUDUMP DD SYSOUT=*
//SYSREC00 DD SYSOUT=*
//SYSIN DD *
&STR(SELECT) .....
FROM .....
WHERE ....;
$$
jasper57
 
Posts: 2
Joined: Fri Jan 22, 2010 6:10 pm
Has thanked: 0 time
Been thanked: 0 time

Re: DB2 via Clist

 

Re: DB2 via Clist

Postby Robert Sample » Fri Jan 22, 2010 6:24 pm

Have you tried putting a line with /*EOF after the $$ line? If you try this and it doesn't work, it almost certainly is a problem with the job card and you'll need to contact your site support group for assistance.
Robert Sample
Global moderator
 
Posts: 3367
Joined: Sat Dec 19, 2009 8:32 pm
Location: Dubuque, Iowa, USA
Has thanked: 1 time
Been thanked: 222 times

Re: DB2 via Clist

Postby jasper57 » Fri Feb 05, 2010 4:39 pm

This did the trick:

CONTROL NOMSG NOLIST NOCONLIST NOSYMLIST NOFLUSH

SUBMIT * END($$)

//uidSQL JOB (00),'EXTRACTIE DATUM',CLASS=Y,MSGCLASS=G,
// MSGLEVEL=(1,1),REGION=2048K,NOTIFY=uid
//**************************************************************
//STEP010 EXEC PGM=IKJEFT01,DYNAMNBR=20
//SYSTSPRT DD SYSOUT=*
//SYSTSIN DD DSN=uid.UTIL.CNTL(DSNTIAUL),DISP=SHR
//SYSPUNCH DD SYSOUT=*
//SYSPRINT DD SYSOUT=*
//SYSUDUMP DD SYSOUT=*
//SYSREC00 DD SYSOUT=*
//SYSIN DD *
&STR(SELECT) ....
FROM ....
WHERE ....;
$$

It just irritates me that I don't understand why this works while the other one doesn't.
jasper57
 
Posts: 2
Joined: Fri Jan 22, 2010 6:10 pm
Has thanked: 0 time
Been thanked: 0 time

Re: DB2 via Clist

Postby dick scherrer » Sat Feb 06, 2010 12:29 am

Hello,

To repeat what Robert posted:
it almost certainly is a problem with the job card and you'll need to contact your site support group for assistance.

There can be jcl that is syntactically correct but is rejected by site standards/policies. . .
Hope this helps,
d.sch.
User avatar
dick scherrer
Global moderator
 
Posts: 6304
Joined: Sat Jun 09, 2007 8:58 am
Has thanked: 3 times
Been thanked: 91 times


Return to CLIST & REXX

 


  • Related topics
    Replies
    Views
    Last post