|
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 196 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
|
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.
|