ODBCLINK/SE Reference Manual (36217-90410)

Application Development ODBCLink/SE Reference Manual
ODBCLink/SE
32 ©M.B. Foster Associates Limited 1995-2000
SQL_COLUMN_COUNT
SQL_COLUMN_NAME
SQL_COLUMN_TYPE
SQL_COLUMN_LENGTH
SQL_COLUMN_PRECISION
SQL_COLUMN_SCALE
SQL_COLUMN_DISPLAY_SIZE
SQL_COLUMN_NULLABLE
⊗ R2: The following SQLSetConnectOptions are supported. All other will
return a “Driver not Capable (SQLState S1C00)”.
SQL_AUTOCOMMIT 1=ON (default) 0=OFF
SQL_MAX_ROWS 0=All Rows (default)
SQL_OPT_TRACE supported by Driver Manager
SQL_OPT_TRACEFILE supported by Driver Manager
SQL_QUERY_TIMEOUT 0=No Timeout (default) Use ALLBASE
Timeout
SQL_TRANSLATE_DLL supported
SQL_TRANSLATE_OPTION supported
SQL_TXN_ISOLATION supported: Cursor Stability isolation level
(CS) is not supported by
SQLSetConnectOption but you may set
it from the ODBC Administrator
SQL_TXN_READ_UNCOMMITTED (Read Uncommitted (RU))
SQL_TXN_READ_COMMITTED (Read Committed (RC))
SQL_TXN_REPEATABLE_READ (Repeatable Read (RR))
SQL_TXN_SERIALIZABLE (Note: Sets to Repeatable Read (RR))
SQL_TXN_VERSIONING Not Implemented - DO NOT USE
Note: For information on isolation levels, refer to the "Isolation
Levels" section in this chapter.
⊗ R3: All SQLGetInfo Options are supported.
⊗ R4: SQLSetStmtOptions are not supported. The driver will return
either a “Driver not Capable (SQLState S1C00)” or “Option value changed
(SQLState 01S02)”.