Job DSNTEJ63

Job DSNTEJ63 prepares the sample external SQL procedure, DSN8ES1, which accepts a department number and returns salary and bonus data.

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.

If a remote location was specified in the REMOTE LOCATION field of panel DSNTIPY, job DSNTEJ63 should be run on the remote server subsystem.

Before running DSNTEJ63, you should manually edit the job as described in the dependencies information in the job prolog.

If DSNTEJ63 runs successfully, it produces the return codes that are shown in the following table.

Table 1. DSNTEJ63 return codes
Step
PROCSTEP
Return code
PH063S01
0000
PH063S02
PC
PCC
C
PLKED1
LKED
0004
0004
0000
0004
0000
PH063S03
0000 or 0004
Note:
  1. The PLKED step does not exist in the job if the value of the C LE PRELINKER PHASE field is set to NO.