Jobtrac

 View Only
Back to discussions
Expand all | Collapse all

JCLTRAC cannot interpret System Symbols for DB2 Table Loads

  • 1.  JCLTRAC cannot interpret System Symbols for DB2 Table Loads

    Posted Oct 19, 2020 12:01 PM
    Hi.
    We have started using system symbols in our batch JCL to substitute the version of a product. Example:

    SYS1.PARMLIB(IEASYMPP)
    SYSDEF SYMDEF(&YDB2DB2C='V12M1')

    JCL when Job runs.
    XXSTEPLIB DD DSN=RUN.DB2.&YDB2DB2C..DB2C.SDSNEXIT,DISP=SHR
    IEFC653I SUBSTITUTION JCL - DSN=RUN.DB2.V12M1.DB2C.SDSNEXIT,DISP=SHR

    The problem is with our batch job that we use to load the DB2 Tables for JCLTRAC. It gives this error:

    XXSTEPLIB DD DSN=RUN.DB2.&YDB2DB2C..DB2C.SDSNEXIT,DISP=SHR
    IEFC627I INCORRECT USE OF AMPERSAND IN THE DSN FIELD

    The only way we have found to get round this issue is to run a job like this for every symbol that is giving the error.

    //STEP010 EXEC PGM=IDCAMS
    //SYSPRINT DD SYSOUT=*
    //SYSIN DD *

    DEFINE ALIAS (NAME(RUN.DB2.DB2C.SDSNEXIT) -
    SYMBOLICRELATE(RUN.DB2.&YDB2DB2C..DB2C.SDSNEXIT))   
    // 

    I did raise an issue on this but there is no ptf/solution to it.

    Has anyone else had this issue and managed to resolve it without having to use our solution?

    Regards.

    Steve.