📄 odbc.pm
字号:
# $Id: ODBC.pm,v 1.3 2003/02/26 17:56:01 timbo Exp $## Copyright (c) 2002 Tim Bunce Ireland## Constant data describing Microsoft ODBC info types and return values# for the SQLGetInfo() method of ODBC.## You may distribute under the terms of either the GNU General Public# License or the Artistic License, as specified in the Perl README file.package DBI::Const::GetInfo::ODBC;=head1 NAMEDBI::Const::GetInfo::ODBC - ODBC Constants for GetInfo=head1 SYNOPSIS The API for this module is private and subject to change.=head1 DESCRIPTIONInformation requested by GetInfo().The API for this module is private and subject to change. =head1 REFERENCES MDAC SDK 2.6 ODBC version number (0x0351) sql.h sqlext.h=cutmy$VERSION = sprintf "%d.%02d", '$Revision: 1.3 $ ' =~ /(\d+)\.(\d+)/;%InfoTypes =( SQL_ACCESSIBLE_PROCEDURES => 20, SQL_ACCESSIBLE_TABLES => 19, SQL_ACTIVE_CONNECTIONS => 0, SQL_ACTIVE_ENVIRONMENTS => 116, SQL_ACTIVE_STATEMENTS => 1, SQL_AGGREGATE_FUNCTIONS => 169, SQL_ALTER_DOMAIN => 117, SQL_ALTER_TABLE => 86, SQL_ASYNC_MODE => 10021, SQL_BATCH_ROW_COUNT => 120, SQL_BATCH_SUPPORT => 121, SQL_BOOKMARK_PERSISTENCE => 82, SQL_CATALOG_LOCATION => 114 # SQL_QUALIFIER_LOCATION, SQL_CATALOG_NAME => 10003, SQL_CATALOG_NAME_SEPARATOR => 41 # SQL_QUALIFIER_NAME_SEPARATOR, SQL_CATALOG_TERM => 42 # SQL_QUALIFIER_TERM, SQL_CATALOG_USAGE => 92 # SQL_QUALIFIER_USAGE, SQL_COLLATION_SEQ => 10004, SQL_COLUMN_ALIAS => 87, SQL_CONCAT_NULL_BEHAVIOR => 22, SQL_CONVERT_BIGINT => 53, SQL_CONVERT_BINARY => 54, SQL_CONVERT_BIT => 55, SQL_CONVERT_CHAR => 56, SQL_CONVERT_DATE => 57, SQL_CONVERT_DECIMAL => 58, SQL_CONVERT_DOUBLE => 59, SQL_CONVERT_FLOAT => 60, SQL_CONVERT_FUNCTIONS => 48, SQL_CONVERT_GUID => 173, SQL_CONVERT_INTEGER => 61, SQL_CONVERT_INTERVAL_DAY_TIME => 123, SQL_CONVERT_INTERVAL_YEAR_MONTH => 124, SQL_CONVERT_LONGVARBINARY => 71, SQL_CONVERT_LONGVARCHAR => 62, SQL_CONVERT_NUMERIC => 63, SQL_CONVERT_REAL => 64, SQL_CONVERT_SMALLINT => 65, SQL_CONVERT_TIME => 66, SQL_CONVERT_TIMESTAMP => 67, SQL_CONVERT_TINYINT => 68, SQL_CONVERT_VARBINARY => 69, SQL_CONVERT_VARCHAR => 70, SQL_CONVERT_WCHAR => 122, SQL_CONVERT_WLONGVARCHAR => 125, SQL_CONVERT_WVARCHAR => 126, SQL_CORRELATION_NAME => 74, SQL_CREATE_ASSERTION => 127, SQL_CREATE_CHARACTER_SET => 128, SQL_CREATE_COLLATION => 129, SQL_CREATE_DOMAIN => 130, SQL_CREATE_SCHEMA => 131, SQL_CREATE_TABLE => 132, SQL_CREATE_TRANSLATION => 133, SQL_CREATE_VIEW => 134, SQL_CURSOR_COMMIT_BEHAVIOR => 23, SQL_CURSOR_ROLLBACK_BEHAVIOR => 24, SQL_CURSOR_SENSITIVITY => 10001, SQL_DATA_SOURCE_NAME => 2, SQL_DATA_SOURCE_READ_ONLY => 25, SQL_DATABASE_NAME => 16 , SQL_DATETIME_LITERALS => 119, SQL_DBMS_NAME => 17, SQL_DBMS_VER => 18, SQL_DDL_INDEX => 170, SQL_DEFAULT_TXN_ISOLATION => 26, SQL_DESCRIBE_PARAMETER => 10002, SQL_DM_VER => 171, SQL_DRIVER_HDBC => 3, SQL_DRIVER_HDESC => 135, SQL_DRIVER_HENV => 4, SQL_DRIVER_HLIB => 76, SQL_DRIVER_HSTMT => 5, SQL_DRIVER_NAME => 6, SQL_DRIVER_ODBC_VER => 77, SQL_DRIVER_VER => 7, SQL_DROP_ASSERTION => 136, SQL_DROP_CHARACTER_SET => 137, SQL_DROP_COLLATION => 138, SQL_DROP_DOMAIN => 139, SQL_DROP_SCHEMA => 140, SQL_DROP_TABLE => 141, SQL_DROP_TRANSLATION => 142, SQL_DROP_VIEW => 143, SQL_DYNAMIC_CURSOR_ATTRIBUTES1 => 144, SQL_DYNAMIC_CURSOR_ATTRIBUTES2 => 145, SQL_EXPRESSIONS_IN_ORDERBY => 27, SQL_FETCH_DIRECTION => 8, SQL_FILE_USAGE => 84, SQL_FORWARD_ONLY_CURSOR_ATTRIBUTES1 => 146, SQL_FORWARD_ONLY_CURSOR_ATTRIBUTES2 => 147, SQL_GETDATA_EXTENSIONS => 81, SQL_GROUP_BY => 88, SQL_IDENTIFIER_CASE => 28, SQL_IDENTIFIER_QUOTE_CHAR => 29, SQL_INDEX_KEYWORDS => 148# SQL_INFO_DRIVER_START => 1000# SQL_INFO_FIRST => 0# SQL_INFO_LAST => 114 # SQL_QUALIFIER_LOCATION, SQL_INFO_SCHEMA_VIEWS => 149, SQL_INSERT_STATEMENT => 172, SQL_INTEGRITY => 73, SQL_KEYSET_CURSOR_ATTRIBUTES1 => 150, SQL_KEYSET_CURSOR_ATTRIBUTES2 => 151, SQL_KEYWORDS => 89, SQL_LIKE_ESCAPE_CLAUSE => 113, SQL_LOCK_TYPES => 78, SQL_MAXIMUM_CATALOG_NAME_LENGTH => 34 # SQL_MAX_CATALOG_NAME_LEN, SQL_MAXIMUM_COLUMNS_IN_GROUP_BY => 97 # SQL_MAX_COLUMNS_IN_GROUP_BY, SQL_MAXIMUM_COLUMNS_IN_INDEX => 98 # SQL_MAX_COLUMNS_IN_INDEX, SQL_MAXIMUM_COLUMNS_IN_ORDER_BY => 99 # SQL_MAX_COLUMNS_IN_ORDER_BY, SQL_MAXIMUM_COLUMNS_IN_SELECT => 100 # SQL_MAX_COLUMNS_IN_SELECT, SQL_MAXIMUM_COLUMN_NAME_LENGTH => 30 # SQL_MAX_COLUMN_NAME_LEN, SQL_MAXIMUM_CONCURRENT_ACTIVITIES => 1 # SQL_MAX_CONCURRENT_ACTIVITIES, SQL_MAXIMUM_CURSOR_NAME_LENGTH => 31 # SQL_MAX_CURSOR_NAME_LEN, SQL_MAXIMUM_DRIVER_CONNECTIONS => 0 # SQL_MAX_DRIVER_CONNECTIONS, SQL_MAXIMUM_IDENTIFIER_LENGTH => 10005 # SQL_MAX_IDENTIFIER_LEN, SQL_MAXIMUM_INDEX_SIZE => 102 # SQL_MAX_INDEX_SIZE, SQL_MAXIMUM_ROW_SIZE => 104 # SQL_MAX_ROW_SIZE, SQL_MAXIMUM_SCHEMA_NAME_LENGTH => 32 # SQL_MAX_SCHEMA_NAME_LEN, SQL_MAXIMUM_STATEMENT_LENGTH => 105 # SQL_MAX_STATEMENT_LEN, SQL_MAXIMUM_TABLES_IN_SELECT => 106 # SQL_MAX_TABLES_IN_SELECT, SQL_MAXIMUM_USER_NAME_LENGTH => 107 # SQL_MAX_USER_NAME_LEN, SQL_MAX_ASYNC_CONCURRENT_STATEMENTS => 10022, SQL_MAX_BINARY_LITERAL_LEN => 112, SQL_MAX_CATALOG_NAME_LEN => 34, SQL_MAX_CHAR_LITERAL_LEN => 108, SQL_MAX_COLUMNS_IN_GROUP_BY => 97, SQL_MAX_COLUMNS_IN_INDEX => 98, SQL_MAX_COLUMNS_IN_ORDER_BY => 99, SQL_MAX_COLUMNS_IN_SELECT => 100, SQL_MAX_COLUMNS_IN_TABLE => 101, SQL_MAX_COLUMN_NAME_LEN => 30, SQL_MAX_CONCURRENT_ACTIVITIES => 1, SQL_MAX_CURSOR_NAME_LEN => 31, SQL_MAX_DRIVER_CONNECTIONS => 0, SQL_MAX_IDENTIFIER_LEN => 10005, SQL_MAX_INDEX_SIZE => 102, SQL_MAX_OWNER_NAME_LEN => 32, SQL_MAX_PROCEDURE_NAME_LEN => 33, SQL_MAX_QUALIFIER_NAME_LEN => 34, SQL_MAX_ROW_SIZE => 104, SQL_MAX_ROW_SIZE_INCLUDES_LONG => 103, SQL_MAX_SCHEMA_NAME_LEN => 32, SQL_MAX_STATEMENT_LEN => 105, SQL_MAX_TABLES_IN_SELECT => 106, SQL_MAX_TABLE_NAME_LEN => 35, SQL_MAX_USER_NAME_LEN => 107, SQL_MULTIPLE_ACTIVE_TXN => 37, SQL_MULT_RESULT_SETS => 36, SQL_NEED_LONG_DATA_LEN => 111, SQL_NON_NULLABLE_COLUMNS => 75, SQL_NULL_COLLATION => 85, SQL_NUMERIC_FUNCTIONS => 49, SQL_ODBC_API_CONFORMANCE => 9, SQL_ODBC_INTERFACE_CONFORMANCE => 152, SQL_ODBC_SAG_CLI_CONFORMANCE => 12, SQL_ODBC_SQL_CONFORMANCE => 15, SQL_ODBC_SQL_OPT_IEF => 73, SQL_ODBC_VER => 10, SQL_OJ_CAPABILITIES => 115, SQL_ORDER_BY_COLUMNS_IN_SELECT => 90, SQL_OUTER_JOINS => 38, SQL_OUTER_JOIN_CAPABILITIES => 115 # SQL_OJ_CAPABILITIES, SQL_OWNER_TERM => 39, SQL_OWNER_USAGE => 91, SQL_PARAM_ARRAY_ROW_COUNTS => 153, SQL_PARAM_ARRAY_SELECTS => 154, SQL_POSITIONED_STATEMENTS => 80, SQL_POS_OPERATIONS => 79, SQL_PROCEDURES => 21, SQL_PROCEDURE_TERM => 40, SQL_QUALIFIER_LOCATION => 114, SQL_QUALIFIER_NAME_SEPARATOR => 41, SQL_QUALIFIER_TERM => 42, SQL_QUALIFIER_USAGE => 92, SQL_QUOTED_IDENTIFIER_CASE => 93, SQL_ROW_UPDATES => 11, SQL_SCHEMA_TERM => 39 # SQL_OWNER_TERM, SQL_SCHEMA_USAGE => 91 # SQL_OWNER_USAGE, SQL_SCROLL_CONCURRENCY => 43, SQL_SCROLL_OPTIONS => 44, SQL_SEARCH_PATTERN_ESCAPE => 14, SQL_SERVER_NAME => 13, SQL_SPECIAL_CHARACTERS => 94, SQL_SQL92_DATETIME_FUNCTIONS => 155, SQL_SQL92_FOREIGN_KEY_DELETE_RULE => 156, SQL_SQL92_FOREIGN_KEY_UPDATE_RULE => 157, SQL_SQL92_GRANT => 158, SQL_SQL92_NUMERIC_VALUE_FUNCTIONS => 159, SQL_SQL92_PREDICATES => 160, SQL_SQL92_RELATIONAL_JOIN_OPERATORS => 161, SQL_SQL92_REVOKE => 162, SQL_SQL92_ROW_VALUE_CONSTRUCTOR => 163, SQL_SQL92_STRING_FUNCTIONS => 164, SQL_SQL92_VALUE_EXPRESSIONS => 165, SQL_SQL_CONFORMANCE => 118, SQL_STANDARD_CLI_CONFORMANCE => 166, SQL_STATIC_CURSOR_ATTRIBUTES1 => 167, SQL_STATIC_CURSOR_ATTRIBUTES2 => 168, SQL_STATIC_SENSITIVITY => 83, SQL_STRING_FUNCTIONS => 50, SQL_SUBQUERIES => 95, SQL_SYSTEM_FUNCTIONS => 51, SQL_TABLE_TERM => 45, SQL_TIMEDATE_ADD_INTERVALS => 109, SQL_TIMEDATE_DIFF_INTERVALS => 110, SQL_TIMEDATE_FUNCTIONS => 52, SQL_TRANSACTION_CAPABLE => 46 # SQL_TXN_CAPABLE, SQL_TRANSACTION_ISOLATION_OPTION => 72 # SQL_TXN_ISOLATION_OPTION, SQL_TXN_CAPABLE => 46, SQL_TXN_ISOLATION_OPTION => 72, SQL_UNION => 96, SQL_UNION_STATEMENT => 96 # SQL_UNION, SQL_USER_NAME => 47, SQL_XOPEN_CLI_YEAR => 10000);=head2 %ReturnTypesSee: mk:@MSITStore:X:\dm\cli\mdac\sdk26\Docs\odbc.chm::/htm/odbcsqlgetinfo.htm => : alias => !!! : edited=cut⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -