SQLGetInfo (Extension Level 1)

The following table lists the information type values for the SQLGetInfo function.

ValueMeaning
SQL_ACCESSIBLE_PROCEDURESReturns: 'Y'

The SQLProcedures function is unsupported.

SQL_ACCESSIBLE_TABLESReturns: 'Y'

Can be selected on all tables that are returned by SQLTables.

SQL_ACTIVE_CONNECTIONSReturns: 0

Maximum number of active connections that the adapter can support (0 means no limit).

SQL_ACTIVE_STATEMENTSReturns: 0

Maximum number of active statements on a given connection (0 means no limit).

SQL_ALTER_TABLEReturns: 0X0000

Bitmask that indicates how the columns of a table can be altered.

SQL_BOOKMARK_PERSISTENCEReturns: 0x0000

Bitmask that indicates the persistence of bookmarks. The adapter does not support bookmarks.

SQL_COLUMN_ALIASReturns: 'N'

Adapter does not support column aliasing.

SQL_CONCAT_NULL_BEHAVIORReturns: SQL_CB_NON_NULL

Result is the concatenation of non-null valued columns.

SQL_CONVERT_XXXXXXXXXReturns: 0X0000

Adapter does not support the CONVERT scalar function.

SQL_CONVERT_FUNCTIONSReturns: 0X0000

Adapter does not support the CONVERT scalar function.

SQL_CORRELATION_NAMEReturns: SQL_CN_ANY

Correlation name can be any user-defined name.

SQL_CURSOR_COMMIT_BEHAVIORReturns: SQL_CB_CLOSE

Closes cursor after a commit operation. Cursors are unsupported.

SQL_CURSOR_ROLLBACK_BEHAVIORReturns: SQL_CB_CLOSE

Closes cursor after a rollback operation. Cursors are unsupported.

SQL_DATA_SOURCE_NAMEReturns: Data source name
SQL_DATA_SOURCE_READONLYReturns: 'Y'
SQL_DATABASE_NAMESee SQL_CURRENT_QUALIFIER.
SQL_DBMS_NAMEReturns: MOServer@ServerName.

ServerName is obtained from a standard WMI class.

SQL_DBMS_VERReturns: version number of the MO Server

The version number can be obtained from a standard WMI class.

SQL_DEFAULT_TXN_ISOLATIONReturns: 0x0000

Adapter does not support transactions.

SQL_DRIVER_HDBCReturns: adapter's connection handle

Implemented by the ODBC Driver Manager.

SQL_DRIVER_HENVReturns: adapter's environment handle

Implemented by the ODBC Driver Manager.

SQL_DRIVER_HLIBReturns: library handle returned to the ODBC Driver Manager when the manager loaded the adapter library

Implemented by the ODBC Driver Manager.

SQL_DRIVER_HSTMTReturns: adapter's statement handle

Implemented by the ODBC Driver Manager.

SQL_DRIVER_NAMEReturns: WBEMDR32.DLL
SQL_DRIVER_ODBC_VERSIONReturns: "02.10.0000"
SQL_EXPRESSION_IN_ORDERBYReturns: "N"

Adapter does not support expressions in the ORDER BY clause.

SQL_FETCH_DIRECTIONReturns: 0x0000

Adapter does not support cursors.

SQL_FILE_USAGEReturns: SQL_FILE_NOT_SUPPORTED

Adapter is not a single-tier adapter.

SQL_GETDATA_EXTENSIONSReturns: SQL_GD_ANY_COLUMN | SQLGD_ANY_ORDER | SQL_GD_BOUND
SQL_GROUP_BYReturns: SQL_GROUP_BY_CONTAINS_SELECT

The GROUP BY clause must contain all non-aggregated columns in the select list, and it can contain columns that are not in the select list.

SQL_IDENTIFIER_CASEReturns: SQL_IC_MIXED

Identifiers are case-insensitive and are stored in the system catalog in mixed case, which is how WMI treats class and property names.

SQL_IDENTIFIER_QUOTE_CHARReturns: "\"
SQL_KEYWORDSReturns: ""

No data-source specific keywords.

SQL_LIKE_ESCAPE_CLAUSEReturns: "N".

No escape support for % and _ in a LIKE predicate.

SQL_LOCK_TYPESReturns: 0x0000
SQL_MAX_BINARY_LITERAL_LENReturns: 0L

No limit on a binary literal in a SQL statement.

SQL_MAX_CHAR_LITERAL_LENSet to 255.
SQL_MAX_COLUMN_NAME_LENReturns: 0

No limit.

