The following examples show how -117 and -118 are displayed on CA Datacom Datadictionary Interactive SQL Service Facility panels when an error is detected when executing an SQL statement.
Example 1 (SQLCODE = -117)
=> => => ---------------------------------------------------------------------------->>> Interactive SQL Service Facility SQLMAINT SQL Output Panel S01O EDIT Member: $DDSQL Description: CREATE TABLE FOR DEPTTBL ------------------------------------------------------------------------------- 000010 NUMBER OF SQL STATEMENTS PROCESSED IS 0001 000011 (OUTPUT CREATED FROM SQL SOURCE MEMBER $DDSQL) 000012 create table depttbl 000013 (deptno char (2), 000014 deptname char (24)); 000015 --------+--------+--------+--------+--------+--------+--------+--------+ 000016 ERROR OCCURRED DELETING A PLAN -0117(36,192) (QDELP) 000017 DB ERROR OCCURRED DURING SQL PROCESSING 000018 --------+--------+--------+--------+--------+--------+--------+--------+ ====== =========================== B O T T O M ================================ PF1=HELP PF2=END PF3=SPLIT PF4=PROCESS PF5=TOP PF6=BOTTOM PF7=BACKWARD PF8=FORWARD PF9=EXECUTE PF10=LEFT PF11=RIGHT PF12=ALTERNATE
In this panel, the error messages and return codes that display are as follows:
ERROR OCCURRED ccccccccccccccccccccc snnnn(xx,yyy) (bbbbb)
Indicates an error was encountered during SQL statement execution.
Indicates where the error occurred during the SQL statement execution. In the previous example, an error occurred deleting a plan.
The snnnn string indicates that an error occurred during CA Datacom/DB or CA Datacom Datadictionary execution, where the s is the sign (+ or -) and nnnn is the error code number. The value -0117 of snnnn in the previous example indicates an error occurred in executing CA Datacom/DB.
The (xx,yyy) represents the external and internal CA Datacom/DB return codes where xx is the external return code and yyy is the internal return code.
These characters identify the internal CA Datacom/DB SQL command.
Example 2 (SQLCODE = -118)
=> => => ---------------------------------------------------------------------------->>> Interactive SQL Service Facility SQLMAINT SQL Output Panel S01O EDIT Member: $DDSQL Description: CREATE MY SCHEMA ------------------------------------------------------------------------------- 000001 (OUTPUT CREATED FROM SQL SOURCE MEMBER $DDSQL) 000002 create schema authorization jones; 000003 --------+--------+--------+--------+--------+--------+--------+--------+ 000004 ERROR OCCURRED EXECUTING A PLAN -0118(MAAE) DDLGETEN (QEXEI) 000005 --------+--------+--------+--------+--------+--------+--------+--------+ ====== =========================== B O T T O M ================================ PF1=HELP PF2=END PF3=SPLIT PF4=PROCESS PF5=TOP PF6=BOTTOM PF7=BACKWARD PF8=FORWARD PF9=EXECUTE PF10=LEFT PF11=RIGHT PF12=ALTERNATE
In this panel, the error messages and return codes that display are as follows:
ERROR OCCURRED ccccccccccccccccccccc snnnn(aaaa :xx,yyy) dddddddd (bbbbb)
Indicates an error was encountered during SQL statement execution.
Indicates where the error occurred during the SQL statement execution. In the previous example, an error occurred executing a plan.
The snnnn string indicates that an error occurred during CA Datacom/DB or CA Datacom Datadictionary execution, were s is the sign (+ or -) and nnnn is the error number. The value -0118 of snnnn in the previous example indicates an error occurred in executing CA Datacom Datadictionary.
The aaaa string indicates the CA Datacom Datadictionary Service Facility return code and corresponds to the SQLCA-DSFCODE. (See the table at the start of this chapter for the interpretation of this error.) The M in MAAE in the previous example means that the return code is from a module of CA Datacom Datadictionary, while the three characters following the M are the CA Datacom Datadictionary Service Facility return code from the interface module that populates CA Datacom Datadictionary. In this case, AAE means "authorization already exists."
When aaaa is D000, xx,yyy represents the external and internal CA Datacom/DB return codes where xx is the external return code and yyy is the internal return code. In the previous example, no CA Datacom/DB return code is displayed on the panel since the error was not one detected by CA Datacom/DB.
The DDL in DDLGETEN in the previous example identifies the module that populates CA Datacom Datadictionary, while the GETEN is a CA Datacom Datadictionary Service Facility command.
These characters identify the internal CA Datacom/DB SQL command.
Example 3 (SQLCODE = 243)
=> => => ---------------------------------------------------------------------------->>> Interactive SQL Service Facility SQLMAINT SQL Output Panel S01O EDIT Member: $DDSQL Description: DROP TABLE DEPTTBL ------------------------------------------------------------------------------- 000010 NUMBER OF SQL STATEMENTS PROCESSED IS 0001 000011 (OUTPUT CREATED FROM SQL SOURCE MEMBER $DDSQL) 000012 drop table depttbl; 000013 --------+--------+--------+--------+--------+--------+--------+--------+ 000014 ERROR OCCURRED EXECUTING A PLAN +0243 TBLUPD (QEXEI) 000015 ANSI EXTENSION 000016 --------+--------+--------+--------+--------+--------+--------+--------+ ====== =========================== B O T T O M ================================ PF1=HELP PF2=END PF3=SPLIT PF4=PROCESS PF5=TOP PF6=BOTTOM PF7=BACKWARD PF8=FORWARD PF9=EXECUTE PF10=LEFT PF11=RIGHT PF12=ALTERNATE
In this panel, the error messages and return codes that display are as follows:
ERROR OCCURRED ccccccccccccccccccccc snnnn(xx,yyy) aaaaaa (bbbbb)
Indicates an error was encountered during SQL statement execution.
Indicates where the error occurred during the SQL statement execution. In the previous example, an error occurred executing a plan.
The snnnn string indicates that an error occurred during CA Datacom/DB or CA Datacom Datadictionary execution, where the s is the sign (+ or -) and nnnn is the error code number.
Note: In the list of SQL codes found in the CA Datacom/DB Message Reference Guide, positive return codes are listed without the plus (+) sign and without the leading zero, for example the previously shown +0243, is listed as 243.
The (xx,yyy) represents the external and internal CA Datacom/DB return codes where xx is the external return code and yyy is the internal return code.
These characters identify the function being performed.
These characters identify the internal CA Datacom/DB SQL command.
|
Copyright © 2014 CA.
All rights reserved.
|
|