SQLGetInfo (Extension Level 1)

[This is preliminary documentation and subject to change.]

Information Type Returns
SQL_ACCESSIBLE_PROCEDURES 'Y' - SQLProcedures is unsupported.
SQL_ACCESSIBLE_TABLES 'Y' - Can select on all tables returned by SQLTables.
SQL_ACTIVE_CONNECTIONS 0 - Maximum number of active connections that the driver can support (0 means no limit) .
SQL_ACTIVE_STATEMENTS 0 - Maximum number of active statements on a given connection (0 means no limit)
SQL_ALTER_TABLE 0X0000 - A bitmask indicating how the columns of a table can be altered
SQL_BOOKMARK_PERSISTENCE 0x0000 - A bitmask indicating persistence of bookmarks. The adapter does not support bookmarks
SQL_COLUMN_ALIAS 'N' - The adapter does not support column aliasing.
SQL_CONCAT_NULL_BEHAVIOR SQL_CB_NON_NULL - The result is the concatenation of non-null valued column or columns.
SQL_CONVERT_XXXXXXXXX 0X0000 - The adapter does not support the Convert Scalar Function
SQL_CONVERT_FUNCTIONS 0X0000 - The adapter does not support the Convert Scalar Functions.
SQL_CORRELATION_NAME SQL_CN_ANY - The correlation name can be any user-defined name.
SQL_CURSOR_COMMIT_BEHAVIOR SQL_CB_CLOSE - Close cursor after a commit operation. Cursors are unsupported.
SQL_CURSOR_COMMIT_BEHAVIOR SQL_CB_CLOSE - Close Cursor after a rollback operation. Cursors are unsupported.
SQL_DATA_SOURCE_NAME The data source name.
SQL_DATA_SOURCE_READONLY 'Y'
SQL_DATABASE_NAME See SQL_CURRENT_QUALIFIER
SQL_DBMS_NAME This returns MOServer@ServerName. ServerName is obtained from a standard WBEM class
SQL_DBMS_VER This returns the version number of the MO Server. This can be obtained from a standard WBEMclass
SQL_DEFAULT_TXN_ISOLATION 0x0000 - The adapter does not support transactions
SQL_DRIVER_HDBC Implemented by the Driver Manager. It returns the adapter's connection handle.
SQL_DRIVER_HENV Implemented by the Driver Manager. It returns the adapter's environment handle.
SQL_DRIVER_HLIB Implemented by the Driver Manager. The library handle returned to the Driver Manager when it loaded the adapter library.
SQL_DRIVER_HSTMT Implemented by the Driver Manager. It returns the adapter's statement handle.
SQL_DRIVER_NAME WBEM DR32.DLL
SQL_DRIVER_ODBC_VERSION "02.10.0000"
SQL_EXPRESSION_IN_ORDERBY "n" - The adapter does not support expressions in the ORDER BY clause
SQL_FETCH_DIRECTION 0x0000 - The adapter does not support cursors.
SQL_FILE_USAGE SQL_FILE_NOT_SUPPORTED - The adapter is not a single-tier adapter
SQL_GETDATA_EXTENSIONS SQL_GD_ANY_COLUMN | SQLGD_ANY_ORDER | SQL_GD_BOUND
SQL_GROUP_BY SQL_GROUP_BY_NOT_SUPPORTED. The Core SQL Grammar does not require support for GROUP BY.
SQL_IDENTIFIER_CASE SQL_IC_MIXED - This means identifiers are case insensitive and are stored in the system catalog in mixed case, which is how WBEM treats class and property names.
SQL_IDENTIFIER_QUOTE_CHAR "\""
SQL_KEYWORDS "" - No data source-specific keywords
SQL_LIKE_ESCAPE_CLAUSE "N" - No escape support for % and _ in a LIKE predicate.
SQL_LOCK_TYPES 0x0000
SQL_MAX_BINARY_LITERAL_LEN 0L - No limit on a binary literal in a SQL statement.
SQL_MAX_CHAR_LITERAL_LEN Set to 255.
SQL_MAX_COLUMN_NAME_LEN 0 - no limit.
SQL_MAX_COLUMNS_IN GROUP_BY 0 - No limit. Does not matter, as GROUP BY is not supported.
SQL_MAX_COLUMNS_IN_INDEX 0 - No limit. Does not matter, as indexes are not supported.
SQL_MAX_COLUMNS_IN_ORDER_BY Set to 20.
SQL_MAX_COLUMNS_IN_SELECT 0 - No limit on the number of columns in a select.
SQL_MAX_COLUMNS_IN_TABLE 0 - No limit on the number of columns in a table.
SQL_MAX_CURSOR_NAME_LEN Set to 19.
SQL_MAXINDEX_SIZE 0 - No limit
SQL_MAX_OWNER_NAME_LEN 0 - No limit
SQL_MAX_PROCEDURE_NAME_LEN 0 - No limit. Does not matter, as the adapter does not support procedures.
SQL_MAX_QUALIFIER_NAME_LEN 0 - No limit.
SQL_MAX_ROW_SIZE 0 - No limit.
SQL_MAX_ROW_SIZE_INCLUDES_LONG "Y" - The maximum row size returned by SQL_MAX_ROW_SIZE includes the length of SQL_LONG_VARCHAR and SQL_LONGVARBINARY
SQL_MAX_STATEMENT_LEN 0L - No limit on the size of a SQL Statement.
SQL_MAX_TABLE_NAME_LEN 128
SQL_MAX_TABLES_IN_SELECT 0 - No limit on the number of tables in select statement.
SQL_MAX_USER_NAME_LEN Set to 63.
SQL_MULT_RESULT_SETS "N" - The adapter does not support multiple result sets.
SQL_MULTIPLE_ACTIVE_TXN "N" - Does not matter, as transactions are not supported.
SQL_NEED_LONG_DATA_LEN "N" - Need to check into this.
SQL_NON_NULLABLE_COLUMNS SQL_NNC_NON_NULL
SQL_NULL_COLLATION SQL_NC_LOW - NULLs are sorted at the low end of a list.
SQL_NUMERIC_FUNCTIONS 0x0000 - The adapter does not support scalar numeric functions.
SQL_ODBC_API_CONFORMANCE SQL_OAC_LEVEL
SQL_ODBC_SAG_CLI_CONFORMANCE SQL_OSCC_COMPLIANT
SQL_ODBC_SQL_CONFORMANCE SQL_OSC_MINIMUM (in spite of not supporting CREATE, and so forth.)
SQL_ODBC_OPT_IEF "N" - The adapter does not support Integrity Enhancement Facility.
SQL_DRIVER_VER "01.00.0000"
SQL_ORDER_BY_COLUMNS_IN_SELECT "N" - The columns in the ORDER BY clause do not need to be in the select list.
SQL_OUTER_JOINS "N" - The data source does not support outer joins
SQL_OWNER_TERM "" - This is a character string with the data source vendor's name for an owner.
SQL_OWNER_USAGE 0x0000 - The owner is not supported in any statements.
SQL_POS_OPERATIONS 0x0000 - Does not have cursors.
SQL_POSITIONED_STATEMENTS 0x0000 - Does not have cursors.
SQL_PROCEDURE_TERM "" - The adapter does not support procedures.
SQL_PROCEDURES "N" - The adapter does not support procedures.
SQL_QUALIFIER_LOCATION SQL_QL_START - The qualifier comes first in a qualified table name; for example, we say Wellfleet.TcpConnectionTable, and not TcpConnectionTable.Wellfleet
SQL_QUALIFIER_NAME_SEPARATOR "."
SQL_QUALIFIER_TERM "Namespace"
SQL_QUALIFIER_USAGE SQL_QU_DML_STATEMENTS, at least. For example, in all DML statements to allow it in SELECTs. You can use the logical OR with SQL_QU_PROCEDURE_INVOCATION and SQL_QU_TABLE_DEFINITION and SQL_QU_INDEX_DEFINITION, but since the adapter does not support procedures, table creation, or indexes, these items are not relevant.
SQL_QUOTED_IDENTIFIER_CASE SQL_IC_MIXED - Quoted identifiers are case-insensitive, and are stored in mixed case.
SQL_ROW_UPDATES "N" - The adapter does not support scrollable cursors.
SQL_SCROLL_CONCURRENCY 0x0000 - The adapter does not support scrollable cursors.
SQL_SCROLL_OPTIONS 0x0000 - The adapter does not support scrollable cursors.
SQL_SEARCH_PATTERN_ESCAPE "\" is a search pattern escape character for % and _.
SQL_SERVER_NAME "" - Unnecessary
SQL_SPECIAL_CHARACTERS "" - This is a string that contains all the special characters (such as characters not in a-z, A-Z, 0-9) that can be included in a table name.
SQL_STATIC_SENSITIVITY 0x0000 - The adapter does not support cursors.
SQL_STRING_FUNCTIONS 0x0000 - The adapter does not support scalar string functions.
SQL_SUBQUERIES 0x0000 - The adapter does not support sub-queries in predicates.
SQL_SYSTEM_FUNCTIONS 0x0000 - The adapter does not support system scalar functions.
SQL_TABLE_TERM "Class"
SQL_TIMEDATE_ADD_INTERVALS 0x0000 - The adapter does not support the TIMESTAMPADD Scalar function.
SQL_TIMEDATE_DIFF_INTERVALS 0x0000 - The adapter does not support the TIMESTAMPDIFF Scalar function.
SQL_TIMEDATE_FUNCTIONS 0x0000 - The adapter does not support the TIMESTAMPXXXX Scalar functions.
SQL_TXN_CAPABLE SQL_TC_NONE - The adapter does not support transactions.
SQL_TXN_ISOLATION_OPTION 0x0000 - The adapter does not support transactions.
SQL_UNION 0x0000 - The Data Source does not support the UNION clause.
SQL_USER_NAME "" - Not applicable.