Syntax
define external counter function SQLSetStmtAttr
( read-only SQL_handle_type StatementHandle,
value counter Attribute,
read-only SQL_array_type Value,
value counter StringLength,
value counter ValueType )
Purpose
Sets a statement attribute.
Input arguments:
- StatementHandle.
- Attribute. The attribute identifier. The following values are allowed:
- SQL_ATTR_APP_ROW_DESC
- SQL_ATTR_APP_PARAM_DESC
- SQL_ATTR_IMP_ROW_DESC
- SQL_ATTR_IMP_PARAM_DESC
- SQL_ATTR_CURSOR_SCROLLABLE
- SQL_ATTR_CURSOR_SENSITIVITY
- SQL_ATTR_ASYNC_ENABLE
- SQL_ATTR_CONCURRENCY
- SQL_ATTR_CURSOR_TYPE
- SQL_ATTR_ENABLE_AUTO_IPD
- SQL_ATTR_FETCH_BOOKMARK_PTR
- SQL_ATTR_KEYSET_SIZE
- SQL_ATTR_MAX_LENGTH
- SQL_ATTR_MAX_ROWS
- SQL_ATTR_NOSCAN
- SQL_ATTR_PARAM_BIND_OFFSET_PTR
- SQL_ATTR_PARAM_BIND_TYPE
- SQL_ATTR_PARAM_OPERATION_PTR
- SQL_ATTR_PARAM_STATUS_PTR
- SQL_ATTR_PARAMS_PROCESSED_PTR
- SQL_ATTR_PARAMSET_SIZE
- SQL_ATTR_QUERY_TIMEOUT
- SQL_ATTR_RETRIEVE_DATA
- SQL_ATTR_ROW_BIND_OFFSET_PTR
- SQL_ATTR_ROW_BIND_TYPE
- SQL_ATTR_ROW_OPERATION_PTR
- SQL_ATTR_ROW_STATUS_PTR
- SQL_ATTR_ROWS_FETCHED_PTR
- SQL_ATTR_ROW_ARRAY_SIZE
- SQL_ATTR_SIMULATE_CURSOR
- Value. The value to be associated with the Attribute.
- StringLength. The length of Value.
- ValueType. The type of data specified in Value. Two values are allowed: SQL_CHAR and SQL_INTEGER .
|