sqlipSetInfo

This statement-level method is called by the OpenAccess SDK layer to inform the IP of various connection and statement level options such as the maximum number of rows to return, transaction commit mode, and query timeout. The IP can optionally use this information in its processing.

Table 75: Parameters for sqlipSetInfo
Parameter	Type	Description
INPUT
iInfoValue	int	Information type. Options are defined in Table 76.
sInfoValue	String	Option value.
RETURN
	int	OADS_SUCCESS – if you are able to successfully apply the option or if you want to ignore the options. OADS_ERROR – if an error occurs in handling the requested option for which you have support.

Table 76: sqlipSetInfo Options
ilnfoType	Description
OADS_CONN_INFO_CLIENT_ PROD_VERSION	A string value indicating the version of the client product that the OpenAccess SDK client is accessing for this connection.
OADS_CONN_INFO_CLIENT_TYPE	An integer value indicating the OpenAccess SDK client type (ODBC, JDBC, OLE DB, or ADO.NET). Valid values: • SQLDRV_CLIENTTYPE_ODBC • SQLDRV_CLIENTTYPE_JDBC • SQLDRV_CLIENTTYPE_OLEDB • SQLDRV_CLIENTTYPE_NET
OADS_STMT_INFO_QUERY_TIMEOUT	Seconds to wait for the query to finish executing. A value of 0 indicates no limit.
OADS_STMT_INFO_MAX_ROWS	Maximum number of rows to return. A value of 0 indicates no limit.
OADS_CONN_INFO_SESSION_ CIPHER_SUITE	A string value indicating the cipher suite used for communication between the OpenAccess SDK client and server.
OADS_CONN_INFO_SESSION_ CRYPTO_PROTOCOL_VERSION	An integer value indicating the cryptographic protocol version that can be used to create an SSL connection between the OpenAccess SDK client and server. Valid or expected values are the following SSL/TLS versions: • DAM_VERSION_UNDEFINED – 0 • DAM_VERSION_TLS1 – 1 • DAM_VERSION_TLS1_1 – 2 • DAM_VERSION_TLS1_2 – 3 • Default when SSL Enabled DAM_VERSION_TLS1_2 – 2