COMM (Communicate with Multi-User Facility) › COMM EOJ (End Multi-User Facility Processing) › EOJ Reports › SQL Code Summary Information

SQL Code Summary Information

The following example of an EOJ Report provides SQL Codes Summary Information:

Date: mm/dd/ccyy    ********************************************************************************         Page:     1
                    *                                 CA Datacom/DB                                *
Time: hh.mm.ss      *                                General Utility                               *      Release: 12
                    *                   Copyright © 2009 CA. All rights reserved.                  *               SPnn
                    ********************************************************************************
 
                                             SQL CODE SUMMARY INFORMATION
             SQL CODE    OCCURRENCES
                  Œ
                  -14              2
                  -20              1
                  -56              1
                 -124              2

Œ

Note that these are SQL error codes. Also note that SQL code 100 (that is, +100, not -100) is not listed in these counts because it indicates a non-error situation. Specifically, SQL code 100 indicates NO ROW FOUND and can occur during a DELETE or UPDATE, if no rows are found to delete or update. It is a normal, non-error condition for which no action is required, and therefore it is not counted in the SQL Code Summary Information report.