DB2 Version 10.1 for Linux, UNIX, and Windows

sqleqryc API - Query client connection settings

Returns current connection settings for an application process. The sqle_conn_setting data structure is populated with the connection setting types and values.

Authorization

None

Required connection

None

API include file

sqlenv.h

API and data structure syntax

SQL_API_RC SQL_API_FN
  sqleqryc (
        struct sqle_conn_setting * pConnectionSettings,
        unsigned short NumSettings,
        struct sqlca * pSqlca);

SQL_API_RC SQL_API_FN
  sqlgqryc (
        struct sqle_conn_setting * pConnectionSettings,
        unsigned short NumSettings,
        struct sqlca * pSqlca);

sqleqryc API parameters

pConnectionSettings: Input/Output. A pointer to an sqle_conn_setting structure, which specifies connection setting types and values. The user defines an array of NumSettings connection settings structures, and sets the type field of each element in this array to indicate one of the five possible connection settings options. Upon return, the value field of each element contains the current setting of the option specified.
NumSettings: Input. Any integer (from 0 to 7) representing the number of connection option values to be returned.
pSqlca: Output. A pointer to the sqlca structure.

Usage notes

The connection settings for an application process can be queried at any time during execution.

If QUERY CLIENT is successful, the fields in the sqle_conn_setting structure will contain the current connection settings of the application process. If SET CLIENT has never been called, the settings will contain the values of the precompile options only if an SQL statement has already been processed; otherwise, they will contain the default values for the precompile options.

REXX API syntax

QUERY CLIENT INTO :output

REXX API parameters

output

A compound REXX host variable containing information about the current connection settings of the application process. In the following, XXX represents the host variable name.

XXX.1: Currentconnection setting for the CONNECTION type
XXX.2: Currentconnection setting for the SQLRULES
XXX.3: Currentconnection setting indicating which connections will be released when a COMMIT is issued.
XXX.4: Currentconnection setting of the SYNCPOINT option. The SYNCPOINT option is ignored and is available only for backward compatibility. Indicates whether a transaction manager should be used to enforce two-phase commit semantics, whether the database manager should ensure that there is only one database being updated when multiple databases are accessed within a single transaction, or whether neither of these options is to be used.
XXX.6: Currentconnection setting for deferred PREPARE.