SQL_MAX_COLUMNS_IN_GROUP_BYSet to 20.
SQL_MAX_COLUMNS_IN_INDEXReturns: 0

No limit. The limit does not matter because indexes are not supported.

SQL_MAX_COLUMNS_IN_ORDER_BYSet to 20.
SQL_MAX_COLUMNS_IN_SELECTReturns: 0

No limit on the number of columns in a SELECT statement.

SQL_MAX_COLUMNS_IN_TABLEReturns: 0

No limit on the number of columns in a table.

SQL_MAX_CURSOR_NAME_LENSet to 19.
SQL_MAXINDEX_SIZEReturns: 0

No limit.

SQL_MAX_OWNER_NAME_LENReturns: 0

No limit.

SQL_MAX_PROCEDURE_NAME_LENReturns: 0

No limit. The limit does not matter because the adapter does not support procedures.

SQL_MAX_QUALIFIER_NAME_LENReturns: 0

No limit.

SQL_MAX_ROW_SIZEReturns: 0

No limit.

SQL_MAX_ROW_SIZE_INCLUDES_LONGReturns: "Y"

Maximum row size returned by SQL_MAX_ROW_SIZE includes the length of SQL_LONG_VARCHAR and SQL_LONGVARBINARY.

SQL_MAX_STATEMENT_LENReturns: 0L

No limit on the size of an SQL statement.

SQL_MAX_TABLE_NAME_LENReturns: 128
SQL_MAX_TABLES_IN_SELECTReturns: 0

No limit on the number of tables in a SELECT statement.

SQL_MAX_USER_NAME_LENSet to 63.
SQL_MULT_RESULT_SETSReturns: "N"

Adapter does not support multiple result sets.

SQL_MULTIPLE_ACTIVE_TXNReturns: "N"

This value not matter as transactions are not supported.

SQL_NEED_LONG_DATA_LENReturns: "N"
SQL_NON_NULLABLE_COLUMNSReturns: SQL_NNC_NON_NULL
SQL_NULL_COLLATIONReturns: SQL_NC_LOW

NULLs are sorted at the low end of a list.

SQL_NUMERIC_FUNCTIONSReturns one of the following:
SQL_FN_NUM_ABS
SQL_FN_NUM_ACOS
SQL_FN_NUM_ASIN
SQL_FN_NUM_ATAN
SQL_FN_NUM_ATAN2
SQL_FN_NUM_CEILING
SQL_FN_NUM_COS
SQL_FN_NUM_COT
SQL_FN_NUM_DEGREES
SQL_FN_NUM_EXP
SQL_FN_NUM_FLOOR
SQL_FN_NUM_LOG
SQL_FN_NUM_LOG10
SQL_FN_NUM_MOD
SQL_FN_NUM_PI
SQL_FN_NUM_POWER
SQL_FN_NUM_RADIANS
SQL_FN_NUM_RAND
SQL_FN_NUM_ROUND
SQL_FN_NUM_SIGN
SQL_FN_NUM_SIN
SQL_FN_NUM_SQRT
SQL_FN_NUM_TRUNCATE
SQL_FN_NUM_TAN
SQL_ODBC_API_CONFORMANCEReturns: SQL_OAC_LEVEL
SQL_ODBC_SAG_CLI_CONFORMANCEReturns: SQL_OSCC_COMPLIANT
SQL_ODBC_SQL_CONFORMANCEReturns: SQL_OSC_MINIMUM
SQL_ODBC_OPT_IEFReturns: "N"

Adapter does not support the Integrity Enhancement Facility (a subset of SQL that is designed to maintain the integrity of a database).

SQL_DRIVER_VERReturns: "01.00.0000"
SQL_ORDER_BY_COLUMNS_IN_SELECTReturns: "N"

Columns in the ORDER BY clause do not must be in the select list.

SQL_OUTER_JOINSReturns: "Y"
SQL_OWNER_TERMReturns: ""

Character string with the data source vendor's name for an owner.

SQL_OWNER_USAGEReturns: 0x0000

Owner is not supported in any statements.

SQL_POS_OPERATIONSReturns: 0x0000

Adapter does not have cursors.

SQL_POSITIONED_STATEMENTSReturns: 0x0000

Adapter does not have cursors.

SQL_PROCEDURE_TERMReturns: ""

Adapter does not support procedures.

SQL_PROCEDURESReturns: "N"

Adapter does not support procedures.

SQL_QUALIFIER_LOCATIONReturns: SQL_QL_START

Qualifier comes first in a qualified table name; for example, Wellfleet.TcpConnectionTable, and not TcpConnectionTable.Wellfleet.

