Job DSNTEJ64

Job DSNTEJ64 prepares and executes DSN8ED3, which is a sample routine that calls the sample external SQL procedure, DSN8ES1. DSN8ES1 was created by job DSNTIJ63.

The sample caller first connects to the location that is specified in the REMOTE LOCATION field of panel DSNTIPY. If the remote location name is the same as the name that is specified in the DB2 LOCATION NAME field of panel DSNTIPR, the local Db2 subsystem is used as both the client and server.

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.

Before running job DSNTEJ64, ensure that job DSNTEJ6S was run on the server subsystem. Also run job DSNTEJ63 before running job DSNTEJ64. Before running DSNTEJ64, you should manually edit the job as described in the dependencies information in the job prolog.

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

Table 1. DSNTEJ64 return codes
Step
PROCSTEP
Return code
PH064S01
PC
C
PLKED1
LKED
0000
0000
0004
0000
PH064S02
0000 or 0004
PH064S03
0000
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.

You can compare the output from this job to the sample output for DSNTEJ64, which is found in member DSN8TJ64 in data set named prefix.SDSNIVPD.