Job DSNTEJ6S

Job DSNTEJ6S compiles and link-edits the sample stored procedure DSN8EP2. DSNTEJ6S also updates the SYSIBM.SYSROUTINES catalog table with information about the stored procedure.

The installation CLIST edits this job only if the following conditions are met:

  • You specified AUTO or COMMAND in the DDF STARTUP OPTION field of panel DSNTIPR.
  • You specified a name in the WLM ENVIRONMENT field of panel DSNTIPX.
  • You specified a name in the REMOTE LOCATION field of panel DSNTIPY. The name can match the name that is specified in the DB2 LOCATION NAME field of panel DSNTIPR.

If you have SQL statements in your stored procedure, you must remove the comment character in the JCL from the step that binds the stored procedure package.

You must run job DSNTEJ6S on the server Db2 subsystem.

If DSNTEJ6S runs successfully, it produces the return codes that are shown in the table below.

Table 1. DSNTEJ6S return codes
Step PROCSTEP Return code
PH06SS01   0000
PH06SS02   0000
PH06SS03
PPLI
PC
PLI
PLKED1
LKED
0000
0004
0004
0004
0000
Note:
  1. The PLKED step does not exist in the job if the value of the PL/I LE PRELINKER PHASE field is set to NO.

If SQLCODE -592 is received during the execution of DSNTEJ6T, ensure that SPA is active.