sqlipSetInfo
- Last Updated: May 12, 2026
- 2 minute read
- OpenAccess SDK
- Version 8.1
- Documentation
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.
int sqlipSetInfo(
int iInfoType,
String sInfoValue);
Parameters for sqlipSetInfo
| Parameter | Type | Description |
| INPUT | ||
| iInfoValue | int | Information type. Options are defined in Table sqlipSetInfo Options. |
| 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. |
The following table describes the options for the set_info method.
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: |
| 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 |
Connection level information. Returns the cryptographic protocol version that can be used to create an SSL connection between the OpenAccess SDK client and server. The value returned is an integer data type. Valid or expected values are the following SSL/TLS versions:
|