Job DSNTEJ65

Job DSNTEJ65 prepares and runs a sample application that calls the SYSPROC.DSNTPSMP stored procedure processor to create a sample external SQL procedure. The sample external SQL procedure is created at the location that is specified in the REMOTE LOCATION field of panel DSNTIPY.

Job DSNTEJ65 then prepares and runs a sample application that calls the external SQL procedure. The sample caller first connects to the location that is specified in the REMOTE LOCATION field of panel DSNTIPY.

If a remote location is specified in the REMOTE LOCATION field name on installation panel DSNTIPY, ensure that both Db2 REXX language support and the DSNTPSMP stored procedure are available at that location. 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 major components of job DSNTEJ65 are as follows:

DSNWLM_REXX is the WLM core environment for DSNTPSMP.
DSN8ED4 is a sample C program that calls the Db2 external SQL procedures processor.
DSN8ES2 is a sample external SQL procedure that calculates employee bonuses.
DSN8ED5 is a sample C program that calls the external SQL procedure DSN8ES2.

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 DSNTEJ65, ensure that DSNTPSMP has been created as part of the installation or migration process.

Recommendation: DSNTPSMP requires that the default EBCDIC CCSID that is used by Db2 also be compatible with the C compiler. Do not run DSNTEJ65 if the default EBCDIC CCSID for Db2 is not compatible with the C compiler. Using an incompatible CCSID results in compile-time errors. Examples of incompatible CCSIDs include 290, 930, 1026, and 1155.

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

Table 1. DSNTEJ65 return codes
Step	PROCSTEP	Return code
PH065S01	PC C PLKED¹ LKED	0000 0000 0004 0000
PH065S02		0000 or 0004
PH065S03		0000 or 0004
PH065S04		0000 or 0004
PH065S05	PC C PLKED¹ LKED	0000 0000 0004 0000
PH065S06		0000 or 0004
PH065S07		0000
Note: 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 DSNTEJ65, which is found in member DSN8TJ65 in the data set named prefix.SDSNIVPD.