SQLGetInfo
SQLGetInfo
The following table lists the information types used by ODBC along with the responses from the KB_SQL Server. Note that items marked with an asterisk (*) are based on site-defined names or values that could be different in your installation. This list can be reproduced using the GetInfoAll option of the ODBC Test utility that comes with the Microsoft ODBC SDK.
|InfoType |* |Value |
|SQL_ACCESSIBLE_PROCEDURES=20 | |"Y" |
|SQL_ACCESSIBLE_TABLES=19 | |"Y" |
|SQL_ACTIVE_CONNECTIONS=0 | |254 |
|SQL_ACTIVE_ENVIRONMENTS=116 | |254 |
|SQL_ACTIVE_STATEMENTS=1 | |65534 |
|SQL_ALTER_DOMAIN=117 | |0x00000000 |
|SQL_ALTER_TABLE=86 | |0x00000020 = SQL_AT_ADD_COLUMN_SINGLE |
|SQL_ASYNC_MODE=10021 | |SQL_AM_NONE = 0 |
|SQL_BATCH_ROW_COUNT=120 | |0x00000002 = SQL_BRC_EXPLICIT |
|SQL_BATCH_SUPPORT=121 | |0x00000000 |
|SQL_BOOKMARK_PERSISTENCE=82 | |0x00000052 = SQL_BP_DELETE | SQL_BP_UPDATE | SQL_BP_SCROLL |
|SQL_CATALOG_LOCATION=114 | |SQL_CL_START = 1 |
|SQL_CATALOG_NAME_SEPARATOR=41 | |"." |
|SQL_CATALOG_NAME=10003 | |"N" |
|SQL_CATALOG_TERM=42 | |"Catalog" |
|SQL_CATALOG_USAGE=92 | |0x00000000 |
|SQL_COLLATION_SEQ=10004 | |"ISO8859-1" |
|SQL_COLUMN_ALIAS=87 | |"Y" |
|SQL_CONCAT_NULL_BEHAVIOR=22 |* |SQL_CB_NULL = 0 |
|SQL_CONVERT_BIGINT=53 | |0x00000000 |
|SQL_CONVERT_BINARY=54 | |0x00000000 |
|SQL_CONVERT_BIT=55 | |0x00000000 |
|SQL_CONVERT_CHAR=56 | |0x00000000 |
|SQL_CONVERT_DATE=57 | |0x00000000 |
|SQL_CONVERT_DECIMAL=58 | |0x00000000 |
|SQL_CONVERT_DOUBLE=59 | |0x00000000 |
|SQL_CONVERT_FLOAT=60 | |0x00000000 |
|SQL_CONVERT_FUNCTIONS=48 | |0x00000000 |
|SQL_CONVERT_INTEGER=61 | |0x00000000 |
|SQL_CONVERT_INTERVAL_DAY_TIME=123 | |0x00000000 |
|SQL_CONVERT_INTERVAL_YEAR_MONTH=124 | |0x00000000 |
|SQL_CONVERT_LONGVARBINARY=71 | |0x00000000 |
|SQL_CONVERT_LONGVARCHAR=62 | |0x00000000 |
|SQL_CONVERT_NUMERIC=63 | |0x00000000 |
|SQL_CONVERT_REAL=64 | |0x00000000 |
|SQL_CONVERT_SMALLINT=65 | |0x00000000 |
|SQL_CONVERT_TIME=66 | |0x00000000 |
|SQL_CONVERT_TIMESTAMP=67 | |0x00000000 |
|SQL_CONVERT_TINYINT=68 | |0x00000000 |
|SQL_CONVERT_VARBINARY=69 | |0x00000000 |
|SQL_CONVERT_VARCHAR=70 | |0x00000000 |
|SQL_CONVERT_WCHAR=122 | |0x00000000 |
|SQL_CONVERT_WLONGVARCHAR=125 | |0x00000000 |
|SQL_CONVERT_WVARCHAR=126 | |0x00000000 |
|SQL_CORRELATION_NAME=74 | |SQL_CN_ANY = 2 |
|SQL_CREATE_ASSERTION=127 | |0x00000000 |
|SQL_CREATE_CHARACTER_SET=128 | |0x00000000 |
|SQL_CREATE_COLLATION=129 | |0x00000000 |
|SQL_CREATE_DOMAIN=130 | |0x00000000 |
|SQL_CREATE_SCHEMA=131 | |0x00000001 = SQL_CS_CREATE_SCHEMA |
|SQL_CREATE_TABLE=132 | |0x00000001 = SQL_CT_CREATE_TABLE |
|SQL_CREATE_TRANSLATION=133 | |0x00000000 |
|SQL_CREATE_VIEW=134 | |0x00000001 = SQL_CV_CREATE_VIEW |
|SQL_CURSOR_COMMIT_BEHAVIOR=23 | |SQL_CB_PRESERVE = 2 |
|SQL_CURSOR_ROLLBACK_BEHAVIOR=24 | |SQL_CB_PRESERVE = 2 |
|SQL_CURSOR_SENSITIVITY=10001 | |SQL_UNSPECIFIED = 0 |
|SQL_DATA_SOURCE_NAME=2 |* |"KB_SQL" |
|SQL_DATA_SOURCE_READ_ONLY=25 | |"N" |
|SQL_DATABASE_NAME=16 | |"" |
|SQL_DATETIME_LITERALS=119 | |0x00000007 = SQL_DL_SQL92_DATE | SQL_DL_SQL92_TIME | SQL_DL_SQL92_TIMESTAMP |
|SQL_DBMS_NAME=17 |* |"KB_SQL" |
|SQL_DBMS_VER=18 |* |"04.00.mmdd" |
|SQL_DEFAULT_TXN_ISOLATION=26 |* |SQL_TXN_READ_UNCOMMITTED = 1 |
|SQL_DESCRIBE_PARAMETER=10002 | |"N" |
|SQL_DM_VER=171 |* |"03.51.300213.0000" |
|SQL_DRIVER_HDBC=3 |* |0x01010000 |
|SQL_DRIVER_HDESC=135 |* |0x00000001 |
|SQL_DRIVER_HENV=4 |* |0x01000000 |
|SQL_DRIVER_HLIB=76 |* |0x00FC0000 |
|SQL_DRIVER_HSTMT=5 |* |0x01010001 |
|SQL_DRIVER_NAME=6 |* |"kbodbc32.dll" |
|SQL_DRIVER_ODBC_VER=77 |* |"03.51" |
|SQL_DRIVER_VER=7 |* |"04.00.mmdd" |
|SQL_DROP_ASSERTION=136 | |0x00000000 |
|SQL_DROP_CHARACTER_SET=137 | |0x00000000 |
|SQL_DROP_COLLATION=138 | |0x00000000 |
|SQL_DROP_DOMAIN=139 | |0x00000000 |
|SQL_DROP_SCHEMA=140 | |0x00000001 = SQL_DS_DROP_SCHEMA |
|SQL_DROP_TABLE=141 | |0x00000001 = SQL_DT_DROP_TABLE |
|SQL_DROP_TRANSLATION=142 | |0x00000000 |
|SQL_DROP_VIEW=143 | |0x00000001 = SQL_DV_DROP_VIEW |
|SQL_DYNAMIC_CURSOR_ATTRIBUTES1=144 | |0x00000000 |
|SQL_DYNAMIC_CURSOR_ATTRIBUTES2=145 | |0x00000000 |
|SQL_EXPRESSIONS_IN_ORDERBY=27 | |"Y" |
|SQL_FETCH_DIRECTION=8 | |0x00000001 = SQL_FD_FETCH_NEXT |
|SQL_FILE_USAGE=84 | |SQL_FILE_NOT_SUPPORTED = 0 |
|SQL_FORWARD_ONLY_CURSOR_ATTRIBUTES1=146 | |0x00000001 = SQL_CA1_NEXT |
|SQL_FORWARD_ONLY_CURSOR_ATTRIBUTES2=147 | |0x00000000 |
|SQL_GETDATA_EXTENSIONS=81 | |0x0000000B = SQL_GD_ANY_COLUMN | SQL_GD_ANY_ORDER | SQL_GD_BOUND |
|SQL_GROUP_BY=88 | |SQL_GB_GROUP_BY_CONTAINS_SELECT = 2 |
|SQL_IDENTIFIER_CASE=28 | |SQL_IC_UPPER = 1 |
|SQL_IDENTIFIER_QUOTE_CHAR=29 | |" " |
|SQL_INDEX_KEYWORDS=148 | |0x00000003 = SQL_IK_ASC | SQL_IK_DESC |
|SQL_INFO_SCHEMA_VIEWS=149 | |0x00000000 |
|SQL_INTEGRITY=73 | |"N" |
|SQL_KEYSET_CURSOR_ATTRIBUTES1=150 | |0x00000000 |
|SQL_KEYSET_CURSOR_ATTRIBUTES2=151 | |0x00000000 |
|SQL_KEYWORDS=89 | |"" |
|SQL_LIKE_ESCAPE_CLAUSE=113 | |"Y" |
|SQL_LOCK_TYPES=78 | |0x00000001 = SQL_LCK_NO_CHANGE |
|SQL_MAX_ASYNC_CONCURRENT_STATEMENTS=10022 | |0 |
|SQL_MAX_BINARY_LITERAL_LEN=112 | |0 |
|SQL_MAX_CATALOG_NAME_LEN=34 | |30 |
|SQL_MAX_CHAR_LITERAL_LEN=108 | |200 |
|SQL_MAX_COLUMN_NAME_LEN=30 | |30 |
|SQL_MAX_COLUMNS_IN_GROUP_BY=97 | |0 |
|SQL_MAX_COLUMNS_IN_INDEX=98 | |0 |
|SQL_MAX_COLUMNS_IN_ORDER_BY=99 | |0 |
|SQL_MAX_COLUMNS_IN_SELECT=100 | |0 |
|SQL_MAX_COLUMNS_IN_TABLE=101 | |0 |
|SQL_MAX_CONCURRENT_ACTIVITIES=1 | |65534 |
|SQL_MAX_CURSOR_NAME_LEN=31 | |30 |
|SQL_MAX_DRIVER_CONNECTIONS=0 | |254 |
|SQL_MAX_IDENTIFIER_LEN=10005 | |30 |
|SQL_MAX_INDEX_SIZE=102 | |0 |
|SQL_MAX_OWNER_NAME_LEN=32 | |30 |
|SQL_MAX_PROCEDURE_NAME_LEN=33 | |35 |
|SQL_MAX_QUALIFIER_NAME_LEN=34 | |30 |
|SQL_MAX_ROW_SIZE_INCLUDES_LONG=103 | |"N" |
|SQL_MAX_ROW_SIZE=104 | |32767 |
|SQL_MAX_SCHEMA_NAME_LEN=32 | |30 |
|SQL_MAX_STATEMENT_LEN=105 | |0 |
|SQL_MAX_TABLE_NAME_LEN=35 | |30 |
|SQL_MAX_TABLES_IN_SELECT=106 | |0 |
|SQL_MAX_USER_NAME_LEN=107 | |30 |
|SQL_MULT_RESULT_SETS=36 | |"N" |
|SQL_MULTIPLE_ACTIVE_TXN=37 | |"Y" |
|SQL_NEED_LONG_DATA_LEN=111 | |"N" |
|SQL_NON_NULLABLE_COLUMNS=75 | |SQL_NNC_NON_NULL = 1 |
|SQL_NULL_COLLATION=85 |* |SQL_NC_END = 4 |
|SQL_NUMERIC_FUNCTIONS=49 | |0x00D35A21 = SQL_FN_NUM_ABS | SQL_FN_NUM_CEILING | SQL_FN_NUM_FLOOR | SQL_FN_NUM_MOD | SQL_FN_NUM_SIGN | |
| | |SQL_FN_NUM_SQRT | SQL_FN_NUM_PI | SQL_FN_NUM_RAND | SQL_FN_NUM_POWER | SQL_FN_NUM_ROUND | SQL_FN_NUM_TRUNCATE |
|SQL_ODBC_API_CONFORMANCE=9 | |SQL_OAC_LEVEL1 = 1 |
|SQL_ODBC_INTERFACE_CONFORMANCE=152 | |SQL_OIC_CORE = 1 |
|SQL_ODBC_SAG_CLI_CONFORMANCE=12 | |SQL_OSCC_COMPLIANT = 1 |
|SQL_ODBC_SQL_CONFORMANCE=15 | |SQL_OSC_CORE = 1 |
|SQL_ODBC_SQL_OPT_IEF=73 | |"N" |
|SQL_ODBC_VER=10 |* |"03.51.0000" |
|SQL_OJ_CAPABILITIES=115 | |0x00000043 = SQL_OJ_LEFT | SQL_OJ_RIGHT | SQL_OJ_ALL_COMPARISON_OPS |
|SQL_ORDER_BY_COLUMNS_IN_SELECT=90 | |"N" |
|SQL_OUTER_JOINS=38 | |"P" |
|SQL_OWNER_TERM=39 | |"Schema" |
|SQL_OWNER_USAGE=91 | |0x0000001F = SQL_OU_DML_STATEMENTS | SQL_OU_PROCEDURE_INVOCATION|SQL_OU_TABLE_DEFINITION | |
| | |SQL_OU_INDEX_DEFINITION | SQL_OU_PRIVILEGE_DEFINITION |
|SQL_PARAM_ARRAY_ROW_COUNTS=153 | |SQL_PARC_BATCH = 1 |
|SQL_PARAM_ARRAY_SELECTS=154 | |SQL_PAS_NO_BATCH = 2 |
|SQL_POS_OPERATIONS=79 | |0x00000000 |
|SQL_POSITIONED_STATEMENTS=80 | |0x00000007 = SQL_PS_POSITIONED_DELETE | SQL_PS_POSITIONED_UPDATE | SQL_PS_SELECT_FOR_UPDATE |
|SQL_PROCEDURE_TERM=40 | |"Procedure" |
|SQL_PROCEDURES=21 | |"Y" |
|SQL_QUALIFIER_LOCATION=114 | |SQL_CL_START = 1 |
|SQL_QUALIFIER_NAME_SEPARATOR=41 | |"." |
|SQL_QUALIFIER_TERM=42 | |"Catalog" |
|SQL_QUALIFIER_USAGE=92 | |0x00000000 |
|SQL_QUOTED_IDENTIFIER_CASE=93 | |SQL_IC_SENSITIVE = 3 |
|SQL_ROW_UPDATES=11 | |"N" |
|SQL_SCHEMA_TERM=39 | |"Schema" |
|SQL_SCHEMA_USAGE=91 | |0x0000001F = SQL_OU_DML_STATEMENTS | SQL_OU_PROCEDURE_INVOCATION| SQL_OU_TABLE_DEFINITION | |
| | |SQL_OU_INDEX_DEFINITION | SQL_OU_PRIVILEGE_DEFINITION |
|SQL_SCROLL_CONCURRENCY=43 | |0x00000001 = SQL_SCCO_READ_ONLY |
|SQL_SCROLL_OPTIONS=44 | |0x00000011 = SQL_SO_FORWARD_ONLY | SQL_SO_STATIC |
|SQL_SEARCH_PATTERN_ESCAPE=14 |* |"\" |
|SQL_SERVER_NAME=13 |* |"Server1" |
|SQL_SPECIAL_CHARACTERS=94 | |"" |
|SQL_SQL_CONFORMANCE=118 | |SQL_SC_SQL92_ENTRY = 1 |
|SQL_SQL92_DATETIME_FUNCTIONS=155 | |0x00000007 = SQL_SDF_CURRENT_DATE | SQL_SDF_CURRENT_TIME | SQL_SDF_CURRENT_TIMESTAMP |
|SQL_SQL92_FOREIGN_KEY_DELETE_RULE=156 | |0x00000000 |
|SQL_SQL92_FOREIGN_KEY_UPDATE_RULE=157 | |0x00000000 |
|SQL_SQL92_GRANT=158 | |0x00000C70 = SQL_SG_WITH_GRANT_OPTION | SQL_SG_DELETE_TABLE | SQL_SG_INSERT_TABLE | SQL_SG_SELECT_TABLE | |
| | |SQL_SG_UPDATE_TABLE |
|SQL_SQL92_NUMERIC_VALUE_FUNCTIONS=159 | |0x00000000 |
|SQL_SQL92_PREDICATES=160 | |0x00000E07 = SQL_SP_EXISTS | SQL_SP_ISNOTNULL | SQL_SP_ISNULL | SQL_SP_LIKE | SQL_SP_IN | SQL_SP_BETWEEN |
|SQL_SQL92_RELATIONAL_JOIN_OPERATORS=161 | |0x00000140 = SQL_SRJO_LEFT_OUTER_JOIN | SQL_SRJO_RIGHT_OUTER_JOIN |
|SQL_SQL92_REVOKE=162 | |0x00003190 = SQL_SR_GRANT_OPTION_FOR | SQL_SR_DELETE_TABLE | SQL_SR_INSERT_TABLE | SQL_SR_SELECT_TABLE | |
| | |SQL_SR_UPDATE_TABLE |
|SQL_SQL92_ROW_VALUE_CONSTRUCTOR=163 | |0x00000003 = SQL_SRVC_VALUE_EXPRESSION | SQL_SRVC_NULL |
|SQL_SQL92_STRING_FUNCTIONS=164 | |0x0000003E = SQL_SSF_LOWER | SQL_SSF_UPPER | SQL_SSF_SUBSTRING | SQL_SSF_TRANSLATE | SQL_SSF_TRIM_BOTH |
|SQL_SQL92_VALUE_EXPRESSIONS=165 | |0x00000005 = SQL_SVE_CASE | SQL_SVE_COALESCE |
|SQL_STANDARD_CLI_CONFORMANCE=166 | |0x00000002 = SQL_SCC_ISO92_CLI |
|SQL_STATIC_CURSOR_ATTRIBUTES1=167 | |0x00000001 = SQL_CA1_NEXT |
|SQL_STATIC_CURSOR_ATTRIBUTES2=168 | |0x00000000 |
|SQL_STATIC_SENSITIVITY=83 | |0x00000000 |
|SQL_STRING_FUNCTIONS=50 | |0x0007FFFF = SQL_FN_STR_CONCAT | SQL_FN_STR_INSERT | SQL_FN_STR_LEFT | SQL_FN_STR_LTRIM | SQL_FN_STR_LENGTH | |
| | |SQL_FN_STR_LOCATE | SQL_FN_STR_LCASE | SQL_FN_STR_REPEAT | SQL_FN_STR_REPLACE | SQL_FN_STR_RIGHT | |
| | |SQL_FN_STR_RTRIM | SQL_FN_STR_SUBSTRING | SQL_FN_STR_UCASE | SQL_FN_STR_ASCII | SQL_FN_STR_CHAR | |
| | |SQL_FN_STR_DIFFERENCE | SQL_FN_STR_LOCATE_2 | SQL_FN_STR_SOUNDEX | SQL_FN_STR_SPACE |
|SQL_SUBQUERIES=95 | |0x0000001F = SQL_SQ_COMPARISON | SQL_SQ_EXISTS | SQL_SQ_IN | SQL_SQ_QUANTIFIED | SQL_SQ_CORRELATED_SUBQUERIES |
|SQL_SYSTEM_FUNCTIONS=51 | |0x00000007 = SQL_FN_SYS_USERNAME | SQL_FN_SYS_DBNAME | SQL_FN_SYS_IFNULL |
|SQL_TABLE_TERM=45 | |"Table" |
|SQL_TIMEDATE_ADD_INTERVALS=109 | |0x000001FF = 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=110 | |0x000001FF = 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=52 | |0x0001FFFF = SQL_FN_TD_NOW | SQL_FN_TD_CURDATE | SQL_FN_TD_DAYOFMONTH | SQL_FN_TD_DAYOFWEEK | SQL_FN_TD_DAYOFYEAR|
| | || SQL_FN_TD_MONTH | 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_FN_TD_DAYNAME | |
| | |SQL_FN_TD_MONTHNAME |
|SQL_TXN_CAPABLE=46 | |SQL_TC_DML = 1 |
|SQL_TXN_ISOLATION_OPTION=72 | |0x00000007 = SQL_TXN_READ_UNCOMMITTED | SQL_TXN_READ_COMMITTED | SQL_TXN_REPEATABLE_READ |
|SQL_UNION=96 | |0x00000000 |
|SQL_USER_NAME=47 |* |"User2" |
|SQL_XOPEN_CLI_YEAR=10000 | |"1995" |
................
................
In order to avoid copyright disputes, this page is only a partial summary.
To fulfill the demand for quickly locating and searching documents.
It is intelligent file search solution for home and business.
Related download
- sql workshop
- to char function with dates
- date functions in sql server with examples
- all about datetime sqlservergeeks
- date time data type of sql server
- sql server convert datetime to int
- oraclesqlserverproceduresfunctionstriggers
- temple university
- summary the 1 sql server community
- disaster recovery for sql server