📄 ansi.pm
字号:
# $Id: ANSI.pm,v 1.3 2003/02/26 17:56:01 timbo Exp $## Copyright (c) 2002 Tim Bunce Ireland## Constant data describing ANSI CLI 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::ANSI;=head1 NAMEDBI::Const::GetInfo::ANSI - ISO/IEC SQL/CLI Constants for GetInfo=head1 SYNOPSIS The API for this module is private and subject to change.=head1 DESCRIPTIONInformation requested by GetInfo().See: A.1 C header file SQLCLI.H, Page 316, 317.The API for this module is private and subject to change.=head1 REFERENCES ISO/IEC FCD 9075-3:200x Information technology - Database Languages - SQL - Part 3: Call-Level Interface (SQL/CLI) SC32 N00744 = WG3:VIE-005 = H2-2002-007 Date: 2002-01-15=cutmy$VERSION = sprintf "%d.%02d", '$Revision: 1.3 $ ' =~ /(\d+)\.(\d+)/;%InfoTypes =( SQL_ALTER_TABLE => 86, SQL_CATALOG_NAME => 10003, SQL_COLLATING_SEQUENCE => 10004, SQL_CURSOR_COMMIT_BEHAVIOR => 23, SQL_CURSOR_SENSITIVITY => 10001, SQL_DATA_SOURCE_NAME => 2, SQL_DATA_SOURCE_READ_ONLY => 25, SQL_DBMS_NAME => 17, SQL_DBMS_VERSION => 18, SQL_DEFAULT_TRANSACTION_ISOLATION => 26, SQL_DESCRIBE_PARAMETER => 10002, SQL_FETCH_DIRECTION => 8, SQL_GETDATA_EXTENSIONS => 81, SQL_IDENTIFIER_CASE => 28, SQL_INTEGRITY => 73, SQL_MAXIMUM_CATALOG_NAME_LENGTH => 34, SQL_MAXIMUM_COLUMNS_IN_GROUP_BY => 97, SQL_MAXIMUM_COLUMNS_IN_ORDER_BY => 99, SQL_MAXIMUM_COLUMNS_IN_SELECT => 100, SQL_MAXIMUM_COLUMNS_IN_TABLE => 101, SQL_MAXIMUM_COLUMN_NAME_LENGTH => 30, SQL_MAXIMUM_CONCURRENT_ACTIVITIES => 1, SQL_MAXIMUM_CURSOR_NAME_LENGTH => 31, SQL_MAXIMUM_DRIVER_CONNECTIONS => 0, SQL_MAXIMUM_IDENTIFIER_LENGTH => 10005, SQL_MAXIMUM_SCHEMA_NAME_LENGTH => 32, SQL_MAXIMUM_STMT_OCTETS => 20000, SQL_MAXIMUM_STMT_OCTETS_DATA => 20001, SQL_MAXIMUM_STMT_OCTETS_SCHEMA => 20002, SQL_MAXIMUM_TABLES_IN_SELECT => 106, SQL_MAXIMUM_TABLE_NAME_LENGTH => 35, SQL_MAXIMUM_USER_NAME_LENGTH => 107, SQL_NULL_COLLATION => 85, SQL_ORDER_BY_COLUMNS_IN_SELECT => 90, SQL_OUTER_JOIN_CAPABILITIES => 115, SQL_SCROLL_CONCURRENCY => 43, SQL_SEARCH_PATTERN_ESCAPE => 14, SQL_SERVER_NAME => 13, SQL_SPECIAL_CHARACTERS => 94, SQL_TRANSACTION_CAPABLE => 46, SQL_TRANSACTION_ISOLATION_OPTION => 72, SQL_USER_NAME => 47);=head2 %ReturnTypesSee: Codes and data types for implementation information (Table 28), Page 85, 86.Mapped to ODBC datatype names.=cut%ReturnTypes = # maxlen( SQL_ALTER_TABLE => 'SQLUINTEGER bitmask' # INTEGER, SQL_CATALOG_NAME => 'SQLCHAR' # CHARACTER (1), SQL_COLLATING_SEQUENCE => 'SQLCHAR' # CHARACTER (254), SQL_CURSOR_COMMIT_BEHAVIOR => 'SQLUSMALLINT' # SMALLINT, SQL_CURSOR_SENSITIVITY => 'SQLUINTEGER' # INTEGER, SQL_DATA_SOURCE_NAME => 'SQLCHAR' # CHARACTER (128), SQL_DATA_SOURCE_READ_ONLY => 'SQLCHAR' # CHARACTER (1), SQL_DBMS_NAME => 'SQLCHAR' # CHARACTER (254), SQL_DBMS_VERSION => 'SQLCHAR' # CHARACTER (254), SQL_DEFAULT_TRANSACTION_ISOLATION => 'SQLUINTEGER' # INTEGER, SQL_DESCRIBE_PARAMETER => 'SQLCHAR' # CHARACTER (1), SQL_FETCH_DIRECTION => 'SQLUINTEGER bitmask' # INTEGER, SQL_GETDATA_EXTENSIONS => 'SQLUINTEGER bitmask' # INTEGER, SQL_IDENTIFIER_CASE => 'SQLUSMALLINT' # SMALLINT, SQL_INTEGRITY => 'SQLCHAR' # CHARACTER (1), SQL_MAXIMUM_CATALOG_NAME_LENGTH => 'SQLUSMALLINT' # SMALLINT, SQL_MAXIMUM_COLUMNS_IN_GROUP_BY => 'SQLUSMALLINT' # SMALLINT, SQL_MAXIMUM_COLUMNS_IN_ORDER_BY => 'SQLUSMALLINT' # SMALLINT, SQL_MAXIMUM_COLUMNS_IN_SELECT => 'SQLUSMALLINT' # SMALLINT, SQL_MAXIMUM_COLUMNS_IN_TABLE => 'SQLUSMALLINT' # SMALLINT, SQL_MAXIMUM_COLUMN_NAME_LENGTH => 'SQLUSMALLINT' # SMALLINT, SQL_MAXIMUM_CONCURRENT_ACTIVITIES => 'SQLUSMALLINT' # SMALLINT, SQL_MAXIMUM_CURSOR_NAME_LENGTH => 'SQLUSMALLINT' # SMALLINT, SQL_MAXIMUM_DRIVER_CONNECTIONS => 'SQLUSMALLINT' # SMALLINT, SQL_MAXIMUM_IDENTIFIER_LENGTH => 'SQLUSMALLINT' # SMALLINT, SQL_MAXIMUM_SCHEMA_NAME_LENGTH => 'SQLUSMALLINT' # SMALLINT, SQL_MAXIMUM_STMT_OCTETS => 'SQLUSMALLINT' # SMALLINT, SQL_MAXIMUM_STMT_OCTETS_DATA => 'SQLUSMALLINT' # SMALLINT, SQL_MAXIMUM_STMT_OCTETS_SCHEMA => 'SQLUSMALLINT' # SMALLINT, SQL_MAXIMUM_TABLES_IN_SELECT => 'SQLUSMALLINT' # SMALLINT, SQL_MAXIMUM_TABLE_NAME_LENGTH => 'SQLUSMALLINT' # SMALLINT, SQL_MAXIMUM_USER_NAME_LENGTH => 'SQLUSMALLINT' # SMALLINT, SQL_NULL_COLLATION => 'SQLUSMALLINT' # SMALLINT, SQL_ORDER_BY_COLUMNS_IN_SELECT => 'SQLCHAR' # CHARACTER (1), SQL_OUTER_JOIN_CAPABILITIES => 'SQLUINTEGER bitmask' # INTEGER, SQL_SCROLL_CONCURRENCY => 'SQLUINTEGER bitmask' # INTEGER, SQL_SEARCH_PATTERN_ESCAPE => 'SQLCHAR' # CHARACTER (1), SQL_SERVER_NAME => 'SQLCHAR' # CHARACTER (128), SQL_SPECIAL_CHARACTERS => 'SQLCHAR' # CHARACTER (254), SQL_TRANSACTION_CAPABLE => 'SQLUSMALLINT' # SMALLINT, SQL_TRANSACTION_ISOLATION_OPTION => 'SQLUINTEGER bitmask' # INTEGER, SQL_USER_NAME => 'SQLCHAR' # CHARACTER (128));=head2 %ReturnValuesSee: A.1 C header file SQLCLI.H, Page 317, 318.=cut$ReturnValues{SQL_ALTER_TABLE} ={ SQL_AT_ADD_COLUMN => 0x00000001, SQL_AT_DROP_COLUMN => 0x00000002, SQL_AT_ALTER_COLUMN => 0x00000004, SQL_AT_ADD_CONSTRAINT => 0x00000008, SQL_AT_DROP_CONSTRAINT => 0x00000010};$ReturnValues{SQL_CURSOR_COMMIT_BEHAVIOR} ={ SQL_CB_DELETE => 0, SQL_CB_CLOSE => 1, SQL_CB_PRESERVE => 2};$ReturnValues{SQL_FETCH_DIRECTION} ={ SQL_FD_FETCH_NEXT => 0x00000001, SQL_FD_FETCH_FIRST => 0x00000002, SQL_FD_FETCH_LAST => 0x00000004, SQL_FD_FETCH_PRIOR => 0x00000008, SQL_FD_FETCH_ABSOLUTE => 0x00000010, SQL_FD_FETCH_RELATIVE => 0x00000020};$ReturnValues{SQL_GETDATA_EXTENSIONS} ={ SQL_GD_ANY_COLUMN => 0x00000001, SQL_GD_ANY_ORDER => 0x00000002};$ReturnValues{SQL_IDENTIFIER_CASE} ={ SQL_IC_UPPER => 1, SQL_IC_LOWER => 2, SQL_IC_SENSITIVE => 3, SQL_IC_MIXED => 4};$ReturnValues{SQL_NULL_COLLATION} ={ SQL_NC_HIGH => 1, SQL_NC_LOW => 2};$ReturnValues{SQL_OUTER_JOIN_CAPABILITIES} ={ SQL_OUTER_JOIN_LEFT => 0x00000001, SQL_OUTER_JOIN_RIGHT => 0x00000002, SQL_OUTER_JOIN_FULL => 0x00000004, SQL_OUTER_JOIN_NESTED => 0x00000008, SQL_OUTER_JOIN_NOT_ORDERED => 0x00000010, SQL_OUTER_JOIN_INNER => 0x00000020, SQL_OUTER_JOIN_ALL_COMPARISON_OPS => 0x00000040};$ReturnValues{SQL_SCROLL_CONCURRENCY} ={ SQL_SCCO_READ_ONLY => 0x00000001, SQL_SCCO_LOCK => 0x00000002, SQL_SCCO_OPT_ROWVER => 0x00000004, SQL_SCCO_OPT_VALUES => 0x00000008};$ReturnValues{SQL_TRANSACTION_ACCESS_MODE} ={ SQL_TRANSACTION_READ_ONLY => 0x00000001, SQL_TRANSACTION_READ_WRITE => 0x00000002};$ReturnValues{SQL_TRANSACTION_CAPABLE} ={ SQL_TC_NONE => 0, SQL_TC_DML => 1, SQL_TC_ALL => 2, SQL_TC_DDL_COMMIT => 3, SQL_TC_DDL_IGNORE => 4};$ReturnValues{SQL_TRANSACTION_ISOLATION} ={ SQL_TRANSACTION_READ_UNCOMMITTED => 0x00000001, SQL_TRANSACTION_READ_COMMITTED => 0x00000002, SQL_TRANSACTION_REPEATABLE_READ => 0x00000004, SQL_TRANSACTION_SERIALIZABLE => 0x00000008};1;=head1 TODOCorrections, e.g.: SQL_TRANSACTION_ISOLATION_OPTION vs. SQL_TRANSACTION_ISOLATION=cut⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -