blib/lib/DBI/Const/GetInfo/ANSI.pm

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