Application Development

ODBCLink/SE Reference Manual

 

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

 

SQL_TRANSLATE_DLL

Timeout

 

supported

 

SQL_TRANSLATE_OPTION

supported

 

SQL_TXN_ISOLATION

supported: Cursor Stability isolation level

 

 

 

(CS) is not supported by

 

 

 

SQLSetConnectOption but you may set

 

SQL_TXN_READ_UNCOMMITTED

it from the ODBC Administrator

 

(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)”.

 

ODBCLink/SE

32

©M.B. Foster Associates Limited 1995-2000

Page 42
Image 42
HP MPE/iX 6.x Operating System manual =ON default 0=OFF, =All Rows default, Supported by Driver Manager, Timeout