List of all attributes and return values supported by the MaxDB ODBC driver
Attributes |
Return Values |
SQL_ACCESSIBLE_PROCEDURES |
rgbInfoValue = "N" |
SQL_ACCESSIBLE_TABLES |
rgbInfoValue = "N" |
SQL_ACTIVE_CONNECTIONS |
rgbInfoValue = 0 |
SQL_ACTIVE_STATEMENTS |
rgbInfoValue = 32767 |
SQL_ALTER_TABLE |
rgbInfoValue = |
SQL_BOOKMARK_PERSISTENCE |
rgbInfoValue = |
SQL_CATALOG_LOCATION |
rgbInfoValue = 1 (SQL_CL_START) |
SQL_CATALOG_NAME_SEPARATOR |
rgbInfoValue = "." |
SQL_CATALOG_TERM |
rgbInfoValue = "Qualifier" |
SQL_CATALOG_USAGE |
rgbInfoValue = 0x00000000 |
SQL_COLUMN_ALIAS |
rgbInfoValue = "Y" |
SQL_CONCAT_NULL_BEHAVIOR |
rgbInfoValue = 0 (SQL_CB_NULL) |
SQL_CONVERT_BIGINT |
|
SQL_CONVERT_BINARY |
|
SQL_CONVERT_BIT |
|
SQL_CONVERT_CHAR |
|
SQL_CONVERT_DATE |
|
SQL_CONVERT_DECIMAL |
|
SQL_CONVERT_DOUBLE |
|
SQL_CONVERT_FLOAT |
|
SQL_CONVERT_FUNCTIONS |
rgbInfoValue = 0x00000000L |
SQL_CONVERT_INTEGER |
|
SQL_CONVERT_LONGVARBINARY |
rgbInfoValue = 0x00000000L |
SQL_CONVERT_LONGVARCHAR |
|
SQL_CONVERT_NUMERIC |
|
SQL_CONVERT_REAL |
|
SQL_CONVERT_SMALLINT |
|
SQL_CONVERT_TIME |
|
SQL_CONVERT_TIMESTAMP |
|
SQL_CONVERT_TINYINT |
|
SQL_CONVERT_VARBINARY |
|
SQL_CONVERT_VARCHAR |
|
SQL_CORRELATION_NAME |
rgbInfoValue = 2 (SQL_CN_ANY) |
SQL_CURSOR_COMMIT_BEHAVIOR |
rgbInfoValue = |
SQL_CURSOR_ROLLBACK_BEHAVIOR |
rgbInfoValue = |
SQL_DATA_SOURCE_NAME |
rgbInfoValue = (Name of the opened data source) |
SQL_DATA_SOURCE_READ_ONLY |
rgbInfoValue = "N" |
SQL_DBMS_NAME |
rgbInfoValue = "MaxDB" |
SQL_DBMS_VER |
rgbInfoValue = "07.06.nnn" |
SQL_DEFAULT_TXN_ISOLATION |
rgbInfoValue = SQL_TXN_READ_COMMITTED |
SQL_DRIVER_HDBC |
rgbInfoValue = (Handle of the driver logon) |
SQL_DRIVER_HENV |
rgbInfoValue = (Handle of the driver environment) |
SQL_DRIVER_HLIB |
rgbInfoValue = (Handle of the library) |
SQL_DRIVER_HSTMT |
rgbInfoValue = (Handle of the driver statement) |
SQL_DRIVER_NAME |
rgbInfoValue = "sqlod32.dll", "libsqlod.so" (UNIX) |
SQL_DRIVER_ODBC_VER |
rgbInfoValue = "03.51" |
SQL_DRIVER_ODBC_VER |
rgbInfoValue = (Version of the driver manager > 3.51) |
SQL_DRIVER_VER |
rgbInfoValue = "7.<minor_version>.<correction_level>b<build_number>" |
SQL_EXPRESSIONS_IN_ORDERBY |
rgbInfoValue = "N" |
SQL_FETCH_DIRECTION |
rgbInfoValue = |
SQL_FILE_USAGE |
rgbInfoValue = 0 (SQL_FILE_NOT_SUPPORTED) |
SQL_GETDATA_EXTENSIONS |
rgbInfoValue = |
SQL_GROUP_BY |
rgbInfoValue = SQL_GB_GROUP_BY_CONTAINS_SELECT |
SQL_IDENTIFIER_CASE |
rgbInfoValue = 1 (SQL_IC_UPPER) |
SQL_IDENTIFIER_QUOTE_CHAR |
rgbInfoValue = "\"" |
SQL_INTEGRITY |
rgbInfoValue = "N" |
SQL_KEYWORDS |
rgbInfoValue = (List of key words, depends on SQLMode) |
SQL_LIKE_ESCAPE_CLAUSE |
rgbInfoValue = "Y" |
SQL_LOCK_TYPES |
rgbInfoValue = 1 SQL_LCK_NO_CHANGE |
SQL_MAX_BINARY_LITERAL_LEN |
rgbInfoValue = 0 |
SQL_MAX_CATALOG_NAME_LEN |
rgbInfoValue = 0 |
SQL_MAX_CHAR_LITERAL_LEN |
rgbInfoValue = 0 |
SQL_MAX_COLUMN_NAME_LEN |
rgbInfoValue = 32 |
SQL_MAX_COLUMNS_IN_GROUP_BY |
rgbInfoValue = 128 |
SQL_MAX_COLUMNS_IN_INDEX |
rgbInfoValue = 16 |
SQL_MAX_COLUMNS_IN_ORDER_BY |
rgbInfoValue = 128 |
SQL_MAX_COLUMNS_IN_SELECT |
rgbInfoValue = 1023 |
SQL_MAX_COLUMNS_IN_TABLE |
rgbInfoValue = 1023 |
SQL_MAX_CONCURRENT_ACTIVITIES |
rgbInfoValue = 32767 |
SQL_MAX_CURSOR_NAME_LEN |
rgbInfoValue = 32 |
SQL_MAX_DRIVER_CONNECTIONS |
rgbInfoValue = 0 |
SQL_MAX_INDEX_SIZE |
rgbInfoValue = 1024 |
SQL_MAX_OWNER_NAME_LEN |
rgbInfoValue = 32 |
SQL_MAX_PROCEDURE_NAME_LEN |
rgbInfoValue = 32 |
SQL_MAX_QUALIFIER_NAME_LEN |
rgbInfoValue = 0 |
SQL_MAX_ROW_SIZE |
rgbInfoValue = 0 |
SQL_MAX_ROW_SIZE_INCLUDES_LONG |
rgbInfoValue = "N" |
SQL_MAX_SCHEMA_NAME_LEN |
rgbInfoValue = 32 |
SQL_MAX_STATEMENT_LEN |
rgbInfoValue = 0 |
SQL_MAX_TABLE_NAME_LEN |
rgbInfoValue = 32 |
SQL_MAX_TABLES_IN_SELECT |
rgbInfoValue = 64 |
SQL_MAX_USER_NAME_LEN |
rgbInfoValue = 32 |
SQL_MULT_RESULT_SETS |
rgbInfoValue = "N" |
SQL_MULTIPLE_ACTIVE_TXN |
rgbInfoValue = "Y" |
SQL_NEED_LONG_DATA_LEN |
rgbInfoValue = "N" |
SQL_NON_NULLABLE_COLUMN |
rgbInfoValue = 1 (SQL_NNC_NON_NULL) |
SQL_NULL_COLLATION |
rgbInfoValue = 1 (SQL_NC_LOW) |
SQL_NUMERIC_FUNCTIONS |
rgbInfoValue = |
SQL_ODBC_API_CONFORMANCE |
rgbInfoValue = 2 (SQL_OAC_LEVEL2) |
SQL_ODBC_SAG_CLI_CONFORMANCE |
rgbInfoValue = 1 (SQL_OSCC_COMPLIANT) |
SQL_ODBC_SQL_CONFORMANCE |
rgbInfoValue = 2 (SQL_OSC_EXTENDED) |
SQL_ODBC_SQL_OPT_IEF |
rgbInfoValue = "N" |
SQL_ODBC_VER |
rgbInfoValue = "03.520000" |
SQL_ORDER_BY_COLUMNS_IN_SELECT |
rgbInfoValue = "N" |
SQL_OUTER_JOINS |
rgbInfoValue = "Y" |
SQL_OWNER_TERM |
rgbInfoValue = "Schema" |
SQL_OWNER_USAGE |
rgbInfoValue = |
SQL_POS_OPERATIONS |
rgbInfoValue = |
SQL_POSITIONED_STATEMENTS |
rgbInfoValue = |
SQL_PROCEDURE_TERM |
rgbInfoValue = "stored procedure" |
SQL_PROCEDURES |
rgbInfoValue = "Y" |
SQL_QUALIFIER_LOCATION |
rgbInfoValue = 1 (SQL_CL_START) |
SQL_QUALIFIER_NAME_SEPARATOR |
rgbInfoValue = "." |
SQL_QUALIFIER_TERM |
rgbInfoValue = "Qualifier" |
SQL_QUALIFIER_USAGE |
rgbInfoValue = 0x00000000 |
SQL_QUOTED_IDENTIFIER_CASE |
rgbInfoValue = 3 (SQL_IC_SENSITIVE) |
SQL_ROW_UPDATES |
rgbInfoValue = "Y" |
SQL_SCHEMA_TERM |
rgbInfoValue = "Schema" |
SQL_SCHEMA_USAGE |
rgbInfoValue = |
SQL_SCROLL_CONCURRENCY |
rgbInfoValue = |
SQL_SCROLL_OPTIONS |
rgbInfoValue = |
SQL_SEARCH_PATTERN_ESCAPE |
rgbInfoValue = "\" |
SQL_SERVER_NAME |
rgbInfoValue = (Name of the database computer) |
SQL_SPECIAL_CHARACTERS |
rgbInfoValue = "#@$" |
SQL_STATIC_SENSITIVITY |
rgbInfoValue = 0x00000000 |
SQL_STRING_FUNCTIONS |
rgbInfoValue = |
SQL_SUBQUERIES |
rgbInfoValue = |
SQL_SYSTEM_FUNCTIONS |
rgbInfoValue = |
SQL_TABLE_TERM |
rgbInfoValue = "Table" |
SQL_TIMEDATE_ADD_INTERVALS |
rgbInfoValue = 0x00000000 |
SQL_TIMEDATE_DIFF_INTERVALS |
rgbInfoValue = 0x00000000 |
SQL_TIMEDATE_FUNCTIONS |
rgbInfoValue = |
SQL_TXN_CAPABLE |
rgbInfoValue = 2 (SQL_TC_ALL) |
SQL_TXN_ISOLATION_OPTION |
rgbInfoValue = |
SQL_UNION |
rgbInfoValue = |
SQL_USER_NAME |
rgbInfoValue = (Name of the active user) |