next up previous contents
Next: SpecialColumns Up: Konstantendeklarationen Previous: GetConnOption and SetConnOption

GetInfo

 
 nnnnnn¯

ODBC-Version < 200

SQL_ACTIVE_CONNECTIONS 0 IntField

SQL_ACTIVE_STATEMENTS 1 IntField

SQL_DATA_SOURCE_NAME 2 StringField

SQL_DRIVER_HDBC 3 IntField

SQL_DRIVER_HENV 4 IntField

SQL_DRIVER_HSTMT 5 IntField

SQL_DRIVER_NAME 6 StringField

SQL_DRIVER_VER 7 StringField

SQL_FETCH_DIRECTION 8 IntField

SQL_FD_FETCH_NEXT 1H

SQL_FD_FETCH_FIRST 2H

SQL_FD_FETCH_LAST 4H

SQL_FD_FETCH_PRIOR 8H

SQL_FD_FETCH_ABSOLUTE 10H

SQL_FD_FETCH_RELATIVE 20H

SQL_FD_FETCH_RESUME 40H

SQL_FD_FETCH_BOOKMARK 80H

SQL_ODBC_API_CONFORMANCE 9 IntField

SQL_OAC_NONE 0H

SQL_OAC_LEVEL1 1H

SQL_OAC_LEVEL2 2H

SQL_ODBC_VER 10 StringField

SQL_ROW_UPDATES 11 StringField

SQL_ODBC_SAG_CLI_CONFORMANCE 12 IntField

SQL_OSCC_NOT_COMPLIANT 0H

SQL_OSCC_COMPLIANT 1H

SQL_SERVER_NAME 13 StringField

SQL_SEARCH_PATTERN_ESCAPE 14 StringField

SQL_ODBC_SQL_CONFORMANCE 15 IntField

SQL_OSC_MINIMUM 0H

SQL_OSC_CORE 1H

SQL_OSC_EXTENDED 2H

SQL_DBMS_NAME 17 StringField

SQL_DBMS_VER 18 StringField

SQL_ACCESSIBLE_TABLES 19 StringField

"Y" if the user has SELECT privileges on all tables returned by Tables,

"N" if there may be tables that the user cannot access.

SQL_ACCESSIBLE_PROCEDURES 20 StringField

"Y" if the user can execute all procedures returned by Procedures,

"N" if there may be procedures that the user cannot execute.

SQL_PROCEDURES 21 StringField

SQL_CONCAT_NULL_BEHAVIOR 22 IntField

SQL_CB_NULL 0H

SQL_CB_NON_NULL 1H

SQL_CURSOR_COMMIT_BEHAVIOR 23 IntField

SQL_CB_DELETE 0H

SQL_CB_CLOSE 1H

SQL_CB_PRESERVE 2H

SQL_CURSOR_ROLLBACK_BEHAVIOR 24 IntField

SQL_CB_DELETE 0H

SQL_CB_CLOSE 1H

SQL_CB_PRESERVE 2H

SQL_DATA_SOURCE_READ_ONLY 25 StringField

SQL_DEFAULT_TXN_ISOLATION 26 IntField

SQL_TXN_READ_UNCOMMITTED 1H

SQL_TXN_READ_COMMITTED 2H

SQL_TXN_REPEATABLE_READ 4H

SQL_TXN_SERIALIZABLE 8H

SQL_TXN_VERSIONING 10H

SQL_EXPRESSIONS_IN_ORDERBY 27 StringField

SQL_IDENTIFIER_CASE 28 IntField

SQL_IC_UPPER 1H

SQL_IC_LOWER 2H

SQL_IC_SENSITIVE 3H

SQL_IC_MIXED 4H

SQL_IDENTIFIER_QUOTE_CHAR 29 StringField

SQL_MAX_COLUMN_NAME_LEN 30 IntField

SQL_MAX_CURSOR_NAME_LEN 31 IntField

SQL_MAX_OWNER_NAME_LEN 32 IntField

SQL_MAX_PROCEDURE_NAME_LEN 33 IntField

SQL_MAX_QUALIFIER_NAME_LEN 34 IntField

SQL_MAX_TABLE_NAME_LEN 35 IntField

SQL_MULT_RESULT_SETS 36 StringField

SQL_MULTIPLE_ACTIVE_TXN 37 StringField

SQL_OUTER_JOINS 38 StringField

SQL_OWNER_TERM 39 StringField

SQL_PROCEDURE_TERM 40 StringField

SQL_QUALIFIER_NAME_SEPARATOR 41 StringField

SQL_QUALIFIER_TERM 42 StringField

SQL_SCROLL_CONCURRENCY 43 IntField

