SQL Codes › SQL Return Codes -1 through -999 › -117 - RAAT/CBS ERROR: CMD=xxxxx TBL=ttt DBID=nnnn KEY=kkkkk RC=rr (iii)

-117 - RAAT/CBS ERROR: CMD=xxxxx TBL=ttt DBID=nnnn KEY=kkkkk RC=rr (iii)

Reason:

In attempting to process an SQL transaction, CA Datacom/DB detected an error. The following are displayed in the message text: the SQL command, the table DATACOM-NAME, the database DBID, the key DATACOM-NAME, and the CA Datacom/DB return code and internal return code.

The SQLSTATE that equates to this SQL return code is Seeii, where ee represents the 2-byte external CA Datacom/DB return code, and ii is the CA Datacom/DB internal return code in hexadecimal characters.

Action:

The nature of the problem can be further understood by examining columns within the SQLCA. The column names are SQLCA-DBCODE-INT, SQLCA-DBCODE-EXT, SQLCA-ERROR-PGM. These columns contain, respectively, the CA Datacom/DB internal return code, the CA Datacom/DB return code, and the name of the CA Datacom/DB module that reported the error.

For further explanation, see the CA Datacom/DB SQL User Guide.