GET_CONNECTION_OPTION¶

Applies to: SQLFlex

This command gets the value of a connection option that was set using SET_CONNECTION_OPTION. Only options that are not used internally by the driver can be retrieved using this command. Connection options that CANNOT be retrieved: Database, Server, FailoverPartner, MarsConn, uid, pwd, Trusted_Connection, wsid, app, AutoTranslate, Timeout.

Syntax

GET_CONNECTION_OPTION {option} to {variable}

Parameter

Description

option

The connection option to get

value

A variable to hold the retrieved value of the connection option.

Example

GET_CONNECTION_OPTION "ApplicationIntent" to sVal