SQL_SCCO_READ_ONLY 1H

SQL_SCCO_LOCK 2H

SQL_SCCO_OPT_ROWVER 4H

SQL_SCCO_OPT_VALUES 8H

SQL_SCROLL_OPTIONS 44 IntField

SQL_SO_FORWARD_ONLY 1H

SQL_SO_KEYSET_DRIVEN 2H

SQL_SO_DYNAMIC 4H

SQL_SO_MIXED 8H

SQL_SO_STATIC 10H

SQL_TABLE_TERM 45 StringField

SQL_TXN_CAPABLE 46 IntField

SQL_TC_NONE 0H

SQL_TC_DML 1H

SQL_TC_ALL 2H

SQL_TC_DDL_COMMIT 3H

SQL_TC_DDL_IGNORE 4H

SQL_USER_NAME 47 StringField

SQL_CONVERT_FUNCTIONS 48 IntField

SQL_CVT_CHAR 1H

SQL_CVT_NUMERIC 2H

SQL_CVT_DECIMAL 4H

SQL_CVT_INTEGER 8H

SQL_CVT_SMALLINT 10H

SQL_CVT_FLOAT 20H

SQL_CVT_REAL 40H

SQL_CVT_DOUBLE 80H

SQL_CVT_VARCHAR 100H

SQL_CVT_LONGVARCHAR 200H

SQL_CVT_BINARY 400H

SQL_CVT_VARBINARY 800H

SQL_CVT_BIT 1000H

SQL_CVT_TINYINT 2000H

SQL_CVT_BIGINT 4000H

SQL_CVT_DATE 8000H

SQL_CVT_TIME 10000H

SQL_CVT_TIMESTAMP 20000H

SQL_CVT_LONGVARBINARY 40000H

SQL_NUMERIC_FUNCTIONS 49 IntField

SQL_FN_NUM_ABS 1H

SQL_FN_NUM_ACOS 2H

SQL_FN_NUM_ASIN 4H

SQL_FN_NUM_ATAN 8H

SQL_FN_NUM_ATAN2 10H

SQL_FN_NUM_CEILING 20H

SQL_FN_NUM_COS 40H

SQL_FN_NUM_COT 80H

SQL_FN_NUM_EXP 100H

SQL_FN_NUM_FLOOR 200H

SQL_FN_NUM_LOG 400H

SQL_FN_NUM_MOD 800H

SQL_FN_NUM_SIGN 1000H

SQL_FN_NUM_SIN 2000H

SQL_FN_NUM_SQRT 4000H

SQL_FN_NUM_TAN 8000H

SQL_FN_NUM_PI 10000H

SQL_FN_NUM_RAND 20000H

SQL_FN_NUM_DEGREES 40000H

SQL_FN_NUM_LOG10 80000H

SQL_FN_NUM_POWER 100000H

SQL_FN_NUM_RADIANS 200000H

SQL_FN_NUM_ROUND 400000H

SQL_FN_NUM_TRUNCATE 800000H

SQL_STRING_FUNCTIONS 50 IntField

SQL_FN_STR_CONCAT 1H

SQL_FN_STR_INSERT 2H

SQL_FN_STR_LEFT 4H

SQL_FN_STR_LTRIM 8H

SQL_FN_STR_LENGTH 10H

SQL_FN_STR_LOCATE 20H

SQL_FN_STR_LCASE 40H

SQL_FN_STR_REPEAT 80H

SQL_FN_STR_REPLACE 100H

SQL_FN_STR_RIGHT 200H

SQL_FN_STR_RTRIM 400H

SQL_FN_STR_SUBSTRING 800H

SQL_FN_STR_UCASE 1000H

SQL_FN_STR_ASCII 2000H

SQL_FN_STR_CHAR 4000H

SQL_FN_STR_DIFFERENCE 8000H

SQL_FN_STR_LOCATE_2 10000H

SQL_FN_STR_SOUNDEX 20000H

SQL_FN_STR_SPACE 40000H

SQL_SYSTEM_FUNCTIONS 51 IntField

SQL_FN_SYS_USERNAME 1H

SQL_FN_SYS_DBNAME 2H

SQL_FN_SYS_IFNULL 4H

SQL_TIMEDATE_FUNCTIONS 52 IntField

SQL_FN_TD_NOW 1H

SQL_FN_TD_CURDATE 2H

SQL_FN_TD_DAYOFMONTH 4H

SQL_FN_TD_DAYOFWEEK 8H

SQL_FN_TD_DAYOFYEAR 10H

SQL_FN_TD_MONTH 20H

SQL_FN_TD_QUARTER 40H

