SQLSetStmtAttr
Full Description
swirl
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:

  1. StatementHandle.
  2. 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
  3. Value. The value to be associated with the Attribute.
  4. StringLength. The length of Value.
  5. ValueType. The type of data specified in Value. Two values are allowed: SQL_CHAR and SQL_INTEGER .

Copyright © OmniMark Technologies Corporation, 1988-1998.