SQL Code Summary Information

The following example of an EOJ Report provides SQL Codes Summary Information:
cdatvse
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
Œ
These are SQL error codes. The 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. Therefore, it is not counted in the SQL Code Summary Information report.