SQL_FN_TD_WEEK 80H

SQL_FN_TD_YEAR 100H

SQL_FN_TD_CURTIME 200H

SQL_FN_TD_HOUR 400H

SQL_FN_TD_MINUTE 800H

SQL_FN_TD_SECOND 1000H

SQL_FN_TD_TIMESTAMPADD 2000H

SQL_FN_TD_TIMESTAMPDIFF 4000H

SQL_FN_TD_DAYNAME 8000H

SQL_FN_TD_MONTHNAME 10000H

SQL_CONVERT_BIGINT 53 IntField

SQL_CONVERT_BINARY 54 IntField

SQL_CONVERT_BIT 55 IntField

SQL_CONVERT_CHAR 56 IntField

SQL_CONVERT_DATE 57 IntField

SQL_CONVERT_DECIMAL 58 IntField

SQL_CONVERT_DOUBLE 59 IntField

SQL_CONVERT_FLOAT 60 IntField

SQL_CONVERT_INTEGER 61 IntField

SQL_CONVERT_LONGVARCHAR 62 IntField

SQL_CONVERT_NUMERIC 63 IntField

SQL_CONVERT_REAL 64 IntField

SQL_CONVERT_SMALLINT 65 IntField

SQL_CONVERT_TIME 66 IntField

SQL_CONVERT_TIMESTAMP 67 IntField

SQL_CONVERT_TINYINT 68 IntField

SQL_CONVERT_VARBINARY 69 IntField

SQL_CONVERT_VARCHAR 70 IntField

SQL_CONVERT_LONGVARBINARY 71 IntField

SQL_TXN_ISOLATION_OPTION 72 IntField

SQL_TXN_READ_UNCOMMITTED 1H

SQL_TXN_READ_COMMITTED 2H

SQL_TXN_REPEATABLE_READ 4H

SQL_TXN_SERIALIZABLE 8H

SQL_TXN_VERSIONING 10H

SQL_ODBC_SQL_OPT_IEF 73 StringField

SQL_CORRELATION_NAME 74 IntField

SQL_CN_NONE 0H

SQL_CN_DIFFERENT 1H

SQL_CN_ANY 2H

SQL_NON_NULLABLE_COLUMNS 75 IntField

SQL_NNC_NULL 0H

SQL_NNC_NON_NULL 1H

ODBC-Version

SQL_DRIVER_HLIB 76 IntField

SQL_DRIVER_ODBC_VER 77 StringField

SQL_LOCK_TYPES 78 IntField

SQL_LCK_NO_CHANGE 1H

SQL_LCK_EXCLUSIVE 2H

SQL_LCK_UNLOCK 4H

SQL_POS_OPERATIONS 79 IntField

SQL_POS_POSITION 1H

SQL_POS_REFRESH 2H

SQL_POS_UPDATE 4H

SQL_POS_DELETE 8H

SQL_POS_ADD 10H

SQL_POSITIONED_STATEMENTS 80 IntField

SQL_PS_POSITIONED_DELETE 1H

SQL_PS_POSITIONED_UPDATE 2H

SQL_PS_SELECT_FOR_UPDATE 4H

SQL_GETDATA_EXTENSIONS 81 IntField

SQL_GD_ANY_COLUMN 1H

SQL_GD_ANY_ORDER 2H

SQL_GD_BLOCK 4H

SQL_GD_BOUND 8H

SQL_BOOKMARK_PERSISTENCE 82 IntField

SQL_BP_CLOSE 1H

SQL_BP_DELETE 2H

SQL_BP_DROP 4H

SQL_BP_TRANSACTION 8H

SQL_BP_UPDATE 10H

SQL_BP_OTHER_HSTMT 20H

SQL_BP_SCROLL 40H

SQL_STATIC_SENSITIVITY 83 IntField

SQL_SS_ADDITIONS 1H

SQL_SS_DELETIONS 2H

SQL_SS_UPDATES 4H

SQL_FILE_USAGE 84 IntField

SQL_FILE_NOT_SUPPORTED 0H

SQL_FILE_TABLE 1H

SQL_FILE_QUALIFIER 2H

SQL_NULL_COLLATION 85 IntField

SQL_NC_HIGH 0H

SQL_NC_LOW 1H

SQL_NC_START 2H

SQL_NC_END 4H

SQL_ALTER_TABLE 86 IntField as bitmask of supported clauses

SQL_AT_ADD_COLUMN 1H

SQL_AT_DROP_COLUMN 2H

SQL_COLUMN_ALIAS 87 StringField

"Y" if the data source supports column aliases; otherwise "N".

SQL_GROUP_BY 88 IntField

