Job DSNTEJ2A
DSNTEJ2A tests the assembler program preparation procedures.
This job prepares and invokes program DSNTIAUL, which demonstrates the use of dynamic SQL in assembler to unload the data from tables or views. It also generates LOAD utility statements so the data can be loaded into another table. DSNTEJ2A then uses the LOAD utility to put data into copies of the unloaded tables.
If DSNTEJ2A runs successfully, it produces the return codes that are shown in the table below.
| Step | PROCSTEP | Return code |
|---|---|---|
| PREPUNL | PC
ASM LKED |
0000
0000 or 0004 0000 or 0004 |
| BINDUNL | 0000 | |
| DELETE | 0000 | |
| CREATE | 0000 | |
| UNLOAD | 0000 | |
| EDIT | 0000 | |
| LOAD | DSNUPROC | 0004 |
You can compare the output from this job with the sample output for DSNTEJ2A found in member DSN8TJ2A in your prefix.SDSNIVPD data set.