DB2 Version 10.1 for Linux, UNIX, and Windows

sqlegdge API - Get a specific entry in the database connection services (DCS) directory

Returns information for a specific entry in the Database Connection Services (DCS) directory.

Authorization

None

Required connection

None

API include file

sqlenv.h

API and data structure syntax

SQL_API_RC SQL_API_FN
  sqlegdge (
        struct sql_dir_entry * pDCSDirEntry,
        struct sqlca * pSqlca);

SQL_API_RC SQL_API_FN
  sqlggdge (
        struct sqlca * pSqlca,
        struct sql_dir_entry * pDCSDirEntry);

sqlegdge API parameters

pDCSDirEntry: Input/Output. Pointer to the Database Connection Services directory structure. Fill in the ldb field of this structure with the local name of the database whose DCS directory entry is to be retrieved.
The remaining fields in the structure are filled in upon return of this API.
pSqlca: Output. A pointer to the sqlca structure.

REXX API syntax

GET DCS DIRECTORY ENTRY FOR DATABASE dbname [USING :value]

REXX API parameters

dbname

Specifies the local database name of the directory entry to be obtained.

value

A compound REXX host variable into which the directory entry information is returned. In the following, XXX represents the host variable name. If no name is given, the name SQLGWINF is used.

XXX.0: Number of elements in the variable (always 7)
XXX.1: RELEASE
XXX.2: LDB
XXX.3: TDB
XXX.4: AR
XXX.5: PARMS
XXX.6: COMMENT
XXX.7: RESERVED.