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: SpecialColumns Up: Konstantendeklarationen Previous: GetConnOption and SetConnOption

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