DB2 via Clist

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • jasper57
    New Member
    • Jan 2010
    • 1

    DB2 via Clist

    When using this Clist I get a condition code 0 but SYSREC00 does not appear in IOF. What am I doing wrong?

    CONTROL NOMSG NOLIST NOCONLIST NOSYMLIST NOFLUSH

    SUBMIT * END($$)

    //uidSQL JOB (CPB00000),,CLA SS=Y,MSGCLASS=G ,
    // MSGLEVEL=(1,1), REGION=2048K,NO TIFY=uid
    //*************** *************** *************** *************** **
    //STEP010 EXEC PGM=IKJEFT01,DY NAMNBR=20
    //SYSTSPRT DD SYSOUT=*
    //SYSTSIN DD *
    DSN SYSTEM(DB2)
    RUN PROGRAM(DSNTIAU L) 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 ....;
    $$
Working...