COBOL: SQLCA-EYE-CATCH
PL/I: SQLCA_EYE_CATCH
Assembler: SQLCAEYE
C: sqlca_eye_catch

A core mark to help find the SQLCA in diagnostic situations (containing 'SQLCA***' in COBOL).

COBOL: SQLCA-LEN
PL/I: SQLCA_LEN
Assembler: SQLCALEN
C: sqlca_len

The length of the SQLCA (196 in COBOL).

COBOL: SQLCA-DB-VRS
PL/I: SQLCA_DB_VRS
Assembler: SQLCADBV
C: sqlca_db_vrs

The CA Datacom/DB version.

COBOL: SQLCA-DB-RLS
PL/I: SQLCA_DB_RLS
Assembler: SQLCADBR
C: sqlca_db_rls

The CA Datacom/DB release.

COBOL: SQLCA-LUWID
PL/I: SQLCA_LUWID
Assembler: SQLCALUW
C: sqlca_luwid

Reserved.

COBOL: SQLCODE
PL/I: SQLCA_CODE (ANSI)
PL/I: SQLCODE (non-ANSI)
Assembler: SQLCODE
C: sqlca_code or sqlcode or sqlcade

Value returned from an SQL call.

If an exception declaration (WHENEVER statement) is not provided, the recommended practice is that your program include code to check the returned value immediately after each executable SQL statement.

COBOL: SQLCA-ERROR-INFO
PL/I: SQLCA_ERROR_INFO
Assembler: SQLCAERI
C: N/A (See following error fields for C.)

The error information area.

COBOL: SQLCA-ERROR-LEN
PL/I: SQLCA_ERROR_LEN
Assembler: SQLCAELN
C: sqlca_err_len

The length of the error return string.

COBOL: SQLCA-ERROR-MSG
PL/I: SQLCA_ERROR_MSG
Assembler: SQLCAEMS
C: sqlca_err_msg

A brief description of the error.

COBOL: SQLCA-ERROR-PGM
PL/I: SQLCA_ERROR_PGM
Assembler: SQLCAEPG
C: sqlca_err_pgm

Contains the name of the CA Datacom/DB module which reported the error.

COBOL: SQLCA-FILLER-1
PL/I: SQLCA_FILLER_1
Assembler: SQLCAFL1
C: sqlca_filler_1

In PL/I and Assembler, this is a place holder.

COBOL: SQLCA-ERROR-DATA
PL/I: SQLCA_ERROR_DATA
Assembler: SQLCAEDT
C: N/A (See following code fields for C.)

Provides diagnostic information.

COBOL: SQLCA-DSFCODE
PL/I: SQLCA_DSFCODE
Assembler: SQLCADSF
C: sqlca_dsfcode

The return code from the CA Datacom Datadictionary Service Facility.

COBOL: SQLCA-INFCODE
PL/I: SQLCA_INFCODE
Assembler: SQLCAINF
C: sqlca_infcode

Reserved for future use.

COBOL: SQLCA-DBCODE
PL/I: SQLCA_DBCODE
Assembler: SQLCADBC
C: sqlca_dbcode

Contains additional return codes from CA Datacom/DB for some error conditions, to aid in diagnosing errors.

COBOL: SQLCA-DBCODE-EXT
PL/I: SQLCA_DBCODE_EXT
Assembler: SQLCADBEX
C: sqlca_dbcode_ext

The CA Datacom/DB external return code.

COBOL: SQLCA-DBCODE-INT
PL/I: SQLCA_DBCODE_INT
Assembler: SQLCADBI
C: sqlca_dbcode_int

The CA Datacom/DB internal return code.

COBOL: SQLCA-MISC-DATA
PL/I: SQLCA_MISC_DATA
Assembler: SQLCAMC1
C: sqlca_misc_code1

Number of rows affected by an UPDATE, INSERT or DELETE statement.

COBOL: SQLCA-MISC-CODE2
COBOL: SQLCA-MISC-CODE3
PL/I: SQLCA_MISC_CODE2
PL/I: SQLCA_MISC_CODE3

redefined (following) to SQLSTATE field.

COBOL: SQLSTATE
PL/I: SQLSTATE
Assembler: SQLSTATE
C: sqlca_sqlstate or sqlstate

The field in which the ANSI-compatible SQLSTATE return code is supplied.

Assembler: SQLCAMC2
Assembler: SQLCAMC3
C: sqlca_filler_2
C: sqlca_misc_code2

Reserved.

COBOL: SQLCA-WARNING
PL/I: SQLCA_WARNING
Assembler: SQLCAWRN
C: sqlca_wrn_area

An array of eight characters which provides warning return codes (a W indicates that a warning has been returned). For tables that explain the significance of the return code for each element in the array, see:

• Warning Array - COBOL (for COBOL)
• Warning Arrays - PL/I, Assembler, C (for PL/I, Assembler, and C).

COBOL: SQLCA-PGM-NAME
PL/I: SQLCA_PGM_NAME
Assembler: SQLCAPGM
C: sqlca_pgm_name

Contains the program identification assigned in the PROGRAM-ID statement.

COBOL: SQLCA-AUTHID
PL/I: SQLCA_AUTHID
Assembler: SQLCAATH
C: sqlca_authid

Contains the authorization ID specified in the Preprocessor AUTHID= option.

COBOL: SQLCA-PLAN-NAME
PL/I: SQLCA_PLAN_NAME
Assembler: SQLCAPLN
C: sqlca_plan_name

Contains the name of the plan specified in the Preprocessor PLANAME= (or PLANNAME= in PL/I) option. (In COBOL, if the option is not specified, the default is the PROGRAM-ID.)

Assembler: SQLCADLN

The length of the SQLCA.