SQL_QUALIFIER_NAME_SEPARATORReturns: "."
SQL_QUALIFIER_TERMReturns: "Namespace"
SQL_QUALIFIER_USAGEReturns: SQL_QU_DML_STATEMENTS, at least

For example, all DML statements allow this type in SELECT statements. You can use the logical OR with SQL_QU_PROCEDURE_INVOCATION, SQL_QU_TABLE_DEFINITION, and SQL_QU_INDEX_DEFINITION, but because the adapter does not support procedures, table creation, or indexes, these items are not relevant.

SQL_QUOTED_IDENTIFIER_CASEReturns: SQL_IC_MIXED

Quoted identifiers are case-insensitive and are stored in mixed case.

SQL_ROW_UPDATESReturns: "N"

Adapter does not support scrollable cursors.

SQL_SCROLL_CONCURRENCYReturns: 0x0000

Adapter does not support scrollable cursors.

SQL_SCROLL_OPTIONSReturns: 0x0000

Adapter does not support scrollable cursors.

SQL_SEARCH_PATTERN_ESCAPEReturns: "\"

Search pattern escape character for % and _.

SQL_SERVER_NAMEReturns: ""

Not needed.

SQL_SPECIAL_CHARACTERSReturns: ""

String 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_SENSITIVITYReturns: 0x0000

Adapter does not support cursors.

SQL_STRING_FUNCTIONSReturns one of the following:
SQL_FN_STR_ASCII
SQL_FN_STR_CHAR
SQL_FN_STR_CONCAT
SQL_FN_STR_DIFFERENCE
SQL_FN_STR_INSERT
SQL_FN_STR_LCASE
SQL_FN_STR_LEFT
SQL_FN_STR_LENGTH
SQL_FN_STR_LOCATE
SQL_FN_STR_LOCATE2
SQL_FN_STR_LTRIM
SQL_FN_STR_REPEAT
SQL_FN_STR_REPLACE
SQL_FN_STR_RIGHT
SQL_FN_STR_RTRIM
SQL_FN_STR_SOUNDEX
SQL_FN_STR_SPACE
SQL_FN_STR_SUBSTRING
SQL_FN_STR_UCASE
SQL_SUBQUERIESReturns: 0x0000

Adapter does not support sub-queries in predicates.

SQL_SYSTEM_FUNCTIONSReturns one of the following:
SQL_FN_SYS_DBNAME
SQL_FN_SYS_IFNULL
SQL_FN_SYS_USERNAME
SQL_TABLE_TERMReturns: "Class"
SQL_TIMEDATE_ADD_INTERVALSReturns one of the following:
SQL_FN_TSI_SECOND
SQL_FN_TSI_MINUTE
SQL_FN_TSI_HOUR
SQL_FN_TSI_DAY
SQL_FN_TSI_WEEK
SQL_FN_TSI_MONTH
SQL_FN_TSI_QUARTER
SQL_FN_TSI_YEAR
SQL_TIMEDATE_DIFF_INTERVALSReturns one of the following:
SQL_FN_TSI_SECOND
SQL_FN_TSI_MINUTE
SQL_FN_TSI_HOUR
SQL_FN_TSI_DAY
SQL_FN_TSI_WEEK
SQL_FN_TSI_MONTH
SQL_FN_TSI_QUARTER
SQL_FN_TSI_YEAR
SQL_TIMEDATE_FUNCTIONSReturns one of the following:
SQL_FN_TD_CURDATE
SQL_FN_TD_CURTIME
SQL_FN_TD_DAYNAME
SQL_FN_TD_DAYOFWEEK
SQL_FN_TD_DAYOFMONTH
SQL_FN_TD_DAYOFYEAR
SQL_FN_TD_HOUR
SQL_FN_TD_MINUTE
SQL_FN_TD_MONTH
SQL_FN_TD_MONTHNAME
SQL_FN_TD_NOW
SQL_FN_TD_QUARTER
SQL_FN_TD_SECOND
SQL_FN_TD_TIMESTAMPADD
SQL_FN_TD_TIMESTAMPDIFF
SQL_FN_TD_WEEK
SQL_FN_TD_YEAR
SQL_TXN_CAPABLEReturns: SQL_TC_NONE

Adapter does not support transactions.

SQL_TXN_ISOLATION_OPTIONReturns: 0x0000

Adapter does not support transactions.

SQL_UNIONReturns: 0x0000

Data source does not support the UNION clause.

SQL_USER_NAMEReturns: ""

Not applicable.

 

Note  For more information about support or requirements for installation on a specific operating system, see Operating System Availability of WMI Components.

 

 

Show: