[ Index ] |
PHP Cross Reference of Unnamed Project |
[Summary view] [Print] [Text view]
1 # $Id: ANSI.pm 8696 2007-01-24 23:12:38Z timbo $ 2 # 3 # Copyright (c) 2002 Tim Bunce Ireland 4 # 5 # Constant data describing ANSI CLI info types and return values for the 6 # SQLGetInfo() method of ODBC. 7 # 8 # You may distribute under the terms of either the GNU General Public 9 # License or the Artistic License, as specified in the Perl README file. 10 11 package DBI::Const::GetInfo::ANSI; 12 13 =head1 NAME 14 15 DBI::Const::GetInfo::ANSI - ISO/IEC SQL/CLI Constants for GetInfo 16 17 =head1 SYNOPSIS 18 19 The API for this module is private and subject to change. 20 21 =head1 DESCRIPTION 22 23 Information requested by GetInfo(). 24 25 See: A.1 C header file SQLCLI.H, Page 316, 317. 26 27 The API for this module is private and subject to change. 28 29 =head1 REFERENCES 30 31 ISO/IEC FCD 9075-3:200x Information technology - Database Languages - 32 SQL - Part 3: Call-Level Interface (SQL/CLI) 33 34 SC32 N00744 = WG3:VIE-005 = H2-2002-007 35 36 Date: 2002-01-15 37 38 =cut 39 40 my 41 $VERSION = sprintf("2.%06d", q$Revision: 8696 $ =~ /(\d+)/o); 42 43 44 %InfoTypes = 45 ( 46 SQL_ALTER_TABLE => 86 47 , SQL_CATALOG_NAME => 10003 48 , SQL_COLLATING_SEQUENCE => 10004 49 , SQL_CURSOR_COMMIT_BEHAVIOR => 23 50 , SQL_CURSOR_SENSITIVITY => 10001 51 , SQL_DATA_SOURCE_NAME => 2 52 , SQL_DATA_SOURCE_READ_ONLY => 25 53 , SQL_DBMS_NAME => 17 54 , SQL_DBMS_VERSION => 18 55 , SQL_DEFAULT_TRANSACTION_ISOLATION => 26 56 , SQL_DESCRIBE_PARAMETER => 10002 57 , SQL_FETCH_DIRECTION => 8 58 , SQL_GETDATA_EXTENSIONS => 81 59 , SQL_IDENTIFIER_CASE => 28 60 , SQL_INTEGRITY => 73 61 , SQL_MAXIMUM_CATALOG_NAME_LENGTH => 34 62 , SQL_MAXIMUM_COLUMNS_IN_GROUP_BY => 97 63 , SQL_MAXIMUM_COLUMNS_IN_ORDER_BY => 99 64 , SQL_MAXIMUM_COLUMNS_IN_SELECT => 100 65 , SQL_MAXIMUM_COLUMNS_IN_TABLE => 101 66 , SQL_MAXIMUM_COLUMN_NAME_LENGTH => 30 67 , SQL_MAXIMUM_CONCURRENT_ACTIVITIES => 1 68 , SQL_MAXIMUM_CURSOR_NAME_LENGTH => 31 69 , SQL_MAXIMUM_DRIVER_CONNECTIONS => 0 70 , SQL_MAXIMUM_IDENTIFIER_LENGTH => 10005 71 , SQL_MAXIMUM_SCHEMA_NAME_LENGTH => 32 72 , SQL_MAXIMUM_STMT_OCTETS => 20000 73 , SQL_MAXIMUM_STMT_OCTETS_DATA => 20001 74 , SQL_MAXIMUM_STMT_OCTETS_SCHEMA => 20002 75 , SQL_MAXIMUM_TABLES_IN_SELECT => 106 76 , SQL_MAXIMUM_TABLE_NAME_LENGTH => 35 77 , SQL_MAXIMUM_USER_NAME_LENGTH => 107 78 , SQL_NULL_COLLATION => 85 79 , SQL_ORDER_BY_COLUMNS_IN_SELECT => 90 80 , SQL_OUTER_JOIN_CAPABILITIES => 115 81 , SQL_SCROLL_CONCURRENCY => 43 82 , SQL_SEARCH_PATTERN_ESCAPE => 14 83 , SQL_SERVER_NAME => 13 84 , SQL_SPECIAL_CHARACTERS => 94 85 , SQL_TRANSACTION_CAPABLE => 46 86 , SQL_TRANSACTION_ISOLATION_OPTION => 72 87 , SQL_USER_NAME => 47 88 ); 89 90 =head2 %ReturnTypes 91 92 See: Codes and data types for implementation information (Table 28), Page 85, 86. 93 94 Mapped to ODBC datatype names. 95 96 =cut 97 98 %ReturnTypes = # maxlen 99 ( 100 SQL_ALTER_TABLE => 'SQLUINTEGER bitmask' # INTEGER 101 , SQL_CATALOG_NAME => 'SQLCHAR' # CHARACTER (1) 102 , SQL_COLLATING_SEQUENCE => 'SQLCHAR' # CHARACTER (254) 103 , SQL_CURSOR_COMMIT_BEHAVIOR => 'SQLUSMALLINT' # SMALLINT 104 , SQL_CURSOR_SENSITIVITY => 'SQLUINTEGER' # INTEGER 105 , SQL_DATA_SOURCE_NAME => 'SQLCHAR' # CHARACTER (128) 106 , SQL_DATA_SOURCE_READ_ONLY => 'SQLCHAR' # CHARACTER (1) 107 , SQL_DBMS_NAME => 'SQLCHAR' # CHARACTER (254) 108 , SQL_DBMS_VERSION => 'SQLCHAR' # CHARACTER (254) 109 , SQL_DEFAULT_TRANSACTION_ISOLATION => 'SQLUINTEGER' # INTEGER 110 , SQL_DESCRIBE_PARAMETER => 'SQLCHAR' # CHARACTER (1) 111 , SQL_FETCH_DIRECTION => 'SQLUINTEGER bitmask' # INTEGER 112 , SQL_GETDATA_EXTENSIONS => 'SQLUINTEGER bitmask' # INTEGER 113 , SQL_IDENTIFIER_CASE => 'SQLUSMALLINT' # SMALLINT 114 , SQL_INTEGRITY => 'SQLCHAR' # CHARACTER (1) 115 , SQL_MAXIMUM_CATALOG_NAME_LENGTH => 'SQLUSMALLINT' # SMALLINT 116 , SQL_MAXIMUM_COLUMNS_IN_GROUP_BY => 'SQLUSMALLINT' # SMALLINT 117 , SQL_MAXIMUM_COLUMNS_IN_ORDER_BY => 'SQLUSMALLINT' # SMALLINT 118 , SQL_MAXIMUM_COLUMNS_IN_SELECT => 'SQLUSMALLINT' # SMALLINT 119 , SQL_MAXIMUM_COLUMNS_IN_TABLE => 'SQLUSMALLINT' # SMALLINT 120 , SQL_MAXIMUM_COLUMN_NAME_LENGTH => 'SQLUSMALLINT' # SMALLINT 121 , SQL_MAXIMUM_CONCURRENT_ACTIVITIES => 'SQLUSMALLINT' # SMALLINT 122 , SQL_MAXIMUM_CURSOR_NAME_LENGTH => 'SQLUSMALLINT' # SMALLINT 123 , SQL_MAXIMUM_DRIVER_CONNECTIONS => 'SQLUSMALLINT' # SMALLINT 124 , SQL_MAXIMUM_IDENTIFIER_LENGTH => 'SQLUSMALLINT' # SMALLINT 125 , SQL_MAXIMUM_SCHEMA_NAME_LENGTH => 'SQLUSMALLINT' # SMALLINT 126 , SQL_MAXIMUM_STMT_OCTETS => 'SQLUSMALLINT' # SMALLINT 127 , SQL_MAXIMUM_STMT_OCTETS_DATA => 'SQLUSMALLINT' # SMALLINT 128 , SQL_MAXIMUM_STMT_OCTETS_SCHEMA => 'SQLUSMALLINT' # SMALLINT 129 , SQL_MAXIMUM_TABLES_IN_SELECT => 'SQLUSMALLINT' # SMALLINT 130 , SQL_MAXIMUM_TABLE_NAME_LENGTH => 'SQLUSMALLINT' # SMALLINT 131 , SQL_MAXIMUM_USER_NAME_LENGTH => 'SQLUSMALLINT' # SMALLINT 132 , SQL_NULL_COLLATION => 'SQLUSMALLINT' # SMALLINT 133 , SQL_ORDER_BY_COLUMNS_IN_SELECT => 'SQLCHAR' # CHARACTER (1) 134 , SQL_OUTER_JOIN_CAPABILITIES => 'SQLUINTEGER bitmask' # INTEGER 135 , SQL_SCROLL_CONCURRENCY => 'SQLUINTEGER bitmask' # INTEGER 136 , SQL_SEARCH_PATTERN_ESCAPE => 'SQLCHAR' # CHARACTER (1) 137 , SQL_SERVER_NAME => 'SQLCHAR' # CHARACTER (128) 138 , SQL_SPECIAL_CHARACTERS => 'SQLCHAR' # CHARACTER (254) 139 , SQL_TRANSACTION_CAPABLE => 'SQLUSMALLINT' # SMALLINT 140 , SQL_TRANSACTION_ISOLATION_OPTION => 'SQLUINTEGER bitmask' # INTEGER 141 , SQL_USER_NAME => 'SQLCHAR' # CHARACTER (128) 142 ); 143 144 =head2 %ReturnValues 145 146 See: A.1 C header file SQLCLI.H, Page 317, 318. 147 148 =cut 149 150 $ReturnValues{SQL_ALTER_TABLE} = 151 { 152 SQL_AT_ADD_COLUMN => 0x00000001 153 , SQL_AT_DROP_COLUMN => 0x00000002 154 , SQL_AT_ALTER_COLUMN => 0x00000004 155 , SQL_AT_ADD_CONSTRAINT => 0x00000008 156 , SQL_AT_DROP_CONSTRAINT => 0x00000010 157 }; 158 $ReturnValues{SQL_CURSOR_COMMIT_BEHAVIOR} = 159 { 160 SQL_CB_DELETE => 0 161 , SQL_CB_CLOSE => 1 162 , SQL_CB_PRESERVE => 2 163 }; 164 $ReturnValues{SQL_FETCH_DIRECTION} = 165 { 166 SQL_FD_FETCH_NEXT => 0x00000001 167 , SQL_FD_FETCH_FIRST => 0x00000002 168 , SQL_FD_FETCH_LAST => 0x00000004 169 , SQL_FD_FETCH_PRIOR => 0x00000008 170 , SQL_FD_FETCH_ABSOLUTE => 0x00000010 171 , SQL_FD_FETCH_RELATIVE => 0x00000020 172 }; 173 $ReturnValues{SQL_GETDATA_EXTENSIONS} = 174 { 175 SQL_GD_ANY_COLUMN => 0x00000001 176 , SQL_GD_ANY_ORDER => 0x00000002 177 }; 178 $ReturnValues{SQL_IDENTIFIER_CASE} = 179 { 180 SQL_IC_UPPER => 1 181 , SQL_IC_LOWER => 2 182 , SQL_IC_SENSITIVE => 3 183 , SQL_IC_MIXED => 4 184 }; 185 $ReturnValues{SQL_NULL_COLLATION} = 186 { 187 SQL_NC_HIGH => 1 188 , SQL_NC_LOW => 2 189 }; 190 $ReturnValues{SQL_OUTER_JOIN_CAPABILITIES} = 191 { 192 SQL_OUTER_JOIN_LEFT => 0x00000001 193 , SQL_OUTER_JOIN_RIGHT => 0x00000002 194 , SQL_OUTER_JOIN_FULL => 0x00000004 195 , SQL_OUTER_JOIN_NESTED => 0x00000008 196 , SQL_OUTER_JOIN_NOT_ORDERED => 0x00000010 197 , SQL_OUTER_JOIN_INNER => 0x00000020 198 , SQL_OUTER_JOIN_ALL_COMPARISON_OPS => 0x00000040 199 }; 200 $ReturnValues{SQL_SCROLL_CONCURRENCY} = 201 { 202 SQL_SCCO_READ_ONLY => 0x00000001 203 , SQL_SCCO_LOCK => 0x00000002 204 , SQL_SCCO_OPT_ROWVER => 0x00000004 205 , SQL_SCCO_OPT_VALUES => 0x00000008 206 }; 207 $ReturnValues{SQL_TRANSACTION_ACCESS_MODE} = 208 { 209 SQL_TRANSACTION_READ_ONLY => 0x00000001 210 , SQL_TRANSACTION_READ_WRITE => 0x00000002 211 }; 212 $ReturnValues{SQL_TRANSACTION_CAPABLE} = 213 { 214 SQL_TC_NONE => 0 215 , SQL_TC_DML => 1 216 , SQL_TC_ALL => 2 217 , SQL_TC_DDL_COMMIT => 3 218 , SQL_TC_DDL_IGNORE => 4 219 }; 220 $ReturnValues{SQL_TRANSACTION_ISOLATION} = 221 { 222 SQL_TRANSACTION_READ_UNCOMMITTED => 0x00000001 223 , SQL_TRANSACTION_READ_COMMITTED => 0x00000002 224 , SQL_TRANSACTION_REPEATABLE_READ => 0x00000004 225 , SQL_TRANSACTION_SERIALIZABLE => 0x00000008 226 }; 227 228 1; 229 230 =head1 TODO 231 232 Corrections, e.g.: 233 234 SQL_TRANSACTION_ISOLATION_OPTION vs. SQL_TRANSACTION_ISOLATION 235 236 =cut
title
Description
Body
title
Description
Body
title
Description
Body
title
Body
Generated: Tue Mar 17 22:47:18 2015 | Cross-referenced by PHPXref 0.7.1 |