SYSTERM output from the precompiler

The SYSTERM output provides a brief summary of the results from the precompiler, all error messages that the precompiler generated, and the statement that is in error, when possible.

The Db2 precompiler provides SYSTERM output when you allocate the DD name SYSTERM. If you use the program preparation panels to prepare and run your program, DB2I allocates SYSTERM according to the TERM option that you specify.

You can use the line number that is provided in each error message in the SYSTERM output to locate the failing source statement.

Figure 1 shows the format of SYSTERM output.

Figure 1. Db2 precompiler SYSTERM output
DB2 SQL PRECOMPILER         MESSAGES
 
DSNH104I E     DSNHPARS LINE 32 COL 26  ILLEGAL SYMBOL "X"  VALID SYMBOLS ARE:, FROM1
SELECT VALUE INTO HIPPO X;2
 
DB2 SQL PRECOMPILER         STATISTICS
SOURCE STATISTICS3
  SOURCE LINES READ: 36
  NUMBER OF SYMBOLS: 15
  SYMBOL TABLE BYTES EXCLUDING ATTRIBUTES: 1848
THERE WERE 1 MESSAGES FOR THIS PROGRAM.4
THERE WERE 0 MESSAGES SUPPRESSED BY THE FLAG OPTION.5
111664 BYTES OF STORAGE WERE USED BY THE PRECOMPILER.6
RETURN CODE IS 87
Notes:
  1. Error message.
  2. Source SQL statement.
  3. Summary statements of source statistics.
  4. Summary statement of the number of errors that were detected.
  5. Summary statement that indicates the number of errors that were detected but not printed. This situation might occur if you specify a FLAG option other than I.
  6. Storage requirement statement that indicates how many bytes of working storage that the Db2 precompiler actually used to process your source statements. That value helps you determine the storage allocation requirements for your program.
  7. Return code: 0 = success, 4 = warning, 8 = error, 12 = severe error, and 16 = unrecoverable error.