Previous Topic: SQLCA DataNext Topic: SQLCA Data for DB2


For Any SQL Access

The following functions display SQLCA data for both DB2 and CA Datacom/DB SQL access.

Function

Synonym

SQLCA Field

Data Type

$SQLCAID

$SQLCA‑EYE‑CATCH

SQLCAID

X8

$SQLCABC

$SQLCA‑LEN

SQLCABC

NB9

$SQLCODE

 

SQLCODE

NB9

$SQLERRM

$SQLCA‑ERROR‑INFO

SQLERRM

V80

$SQLERRP

$SQLCA‑ERROR‑PGM

SQLERRP

X8

$SQLWARN0

 

SQLWARN0

X1

$SQLWARN1

 

SQLWARN1

X1

$SQLWARN2

 

SQLWARN2

X1

$SQLWARN3

 

SQLWARN3

X1

$SQLWARN4

 

SQLWARN4

X1

$SQLWARN5

 

SQLWARN5

X1

$SQLWARN6

 

SQLWARN6

X1

$SQLWARN7

 

SQLWARN7

X1

$SQLSTATE

 

SQLSTATE

X5