📄 odbc.pm
字号:
%ReturnTypes =( SQL_ACCESSIBLE_PROCEDURES => 'SQLCHAR' # 20, SQL_ACCESSIBLE_TABLES => 'SQLCHAR' # 19, SQL_ACTIVE_CONNECTIONS => 'SQLUSMALLINT' # 0 =>, SQL_ACTIVE_ENVIRONMENTS => 'SQLUSMALLINT' # 116, SQL_ACTIVE_STATEMENTS => 'SQLUSMALLINT' # 1 =>, SQL_AGGREGATE_FUNCTIONS => 'SQLUINTEGER bitmask' # 169, SQL_ALTER_DOMAIN => 'SQLUINTEGER bitmask' # 117, SQL_ALTER_TABLE => 'SQLUINTEGER bitmask' # 86, SQL_ASYNC_MODE => 'SQLUINTEGER' # 10021, SQL_BATCH_ROW_COUNT => 'SQLUINTEGER bitmask' # 120, SQL_BATCH_SUPPORT => 'SQLUINTEGER bitmask' # 121, SQL_BOOKMARK_PERSISTENCE => 'SQLUINTEGER bitmask' # 82, SQL_CATALOG_LOCATION => 'SQLUSMALLINT' # 114, SQL_CATALOG_NAME => 'SQLCHAR' # 10003, SQL_CATALOG_NAME_SEPARATOR => 'SQLCHAR' # 41, SQL_CATALOG_TERM => 'SQLCHAR' # 42, SQL_CATALOG_USAGE => 'SQLUINTEGER bitmask' # 92, SQL_COLLATION_SEQ => 'SQLCHAR' # 10004, SQL_COLUMN_ALIAS => 'SQLCHAR' # 87, SQL_CONCAT_NULL_BEHAVIOR => 'SQLUSMALLINT' # 22, SQL_CONVERT_BIGINT => 'SQLUINTEGER bitmask' # 53, SQL_CONVERT_BINARY => 'SQLUINTEGER bitmask' # 54, SQL_CONVERT_BIT => 'SQLUINTEGER bitmask' # 55, SQL_CONVERT_CHAR => 'SQLUINTEGER bitmask' # 56, SQL_CONVERT_DATE => 'SQLUINTEGER bitmask' # 57, SQL_CONVERT_DECIMAL => 'SQLUINTEGER bitmask' # 58, SQL_CONVERT_DOUBLE => 'SQLUINTEGER bitmask' # 59, SQL_CONVERT_FLOAT => 'SQLUINTEGER bitmask' # 60, SQL_CONVERT_FUNCTIONS => 'SQLUINTEGER bitmask' # 48, SQL_CONVERT_GUID => 'SQLUINTEGER bitmask' # 173, SQL_CONVERT_INTEGER => 'SQLUINTEGER bitmask' # 61, SQL_CONVERT_INTERVAL_DAY_TIME => 'SQLUINTEGER bitmask' # 123, SQL_CONVERT_INTERVAL_YEAR_MONTH => 'SQLUINTEGER bitmask' # 124, SQL_CONVERT_LONGVARBINARY => 'SQLUINTEGER bitmask' # 71, SQL_CONVERT_LONGVARCHAR => 'SQLUINTEGER bitmask' # 62, SQL_CONVERT_NUMERIC => 'SQLUINTEGER bitmask' # 63, SQL_CONVERT_REAL => 'SQLUINTEGER bitmask' # 64, SQL_CONVERT_SMALLINT => 'SQLUINTEGER bitmask' # 65, SQL_CONVERT_TIME => 'SQLUINTEGER bitmask' # 66, SQL_CONVERT_TIMESTAMP => 'SQLUINTEGER bitmask' # 67, SQL_CONVERT_TINYINT => 'SQLUINTEGER bitmask' # 68, SQL_CONVERT_VARBINARY => 'SQLUINTEGER bitmask' # 69, SQL_CONVERT_VARCHAR => 'SQLUINTEGER bitmask' # 70, SQL_CONVERT_WCHAR => 'SQLUINTEGER bitmask' # 122 => !!!, SQL_CONVERT_WLONGVARCHAR => 'SQLUINTEGER bitmask' # 125 => !!!, SQL_CONVERT_WVARCHAR => 'SQLUINTEGER bitmask' # 126 => !!!, SQL_CORRELATION_NAME => 'SQLUSMALLINT' # 74, SQL_CREATE_ASSERTION => 'SQLUINTEGER bitmask' # 127, SQL_CREATE_CHARACTER_SET => 'SQLUINTEGER bitmask' # 128, SQL_CREATE_COLLATION => 'SQLUINTEGER bitmask' # 129, SQL_CREATE_DOMAIN => 'SQLUINTEGER bitmask' # 130, SQL_CREATE_SCHEMA => 'SQLUINTEGER bitmask' # 131, SQL_CREATE_TABLE => 'SQLUINTEGER bitmask' # 132, SQL_CREATE_TRANSLATION => 'SQLUINTEGER bitmask' # 133, SQL_CREATE_VIEW => 'SQLUINTEGER bitmask' # 134, SQL_CURSOR_COMMIT_BEHAVIOR => 'SQLUSMALLINT' # 23, SQL_CURSOR_ROLLBACK_BEHAVIOR => 'SQLUSMALLINT' # 24, SQL_CURSOR_SENSITIVITY => 'SQLUINTEGER' # 10001, SQL_DATA_SOURCE_NAME => 'SQLCHAR' # 2, SQL_DATA_SOURCE_READ_ONLY => 'SQLCHAR' # 25, SQL_DATABASE_NAME => 'SQLCHAR' # 16 , SQL_DATETIME_LITERALS => 'SQLUINTEGER bitmask' # 119, SQL_DBMS_NAME => 'SQLCHAR' # 17, SQL_DBMS_VER => 'SQLCHAR' # 18, SQL_DDL_INDEX => 'SQLUINTEGER bitmask' # 170, SQL_DEFAULT_TXN_ISOLATION => 'SQLUINTEGER' # 26, SQL_DESCRIBE_PARAMETER => 'SQLCHAR' # 10002, SQL_DM_VER => 'SQLCHAR' # 171, SQL_DRIVER_HDBC => 'SQLUINTEGER' # 3, SQL_DRIVER_HDESC => 'SQLUINTEGER' # 135, SQL_DRIVER_HENV => 'SQLUINTEGER' # 4, SQL_DRIVER_HLIB => 'SQLUINTEGER' # 76, SQL_DRIVER_HSTMT => 'SQLUINTEGER' # 5, SQL_DRIVER_NAME => 'SQLCHAR' # 6, SQL_DRIVER_ODBC_VER => 'SQLCHAR' # 77, SQL_DRIVER_VER => 'SQLCHAR' # 7, SQL_DROP_ASSERTION => 'SQLUINTEGER bitmask' # 136, SQL_DROP_CHARACTER_SET => 'SQLUINTEGER bitmask' # 137, SQL_DROP_COLLATION => 'SQLUINTEGER bitmask' # 138, SQL_DROP_DOMAIN => 'SQLUINTEGER bitmask' # 139, SQL_DROP_SCHEMA => 'SQLUINTEGER bitmask' # 140, SQL_DROP_TABLE => 'SQLUINTEGER bitmask' # 141, SQL_DROP_TRANSLATION => 'SQLUINTEGER bitmask' # 142, SQL_DROP_VIEW => 'SQLUINTEGER bitmask' # 143, SQL_DYNAMIC_CURSOR_ATTRIBUTES1 => 'SQLUINTEGER bitmask' # 144, SQL_DYNAMIC_CURSOR_ATTRIBUTES2 => 'SQLUINTEGER bitmask' # 145, SQL_EXPRESSIONS_IN_ORDERBY => 'SQLCHAR' # 27, SQL_FETCH_DIRECTION => 'SQLUINTEGER bitmask' # 8 => !!!, SQL_FILE_USAGE => 'SQLUSMALLINT' # 84, SQL_FORWARD_ONLY_CURSOR_ATTRIBUTES1 => 'SQLUINTEGER bitmask' # 146, SQL_FORWARD_ONLY_CURSOR_ATTRIBUTES2 => 'SQLUINTEGER bitmask' # 147, SQL_GETDATA_EXTENSIONS => 'SQLUINTEGER bitmask' # 81, SQL_GROUP_BY => 'SQLUSMALLINT' # 88, SQL_IDENTIFIER_CASE => 'SQLUSMALLINT' # 28, SQL_IDENTIFIER_QUOTE_CHAR => 'SQLCHAR' # 29, SQL_INDEX_KEYWORDS => 'SQLUINTEGER bitmask' # 148# SQL_INFO_DRIVER_START => '' # 1000 =># SQL_INFO_FIRST => 'SQLUSMALLINT' # 0 =># SQL_INFO_LAST => 'SQLUSMALLINT' # 114 =>, SQL_INFO_SCHEMA_VIEWS => 'SQLUINTEGER bitmask' # 149, SQL_INSERT_STATEMENT => 'SQLUINTEGER bitmask' # 172, SQL_INTEGRITY => 'SQLCHAR' # 73, SQL_KEYSET_CURSOR_ATTRIBUTES1 => 'SQLUINTEGER bitmask' # 150, SQL_KEYSET_CURSOR_ATTRIBUTES2 => 'SQLUINTEGER bitmask' # 151, SQL_KEYWORDS => 'SQLCHAR' # 89, SQL_LIKE_ESCAPE_CLAUSE => 'SQLCHAR' # 113, SQL_LOCK_TYPES => 'SQLUINTEGER bitmask' # 78 => !!!, SQL_MAXIMUM_CATALOG_NAME_LENGTH => 'SQLUSMALLINT' # 34 =>, SQL_MAXIMUM_COLUMNS_IN_GROUP_BY => 'SQLUSMALLINT' # 97 =>, SQL_MAXIMUM_COLUMNS_IN_INDEX => 'SQLUSMALLINT' # 98 =>, SQL_MAXIMUM_COLUMNS_IN_ORDER_BY => 'SQLUSMALLINT' # 99 =>, SQL_MAXIMUM_COLUMNS_IN_SELECT => 'SQLUSMALLINT' # 100 =>, SQL_MAXIMUM_COLUMN_NAME_LENGTH => 'SQLUSMALLINT' # 30 =>, SQL_MAXIMUM_CONCURRENT_ACTIVITIES => 'SQLUSMALLINT' # 1 =>, SQL_MAXIMUM_CURSOR_NAME_LENGTH => 'SQLUSMALLINT' # 31 =>, SQL_MAXIMUM_DRIVER_CONNECTIONS => 'SQLUSMALLINT' # 0 =>, SQL_MAXIMUM_IDENTIFIER_LENGTH => 'SQLUSMALLINT' # 10005 =>, SQL_MAXIMUM_INDEX_SIZE => 'SQLUINTEGER' # 102 =>, SQL_MAXIMUM_ROW_SIZE => 'SQLUINTEGER' # 104 =>, SQL_MAXIMUM_SCHEMA_NAME_LENGTH => 'SQLUSMALLINT' # 32 =>, SQL_MAXIMUM_STATEMENT_LENGTH => 'SQLUINTEGER' # 105 =>, SQL_MAXIMUM_TABLES_IN_SELECT => 'SQLUSMALLINT' # 106 =>, SQL_MAXIMUM_USER_NAME_LENGTH => 'SQLUSMALLINT' # 107 =>, SQL_MAX_ASYNC_CONCURRENT_STATEMENTS => 'SQLUINTEGER' # 10022, SQL_MAX_BINARY_LITERAL_LEN => 'SQLUINTEGER' # 112, SQL_MAX_CATALOG_NAME_LEN => 'SQLUSMALLINT' # 34, SQL_MAX_CHAR_LITERAL_LEN => 'SQLUINTEGER' # 108, SQL_MAX_COLUMNS_IN_GROUP_BY => 'SQLUSMALLINT' # 97, SQL_MAX_COLUMNS_IN_INDEX => 'SQLUSMALLINT' # 98, SQL_MAX_COLUMNS_IN_ORDER_BY => 'SQLUSMALLINT' # 99, SQL_MAX_COLUMNS_IN_SELECT => 'SQLUSMALLINT' # 100, SQL_MAX_COLUMNS_IN_TABLE => 'SQLUSMALLINT' # 101, SQL_MAX_COLUMN_NAME_LEN => 'SQLUSMALLINT' # 30, SQL_MAX_CONCURRENT_ACTIVITIES => 'SQLUSMALLINT' # 1, SQL_MAX_CURSOR_NAME_LEN => 'SQLUSMALLINT' # 31, SQL_MAX_DRIVER_CONNECTIONS => 'SQLUSMALLINT' # 0, SQL_MAX_IDENTIFIER_LEN => 'SQLUSMALLINT' # 10005, SQL_MAX_INDEX_SIZE => 'SQLUINTEGER' # 102, SQL_MAX_OWNER_NAME_LEN => 'SQLUSMALLINT' # 32 =>, SQL_MAX_PROCEDURE_NAME_LEN => 'SQLUSMALLINT' # 33, SQL_MAX_QUALIFIER_NAME_LEN => 'SQLUSMALLINT' # 34 =>, SQL_MAX_ROW_SIZE => 'SQLUINTEGER' # 104, SQL_MAX_ROW_SIZE_INCLUDES_LONG => 'SQLCHAR' # 103, SQL_MAX_SCHEMA_NAME_LEN => 'SQLUSMALLINT' # 32, SQL_MAX_STATEMENT_LEN => 'SQLUINTEGER' # 105, SQL_MAX_TABLES_IN_SELECT => 'SQLUSMALLINT' # 106, SQL_MAX_TABLE_NAME_LEN => 'SQLUSMALLINT' # 35, SQL_MAX_USER_NAME_LEN => 'SQLUSMALLINT' # 107, SQL_MULTIPLE_ACTIVE_TXN => 'SQLCHAR' # 37, SQL_MULT_RESULT_SETS => 'SQLCHAR' # 36, SQL_NEED_LONG_DATA_LEN => 'SQLCHAR' # 111, SQL_NON_NULLABLE_COLUMNS => 'SQLUSMALLINT' # 75, SQL_NULL_COLLATION => 'SQLUSMALLINT' # 85, SQL_NUMERIC_FUNCTIONS => 'SQLUINTEGER bitmask' # 49, SQL_ODBC_API_CONFORMANCE => 'SQLUSMALLINT' # 9 => !!!, SQL_ODBC_INTERFACE_CONFORMANCE => 'SQLUINTEGER' # 152, SQL_ODBC_SAG_CLI_CONFORMANCE => 'SQLUSMALLINT' # 12 => !!!, SQL_ODBC_SQL_CONFORMANCE => 'SQLUSMALLINT' # 15 => !!!, SQL_ODBC_SQL_OPT_IEF => 'SQLCHAR' # 73 =>, SQL_ODBC_VER => 'SQLCHAR' # 10, SQL_OJ_CAPABILITIES => 'SQLUINTEGER bitmask' # 115, SQL_ORDER_BY_COLUMNS_IN_SELECT => 'SQLCHAR' # 90, SQL_OUTER_JOINS => 'SQLCHAR' # 38 => !!!, SQL_OUTER_JOIN_CAPABILITIES => 'SQLUINTEGER bitmask' # 115 =>, SQL_OWNER_TERM => 'SQLCHAR' # 39 =>, SQL_OWNER_USAGE => 'SQLUINTEGER bitmask' # 91 =>, SQL_PARAM_ARRAY_ROW_COUNTS => 'SQLUINTEGER' # 153, SQL_PARAM_ARRAY_SELECTS => 'SQLUINTEGER' # 154, SQL_POSITIONED_STATEMENTS => 'SQLUINTEGER bitmask' # 80 => !!!, SQL_POS_OPERATIONS => 'SQLINTEGER bitmask' # 79, SQL_PROCEDURES => 'SQLCHAR' # 21, SQL_PROCEDURE_TERM => 'SQLCHAR' # 40, SQL_QUALIFIER_LOCATION => 'SQLUSMALLINT' # 114 =>, SQL_QUALIFIER_NAME_SEPARATOR => 'SQLCHAR' # 41 =>, SQL_QUALIFIER_TERM => 'SQLCHAR' # 42 =>, SQL_QUALIFIER_USAGE => 'SQLUINTEGER bitmask' # 92 =>, SQL_QUOTED_IDENTIFIER_CASE => 'SQLUSMALLINT' # 93, SQL_ROW_UPDATES => 'SQLCHAR' # 11, SQL_SCHEMA_TERM => 'SQLCHAR' # 39, SQL_SCHEMA_USAGE => 'SQLUINTEGER bitmask' # 91, SQL_SCROLL_CONCURRENCY => 'SQLUINTEGER bitmask' # 43 => !!!, SQL_SCROLL_OPTIONS => 'SQLUINTEGER bitmask' # 44, SQL_SEARCH_PATTERN_ESCAPE => 'SQLCHAR' # 14, SQL_SERVER_NAME => 'SQLCHAR' # 13, SQL_SPECIAL_CHARACTERS => 'SQLCHAR' # 94, SQL_SQL92_DATETIME_FUNCTIONS => 'SQLUINTEGER bitmask' # 155, SQL_SQL92_FOREIGN_KEY_DELETE_RULE => 'SQLUINTEGER bitmask' # 156, SQL_SQL92_FOREIGN_KEY_UPDATE_RULE => 'SQLUINTEGER bitmask' # 157, SQL_SQL92_GRANT => 'SQLUINTEGER bitmask' # 158, SQL_SQL92_NUMERIC_VALUE_FUNCTIONS => 'SQLUINTEGER bitmask' # 159, SQL_SQL92_PREDICATES => 'SQLUINTEGER bitmask' # 160, SQL_SQL92_RELATIONAL_JOIN_OPERATORS => 'SQLUINTEGER bitmask' # 161, SQL_SQL92_REVOKE => 'SQLUINTEGER bitmask' # 162, SQL_SQL92_ROW_VALUE_CONSTRUCTOR => 'SQLUINTEGER bitmask' # 163, SQL_SQL92_STRING_FUNCTIONS => 'SQLUINTEGER bitmask' # 164, SQL_SQL92_VALUE_EXPRESSIONS => 'SQLUINTEGER bitmask' # 165, SQL_SQL_CONFORMANCE => 'SQLUINTEGER' # 118, SQL_STANDARD_CLI_CONFORMANCE => 'SQLUINTEGER bitmask' # 166, SQL_STATIC_CURSOR_ATTRIBUTES1 => 'SQLUINTEGER bitmask' # 167, SQL_STATIC_CURSOR_ATTRIBUTES2 => 'SQLUINTEGER bitmask' # 168, SQL_STATIC_SENSITIVITY => 'SQLUINTEGER bitmask' # 83 => !!!, SQL_STRING_FUNCTIONS => 'SQLUINTEGER bitmask' # 50, SQL_SUBQUERIES => 'SQLUINTEGER bitmask' # 95, SQL_SYSTEM_FUNCTIONS => 'SQLUINTEGER bitmask' # 51, SQL_TABLE_TERM => 'SQLCHAR' # 45, SQL_TIMEDATE_ADD_INTERVALS => 'SQLUINTEGER bitmask' # 109, SQL_TIMEDATE_DIFF_INTERVALS => 'SQLUINTEGER bitmask' # 110, SQL_TIMEDATE_FUNCTIONS => 'SQLUINTEGER bitmask' # 52, SQL_TRANSACTION_CAPABLE => 'SQLUSMALLINT' # 46 =>, SQL_TRANSACTION_ISOLATION_OPTION => 'SQLUINTEGER bitmask' # 72 =>, SQL_TXN_CAPABLE => 'SQLUSMALLINT' # 46, SQL_TXN_ISOLATION_OPTION => 'SQLUINTEGER bitmask' # 72, SQL_UNION => 'SQLUINTEGER bitmask' # 96, SQL_UNION_STATEMENT => 'SQLUINTEGER bitmask' # 96 =>, SQL_USER_NAME => 'SQLCHAR' # 47, SQL_XOPEN_CLI_YEAR => 'SQLCHAR' # 10000);=head2 %ReturnValuesSee: sql.h, sqlext.hEdited: SQL_TXN_ISOLATION_OPTION=cut$ReturnValues{SQL_AGGREGATE_FUNCTIONS} ={ SQL_AF_AVG => 0x00000001, SQL_AF_COUNT => 0x00000002, SQL_AF_MAX => 0x00000004, SQL_AF_MIN => 0x00000008, SQL_AF_SUM => 0x00000010, SQL_AF_DISTINCT => 0x00000020, SQL_AF_ALL => 0x00000040};$ReturnValues{SQL_ALTER_DOMAIN} ={ SQL_AD_CONSTRAINT_NAME_DEFINITION => 0x00000001, SQL_AD_ADD_DOMAIN_CONSTRAINT => 0x00000002, SQL_AD_DROP_DOMAIN_CONSTRAINT => 0x00000004, SQL_AD_ADD_DOMAIN_DEFAULT => 0x00000008, SQL_AD_DROP_DOMAIN_DEFAULT => 0x00000010, SQL_AD_ADD_CONSTRAINT_INITIALLY_DEFERRED => 0x00000020, SQL_AD_ADD_CONSTRAINT_INITIALLY_IMMEDIATE => 0x00000040, SQL_AD_ADD_CONSTRAINT_DEFERRABLE => 0x00000080, SQL_AD_ADD_CONSTRAINT_NON_DEFERRABLE => 0x00000100};$ReturnValues{SQL_ALTER_TABLE} ={ SQL_AT_ADD_COLUMN => 0x00000001, SQL_AT_DROP_COLUMN => 0x00000002, SQL_AT_ADD_CONSTRAINT => 0x00000008, SQL_AT_ADD_COLUMN_SINGLE => 0x00000020, SQL_AT_ADD_COLUMN_DEFAULT => 0x00000040, SQL_AT_ADD_COLUMN_COLLATION => 0x00000080, SQL_AT_SET_COLUMN_DEFAULT => 0x00000100, SQL_AT_DROP_COLUMN_DEFAULT => 0x00000200, SQL_AT_DROP_COLUMN_CASCADE => 0x00000400, SQL_AT_DROP_COLUMN_RESTRICT => 0x00000800, SQL_AT_ADD_TABLE_CONSTRAINT => 0x00001000, SQL_AT_DROP_TABLE_CONSTRAINT_CASCADE => 0x00002000, SQL_AT_DROP_TABLE_CONSTRAINT_RESTRICT => 0x00004000, SQL_AT_CONSTRAINT_NAME_DEFINITION => 0x00008000, SQL_AT_CONSTRAINT_INITIALLY_DEFERRED => 0x00010000, SQL_AT_CONSTRAINT_INITIALLY_IMMEDIATE => 0x00020000⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -