The following table lists the C language #defines for the fInfoType argument and the corresponding values that are returned by SQLGetInfo when connected to SQL Server 6.x. An application retrieves this information by passing the listed C language #defines to SQLGetInfo in the fInfoType argument.
fInfoType argument (#define) | Value returned by SQLGetInfo |
---|---|
SQL_ACCESSIBLE_PROCEDURES | Y |
SQL_ACCESSIBLE_TABLES | Y |
SQL_ACTIVE_CONNECTIONS | 0 (The number of active connections is determined by the number of network connections available on the client computer and the number of connections allowed by the server DBMS.) |
SQL_ACTIVE_STATEMENTS | 1 (Even though this value is 1, the driver supports multiple active statements on a connection if server cursors are being used. For more information, see Using ODBC Cursors.) |
SQL_ALTER_TABLE | SQL_AT_ADD_COLUMN |
SQL_BOOKMARK_PERSISTENCE | 0 |
SQL_COLUMN_ALIAS | Y |
SQL_CONCAT_NULL_BEHAVIOR | SQL_CB_NON_NULL |
SQL_CONVERT_FUNCTIONS | SQL_FN_CVT_CONVERT |
SQL_CONVERT_type where type is the SQL datatype, such as CHAR |
For more information, see the Datatype Mapping_and_Usage topic. |
SQL_CORRELATION_NAME | SQL_CN_ANY |
SQL_CURSOR_COMMIT_BEHAVIOR | SQL_CB_CLOSE (This is the ANSI-specified behavior. Because many applications need to preserve server cursor currency across commits/rollbacks, the driver provides a driver-specific option, SQL_PRESERVE_CURSORS, to override the ANSI default.) |
SQL_CURSOR_ROLLBACK _BEHAVIOR |
SQL_CB_CLOSE (This is the ANSI-specified behavior. Recognizing the need for many applications to preserve server cursor currency across commits/rollbacks, the driver provides a driver-specific option, SQL_PRESERVE_CURSORS, to override the ANSI default.) |
SQL_DBMS_NAME | Microsoft SQL Server |
SQL_DEFAULT_TXN_ISOLATION | SQL_TXN_READ_COMMITTED |
SQL_DRIVER_NAME | SQLSRVR.DLL (16-bit) SQLSRV32.DLL (32-bit) |
SQL_DRIVER_ODBC_VER | 02.50 |
SQL_DRIVER_VER | 02.65.nnnn (where nnnn specifies the build number) |
SQL_EXPRESSIONS_IN_ORDERBY | Y |
SQL_FETCH_DIRECTION | SQL_FD_FETCH_NEXT SQL_FD_FETCH_FIRST SQL_FD_FETCH_LAST SQL_FD_FETCH_PRIOR SQL_FD_FETCH_ABSOLUTE SQL_FD_FETCH_RELATIVE SQL_FD_FETCH_BOOKMARK |
SQL_FILE_USAGE | SQL_FILE_NOT_SUPPORTED |
SQL_GETDATA_EXTENSIONS | SQL_GD_BLOCK |
SQL_GROUP_BY | SQL_GB_GROUP_BY_CONTAINS _SELECT |
SQL_IDENTIFIER_CASE | (Depends on whether SQL Server was installed as case-sensitive or case-insensitive.) |
SQL_IDENTIFIER_QUOTE_CHAR | " (Double quote) |
SQL_KEYWORDS | BREAK BROWSE BULK CHECKPOINT CLUSTERED COMMITTED COMPUTE CONFIRM CONTROLROW DATABASE DBCC DISK DUMMY DUMP ERRLVL ERROREXIT EXIT EXPIREDATE FILE FILLFACTOR FLOPPY GETDEFAULT HOLDLOCK IDENTITY_INSERT IDENTITYCOL IF KILL LINENO LOAD MIRROREXIT NONCLUSTERED OFF OFFSETS ONCE OVER PERM PERMANENT PLAN PROC PROCESSEXIT PUBLIC RAISERROR READ READTEXT RECONFIGURE REPEATABLE RETAINDATE RETURN ROWCOUNT RULE SAVE SERIALIZABLE SETUSER SHUTDOWN STATISTICS TAPE TEMP TEXTSIZE TRAN TRIGGER TRUNCATE TSEQUEL UNCOMMITTED UPDATETEXT USE VOLUME WAITFOR WHILE WRITETEXT |
SQL_LIKE_ESCAPE_CLAUSE | Y |
SQL_LOCK_TYPES | SQL_LCK_NO_CHANGE |
SQL_MAX_BINARY_LITERAL_LEN | 131072 |
SQL_MAX_CHAR_LITERAL_LEN | 131072 |
SQL_MAX_COLUMN_NAME_LEN | 30 |
SQL_MAX_COLUMNS_IN_GROUP _BY |
16 |
SQL_MAX_COLUMNS_IN_INDEX | 16 |
SQL_MAX_COLUMNS_IN_ORDER _BY |
16 |
SQL_MAX_COLUMNS_IN_SELECT | 4000 |
SQL_MAX_COLUMNS_IN_TABLE | 250 |
SQL_MAX_CURSOR_NAME_LEN | 30 |
SQL_MAX_INDEX_SIZE | 900 |
SQL_MAX_OWNER_NAME_LEN | 30 |
SQL_MAX_PROCEDURE_NAME _LEN |
36 (1 to 30 characters followed by a semicolon [;] and one to five digits) |
SQL_MAX_QUALIFIER_NAME_LEN | 30 |
SQL_MAX_ROW_SIZE | 1962 |
SQL_MAX_ROW_SIZE_INCLUDES _LONG |
N |
SQL_MAX_STATEMENT_LEN | 131072 |
SQL_MAX_TABLE_NAME_LEN | 30 |
SQL_MAX_TABLES_IN_SELECT | 16 |
SQL_MAX_USER_NAME_LEN | 30 |
SQL_MULT_RESULT_SETS | Y |
SQL_MULTIPLE_ACTIVE_TXN | Y |
SQL_NEED_LONG_DATA_LEN | Y |
SQL_NON_NULLABLE_COLUMNS | SQL_NNC_NON_NULL |
SQL_NULL_COLLATION | SQL_NC_LOW |
SQL_NUMERIC_FUNCTIONS | 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_TAN |
SQL_ODBC_API_CONFORMANCE | SQL_OAC_LEVEL2 |
SQL_ODBC_SAG_CLI _CONFORMANCE |
SQL_OSCC_NOT_COMPLIANT |
SQL_ODBC_SQL_CONFORMANCE | SQL_OSC_CORE |
SQL_ODBC_SQL_OPT_IEF | Y |
SQL_ORDER_BY_COLUMNS_IN _SELECT |
N |
SQL_OJ_CAPABILITIES | SQL_OJ_LEFT SQL_OJ_RIGHT SQL_OJ_FULL SQL_OJ_NESTED SQL_OJ_NOT_ORDERED SQL_OJ_INNER SQL_OJ_ALL_COMPARISON_OPS |
SQL_OUTER_JOINS | Y |
SQL_OWNER_TERM | owner |
SQL_OWNER_USAGE | SQL_OU_DML_STATEMENTS SQL_OU_PROCEDURE_INVOCATION SQL_OU_TABLE_DEFINITION SQL_OU_INDEX_DEFINITION SQL_OU_PRIVILEGE_DEFINITION |
SQL_POS_OPERATIONS | SQL_POS_ADD SQL_POS_DELETE SQL_POS_POSITION SQL_POS_REFRESH SQL_POS_UPDATE |
SQL_POSITIONED_STATEMENTS | SQL_PS_POSITIONED_DELETE SQL_PS_POSITIONED_UPDATE SQL_PS_SELECT_FOR_UPDATE |
SQL_PROCEDURE_TERM | stored procedure |
SQL_PROCEDURES | Y |
SQL_QUALIFIER_LOCATION | SQL_QL_START |
SQL_QUALIFIER_NAME _SEPARATOR |
. (period) |
SQL_QUALIFIER_TERM | database |
SQL_QUALIFIER_USAGE | SQL_QU_DML_STATEMENTS SQL_QU_PROCEDURE_INVOCATION SQL_QU_TABLE_DEFINITION |
SQL_QUOTED_IDENTIFIER_CASE | (Depends on whether SQL Server was installed as case-sensitive or case-insensitive.) |
SQL_ROW_UPDATES | N |
SQL_SCROLL_CONCURRENCY | SQL_SCCO_LOCK SQL_SCCO_OPT_ROWVER SQL_SCCO_OPT_VALUES SQL_SCCO_READ_ONLY |
SQL_SCROLL_OPTIONS | SQL_SO_DYNAMIC SQL_SO_FORWARD_ONLY SQL_SO_KEYSET_DRIVEN SQL_SO_STATIC |
SQL_SEARCH_PATTERN_ESCAPE | \ (backslash) |
SQL_SPECIAL_CHARACTERS | #$ÀÁÂÃÄÅÆÇÈÉÊËÌÍÎÏÐÑÒÓÔ ÕÖØÙÚÛÜÝÞßàáâãäåæçèéêëìíîïð ñòóôõöøùúûüýþÿ |
SQL_STATIC_SENSITIVITY | SQL_SS_ADDITIONS SQL_SS_UPDATES |
SQL_STRING_FUNCTIONS | 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_2 SQL_FN_STR_LTRIM SQL_FN_STR_REPEAT 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_SUBQUERIES | SQL_SQ_COMPARISON SQL_SQ_EXISTS SQL_SQ_IN SQL_SQ_QUANTIFIED SQL_SQ_CORRELATED _SUBQUERIES |
SQL_SYSTEM_FUNCTIONS | SQL_FN_SYS_DBNAME SQL_FN_SYS_IFNULL SQL_FN_SYS_USERNAME |
SQL_TABLE_TERM | table |
SQL_TIMEDATE_ADD_INTERVALS | SQL_FN_TSI_FRAC_SECOND 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_INTERVALS | SQL_FN_TSI_FRAC_SECOND 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_FUNCTIONS | SQL_FN_TD_NOW SQL_FN_TD_CURDATE SQL_FN_TD_DAYOFMONTH SQL_FN_TD_DAYOFWEEK SQL_FN_TD_DAYOFYEAR SQL_FN_TD_DAYNAME SQL_FN_TD_MONTH SQL_FN_TD_MONTHNAME SQL_FN_TD_QUARTER SQL_FN_TD_WEEK SQL_FN_TD_YEAR SQL_FN_TD_CURTIME SQL_FN_TD_HOUR SQL_FN_TD_MINUTE SQL_FN_TD_SECOND SQL_FN_TD_TIMESTAMPADD SQL_FN_TD_TIMESTAMPDIFF |
SQL_TXN_CAPABLE | SQL_TC_ALL |
SQL_TXN_ISOLATION_OPTION | SQL_TXN_READ_COMMITTED SQL_TXN_READ_UNCOMMITTED SQL_TXN_REPEATABLE_READ SQL_TXN_SERIALIZABLE |
SQL_UNION | SQL_U_UNION SQL_U_UNION_ALL |
The ODBC SQL Server driver supports the following new driver-specific SQLGetInfo value:
fInfoType parameter | rgbInfoValue returned |
---|---|
SQL_INFO_SS_NETLIB_NAME | The name of the Net-Library DLL that is used to connect to SQL Server. (Similar to dbprocinfo.) |