Job DSNTEJ67

Job DSNTEJ67 shows how to convert sample external SQL procedure DSN8.DSN8ES2 to a sample native SQL procedure called DSN8.DSN8ES2. The conversion is performed by the Db2 precompiler and various Db2 sample REXX services that are provided in member DSN8ERL1.

Before running job DSNTEJ67, you must successfully run job DSNTEJ65 to create DSN8.DSN8ES2 through the Db2 SQL procedure processor, DSNTPSMP. See the job DSNTEJ67 prolog for information about adapting this job to convert other SQL procedures that are created through DSNTPSMP.

Table 1. DSNTEJ67 return codes
Step
PROCSTEP
Return code
PH067S00   0000
PH067S01   0000
PH067S02   0000
PH067S03 0000
PH067S04   0000 or 0004