CRTSQLPKG listing

 

The example listing from the Create Structured Query Language Package (CRTSQLPKG) command provides these types of information.

• The values used on the parameters of the command

• The statement in error, if any

• The messages resulting from running the Create Structured Query Language Package (CRTSQLPKG) command

The following figure illustrates this information:Figure 1. Listing from CRTSQLPKG

5722ST1 V5R4M0 060210                 Create SQL package 02/10/06 14:30:31   Page   1
Record*...+... 1 ...+... 2 ...+... 3 ...+... 4 ...+... 5 ...+... 6 ...+... 7 ...+... 8 SEQNBR  Last change Program name..............TST/UPDATEPGM Relational database.......*PGM User .....................*CURRENT Replace...................*YES Default Collection........*PGM Generation level..........10
Printer file..............*LIBL/QSYSPRT Object type...............*PGM Module list...............*ALL Text......................*PGMTXT Source file...............TST/QCSRC Member....................UPDATEPGM  

5722ST1 V5R4M0 060210              Create SQL package 02/10/06 14:30:31   Page   2
Record*...+... 1 ...+... 2 ...+... 3 ...+... 4 ...+... 5 ...+... 6 ...+... 7 ...+... 8 SEQNBR Last change 17   UPDATE RWDS / DPT1 SET deptcode = NULL DIAGNOSTIC MESSAGES MSG ID  SEV  RECORD  TEXT SQL0204  10      17  Position 17 DPT1 in RWDS type *FILE not found.
SQL5057              SQL Package UPDATEPGM in TST created at KC000 from module UPDATEPGM.
Message Summary Total    Info    Warning    Error    Severe    Terminal 1      0         1         0         0          0
10 level severity errors found in source * * * * *  E N D  O F  L I S T I N G  * * * * *

 

Parent topic:

Listings

 

Related reference

Create Structured Query Language Package (CRTSQLPKG) command