SQL Codes › SQL Return Codes -1 through -999 › -118 - DSF dsf-code ERROR OCCURRED DURING SQL DSF PROCESSING

-118 - DSF dsf-code ERROR OCCURRED DURING SQL DSF PROCESSING

Reason:

While attempting to process an SQL transaction, an error was detected by the CA Datacom Datadictionary Service Facility.

For example, following is sample output from DBSQLPR:

 ___________SQL ERROR SUMMARY START___________

 SQLCODE = -118, SQLSTATE = R751A, DB RETURN CODE = 75(26)
 MESSAGE = DSF 'D000' ERROR OCCURRED DURING SQL DSF PROCESSING
 SQLERRD (DECIMAL EXCEPT AS NOTED) = 0,F7F5(HEX),0,0,0,26.

 ____________SQL ERROR SUMMARY END____________

The SQLSTATE that equates to this SQL return code is Reeii, 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-DSFCODE, SQLCA-DBCODE-INT, SQLCA-DBCODE-EXT, and SQLCA-ERROR-PGM. These columns contain, respectively, the CA Datacom Datadictionary Service Facility return code, the CA Datacom/DB internal return code, the CA Datacom/DB return code, and the name of the CA Datacom Datadictionary Service Facility module which reported the error.

For more information, see the CA Datacom/DB SQL User Guide.