dam_setInfo
- Last Updated: May 12, 2026
- 2 minute read
- OpenAccess SDK
- Version 8.1
- Documentation
This method sets the specified global, connection or statement level information to be used by the OpenAccess SDK SQL Engine. See Table Information Type for dam_setInfo for the types of information that can be returned.
int dam_setInfo(
int64 hdbc,
int64 hstmt,
int iInfoType,
string pStrInfoValue,
int intVal)
Parameters for dam_setInfo
| Parameter | Type | Description |
| IN | ||
| hdbc | int64 | The OpenAccess SDK SQL Engine connection handle to be used for connection level options. Set to zero for statement level options. |
| hstmt | int64 | The statement handle to be used for statement level options. Set to zero for connection level options. |
| iInfoType | int | The information to set. See Table Information Type for dam_setInfo for a list of options. |
| pInfoValue | string | String type options are passed in through this argument. |
| intVal | int | Integer type options are passed in through this argument. |
| RETURN | ||
| int | The status of the call: DAM_SUCCESS – set the iInfoType value DAM_FAILURE – wrong value for iInfoType or the input buffer is not large enough |
Information Type for dam_setInfo
| Information Type | Description |
| DAM_INFO_STMT_IP_CONTEXT | Statement level option; used to store a key to an IP defined data structure that needs to persist across all queries executed to handle the requested query. This value can be retrieved using the dam_getInfo. Joins and sub-queries are examples where the IP is called multiple times to execute a given query. The key value pInfoValue is stored as an integer. The methods dam_setIP_hstmt and dam_getIP_hstmt are used to reference IP-defined data structures for a sub-query on a specific table. Use dam_setInfo and dam_getInfo to store IP-specific information that is accessible during the execution of any of the involved tables. |