Previous Topic: SQLCA Data for DB2Next Topic: $SQRT Function

BuiltIn Functions › $SQL Functions (SQL Access Only) › SQLCA Data for DATACOM SQL

SQLCA Data for DATACOM SQL

The following functions display SQLCA data for CA Datacom SQL access only. If the last database accessed was DB2, these functions return N/A.

Function

SQLCA Field

Data Type

$SQLCA‑DB‑VRS

SQLCA‑DB‑VRS

X2

$SQLCA‑DB‑RLS

SQLCA‑DB‑RLS

X2

$SQLCA‑LUWID

SQLCA‑LUWID

X8

$SQLCA‑DSFCODE

SQLCA‑DSFCODE

X4

$SQLCA‑INFCODE

SQLCA‑INFCODE

NB9

$SQLCA‑DBCODE‑EXT

SQLCA‑DBCODE‑EXT

X2

$SQLCA‑DBCODE‑INT

SQLCA‑DBCODE‑INT

NB4

$SQLCA‑PGM‑NAME

SQLCA‑PGM‑NAME

X8

$SQLCA‑AUTHID

SQLCA‑AUTHID

X18

$SQLCA‑PLAN‑NAME

SQLCA‑PLAN‑NAME

X18