SQL_GB_NOT_SUPPORTED 0H

SQL_GB_GROUP_BY_EQUALS_SELECT 1H

SQL_GB_GROUP_BY_CONTAINS_SELECT 2H

SQL_GB_NO_RELATION 3H

SQL_KEYWORDS 89 StringField

SQL_ORDER_BY_COLUMNS_IN_SELECT 90 StringField

SQL_OWNER_USAGE 91 IntField

SQL_OU_DML_STATEMENTS 1H

SQL_OU_PROCEDURE_INVOCATION 2H

SQL_OU_TABLE_DEFINITION 4H

SQL_OU_INDEX_DEFINITION 8H

SQL_OU_PRIVILEGE_DEFINITION 10H

SQL_QUALIFIER_USAGE 92 IntField

SQL_QU_DML_STATEMENTS 1H

SQL_QU_PROCEDURE_INVOCATION 2H

SQL_QU_TABLE_DEFINITION 4H

SQL_QU_INDEX_DEFINITION 8H

SQL_QU_PRIVILEGE_DEFINITION 10H

SQL_QUOTED_IDENTIFIER_CASE 93 IntField

SQL_IC_UPPER 1H

SQL_IC_LOWER 2H

SQL_IC_SENSITIVE 3H

SQL_IC_MIXED 4H

SQL_SPECIAL_CHARACTERS 94 StringField

SQL_SUBQUERIES 95 IntField

SQL_SQ_COMPARISON 1H

SQL_SQ_EXISTS 2H

SQL_SQ_IN 4H

SQL_SQ_QUANTIFIED 8H

SQL_SQ_CORRELATED_SUBQUERIES 10H

SQL_UNION 96 IntField

SQL_U_UNION 1H

SQL_U_UNION_ALL 2H

SQL_MAX_COLUMNS_IN_GROUP_BY 97 IntField

SQL_MAX_COLUMNS_IN_INDEX 98 IntField

SQL_MAX_COLUMNS_IN_ORDER_BY 99 IntField

SQL_MAX_COLUMNS_IN_SELECT 100 IntField

SQL_MAX_COLUMNS_IN_TABLE 101 IntField

SQL_MAX_INDEX_SIZE 102 IntField

SQL_MAX_ROW_SIZE_INCLUDES_LONG 103 StringField

SQL_MAX_ROW_SIZE 104 IntField

SQL_MAX_STATEMENT_LEN 105 IntField

SQL_MAX_TABLES_IN_SELECT 106 IntField

SQL_MAX_USER_NAME_LEN 107 IntField

SQL_MAX_CHAR_LITERAL_LEN 108 IntField

SQL_TIMEDATE_ADD_INTERVALS 109 IntField

SQL_FN_TSI_FRAC_SECOND 1H

SQL_FN_TSI_SECOND 2H

SQL_FN_TSI_MINUTE 4H

SQL_FN_TSI_HOUR 8H

SQL_FN_TSI_DAY 10H

SQL_FN_TSI_WEEK 20H

SQL_FN_TSI_MONTH 40H

SQL_FN_TSI_QUARTER 80H

SQL_FN_TSI_YEAR 100H

SQL_TIMEDATE_DIFF_INTERVALS 110 IntField

SQL_FN_TSI_FRAC_SECOND 1H

SQL_FN_TSI_SECOND 2H

SQL_FN_TSI_MINUTE 4H

SQL_FN_TSI_HOUR 8H

SQL_FN_TSI_DAY 10H

SQL_FN_TSI_WEEK 20H

SQL_FN_TSI_MONTH 40H

SQL_FN_TSI_QUARTER 80H

SQL_FN_TSI_YEAR 100H

SQL_NEED_LONG_DATA_LEN 111 StringField

SQL_MAX_BINARY_LITERAL_LEN 112 IntField

SQL_LIKE_ESCAPE_CLAUSE 113 StringField

SQL_QUALIFIER_LOCATION 114 IntField

SQL_QL_START 1HL

SQL_QL_END 2HL

ODBC-Version

SQL_OJ_CAPABILITIES 65002 temporärer Wert bis ODBC 3.0

SQL_OJ_LEFT 1H

SQL_OJ_RIGHT 2H

SQL_OJ_FULL 4H

SQL_OJ_NESTED 8H

SQL_OJ_NOT_ORDERED 10H

SQL_OJ_INNER 20H

SQL_OJ_ALL_COMPARISON_OPS 40H



next up previous contents
Next: SpecialColumns Up: Konstantendeklarationen Previous: GetConnOption and SetConnOption



Christoph Steindl
Thu Jul 24 14:37:19 MET DST 1997