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

filter: Statementstmt 100% 138 / 138 Branchbran n/a Conditioncond n/a MC/DCmcdc n/a Subroutinesub 100% 2 / 2 Podpod n/a totaltotal 100% 140 / 140 CC 1 SCAR 0.0
CC
1
Cov
100%
BEGIN
1.0
BEGIN
1.0
CRAP 1.0
« blib/lib/DBI/Const/GetInfo/ANSI.pm ↑ Summary blib/lib/DBI/Const/GetInfoType.pm »
1 # $Id: ODBC.pm 11373 2008-06-02 19:01:33Z Tim $
2 #
3 # Copyright (c) 2002 Tim Bunce Ireland
4 #
5 # Constant data describing Microsoft ODBC info types and return values
6 # for the 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 package DBI::Const::GetInfo::ODBC;
13  
14 8 our (%InfoTypes,%ReturnTypes,%ReturnValues,);
15 =head1 NAME
16  
17 DBI::Const::GetInfo::ODBC - ODBC Constants for GetInfo
18  
19 =head1 SYNOPSIS
20  
21 The API for this module is private and subject to change.
22  
23 =head1 DESCRIPTION
24  
25 Information requested by GetInfo().
26  
27 The API for this module is private and subject to change.
28  
29 =head1 REFERENCES
30  
31 MDAC SDK 2.6
32 ODBC version number (0x0351)
33  
34 sql.h
35 sqlext.h
36  
37 =cut
38  
39 my
40 8 $VERSION = "2.011374";
41  
42 8 %InfoTypes =
43 (
44 SQL_ACCESSIBLE_PROCEDURES => 20
45 , SQL_ACCESSIBLE_TABLES => 19
46 , SQL_ACTIVE_CONNECTIONS => 0
47 , SQL_ACTIVE_ENVIRONMENTS => 116
48 , SQL_ACTIVE_STATEMENTS => 1
49 , SQL_AGGREGATE_FUNCTIONS => 169
50 , SQL_ALTER_DOMAIN => 117
51 , SQL_ALTER_TABLE => 86
52 , SQL_ASYNC_MODE => 10021
53 , SQL_BATCH_ROW_COUNT => 120
54 , SQL_BATCH_SUPPORT => 121
55 , SQL_BOOKMARK_PERSISTENCE => 82
56 , SQL_CATALOG_LOCATION => 114 # SQL_QUALIFIER_LOCATION
57 , SQL_CATALOG_NAME => 10003
58 , SQL_CATALOG_NAME_SEPARATOR => 41 # SQL_QUALIFIER_NAME_SEPARATOR
59 , SQL_CATALOG_TERM => 42 # SQL_QUALIFIER_TERM
60 , SQL_CATALOG_USAGE => 92 # SQL_QUALIFIER_USAGE
61 , SQL_COLLATION_SEQ => 10004
62 , SQL_COLUMN_ALIAS => 87
63 , SQL_CONCAT_NULL_BEHAVIOR => 22
64 , SQL_CONVERT_BIGINT => 53
65 , SQL_CONVERT_BINARY => 54
66 , SQL_CONVERT_BIT => 55
67 , SQL_CONVERT_CHAR => 56
68 , SQL_CONVERT_DATE => 57
69 , SQL_CONVERT_DECIMAL => 58
70 , SQL_CONVERT_DOUBLE => 59
71 , SQL_CONVERT_FLOAT => 60
72 , SQL_CONVERT_FUNCTIONS => 48
73 , SQL_CONVERT_GUID => 173
74 , SQL_CONVERT_INTEGER => 61
75 , SQL_CONVERT_INTERVAL_DAY_TIME => 123
76 , SQL_CONVERT_INTERVAL_YEAR_MONTH => 124
77 , SQL_CONVERT_LONGVARBINARY => 71
78 , SQL_CONVERT_LONGVARCHAR => 62
79 , SQL_CONVERT_NUMERIC => 63
80 , SQL_CONVERT_REAL => 64
81 , SQL_CONVERT_SMALLINT => 65
82 , SQL_CONVERT_TIME => 66
83 , SQL_CONVERT_TIMESTAMP => 67
84 , SQL_CONVERT_TINYINT => 68
85 , SQL_CONVERT_VARBINARY => 69
86 , SQL_CONVERT_VARCHAR => 70
87 , SQL_CONVERT_WCHAR => 122
88 , SQL_CONVERT_WLONGVARCHAR => 125
89 , SQL_CONVERT_WVARCHAR => 126
90 , SQL_CORRELATION_NAME => 74
91 , SQL_CREATE_ASSERTION => 127
92 , SQL_CREATE_CHARACTER_SET => 128
93 , SQL_CREATE_COLLATION => 129
94 , SQL_CREATE_DOMAIN => 130
95 , SQL_CREATE_SCHEMA => 131
96 , SQL_CREATE_TABLE => 132
97 , SQL_CREATE_TRANSLATION => 133
98 , SQL_CREATE_VIEW => 134
99 , SQL_CURSOR_COMMIT_BEHAVIOR => 23
100 , SQL_CURSOR_ROLLBACK_BEHAVIOR => 24
101 , SQL_CURSOR_SENSITIVITY => 10001
102 , SQL_DATA_SOURCE_NAME => 2
103 , SQL_DATA_SOURCE_READ_ONLY => 25
104 , SQL_DATABASE_NAME => 16
105 , SQL_DATETIME_LITERALS => 119
106 , SQL_DBMS_NAME => 17
107 , SQL_DBMS_VER => 18
108 , SQL_DDL_INDEX => 170
109 , SQL_DEFAULT_TXN_ISOLATION => 26
110 , SQL_DESCRIBE_PARAMETER => 10002
111 , SQL_DM_VER => 171
112 , SQL_DRIVER_HDBC => 3
113 , SQL_DRIVER_HDESC => 135
114 , SQL_DRIVER_HENV => 4
115 , SQL_DRIVER_HLIB => 76
116 , SQL_DRIVER_HSTMT => 5
117 , SQL_DRIVER_NAME => 6
118 , SQL_DRIVER_ODBC_VER => 77
119 , SQL_DRIVER_VER => 7
120 , SQL_DROP_ASSERTION => 136
121 , SQL_DROP_CHARACTER_SET => 137
122 , SQL_DROP_COLLATION => 138
123 , SQL_DROP_DOMAIN => 139
124 , SQL_DROP_SCHEMA => 140
125 , SQL_DROP_TABLE => 141
126 , SQL_DROP_TRANSLATION => 142
127 , SQL_DROP_VIEW => 143
128 , SQL_DYNAMIC_CURSOR_ATTRIBUTES1 => 144
129 , SQL_DYNAMIC_CURSOR_ATTRIBUTES2 => 145
130 , SQL_EXPRESSIONS_IN_ORDERBY => 27
131 , SQL_FETCH_DIRECTION => 8
132 , SQL_FILE_USAGE => 84
133 , SQL_FORWARD_ONLY_CURSOR_ATTRIBUTES1 => 146
134 , SQL_FORWARD_ONLY_CURSOR_ATTRIBUTES2 => 147
135 , SQL_GETDATA_EXTENSIONS => 81
136 , SQL_GROUP_BY => 88
137 , SQL_IDENTIFIER_CASE => 28
138 , SQL_IDENTIFIER_QUOTE_CHAR => 29
139 , SQL_INDEX_KEYWORDS => 148
140 # SQL_INFO_DRIVER_START => 1000
141 # SQL_INFO_FIRST => 0
142 # SQL_INFO_LAST => 114 # SQL_QUALIFIER_LOCATION
143 , SQL_INFO_SCHEMA_VIEWS => 149
144 , SQL_INSERT_STATEMENT => 172
145 , SQL_INTEGRITY => 73
146 , SQL_KEYSET_CURSOR_ATTRIBUTES1 => 150
147 , SQL_KEYSET_CURSOR_ATTRIBUTES2 => 151
148 , SQL_KEYWORDS => 89
149 , SQL_LIKE_ESCAPE_CLAUSE => 113
150 , SQL_LOCK_TYPES => 78
151 , SQL_MAXIMUM_CATALOG_NAME_LENGTH => 34 # SQL_MAX_CATALOG_NAME_LEN
152 , SQL_MAXIMUM_COLUMNS_IN_GROUP_BY => 97 # SQL_MAX_COLUMNS_IN_GROUP_BY
153 , SQL_MAXIMUM_COLUMNS_IN_INDEX => 98 # SQL_MAX_COLUMNS_IN_INDEX
154 , SQL_MAXIMUM_COLUMNS_IN_ORDER_BY => 99 # SQL_MAX_COLUMNS_IN_ORDER_BY
155 , SQL_MAXIMUM_COLUMNS_IN_SELECT => 100 # SQL_MAX_COLUMNS_IN_SELECT
156 , SQL_MAXIMUM_COLUMN_NAME_LENGTH => 30 # SQL_MAX_COLUMN_NAME_LEN
157 , SQL_MAXIMUM_CONCURRENT_ACTIVITIES => 1 # SQL_MAX_CONCURRENT_ACTIVITIES
158 , SQL_MAXIMUM_CURSOR_NAME_LENGTH => 31 # SQL_MAX_CURSOR_NAME_LEN
159 , SQL_MAXIMUM_DRIVER_CONNECTIONS => 0 # SQL_MAX_DRIVER_CONNECTIONS
160 , SQL_MAXIMUM_IDENTIFIER_LENGTH => 10005 # SQL_MAX_IDENTIFIER_LEN
161 , SQL_MAXIMUM_INDEX_SIZE => 102 # SQL_MAX_INDEX_SIZE
162 , SQL_MAXIMUM_ROW_SIZE => 104 # SQL_MAX_ROW_SIZE
163 , SQL_MAXIMUM_SCHEMA_NAME_LENGTH => 32 # SQL_MAX_SCHEMA_NAME_LEN
164 , SQL_MAXIMUM_STATEMENT_LENGTH => 105 # SQL_MAX_STATEMENT_LEN
165 , SQL_MAXIMUM_TABLES_IN_SELECT => 106 # SQL_MAX_TABLES_IN_SELECT
166 , SQL_MAXIMUM_USER_NAME_LENGTH => 107 # SQL_MAX_USER_NAME_LEN
167 , SQL_MAX_ASYNC_CONCURRENT_STATEMENTS => 10022
168 , SQL_MAX_BINARY_LITERAL_LEN => 112
169 , SQL_MAX_CATALOG_NAME_LEN => 34
170 , SQL_MAX_CHAR_LITERAL_LEN => 108
171 , SQL_MAX_COLUMNS_IN_GROUP_BY => 97
172 , SQL_MAX_COLUMNS_IN_INDEX => 98
173 , SQL_MAX_COLUMNS_IN_ORDER_BY => 99
174 , SQL_MAX_COLUMNS_IN_SELECT => 100
175 , SQL_MAX_COLUMNS_IN_TABLE => 101
176 , SQL_MAX_COLUMN_NAME_LEN => 30
177 , SQL_MAX_CONCURRENT_ACTIVITIES => 1
178 , SQL_MAX_CURSOR_NAME_LEN => 31
179 , SQL_MAX_DRIVER_CONNECTIONS => 0
180 , SQL_MAX_IDENTIFIER_LEN => 10005
181 , SQL_MAX_INDEX_SIZE => 102
182 , SQL_MAX_OWNER_NAME_LEN => 32
183 , SQL_MAX_PROCEDURE_NAME_LEN => 33
184 , SQL_MAX_QUALIFIER_NAME_LEN => 34
185 , SQL_MAX_ROW_SIZE => 104
186 , SQL_MAX_ROW_SIZE_INCLUDES_LONG => 103
187 , SQL_MAX_SCHEMA_NAME_LEN => 32
188 , SQL_MAX_STATEMENT_LEN => 105
189 , SQL_MAX_TABLES_IN_SELECT => 106
190 , SQL_MAX_TABLE_NAME_LEN => 35
191 , SQL_MAX_USER_NAME_LEN => 107
192 , SQL_MULTIPLE_ACTIVE_TXN => 37
193 , SQL_MULT_RESULT_SETS => 36
194 , SQL_NEED_LONG_DATA_LEN => 111
195 , SQL_NON_NULLABLE_COLUMNS => 75
196 , SQL_NULL_COLLATION => 85
197 , SQL_NUMERIC_FUNCTIONS => 49
198 , SQL_ODBC_API_CONFORMANCE => 9
199 , SQL_ODBC_INTERFACE_CONFORMANCE => 152
200 , SQL_ODBC_SAG_CLI_CONFORMANCE => 12
201 , SQL_ODBC_SQL_CONFORMANCE => 15
202 , SQL_ODBC_SQL_OPT_IEF => 73
203 , SQL_ODBC_VER => 10
204 , SQL_OJ_CAPABILITIES => 115
205 , SQL_ORDER_BY_COLUMNS_IN_SELECT => 90
206 , SQL_OUTER_JOINS => 38
207 , SQL_OUTER_JOIN_CAPABILITIES => 115 # SQL_OJ_CAPABILITIES
208 , SQL_OWNER_TERM => 39
209 , SQL_OWNER_USAGE => 91
210 , SQL_PARAM_ARRAY_ROW_COUNTS => 153
211 , SQL_PARAM_ARRAY_SELECTS => 154
212 , SQL_POSITIONED_STATEMENTS => 80
213 , SQL_POS_OPERATIONS => 79
214 , SQL_PROCEDURES => 21
215 , SQL_PROCEDURE_TERM => 40
216 , SQL_QUALIFIER_LOCATION => 114
217 , SQL_QUALIFIER_NAME_SEPARATOR => 41
218 , SQL_QUALIFIER_TERM => 42
219 , SQL_QUALIFIER_USAGE => 92
220 , SQL_QUOTED_IDENTIFIER_CASE => 93
221 , SQL_ROW_UPDATES => 11
222 , SQL_SCHEMA_TERM => 39 # SQL_OWNER_TERM
223 , SQL_SCHEMA_USAGE => 91 # SQL_OWNER_USAGE
224 , SQL_SCROLL_CONCURRENCY => 43
225 , SQL_SCROLL_OPTIONS => 44
226 , SQL_SEARCH_PATTERN_ESCAPE => 14
227 , SQL_SERVER_NAME => 13
228 , SQL_SPECIAL_CHARACTERS => 94
229 , SQL_SQL92_DATETIME_FUNCTIONS => 155
230 , SQL_SQL92_FOREIGN_KEY_DELETE_RULE => 156
231 , SQL_SQL92_FOREIGN_KEY_UPDATE_RULE => 157
232 , SQL_SQL92_GRANT => 158
233 , SQL_SQL92_NUMERIC_VALUE_FUNCTIONS => 159
234 , SQL_SQL92_PREDICATES => 160
235 , SQL_SQL92_RELATIONAL_JOIN_OPERATORS => 161
236 , SQL_SQL92_REVOKE => 162
237 , SQL_SQL92_ROW_VALUE_CONSTRUCTOR => 163
238 , SQL_SQL92_STRING_FUNCTIONS => 164
239 , SQL_SQL92_VALUE_EXPRESSIONS => 165
240 , SQL_SQL_CONFORMANCE => 118
241 , SQL_STANDARD_CLI_CONFORMANCE => 166
242 , SQL_STATIC_CURSOR_ATTRIBUTES1 => 167
243 , SQL_STATIC_CURSOR_ATTRIBUTES2 => 168
244 , SQL_STATIC_SENSITIVITY => 83
245 , SQL_STRING_FUNCTIONS => 50
246 , SQL_SUBQUERIES => 95
247 , SQL_SYSTEM_FUNCTIONS => 51
248 , SQL_TABLE_TERM => 45
249 , SQL_TIMEDATE_ADD_INTERVALS => 109
250 , SQL_TIMEDATE_DIFF_INTERVALS => 110
251 , SQL_TIMEDATE_FUNCTIONS => 52
252 , SQL_TRANSACTION_CAPABLE => 46 # SQL_TXN_CAPABLE
253 , SQL_TRANSACTION_ISOLATION_OPTION => 72 # SQL_TXN_ISOLATION_OPTION
254 , SQL_TXN_CAPABLE => 46
255 , SQL_TXN_ISOLATION_OPTION => 72
256 , SQL_UNION => 96
257 , SQL_UNION_STATEMENT => 96 # SQL_UNION
258 , SQL_USER_NAME => 47
259 , SQL_XOPEN_CLI_YEAR => 10000
260 );
261  
262 =head2 %ReturnTypes
263  
264 See: mk:@MSITStore:X:\dm\cli\mdac\sdk26\Docs\odbc.chm::/htm/odbcsqlgetinfo.htm
265  
266 => : alias
267 => !!! : edited
268  
269 =cut
270  
271 8 %ReturnTypes =
272 (
273 SQL_ACCESSIBLE_PROCEDURES => 'SQLCHAR' # 20
274 , SQL_ACCESSIBLE_TABLES => 'SQLCHAR' # 19
275 , SQL_ACTIVE_CONNECTIONS => 'SQLUSMALLINT' # 0 =>
276 , SQL_ACTIVE_ENVIRONMENTS => 'SQLUSMALLINT' # 116
277 , SQL_ACTIVE_STATEMENTS => 'SQLUSMALLINT' # 1 =>
278 , SQL_AGGREGATE_FUNCTIONS => 'SQLUINTEGER bitmask' # 169
279 , SQL_ALTER_DOMAIN => 'SQLUINTEGER bitmask' # 117
280 , SQL_ALTER_TABLE => 'SQLUINTEGER bitmask' # 86
281 , SQL_ASYNC_MODE => 'SQLUINTEGER' # 10021
282 , SQL_BATCH_ROW_COUNT => 'SQLUINTEGER bitmask' # 120
283 , SQL_BATCH_SUPPORT => 'SQLUINTEGER bitmask' # 121
284 , SQL_BOOKMARK_PERSISTENCE => 'SQLUINTEGER bitmask' # 82
285 , SQL_CATALOG_LOCATION => 'SQLUSMALLINT' # 114
286 , SQL_CATALOG_NAME => 'SQLCHAR' # 10003
287 , SQL_CATALOG_NAME_SEPARATOR => 'SQLCHAR' # 41
288 , SQL_CATALOG_TERM => 'SQLCHAR' # 42
289 , SQL_CATALOG_USAGE => 'SQLUINTEGER bitmask' # 92
290 , SQL_COLLATION_SEQ => 'SQLCHAR' # 10004
291 , SQL_COLUMN_ALIAS => 'SQLCHAR' # 87
292 , SQL_CONCAT_NULL_BEHAVIOR => 'SQLUSMALLINT' # 22
293 , SQL_CONVERT_BIGINT => 'SQLUINTEGER bitmask' # 53
294 , SQL_CONVERT_BINARY => 'SQLUINTEGER bitmask' # 54
295 , SQL_CONVERT_BIT => 'SQLUINTEGER bitmask' # 55
296 , SQL_CONVERT_CHAR => 'SQLUINTEGER bitmask' # 56
297 , SQL_CONVERT_DATE => 'SQLUINTEGER bitmask' # 57
298 , SQL_CONVERT_DECIMAL => 'SQLUINTEGER bitmask' # 58
299 , SQL_CONVERT_DOUBLE => 'SQLUINTEGER bitmask' # 59
300 , SQL_CONVERT_FLOAT => 'SQLUINTEGER bitmask' # 60
301 , SQL_CONVERT_FUNCTIONS => 'SQLUINTEGER bitmask' # 48
302 , SQL_CONVERT_GUID => 'SQLUINTEGER bitmask' # 173
303 , SQL_CONVERT_INTEGER => 'SQLUINTEGER bitmask' # 61
304 , SQL_CONVERT_INTERVAL_DAY_TIME => 'SQLUINTEGER bitmask' # 123
305 , SQL_CONVERT_INTERVAL_YEAR_MONTH => 'SQLUINTEGER bitmask' # 124
306 , SQL_CONVERT_LONGVARBINARY => 'SQLUINTEGER bitmask' # 71
307 , SQL_CONVERT_LONGVARCHAR => 'SQLUINTEGER bitmask' # 62
308 , SQL_CONVERT_NUMERIC => 'SQLUINTEGER bitmask' # 63
309 , SQL_CONVERT_REAL => 'SQLUINTEGER bitmask' # 64
310 , SQL_CONVERT_SMALLINT => 'SQLUINTEGER bitmask' # 65
311 , SQL_CONVERT_TIME => 'SQLUINTEGER bitmask' # 66
312 , SQL_CONVERT_TIMESTAMP => 'SQLUINTEGER bitmask' # 67
313 , SQL_CONVERT_TINYINT => 'SQLUINTEGER bitmask' # 68
314 , SQL_CONVERT_VARBINARY => 'SQLUINTEGER bitmask' # 69
315 , SQL_CONVERT_VARCHAR => 'SQLUINTEGER bitmask' # 70
316 , SQL_CONVERT_WCHAR => 'SQLUINTEGER bitmask' # 122 => !!!
317 , SQL_CONVERT_WLONGVARCHAR => 'SQLUINTEGER bitmask' # 125 => !!!
318 , SQL_CONVERT_WVARCHAR => 'SQLUINTEGER bitmask' # 126 => !!!
319 , SQL_CORRELATION_NAME => 'SQLUSMALLINT' # 74
320 , SQL_CREATE_ASSERTION => 'SQLUINTEGER bitmask' # 127
321 , SQL_CREATE_CHARACTER_SET => 'SQLUINTEGER bitmask' # 128
322 , SQL_CREATE_COLLATION => 'SQLUINTEGER bitmask' # 129
323 , SQL_CREATE_DOMAIN => 'SQLUINTEGER bitmask' # 130
324 , SQL_CREATE_SCHEMA => 'SQLUINTEGER bitmask' # 131
325 , SQL_CREATE_TABLE => 'SQLUINTEGER bitmask' # 132
326 , SQL_CREATE_TRANSLATION => 'SQLUINTEGER bitmask' # 133
327 , SQL_CREATE_VIEW => 'SQLUINTEGER bitmask' # 134
328 , SQL_CURSOR_COMMIT_BEHAVIOR => 'SQLUSMALLINT' # 23
329 , SQL_CURSOR_ROLLBACK_BEHAVIOR => 'SQLUSMALLINT' # 24
330 , SQL_CURSOR_SENSITIVITY => 'SQLUINTEGER' # 10001
331 , SQL_DATA_SOURCE_NAME => 'SQLCHAR' # 2
332 , SQL_DATA_SOURCE_READ_ONLY => 'SQLCHAR' # 25
333 , SQL_DATABASE_NAME => 'SQLCHAR' # 16
334 , SQL_DATETIME_LITERALS => 'SQLUINTEGER bitmask' # 119
335 , SQL_DBMS_NAME => 'SQLCHAR' # 17
336 , SQL_DBMS_VER => 'SQLCHAR' # 18
337 , SQL_DDL_INDEX => 'SQLUINTEGER bitmask' # 170
338 , SQL_DEFAULT_TXN_ISOLATION => 'SQLUINTEGER' # 26
339 , SQL_DESCRIBE_PARAMETER => 'SQLCHAR' # 10002
340 , SQL_DM_VER => 'SQLCHAR' # 171
341 , SQL_DRIVER_HDBC => 'SQLUINTEGER' # 3
342 , SQL_DRIVER_HDESC => 'SQLUINTEGER' # 135
343 , SQL_DRIVER_HENV => 'SQLUINTEGER' # 4
344 , SQL_DRIVER_HLIB => 'SQLUINTEGER' # 76
345 , SQL_DRIVER_HSTMT => 'SQLUINTEGER' # 5
346 , SQL_DRIVER_NAME => 'SQLCHAR' # 6
347 , SQL_DRIVER_ODBC_VER => 'SQLCHAR' # 77
348 , SQL_DRIVER_VER => 'SQLCHAR' # 7
349 , SQL_DROP_ASSERTION => 'SQLUINTEGER bitmask' # 136
350 , SQL_DROP_CHARACTER_SET => 'SQLUINTEGER bitmask' # 137
351 , SQL_DROP_COLLATION => 'SQLUINTEGER bitmask' # 138
352 , SQL_DROP_DOMAIN => 'SQLUINTEGER bitmask' # 139
353 , SQL_DROP_SCHEMA => 'SQLUINTEGER bitmask' # 140
354 , SQL_DROP_TABLE => 'SQLUINTEGER bitmask' # 141
355 , SQL_DROP_TRANSLATION => 'SQLUINTEGER bitmask' # 142
356 , SQL_DROP_VIEW => 'SQLUINTEGER bitmask' # 143
357 , SQL_DYNAMIC_CURSOR_ATTRIBUTES1 => 'SQLUINTEGER bitmask' # 144
358 , SQL_DYNAMIC_CURSOR_ATTRIBUTES2 => 'SQLUINTEGER bitmask' # 145
359 , SQL_EXPRESSIONS_IN_ORDERBY => 'SQLCHAR' # 27
360 , SQL_FETCH_DIRECTION => 'SQLUINTEGER bitmask' # 8 => !!!
361 , SQL_FILE_USAGE => 'SQLUSMALLINT' # 84
362 , SQL_FORWARD_ONLY_CURSOR_ATTRIBUTES1 => 'SQLUINTEGER bitmask' # 146
363 , SQL_FORWARD_ONLY_CURSOR_ATTRIBUTES2 => 'SQLUINTEGER bitmask' # 147
364 , SQL_GETDATA_EXTENSIONS => 'SQLUINTEGER bitmask' # 81
365 , SQL_GROUP_BY => 'SQLUSMALLINT' # 88
366 , SQL_IDENTIFIER_CASE => 'SQLUSMALLINT' # 28
367 , SQL_IDENTIFIER_QUOTE_CHAR => 'SQLCHAR' # 29
368 , SQL_INDEX_KEYWORDS => 'SQLUINTEGER bitmask' # 148
369 # SQL_INFO_DRIVER_START => '' # 1000 =>
370 # SQL_INFO_FIRST => 'SQLUSMALLINT' # 0 =>
371 # SQL_INFO_LAST => 'SQLUSMALLINT' # 114 =>
372 , SQL_INFO_SCHEMA_VIEWS => 'SQLUINTEGER bitmask' # 149
373 , SQL_INSERT_STATEMENT => 'SQLUINTEGER bitmask' # 172
374 , SQL_INTEGRITY => 'SQLCHAR' # 73
375 , SQL_KEYSET_CURSOR_ATTRIBUTES1 => 'SQLUINTEGER bitmask' # 150
376 , SQL_KEYSET_CURSOR_ATTRIBUTES2 => 'SQLUINTEGER bitmask' # 151
377 , SQL_KEYWORDS => 'SQLCHAR' # 89
378 , SQL_LIKE_ESCAPE_CLAUSE => 'SQLCHAR' # 113
379 , SQL_LOCK_TYPES => 'SQLUINTEGER bitmask' # 78 => !!!
380 , SQL_MAXIMUM_CATALOG_NAME_LENGTH => 'SQLUSMALLINT' # 34 =>
381 , SQL_MAXIMUM_COLUMNS_IN_GROUP_BY => 'SQLUSMALLINT' # 97 =>
382 , SQL_MAXIMUM_COLUMNS_IN_INDEX => 'SQLUSMALLINT' # 98 =>
383 , SQL_MAXIMUM_COLUMNS_IN_ORDER_BY => 'SQLUSMALLINT' # 99 =>
384 , SQL_MAXIMUM_COLUMNS_IN_SELECT => 'SQLUSMALLINT' # 100 =>
385 , SQL_MAXIMUM_COLUMN_NAME_LENGTH => 'SQLUSMALLINT' # 30 =>
386 , SQL_MAXIMUM_CONCURRENT_ACTIVITIES => 'SQLUSMALLINT' # 1 =>
387 , SQL_MAXIMUM_CURSOR_NAME_LENGTH => 'SQLUSMALLINT' # 31 =>
388 , SQL_MAXIMUM_DRIVER_CONNECTIONS => 'SQLUSMALLINT' # 0 =>
389 , SQL_MAXIMUM_IDENTIFIER_LENGTH => 'SQLUSMALLINT' # 10005 =>
390 , SQL_MAXIMUM_INDEX_SIZE => 'SQLUINTEGER' # 102 =>
391 , SQL_MAXIMUM_ROW_SIZE => 'SQLUINTEGER' # 104 =>
392 , SQL_MAXIMUM_SCHEMA_NAME_LENGTH => 'SQLUSMALLINT' # 32 =>
393 , SQL_MAXIMUM_STATEMENT_LENGTH => 'SQLUINTEGER' # 105 =>
394 , SQL_MAXIMUM_TABLES_IN_SELECT => 'SQLUSMALLINT' # 106 =>
395 , SQL_MAXIMUM_USER_NAME_LENGTH => 'SQLUSMALLINT' # 107 =>
396 , SQL_MAX_ASYNC_CONCURRENT_STATEMENTS => 'SQLUINTEGER' # 10022
397 , SQL_MAX_BINARY_LITERAL_LEN => 'SQLUINTEGER' # 112
398 , SQL_MAX_CATALOG_NAME_LEN => 'SQLUSMALLINT' # 34
399 , SQL_MAX_CHAR_LITERAL_LEN => 'SQLUINTEGER' # 108
400 , SQL_MAX_COLUMNS_IN_GROUP_BY => 'SQLUSMALLINT' # 97
401 , SQL_MAX_COLUMNS_IN_INDEX => 'SQLUSMALLINT' # 98
402 , SQL_MAX_COLUMNS_IN_ORDER_BY => 'SQLUSMALLINT' # 99
403 , SQL_MAX_COLUMNS_IN_SELECT => 'SQLUSMALLINT' # 100
404 , SQL_MAX_COLUMNS_IN_TABLE => 'SQLUSMALLINT' # 101
405 , SQL_MAX_COLUMN_NAME_LEN => 'SQLUSMALLINT' # 30
406 , SQL_MAX_CONCURRENT_ACTIVITIES => 'SQLUSMALLINT' # 1
407 , SQL_MAX_CURSOR_NAME_LEN => 'SQLUSMALLINT' # 31
408 , SQL_MAX_DRIVER_CONNECTIONS => 'SQLUSMALLINT' # 0
409 , SQL_MAX_IDENTIFIER_LEN => 'SQLUSMALLINT' # 10005
410 , SQL_MAX_INDEX_SIZE => 'SQLUINTEGER' # 102
411 , SQL_MAX_OWNER_NAME_LEN => 'SQLUSMALLINT' # 32 =>
412 , SQL_MAX_PROCEDURE_NAME_LEN => 'SQLUSMALLINT' # 33
413 , SQL_MAX_QUALIFIER_NAME_LEN => 'SQLUSMALLINT' # 34 =>
414 , SQL_MAX_ROW_SIZE => 'SQLUINTEGER' # 104
415 , SQL_MAX_ROW_SIZE_INCLUDES_LONG => 'SQLCHAR' # 103
416 , SQL_MAX_SCHEMA_NAME_LEN => 'SQLUSMALLINT' # 32
417 , SQL_MAX_STATEMENT_LEN => 'SQLUINTEGER' # 105
418 , SQL_MAX_TABLES_IN_SELECT => 'SQLUSMALLINT' # 106
419 , SQL_MAX_TABLE_NAME_LEN => 'SQLUSMALLINT' # 35
420 , SQL_MAX_USER_NAME_LEN => 'SQLUSMALLINT' # 107
421 , SQL_MULTIPLE_ACTIVE_TXN => 'SQLCHAR' # 37
422 , SQL_MULT_RESULT_SETS => 'SQLCHAR' # 36
423 , SQL_NEED_LONG_DATA_LEN => 'SQLCHAR' # 111
424 , SQL_NON_NULLABLE_COLUMNS => 'SQLUSMALLINT' # 75
425 , SQL_NULL_COLLATION => 'SQLUSMALLINT' # 85
426 , SQL_NUMERIC_FUNCTIONS => 'SQLUINTEGER bitmask' # 49
427 , SQL_ODBC_API_CONFORMANCE => 'SQLUSMALLINT' # 9 => !!!
428 , SQL_ODBC_INTERFACE_CONFORMANCE => 'SQLUINTEGER' # 152
429 , SQL_ODBC_SAG_CLI_CONFORMANCE => 'SQLUSMALLINT' # 12 => !!!
430 , SQL_ODBC_SQL_CONFORMANCE => 'SQLUSMALLINT' # 15 => !!!
431 , SQL_ODBC_SQL_OPT_IEF => 'SQLCHAR' # 73 =>
432 , SQL_ODBC_VER => 'SQLCHAR' # 10
433 , SQL_OJ_CAPABILITIES => 'SQLUINTEGER bitmask' # 115
434 , SQL_ORDER_BY_COLUMNS_IN_SELECT => 'SQLCHAR' # 90
435 , SQL_OUTER_JOINS => 'SQLCHAR' # 38 => !!!
436 , SQL_OUTER_JOIN_CAPABILITIES => 'SQLUINTEGER bitmask' # 115 =>
437 , SQL_OWNER_TERM => 'SQLCHAR' # 39 =>
438 , SQL_OWNER_USAGE => 'SQLUINTEGER bitmask' # 91 =>
439 , SQL_PARAM_ARRAY_ROW_COUNTS => 'SQLUINTEGER' # 153
440 , SQL_PARAM_ARRAY_SELECTS => 'SQLUINTEGER' # 154
441 , SQL_POSITIONED_STATEMENTS => 'SQLUINTEGER bitmask' # 80 => !!!
442 , SQL_POS_OPERATIONS => 'SQLINTEGER bitmask' # 79
443 , SQL_PROCEDURES => 'SQLCHAR' # 21
444 , SQL_PROCEDURE_TERM => 'SQLCHAR' # 40
445 , SQL_QUALIFIER_LOCATION => 'SQLUSMALLINT' # 114 =>
446 , SQL_QUALIFIER_NAME_SEPARATOR => 'SQLCHAR' # 41 =>
447 , SQL_QUALIFIER_TERM => 'SQLCHAR' # 42 =>
448 , SQL_QUALIFIER_USAGE => 'SQLUINTEGER bitmask' # 92 =>
449 , SQL_QUOTED_IDENTIFIER_CASE => 'SQLUSMALLINT' # 93
450 , SQL_ROW_UPDATES => 'SQLCHAR' # 11
451 , SQL_SCHEMA_TERM => 'SQLCHAR' # 39
452 , SQL_SCHEMA_USAGE => 'SQLUINTEGER bitmask' # 91
453 , SQL_SCROLL_CONCURRENCY => 'SQLUINTEGER bitmask' # 43 => !!!
454 , SQL_SCROLL_OPTIONS => 'SQLUINTEGER bitmask' # 44
455 , SQL_SEARCH_PATTERN_ESCAPE => 'SQLCHAR' # 14
456 , SQL_SERVER_NAME => 'SQLCHAR' # 13
457 , SQL_SPECIAL_CHARACTERS => 'SQLCHAR' # 94
458 , SQL_SQL92_DATETIME_FUNCTIONS => 'SQLUINTEGER bitmask' # 155
459 , SQL_SQL92_FOREIGN_KEY_DELETE_RULE => 'SQLUINTEGER bitmask' # 156
460 , SQL_SQL92_FOREIGN_KEY_UPDATE_RULE => 'SQLUINTEGER bitmask' # 157
461 , SQL_SQL92_GRANT => 'SQLUINTEGER bitmask' # 158
462 , SQL_SQL92_NUMERIC_VALUE_FUNCTIONS => 'SQLUINTEGER bitmask' # 159
463 , SQL_SQL92_PREDICATES => 'SQLUINTEGER bitmask' # 160
464 , SQL_SQL92_RELATIONAL_JOIN_OPERATORS => 'SQLUINTEGER bitmask' # 161
465 , SQL_SQL92_REVOKE => 'SQLUINTEGER bitmask' # 162
466 , SQL_SQL92_ROW_VALUE_CONSTRUCTOR => 'SQLUINTEGER bitmask' # 163
467 , SQL_SQL92_STRING_FUNCTIONS => 'SQLUINTEGER bitmask' # 164
468 , SQL_SQL92_VALUE_EXPRESSIONS => 'SQLUINTEGER bitmask' # 165
469 , SQL_SQL_CONFORMANCE => 'SQLUINTEGER' # 118
470 , SQL_STANDARD_CLI_CONFORMANCE => 'SQLUINTEGER bitmask' # 166
471 , SQL_STATIC_CURSOR_ATTRIBUTES1 => 'SQLUINTEGER bitmask' # 167
472 , SQL_STATIC_CURSOR_ATTRIBUTES2 => 'SQLUINTEGER bitmask' # 168
473 , SQL_STATIC_SENSITIVITY => 'SQLUINTEGER bitmask' # 83 => !!!
474 , SQL_STRING_FUNCTIONS => 'SQLUINTEGER bitmask' # 50
475 , SQL_SUBQUERIES => 'SQLUINTEGER bitmask' # 95
476 , SQL_SYSTEM_FUNCTIONS => 'SQLUINTEGER bitmask' # 51
477 , SQL_TABLE_TERM => 'SQLCHAR' # 45
478 , SQL_TIMEDATE_ADD_INTERVALS => 'SQLUINTEGER bitmask' # 109
479 , SQL_TIMEDATE_DIFF_INTERVALS => 'SQLUINTEGER bitmask' # 110
480 , SQL_TIMEDATE_FUNCTIONS => 'SQLUINTEGER bitmask' # 52
481 , SQL_TRANSACTION_CAPABLE => 'SQLUSMALLINT' # 46 =>
482 , SQL_TRANSACTION_ISOLATION_OPTION => 'SQLUINTEGER bitmask' # 72 =>
483 , SQL_TXN_CAPABLE => 'SQLUSMALLINT' # 46
484 , SQL_TXN_ISOLATION_OPTION => 'SQLUINTEGER bitmask' # 72
485 , SQL_UNION => 'SQLUINTEGER bitmask' # 96
486 , SQL_UNION_STATEMENT => 'SQLUINTEGER bitmask' # 96 =>
487 , SQL_USER_NAME => 'SQLCHAR' # 47
488 , SQL_XOPEN_CLI_YEAR => 'SQLCHAR' # 10000
489 );
490  
491 =head2 %ReturnValues
492  
493 See: sql.h, sqlext.h
494 Edited:
495 SQL_TXN_ISOLATION_OPTION
496  
497 =cut
498  
499 $ReturnValues{SQL_AGGREGATE_FUNCTIONS} =
500 {
501 8 SQL_AF_AVG => 0x00000001
502 , SQL_AF_COUNT => 0x00000002
503 , SQL_AF_MAX => 0x00000004
504 , SQL_AF_MIN => 0x00000008
505 , SQL_AF_SUM => 0x00000010
506 , SQL_AF_DISTINCT => 0x00000020
507 , SQL_AF_ALL => 0x00000040
508 };
509 $ReturnValues{SQL_ALTER_DOMAIN} =
510 {
511 8 SQL_AD_CONSTRAINT_NAME_DEFINITION => 0x00000001
512 , SQL_AD_ADD_DOMAIN_CONSTRAINT => 0x00000002
513 , SQL_AD_DROP_DOMAIN_CONSTRAINT => 0x00000004
514 , SQL_AD_ADD_DOMAIN_DEFAULT => 0x00000008
515 , SQL_AD_DROP_DOMAIN_DEFAULT => 0x00000010
516 , SQL_AD_ADD_CONSTRAINT_INITIALLY_DEFERRED => 0x00000020
517 , SQL_AD_ADD_CONSTRAINT_INITIALLY_IMMEDIATE => 0x00000040
518 , SQL_AD_ADD_CONSTRAINT_DEFERRABLE => 0x00000080
519 , SQL_AD_ADD_CONSTRAINT_NON_DEFERRABLE => 0x00000100
520 };
521 $ReturnValues{SQL_ALTER_TABLE} =
522 {
523 8 SQL_AT_ADD_COLUMN => 0x00000001
524 , SQL_AT_DROP_COLUMN => 0x00000002
525 , SQL_AT_ADD_CONSTRAINT => 0x00000008
526 , SQL_AT_ADD_COLUMN_SINGLE => 0x00000020
527 , SQL_AT_ADD_COLUMN_DEFAULT => 0x00000040
528 , SQL_AT_ADD_COLUMN_COLLATION => 0x00000080
529 , SQL_AT_SET_COLUMN_DEFAULT => 0x00000100
530 , SQL_AT_DROP_COLUMN_DEFAULT => 0x00000200
531 , SQL_AT_DROP_COLUMN_CASCADE => 0x00000400
532 , SQL_AT_DROP_COLUMN_RESTRICT => 0x00000800
533 , SQL_AT_ADD_TABLE_CONSTRAINT => 0x00001000
534 , SQL_AT_DROP_TABLE_CONSTRAINT_CASCADE => 0x00002000
535 , SQL_AT_DROP_TABLE_CONSTRAINT_RESTRICT => 0x00004000
536 , SQL_AT_CONSTRAINT_NAME_DEFINITION => 0x00008000
537 , SQL_AT_CONSTRAINT_INITIALLY_DEFERRED => 0x00010000
538 , SQL_AT_CONSTRAINT_INITIALLY_IMMEDIATE => 0x00020000
539 , SQL_AT_CONSTRAINT_DEFERRABLE => 0x00040000
540 , SQL_AT_CONSTRAINT_NON_DEFERRABLE => 0x00080000
541 };
542 $ReturnValues{SQL_ASYNC_MODE} =
543 {
544 8 SQL_AM_NONE => 0
545 , SQL_AM_CONNECTION => 1
546 , SQL_AM_STATEMENT => 2
547 };
548 $ReturnValues{SQL_ATTR_MAX_ROWS} =
549 {
550 8 SQL_CA2_MAX_ROWS_SELECT => 0x00000080
551 , SQL_CA2_MAX_ROWS_INSERT => 0x00000100
552 , SQL_CA2_MAX_ROWS_DELETE => 0x00000200
553 , SQL_CA2_MAX_ROWS_UPDATE => 0x00000400
554 , SQL_CA2_MAX_ROWS_CATALOG => 0x00000800
555 # SQL_CA2_MAX_ROWS_AFFECTS_ALL =>
556 };
557 $ReturnValues{SQL_ATTR_SCROLL_CONCURRENCY} =
558 {
559 8 SQL_CA2_READ_ONLY_CONCURRENCY => 0x00000001
560 , SQL_CA2_LOCK_CONCURRENCY => 0x00000002
561 , SQL_CA2_OPT_ROWVER_CONCURRENCY => 0x00000004
562 , SQL_CA2_OPT_VALUES_CONCURRENCY => 0x00000008
563 , SQL_CA2_SENSITIVITY_ADDITIONS => 0x00000010
564 , SQL_CA2_SENSITIVITY_DELETIONS => 0x00000020
565 , SQL_CA2_SENSITIVITY_UPDATES => 0x00000040
566 };
567 $ReturnValues{SQL_BATCH_ROW_COUNT} =
568 {
569 8 SQL_BRC_PROCEDURES => 0x0000001
570 , SQL_BRC_EXPLICIT => 0x0000002
571 , SQL_BRC_ROLLED_UP => 0x0000004
572 };
573 $ReturnValues{SQL_BATCH_SUPPORT} =
574 {
575 8 SQL_BS_SELECT_EXPLICIT => 0x00000001
576 , SQL_BS_ROW_COUNT_EXPLICIT => 0x00000002
577 , SQL_BS_SELECT_PROC => 0x00000004
578 , SQL_BS_ROW_COUNT_PROC => 0x00000008
579 };
580 $ReturnValues{SQL_BOOKMARK_PERSISTENCE} =
581 {
582 8 SQL_BP_CLOSE => 0x00000001
583 , SQL_BP_DELETE => 0x00000002
584 , SQL_BP_DROP => 0x00000004
585 , SQL_BP_TRANSACTION => 0x00000008
586 , SQL_BP_UPDATE => 0x00000010
587 , SQL_BP_OTHER_HSTMT => 0x00000020
588 , SQL_BP_SCROLL => 0x00000040
589 };
590 $ReturnValues{SQL_CATALOG_LOCATION} =
591 {
592 8 SQL_CL_START => 0x0001 # SQL_QL_START
593 , SQL_CL_END => 0x0002 # SQL_QL_END
594 };
595 $ReturnValues{SQL_CATALOG_USAGE} =
596 {
597 8 SQL_CU_DML_STATEMENTS => 0x00000001 # SQL_QU_DML_STATEMENTS
598 , SQL_CU_PROCEDURE_INVOCATION => 0x00000002 # SQL_QU_PROCEDURE_INVOCATION
599 , SQL_CU_TABLE_DEFINITION => 0x00000004 # SQL_QU_TABLE_DEFINITION
600 , SQL_CU_INDEX_DEFINITION => 0x00000008 # SQL_QU_INDEX_DEFINITION
601 , SQL_CU_PRIVILEGE_DEFINITION => 0x00000010 # SQL_QU_PRIVILEGE_DEFINITION
602 };
603 $ReturnValues{SQL_CONCAT_NULL_BEHAVIOR} =
604 {
605 8 SQL_CB_NULL => 0x0000
606 , SQL_CB_NON_NULL => 0x0001
607 };
608 $ReturnValues{SQL_CONVERT_} =
609 {
610 8 SQL_CVT_CHAR => 0x00000001
611 , SQL_CVT_NUMERIC => 0x00000002
612 , SQL_CVT_DECIMAL => 0x00000004
613 , SQL_CVT_INTEGER => 0x00000008
614 , SQL_CVT_SMALLINT => 0x00000010
615 , SQL_CVT_FLOAT => 0x00000020
616 , SQL_CVT_REAL => 0x00000040
617 , SQL_CVT_DOUBLE => 0x00000080
618 , SQL_CVT_VARCHAR => 0x00000100
619 , SQL_CVT_LONGVARCHAR => 0x00000200
620 , SQL_CVT_BINARY => 0x00000400
621 , SQL_CVT_VARBINARY => 0x00000800
622 , SQL_CVT_BIT => 0x00001000
623 , SQL_CVT_TINYINT => 0x00002000
624 , SQL_CVT_BIGINT => 0x00004000
625 , SQL_CVT_DATE => 0x00008000
626 , SQL_CVT_TIME => 0x00010000
627 , SQL_CVT_TIMESTAMP => 0x00020000
628 , SQL_CVT_LONGVARBINARY => 0x00040000
629 , SQL_CVT_INTERVAL_YEAR_MONTH => 0x00080000
630 , SQL_CVT_INTERVAL_DAY_TIME => 0x00100000
631 , SQL_CVT_WCHAR => 0x00200000
632 , SQL_CVT_WLONGVARCHAR => 0x00400000
633 , SQL_CVT_WVARCHAR => 0x00800000
634 , SQL_CVT_GUID => 0x01000000
635 };
636 8 $ReturnValues{SQL_CONVERT_BIGINT } = $ReturnValues{SQL_CONVERT_};
637 8 $ReturnValues{SQL_CONVERT_BINARY } = $ReturnValues{SQL_CONVERT_};
638 8 $ReturnValues{SQL_CONVERT_BIT } = $ReturnValues{SQL_CONVERT_};
639 8 $ReturnValues{SQL_CONVERT_CHAR } = $ReturnValues{SQL_CONVERT_};
640 8 $ReturnValues{SQL_CONVERT_DATE } = $ReturnValues{SQL_CONVERT_};
641 8 $ReturnValues{SQL_CONVERT_DECIMAL } = $ReturnValues{SQL_CONVERT_};
642 8 $ReturnValues{SQL_CONVERT_DOUBLE } = $ReturnValues{SQL_CONVERT_};
643 8 $ReturnValues{SQL_CONVERT_FLOAT } = $ReturnValues{SQL_CONVERT_};
644 8 $ReturnValues{SQL_CONVERT_GUID } = $ReturnValues{SQL_CONVERT_};
645 8 $ReturnValues{SQL_CONVERT_INTEGER } = $ReturnValues{SQL_CONVERT_};
646 8 $ReturnValues{SQL_CONVERT_INTERVAL_DAY_TIME } = $ReturnValues{SQL_CONVERT_};
647 8 $ReturnValues{SQL_CONVERT_INTERVAL_YEAR_MONTH} = $ReturnValues{SQL_CONVERT_};
648 8 $ReturnValues{SQL_CONVERT_LONGVARBINARY } = $ReturnValues{SQL_CONVERT_};
649 8 $ReturnValues{SQL_CONVERT_LONGVARCHAR } = $ReturnValues{SQL_CONVERT_};
650 8 $ReturnValues{SQL_CONVERT_NUMERIC } = $ReturnValues{SQL_CONVERT_};
651 8 $ReturnValues{SQL_CONVERT_REAL } = $ReturnValues{SQL_CONVERT_};
652 8 $ReturnValues{SQL_CONVERT_SMALLINT } = $ReturnValues{SQL_CONVERT_};
653 8 $ReturnValues{SQL_CONVERT_TIME } = $ReturnValues{SQL_CONVERT_};
654 8 $ReturnValues{SQL_CONVERT_TIMESTAMP } = $ReturnValues{SQL_CONVERT_};
655 8 $ReturnValues{SQL_CONVERT_TINYINT } = $ReturnValues{SQL_CONVERT_};
656 8 $ReturnValues{SQL_CONVERT_VARBINARY } = $ReturnValues{SQL_CONVERT_};
657 8 $ReturnValues{SQL_CONVERT_VARCHAR } = $ReturnValues{SQL_CONVERT_};
658 8 $ReturnValues{SQL_CONVERT_WCHAR } = $ReturnValues{SQL_CONVERT_};
659 8 $ReturnValues{SQL_CONVERT_WLONGVARCHAR } = $ReturnValues{SQL_CONVERT_};
660 8 $ReturnValues{SQL_CONVERT_WVARCHAR } = $ReturnValues{SQL_CONVERT_};
661  
662 $ReturnValues{SQL_CONVERT_FUNCTIONS} =
663 {
664 8 SQL_FN_CVT_CONVERT => 0x00000001
665 , SQL_FN_CVT_CAST => 0x00000002
666 };
667 $ReturnValues{SQL_CORRELATION_NAME} =
668 {
669 8 SQL_CN_NONE => 0x0000
670 , SQL_CN_DIFFERENT => 0x0001
671 , SQL_CN_ANY => 0x0002
672 };
673 $ReturnValues{SQL_CREATE_ASSERTION} =
674 {
675 8 SQL_CA_CREATE_ASSERTION => 0x00000001
676 , SQL_CA_CONSTRAINT_INITIALLY_DEFERRED => 0x00000010
677 , SQL_CA_CONSTRAINT_INITIALLY_IMMEDIATE => 0x00000020
678 , SQL_CA_CONSTRAINT_DEFERRABLE => 0x00000040
679 , SQL_CA_CONSTRAINT_NON_DEFERRABLE => 0x00000080
680 };
681 $ReturnValues{SQL_CREATE_CHARACTER_SET} =
682 {
683 8 SQL_CCS_CREATE_CHARACTER_SET => 0x00000001
684 , SQL_CCS_COLLATE_CLAUSE => 0x00000002
685 , SQL_CCS_LIMITED_COLLATION => 0x00000004
686 };
687 $ReturnValues{SQL_CREATE_COLLATION} =
688 {
689 8 SQL_CCOL_CREATE_COLLATION => 0x00000001
690 };
691 $ReturnValues{SQL_CREATE_DOMAIN} =
692 {
693 8 SQL_CDO_CREATE_DOMAIN => 0x00000001
694 , SQL_CDO_DEFAULT => 0x00000002
695 , SQL_CDO_CONSTRAINT => 0x00000004
696 , SQL_CDO_COLLATION => 0x00000008
697 , SQL_CDO_CONSTRAINT_NAME_DEFINITION => 0x00000010
698 , SQL_CDO_CONSTRAINT_INITIALLY_DEFERRED => 0x00000020
699 , SQL_CDO_CONSTRAINT_INITIALLY_IMMEDIATE => 0x00000040
700 , SQL_CDO_CONSTRAINT_DEFERRABLE => 0x00000080
701 , SQL_CDO_CONSTRAINT_NON_DEFERRABLE => 0x00000100
702 };
703 $ReturnValues{SQL_CREATE_SCHEMA} =
704 {
705 8 SQL_CS_CREATE_SCHEMA => 0x00000001
706 , SQL_CS_AUTHORIZATION => 0x00000002
707 , SQL_CS_DEFAULT_CHARACTER_SET => 0x00000004
708 };
709 $ReturnValues{SQL_CREATE_TABLE} =
710 {
711 8 SQL_CT_CREATE_TABLE => 0x00000001
712 , SQL_CT_COMMIT_PRESERVE => 0x00000002
713 , SQL_CT_COMMIT_DELETE => 0x00000004
714 , SQL_CT_GLOBAL_TEMPORARY => 0x00000008
715 , SQL_CT_LOCAL_TEMPORARY => 0x00000010
716 , SQL_CT_CONSTRAINT_INITIALLY_DEFERRED => 0x00000020
717 , SQL_CT_CONSTRAINT_INITIALLY_IMMEDIATE => 0x00000040
718 , SQL_CT_CONSTRAINT_DEFERRABLE => 0x00000080
719 , SQL_CT_CONSTRAINT_NON_DEFERRABLE => 0x00000100
720 , SQL_CT_COLUMN_CONSTRAINT => 0x00000200
721 , SQL_CT_COLUMN_DEFAULT => 0x00000400
722 , SQL_CT_COLUMN_COLLATION => 0x00000800
723 , SQL_CT_TABLE_CONSTRAINT => 0x00001000
724 , SQL_CT_CONSTRAINT_NAME_DEFINITION => 0x00002000
725 };
726 $ReturnValues{SQL_CREATE_TRANSLATION} =
727 {
728 8 SQL_CTR_CREATE_TRANSLATION => 0x00000001
729 };
730 $ReturnValues{SQL_CREATE_VIEW} =
731 {
732 8 SQL_CV_CREATE_VIEW => 0x00000001
733 , SQL_CV_CHECK_OPTION => 0x00000002
734 , SQL_CV_CASCADED => 0x00000004
735 , SQL_CV_LOCAL => 0x00000008
736 };
737 $ReturnValues{SQL_CURSOR_COMMIT_BEHAVIOR} =
738 {
739 8 SQL_CB_DELETE => 0
740 , SQL_CB_CLOSE => 1
741 , SQL_CB_PRESERVE => 2
742 };
743 8 $ReturnValues{SQL_CURSOR_ROLLBACK_BEHAVIOR} = $ReturnValues{SQL_CURSOR_COMMIT_BEHAVIOR};
744  
745 $ReturnValues{SQL_CURSOR_SENSITIVITY} =
746 {
747 8 SQL_UNSPECIFIED => 0
748 , SQL_INSENSITIVE => 1
749 , SQL_SENSITIVE => 2
750 };
751 $ReturnValues{SQL_DATETIME_LITERALS} =
752 {
753 8 SQL_DL_SQL92_DATE => 0x00000001
754 , SQL_DL_SQL92_TIME => 0x00000002
755 , SQL_DL_SQL92_TIMESTAMP => 0x00000004
756 , SQL_DL_SQL92_INTERVAL_YEAR => 0x00000008
757 , SQL_DL_SQL92_INTERVAL_MONTH => 0x00000010
758 , SQL_DL_SQL92_INTERVAL_DAY => 0x00000020
759 , SQL_DL_SQL92_INTERVAL_HOUR => 0x00000040
760 , SQL_DL_SQL92_INTERVAL_MINUTE => 0x00000080
761 , SQL_DL_SQL92_INTERVAL_SECOND => 0x00000100
762 , SQL_DL_SQL92_INTERVAL_YEAR_TO_MONTH => 0x00000200
763 , SQL_DL_SQL92_INTERVAL_DAY_TO_HOUR => 0x00000400
764 , SQL_DL_SQL92_INTERVAL_DAY_TO_MINUTE => 0x00000800
765 , SQL_DL_SQL92_INTERVAL_DAY_TO_SECOND => 0x00001000
766 , SQL_DL_SQL92_INTERVAL_HOUR_TO_MINUTE => 0x00002000
767 , SQL_DL_SQL92_INTERVAL_HOUR_TO_SECOND => 0x00004000
768 , SQL_DL_SQL92_INTERVAL_MINUTE_TO_SECOND => 0x00008000
769 };
770 $ReturnValues{SQL_DDL_INDEX} =
771 {
772 8 SQL_DI_CREATE_INDEX => 0x00000001
773 , SQL_DI_DROP_INDEX => 0x00000002
774 };
775 $ReturnValues{SQL_DIAG_CURSOR_ROW_COUNT} =
776 {
777 8 SQL_CA2_CRC_EXACT => 0x00001000
778 , SQL_CA2_CRC_APPROXIMATE => 0x00002000
779 , SQL_CA2_SIMULATE_NON_UNIQUE => 0x00004000
780 , SQL_CA2_SIMULATE_TRY_UNIQUE => 0x00008000
781 , SQL_CA2_SIMULATE_UNIQUE => 0x00010000
782 };
783 $ReturnValues{SQL_DROP_ASSERTION} =
784 {
785 8 SQL_DA_DROP_ASSERTION => 0x00000001
786 };
787 $ReturnValues{SQL_DROP_CHARACTER_SET} =
788 {
789 8 SQL_DCS_DROP_CHARACTER_SET => 0x00000001
790 };
791 $ReturnValues{SQL_DROP_COLLATION} =
792 {
793 8 SQL_DC_DROP_COLLATION => 0x00000001
794 };
795 $ReturnValues{SQL_DROP_DOMAIN} =
796 {
797 8 SQL_DD_DROP_DOMAIN => 0x00000001
798 , SQL_DD_RESTRICT => 0x00000002
799 , SQL_DD_CASCADE => 0x00000004
800 };
801 $ReturnValues{SQL_DROP_SCHEMA} =
802 {
803 8 SQL_DS_DROP_SCHEMA => 0x00000001
804 , SQL_DS_RESTRICT => 0x00000002
805 , SQL_DS_CASCADE => 0x00000004
806 };
807 $ReturnValues{SQL_DROP_TABLE} =
808 {
809 8 SQL_DT_DROP_TABLE => 0x00000001
810 , SQL_DT_RESTRICT => 0x00000002
811 , SQL_DT_CASCADE => 0x00000004
812 };
813 $ReturnValues{SQL_DROP_TRANSLATION} =
814 {
815 8 SQL_DTR_DROP_TRANSLATION => 0x00000001
816 };
817 $ReturnValues{SQL_DROP_VIEW} =
818 {
819 8 SQL_DV_DROP_VIEW => 0x00000001
820 , SQL_DV_RESTRICT => 0x00000002
821 , SQL_DV_CASCADE => 0x00000004
822 };
823 $ReturnValues{SQL_CURSOR_ATTRIBUTES1} =
824 {
825 8 SQL_CA1_NEXT => 0x00000001
826 , SQL_CA1_ABSOLUTE => 0x00000002
827 , SQL_CA1_RELATIVE => 0x00000004
828 , SQL_CA1_BOOKMARK => 0x00000008
829 , SQL_CA1_LOCK_NO_CHANGE => 0x00000040
830 , SQL_CA1_LOCK_EXCLUSIVE => 0x00000080
831 , SQL_CA1_LOCK_UNLOCK => 0x00000100
832 , SQL_CA1_POS_POSITION => 0x00000200
833 , SQL_CA1_POS_UPDATE => 0x00000400
834 , SQL_CA1_POS_DELETE => 0x00000800
835 , SQL_CA1_POS_REFRESH => 0x00001000
836 , SQL_CA1_POSITIONED_UPDATE => 0x00002000
837 , SQL_CA1_POSITIONED_DELETE => 0x00004000
838 , SQL_CA1_SELECT_FOR_UPDATE => 0x00008000
839 , SQL_CA1_BULK_ADD => 0x00010000
840 , SQL_CA1_BULK_UPDATE_BY_BOOKMARK => 0x00020000
841 , SQL_CA1_BULK_DELETE_BY_BOOKMARK => 0x00040000
842 , SQL_CA1_BULK_FETCH_BY_BOOKMARK => 0x00080000
843 };
844 8 $ReturnValues{ SQL_DYNAMIC_CURSOR_ATTRIBUTES1} = $ReturnValues{SQL_CURSOR_ATTRIBUTES1};
845 8 $ReturnValues{SQL_FORWARD_ONLY_CURSOR_ATTRIBUTES1} = $ReturnValues{SQL_CURSOR_ATTRIBUTES1};
846 8 $ReturnValues{ SQL_KEYSET_CURSOR_ATTRIBUTES1} = $ReturnValues{SQL_CURSOR_ATTRIBUTES1};
847 8 $ReturnValues{ SQL_STATIC_CURSOR_ATTRIBUTES1} = $ReturnValues{SQL_CURSOR_ATTRIBUTES1};
848  
849 $ReturnValues{SQL_CURSOR_ATTRIBUTES2} =
850 {
851 8 SQL_CA2_READ_ONLY_CONCURRENCY => 0x00000001
852 , SQL_CA2_LOCK_CONCURRENCY => 0x00000002
853 , SQL_CA2_OPT_ROWVER_CONCURRENCY => 0x00000004
854 , SQL_CA2_OPT_VALUES_CONCURRENCY => 0x00000008
855 , SQL_CA2_SENSITIVITY_ADDITIONS => 0x00000010
856 , SQL_CA2_SENSITIVITY_DELETIONS => 0x00000020
857 , SQL_CA2_SENSITIVITY_UPDATES => 0x00000040
858 , SQL_CA2_MAX_ROWS_SELECT => 0x00000080
859 , SQL_CA2_MAX_ROWS_INSERT => 0x00000100
860 , SQL_CA2_MAX_ROWS_DELETE => 0x00000200
861 , SQL_CA2_MAX_ROWS_UPDATE => 0x00000400
862 , SQL_CA2_MAX_ROWS_CATALOG => 0x00000800
863 , SQL_CA2_CRC_EXACT => 0x00001000
864 , SQL_CA2_CRC_APPROXIMATE => 0x00002000
865 , SQL_CA2_SIMULATE_NON_UNIQUE => 0x00004000
866 , SQL_CA2_SIMULATE_TRY_UNIQUE => 0x00008000
867 , SQL_CA2_SIMULATE_UNIQUE => 0x00010000
868 };
869 8 $ReturnValues{ SQL_DYNAMIC_CURSOR_ATTRIBUTES2} = $ReturnValues{SQL_CURSOR_ATTRIBUTES2};
870 8 $ReturnValues{SQL_FORWARD_ONLY_CURSOR_ATTRIBUTES2} = $ReturnValues{SQL_CURSOR_ATTRIBUTES2};
871 8 $ReturnValues{ SQL_KEYSET_CURSOR_ATTRIBUTES2} = $ReturnValues{SQL_CURSOR_ATTRIBUTES2};
872 8 $ReturnValues{ SQL_STATIC_CURSOR_ATTRIBUTES2} = $ReturnValues{SQL_CURSOR_ATTRIBUTES2};
873  
874 $ReturnValues{SQL_FETCH_DIRECTION} =
875 {
876 8 SQL_FD_FETCH_NEXT => 0x00000001
877 , SQL_FD_FETCH_FIRST => 0x00000002
878 , SQL_FD_FETCH_LAST => 0x00000004
879 , SQL_FD_FETCH_PRIOR => 0x00000008
880 , SQL_FD_FETCH_ABSOLUTE => 0x00000010
881 , SQL_FD_FETCH_RELATIVE => 0x00000020
882 , SQL_FD_FETCH_RESUME => 0x00000040
883 , SQL_FD_FETCH_BOOKMARK => 0x00000080
884 };
885 $ReturnValues{SQL_FILE_USAGE} =
886 {
887 8 SQL_FILE_NOT_SUPPORTED => 0x0000
888 , SQL_FILE_TABLE => 0x0001
889 , SQL_FILE_QUALIFIER => 0x0002
890 , SQL_FILE_CATALOG => 0x0002 # SQL_FILE_QUALIFIER
891 };
892 $ReturnValues{SQL_GETDATA_EXTENSIONS} =
893 {
894 8 SQL_GD_ANY_COLUMN => 0x00000001
895 , SQL_GD_ANY_ORDER => 0x00000002
896 , SQL_GD_BLOCK => 0x00000004
897 , SQL_GD_BOUND => 0x00000008
898 };
899 $ReturnValues{SQL_GROUP_BY} =
900 {
901 8 SQL_GB_NOT_SUPPORTED => 0x0000
902 , SQL_GB_GROUP_BY_EQUALS_SELECT => 0x0001
903 , SQL_GB_GROUP_BY_CONTAINS_SELECT => 0x0002
904 , SQL_GB_NO_RELATION => 0x0003
905 , SQL_GB_COLLATE => 0x0004
906 };
907 $ReturnValues{SQL_IDENTIFIER_CASE} =
908 {
909 8 SQL_IC_UPPER => 1
910 , SQL_IC_LOWER => 2
911 , SQL_IC_SENSITIVE => 3
912 , SQL_IC_MIXED => 4
913 };
914 $ReturnValues{SQL_INDEX_KEYWORDS} =
915 {
916 8 SQL_IK_NONE => 0x00000000
917 , SQL_IK_ASC => 0x00000001
918 , SQL_IK_DESC => 0x00000002
919 # SQL_IK_ALL =>
920 };
921 $ReturnValues{SQL_INFO_SCHEMA_VIEWS} =
922 {
923 8 SQL_ISV_ASSERTIONS => 0x00000001
924 , SQL_ISV_CHARACTER_SETS => 0x00000002
925 , SQL_ISV_CHECK_CONSTRAINTS => 0x00000004
926 , SQL_ISV_COLLATIONS => 0x00000008
927 , SQL_ISV_COLUMN_DOMAIN_USAGE => 0x00000010
928 , SQL_ISV_COLUMN_PRIVILEGES => 0x00000020
929 , SQL_ISV_COLUMNS => 0x00000040
930 , SQL_ISV_CONSTRAINT_COLUMN_USAGE => 0x00000080
931 , SQL_ISV_CONSTRAINT_TABLE_USAGE => 0x00000100
932 , SQL_ISV_DOMAIN_CONSTRAINTS => 0x00000200
933 , SQL_ISV_DOMAINS => 0x00000400
934 , SQL_ISV_KEY_COLUMN_USAGE => 0x00000800
935 , SQL_ISV_REFERENTIAL_CONSTRAINTS => 0x00001000
936 , SQL_ISV_SCHEMATA => 0x00002000
937 , SQL_ISV_SQL_LANGUAGES => 0x00004000
938 , SQL_ISV_TABLE_CONSTRAINTS => 0x00008000
939 , SQL_ISV_TABLE_PRIVILEGES => 0x00010000
940 , SQL_ISV_TABLES => 0x00020000
941 , SQL_ISV_TRANSLATIONS => 0x00040000
942 , SQL_ISV_USAGE_PRIVILEGES => 0x00080000
943 , SQL_ISV_VIEW_COLUMN_USAGE => 0x00100000
944 , SQL_ISV_VIEW_TABLE_USAGE => 0x00200000
945 , SQL_ISV_VIEWS => 0x00400000
946 };
947 $ReturnValues{SQL_INSERT_STATEMENT} =
948 {
949 8 SQL_IS_INSERT_LITERALS => 0x00000001
950 , SQL_IS_INSERT_SEARCHED => 0x00000002
951 , SQL_IS_SELECT_INTO => 0x00000004
952 };
953 $ReturnValues{SQL_LOCK_TYPES} =
954 {
955 8 SQL_LCK_NO_CHANGE => 0x00000001
956 , SQL_LCK_EXCLUSIVE => 0x00000002
957 , SQL_LCK_UNLOCK => 0x00000004
958 };
959 $ReturnValues{SQL_NON_NULLABLE_COLUMNS} =
960 {
961 8 SQL_NNC_NULL => 0x0000
962 , SQL_NNC_NON_NULL => 0x0001
963 };
964 $ReturnValues{SQL_NULL_COLLATION} =
965 {
966 8 SQL_NC_HIGH => 0
967 , SQL_NC_LOW => 1
968 , SQL_NC_START => 0x0002
969 , SQL_NC_END => 0x0004
970 };
971 $ReturnValues{SQL_NUMERIC_FUNCTIONS} =
972 {
973 8 SQL_FN_NUM_ABS => 0x00000001
974 , SQL_FN_NUM_ACOS => 0x00000002
975 , SQL_FN_NUM_ASIN => 0x00000004
976 , SQL_FN_NUM_ATAN => 0x00000008
977 , SQL_FN_NUM_ATAN2 => 0x00000010
978 , SQL_FN_NUM_CEILING => 0x00000020
979 , SQL_FN_NUM_COS => 0x00000040
980 , SQL_FN_NUM_COT => 0x00000080
981 , SQL_FN_NUM_EXP => 0x00000100
982 , SQL_FN_NUM_FLOOR => 0x00000200
983 , SQL_FN_NUM_LOG => 0x00000400
984 , SQL_FN_NUM_MOD => 0x00000800
985 , SQL_FN_NUM_SIGN => 0x00001000
986 , SQL_FN_NUM_SIN => 0x00002000
987 , SQL_FN_NUM_SQRT => 0x00004000
988 , SQL_FN_NUM_TAN => 0x00008000
989 , SQL_FN_NUM_PI => 0x00010000
990 , SQL_FN_NUM_RAND => 0x00020000
991 , SQL_FN_NUM_DEGREES => 0x00040000
992 , SQL_FN_NUM_LOG10 => 0x00080000
993 , SQL_FN_NUM_POWER => 0x00100000
994 , SQL_FN_NUM_RADIANS => 0x00200000
995 , SQL_FN_NUM_ROUND => 0x00400000
996 , SQL_FN_NUM_TRUNCATE => 0x00800000
997 };
998 $ReturnValues{SQL_ODBC_API_CONFORMANCE} =
999 {
1000 8 SQL_OAC_NONE => 0x0000
1001 , SQL_OAC_LEVEL1 => 0x0001
1002 , SQL_OAC_LEVEL2 => 0x0002
1003 };
1004 $ReturnValues{SQL_ODBC_INTERFACE_CONFORMANCE} =
1005 {
1006 8 SQL_OIC_CORE => 1
1007 , SQL_OIC_LEVEL1 => 2
1008 , SQL_OIC_LEVEL2 => 3
1009 };
1010 $ReturnValues{SQL_ODBC_SAG_CLI_CONFORMANCE} =
1011 {
1012 8 SQL_OSCC_NOT_COMPLIANT => 0x0000
1013 , SQL_OSCC_COMPLIANT => 0x0001
1014 };
1015 $ReturnValues{SQL_ODBC_SQL_CONFORMANCE} =
1016 {
1017 8 SQL_OSC_MINIMUM => 0x0000
1018 , SQL_OSC_CORE => 0x0001
1019 , SQL_OSC_EXTENDED => 0x0002
1020 };
1021 $ReturnValues{SQL_OJ_CAPABILITIES} =
1022 {
1023 8 SQL_OJ_LEFT => 0x00000001
1024 , SQL_OJ_RIGHT => 0x00000002
1025 , SQL_OJ_FULL => 0x00000004
1026 , SQL_OJ_NESTED => 0x00000008
1027 , SQL_OJ_NOT_ORDERED => 0x00000010
1028 , SQL_OJ_INNER => 0x00000020
1029 , SQL_OJ_ALL_COMPARISON_OPS => 0x00000040
1030 };
1031 $ReturnValues{SQL_OWNER_USAGE} =
1032 {
1033 8 SQL_OU_DML_STATEMENTS => 0x00000001
1034 , SQL_OU_PROCEDURE_INVOCATION => 0x00000002
1035 , SQL_OU_TABLE_DEFINITION => 0x00000004
1036 , SQL_OU_INDEX_DEFINITION => 0x00000008
1037 , SQL_OU_PRIVILEGE_DEFINITION => 0x00000010
1038 };
1039 $ReturnValues{SQL_PARAM_ARRAY_ROW_COUNTS} =
1040 {
1041 8 SQL_PARC_BATCH => 1
1042 , SQL_PARC_NO_BATCH => 2
1043 };
1044 $ReturnValues{SQL_PARAM_ARRAY_SELECTS} =
1045 {
1046 8 SQL_PAS_BATCH => 1
1047 , SQL_PAS_NO_BATCH => 2
1048 , SQL_PAS_NO_SELECT => 3
1049 };
1050 $ReturnValues{SQL_POSITIONED_STATEMENTS} =
1051 {
1052 8 SQL_PS_POSITIONED_DELETE => 0x00000001
1053 , SQL_PS_POSITIONED_UPDATE => 0x00000002
1054 , SQL_PS_SELECT_FOR_UPDATE => 0x00000004
1055 };
1056 $ReturnValues{SQL_POS_OPERATIONS} =
1057 {
1058 8 SQL_POS_POSITION => 0x00000001
1059 , SQL_POS_REFRESH => 0x00000002
1060 , SQL_POS_UPDATE => 0x00000004
1061 , SQL_POS_DELETE => 0x00000008
1062 , SQL_POS_ADD => 0x00000010
1063 };
1064 $ReturnValues{SQL_QUALIFIER_LOCATION} =
1065 {
1066 8 SQL_QL_START => 0x0001
1067 , SQL_QL_END => 0x0002
1068 };
1069 $ReturnValues{SQL_QUALIFIER_USAGE} =
1070 {
1071 8 SQL_QU_DML_STATEMENTS => 0x00000001
1072 , SQL_QU_PROCEDURE_INVOCATION => 0x00000002
1073 , SQL_QU_TABLE_DEFINITION => 0x00000004
1074 , SQL_QU_INDEX_DEFINITION => 0x00000008
1075 , SQL_QU_PRIVILEGE_DEFINITION => 0x00000010
1076 };
1077 8 $ReturnValues{SQL_QUOTED_IDENTIFIER_CASE} = $ReturnValues{SQL_IDENTIFIER_CASE};
1078  
1079 $ReturnValues{SQL_SCHEMA_USAGE} =
1080 {
1081 8 SQL_SU_DML_STATEMENTS => 0x00000001 # SQL_OU_DML_STATEMENTS
1082 , SQL_SU_PROCEDURE_INVOCATION => 0x00000002 # SQL_OU_PROCEDURE_INVOCATION
1083 , SQL_SU_TABLE_DEFINITION => 0x00000004 # SQL_OU_TABLE_DEFINITION
1084 , SQL_SU_INDEX_DEFINITION => 0x00000008 # SQL_OU_INDEX_DEFINITION
1085 , SQL_SU_PRIVILEGE_DEFINITION => 0x00000010 # SQL_OU_PRIVILEGE_DEFINITION
1086 };
1087 $ReturnValues{SQL_SCROLL_CONCURRENCY} =
1088 {
1089 8 SQL_SCCO_READ_ONLY => 0x00000001
1090 , SQL_SCCO_LOCK => 0x00000002
1091 , SQL_SCCO_OPT_ROWVER => 0x00000004
1092 , SQL_SCCO_OPT_VALUES => 0x00000008
1093 };
1094 $ReturnValues{SQL_SCROLL_OPTIONS} =
1095 {
1096 8 SQL_SO_FORWARD_ONLY => 0x00000001
1097 , SQL_SO_KEYSET_DRIVEN => 0x00000002
1098 , SQL_SO_DYNAMIC => 0x00000004
1099 , SQL_SO_MIXED => 0x00000008
1100 , SQL_SO_STATIC => 0x00000010
1101 };
1102 $ReturnValues{SQL_SQL92_DATETIME_FUNCTIONS} =
1103 {
1104 8 SQL_SDF_CURRENT_DATE => 0x00000001
1105 , SQL_SDF_CURRENT_TIME => 0x00000002
1106 , SQL_SDF_CURRENT_TIMESTAMP => 0x00000004
1107 };
1108 $ReturnValues{SQL_SQL92_FOREIGN_KEY_DELETE_RULE} =
1109 {
1110 8 SQL_SFKD_CASCADE => 0x00000001
1111 , SQL_SFKD_NO_ACTION => 0x00000002
1112 , SQL_SFKD_SET_DEFAULT => 0x00000004
1113 , SQL_SFKD_SET_NULL => 0x00000008
1114 };
1115 $ReturnValues{SQL_SQL92_FOREIGN_KEY_UPDATE_RULE} =
1116 {
1117 8 SQL_SFKU_CASCADE => 0x00000001
1118 , SQL_SFKU_NO_ACTION => 0x00000002
1119 , SQL_SFKU_SET_DEFAULT => 0x00000004
1120 , SQL_SFKU_SET_NULL => 0x00000008
1121 };
1122 $ReturnValues{SQL_SQL92_GRANT} =
1123 {
1124 8 SQL_SG_USAGE_ON_DOMAIN => 0x00000001
1125 , SQL_SG_USAGE_ON_CHARACTER_SET => 0x00000002
1126 , SQL_SG_USAGE_ON_COLLATION => 0x00000004
1127 , SQL_SG_USAGE_ON_TRANSLATION => 0x00000008
1128 , SQL_SG_WITH_GRANT_OPTION => 0x00000010
1129 , SQL_SG_DELETE_TABLE => 0x00000020
1130 , SQL_SG_INSERT_TABLE => 0x00000040
1131 , SQL_SG_INSERT_COLUMN => 0x00000080
1132 , SQL_SG_REFERENCES_TABLE => 0x00000100
1133 , SQL_SG_REFERENCES_COLUMN => 0x00000200
1134 , SQL_SG_SELECT_TABLE => 0x00000400
1135 , SQL_SG_UPDATE_TABLE => 0x00000800
1136 , SQL_SG_UPDATE_COLUMN => 0x00001000
1137 };
1138 $ReturnValues{SQL_SQL92_NUMERIC_VALUE_FUNCTIONS} =
1139 {
1140 8 SQL_SNVF_BIT_LENGTH => 0x00000001
1141 , SQL_SNVF_CHAR_LENGTH => 0x00000002
1142 , SQL_SNVF_CHARACTER_LENGTH => 0x00000004
1143 , SQL_SNVF_EXTRACT => 0x00000008
1144 , SQL_SNVF_OCTET_LENGTH => 0x00000010
1145 , SQL_SNVF_POSITION => 0x00000020
1146 };
1147 $ReturnValues{SQL_SQL92_PREDICATES} =
1148 {
1149 8 SQL_SP_EXISTS => 0x00000001
1150 , SQL_SP_ISNOTNULL => 0x00000002
1151 , SQL_SP_ISNULL => 0x00000004
1152 , SQL_SP_MATCH_FULL => 0x00000008
1153 , SQL_SP_MATCH_PARTIAL => 0x00000010
1154 , SQL_SP_MATCH_UNIQUE_FULL => 0x00000020
1155 , SQL_SP_MATCH_UNIQUE_PARTIAL => 0x00000040
1156 , SQL_SP_OVERLAPS => 0x00000080
1157 , SQL_SP_UNIQUE => 0x00000100
1158 , SQL_SP_LIKE => 0x00000200
1159 , SQL_SP_IN => 0x00000400
1160 , SQL_SP_BETWEEN => 0x00000800
1161 , SQL_SP_COMPARISON => 0x00001000
1162 , SQL_SP_QUANTIFIED_COMPARISON => 0x00002000
1163 };
1164 $ReturnValues{SQL_SQL92_RELATIONAL_JOIN_OPERATORS} =
1165 {
1166 8 SQL_SRJO_CORRESPONDING_CLAUSE => 0x00000001
1167 , SQL_SRJO_CROSS_JOIN => 0x00000002
1168 , SQL_SRJO_EXCEPT_JOIN => 0x00000004
1169 , SQL_SRJO_FULL_OUTER_JOIN => 0x00000008
1170 , SQL_SRJO_INNER_JOIN => 0x00000010
1171 , SQL_SRJO_INTERSECT_JOIN => 0x00000020
1172 , SQL_SRJO_LEFT_OUTER_JOIN => 0x00000040
1173 , SQL_SRJO_NATURAL_JOIN => 0x00000080
1174 , SQL_SRJO_RIGHT_OUTER_JOIN => 0x00000100
1175 , SQL_SRJO_UNION_JOIN => 0x00000200
1176 };
1177 $ReturnValues{SQL_SQL92_REVOKE} =
1178 {
1179 8 SQL_SR_USAGE_ON_DOMAIN => 0x00000001
1180 , SQL_SR_USAGE_ON_CHARACTER_SET => 0x00000002
1181 , SQL_SR_USAGE_ON_COLLATION => 0x00000004
1182 , SQL_SR_USAGE_ON_TRANSLATION => 0x00000008
1183 , SQL_SR_GRANT_OPTION_FOR => 0x00000010
1184 , SQL_SR_CASCADE => 0x00000020
1185 , SQL_SR_RESTRICT => 0x00000040
1186 , SQL_SR_DELETE_TABLE => 0x00000080
1187 , SQL_SR_INSERT_TABLE => 0x00000100
1188 , SQL_SR_INSERT_COLUMN => 0x00000200
1189 , SQL_SR_REFERENCES_TABLE => 0x00000400
1190 , SQL_SR_REFERENCES_COLUMN => 0x00000800
1191 , SQL_SR_SELECT_TABLE => 0x00001000
1192 , SQL_SR_UPDATE_TABLE => 0x00002000
1193 , SQL_SR_UPDATE_COLUMN => 0x00004000
1194 };
1195 $ReturnValues{SQL_SQL92_ROW_VALUE_CONSTRUCTOR} =
1196 {
1197 8 SQL_SRVC_VALUE_EXPRESSION => 0x00000001
1198 , SQL_SRVC_NULL => 0x00000002
1199 , SQL_SRVC_DEFAULT => 0x00000004
1200 , SQL_SRVC_ROW_SUBQUERY => 0x00000008
1201 };
1202 $ReturnValues{SQL_SQL92_STRING_FUNCTIONS} =
1203 {
1204 8 SQL_SSF_CONVERT => 0x00000001
1205 , SQL_SSF_LOWER => 0x00000002
1206 , SQL_SSF_UPPER => 0x00000004
1207 , SQL_SSF_SUBSTRING => 0x00000008
1208 , SQL_SSF_TRANSLATE => 0x00000010
1209 , SQL_SSF_TRIM_BOTH => 0x00000020
1210 , SQL_SSF_TRIM_LEADING => 0x00000040
1211 , SQL_SSF_TRIM_TRAILING => 0x00000080
1212 };
1213 $ReturnValues{SQL_SQL92_VALUE_EXPRESSIONS} =
1214 {
1215 8 SQL_SVE_CASE => 0x00000001
1216 , SQL_SVE_CAST => 0x00000002
1217 , SQL_SVE_COALESCE => 0x00000004
1218 , SQL_SVE_NULLIF => 0x00000008
1219 };
1220 $ReturnValues{SQL_SQL_CONFORMANCE} =
1221 {
1222 8 SQL_SC_SQL92_ENTRY => 0x00000001
1223 , SQL_SC_FIPS127_2_TRANSITIONAL => 0x00000002
1224 , SQL_SC_SQL92_INTERMEDIATE => 0x00000004
1225 , SQL_SC_SQL92_FULL => 0x00000008
1226 };
1227 $ReturnValues{SQL_STANDARD_CLI_CONFORMANCE} =
1228 {
1229 8 SQL_SCC_XOPEN_CLI_VERSION1 => 0x00000001
1230 , SQL_SCC_ISO92_CLI => 0x00000002
1231 };
1232 $ReturnValues{SQL_STATIC_SENSITIVITY} =
1233 {
1234 8 SQL_SS_ADDITIONS => 0x00000001
1235 , SQL_SS_DELETIONS => 0x00000002
1236 , SQL_SS_UPDATES => 0x00000004
1237 };
1238 $ReturnValues{SQL_STRING_FUNCTIONS} =
1239 {
1240 8 SQL_FN_STR_CONCAT => 0x00000001
1241 , SQL_FN_STR_INSERT => 0x00000002
1242 , SQL_FN_STR_LEFT => 0x00000004
1243 , SQL_FN_STR_LTRIM => 0x00000008
1244 , SQL_FN_STR_LENGTH => 0x00000010
1245 , SQL_FN_STR_LOCATE => 0x00000020
1246 , SQL_FN_STR_LCASE => 0x00000040
1247 , SQL_FN_STR_REPEAT => 0x00000080
1248 , SQL_FN_STR_REPLACE => 0x00000100
1249 , SQL_FN_STR_RIGHT => 0x00000200
1250 , SQL_FN_STR_RTRIM => 0x00000400
1251 , SQL_FN_STR_SUBSTRING => 0x00000800
1252 , SQL_FN_STR_UCASE => 0x00001000
1253 , SQL_FN_STR_ASCII => 0x00002000
1254 , SQL_FN_STR_CHAR => 0x00004000
1255 , SQL_FN_STR_DIFFERENCE => 0x00008000
1256 , SQL_FN_STR_LOCATE_2 => 0x00010000
1257 , SQL_FN_STR_SOUNDEX => 0x00020000
1258 , SQL_FN_STR_SPACE => 0x00040000
1259 , SQL_FN_STR_BIT_LENGTH => 0x00080000
1260 , SQL_FN_STR_CHAR_LENGTH => 0x00100000
1261 , SQL_FN_STR_CHARACTER_LENGTH => 0x00200000
1262 , SQL_FN_STR_OCTET_LENGTH => 0x00400000
1263 , SQL_FN_STR_POSITION => 0x00800000
1264 };
1265 $ReturnValues{SQL_SUBQUERIES} =
1266 {
1267 8 SQL_SQ_COMPARISON => 0x00000001
1268 , SQL_SQ_EXISTS => 0x00000002
1269 , SQL_SQ_IN => 0x00000004
1270 , SQL_SQ_QUANTIFIED => 0x00000008
1271 , SQL_SQ_CORRELATED_SUBQUERIES => 0x00000010
1272 };
1273 $ReturnValues{SQL_SYSTEM_FUNCTIONS} =
1274 {
1275 8 SQL_FN_SYS_USERNAME => 0x00000001
1276 , SQL_FN_SYS_DBNAME => 0x00000002
1277 , SQL_FN_SYS_IFNULL => 0x00000004
1278 };
1279 $ReturnValues{SQL_TIMEDATE_ADD_INTERVALS} =
1280 {
1281 8 SQL_FN_TSI_FRAC_SECOND => 0x00000001
1282 , SQL_FN_TSI_SECOND => 0x00000002
1283 , SQL_FN_TSI_MINUTE => 0x00000004
1284 , SQL_FN_TSI_HOUR => 0x00000008
1285 , SQL_FN_TSI_DAY => 0x00000010
1286 , SQL_FN_TSI_WEEK => 0x00000020
1287 , SQL_FN_TSI_MONTH => 0x00000040
1288 , SQL_FN_TSI_QUARTER => 0x00000080
1289 , SQL_FN_TSI_YEAR => 0x00000100
1290 };
1291 $ReturnValues{SQL_TIMEDATE_FUNCTIONS} =
1292 {
1293 8 SQL_FN_TD_NOW => 0x00000001
1294 , SQL_FN_TD_CURDATE => 0x00000002
1295 , SQL_FN_TD_DAYOFMONTH => 0x00000004
1296 , SQL_FN_TD_DAYOFWEEK => 0x00000008
1297 , SQL_FN_TD_DAYOFYEAR => 0x00000010
1298 , SQL_FN_TD_MONTH => 0x00000020
1299 , SQL_FN_TD_QUARTER => 0x00000040
1300 , SQL_FN_TD_WEEK => 0x00000080
1301 , SQL_FN_TD_YEAR => 0x00000100
1302 , SQL_FN_TD_CURTIME => 0x00000200
1303 , SQL_FN_TD_HOUR => 0x00000400
1304 , SQL_FN_TD_MINUTE => 0x00000800
1305 , SQL_FN_TD_SECOND => 0x00001000
1306 , SQL_FN_TD_TIMESTAMPADD => 0x00002000
1307 , SQL_FN_TD_TIMESTAMPDIFF => 0x00004000
1308 , SQL_FN_TD_DAYNAME => 0x00008000
1309 , SQL_FN_TD_MONTHNAME => 0x00010000
1310 , SQL_FN_TD_CURRENT_DATE => 0x00020000
1311 , SQL_FN_TD_CURRENT_TIME => 0x00040000
1312 , SQL_FN_TD_CURRENT_TIMESTAMP => 0x00080000
1313 , SQL_FN_TD_EXTRACT => 0x00100000
1314 };
1315 $ReturnValues{SQL_TXN_CAPABLE} =
1316 {
1317 8 SQL_TC_NONE => 0
1318 , SQL_TC_DML => 1
1319 , SQL_TC_ALL => 2
1320 , SQL_TC_DDL_COMMIT => 3
1321 , SQL_TC_DDL_IGNORE => 4
1322 };
1323 $ReturnValues{SQL_TRANSACTION_ISOLATION_OPTION} =
1324 {
1325 8 SQL_TRANSACTION_READ_UNCOMMITTED => 0x00000001 # SQL_TXN_READ_UNCOMMITTED
1326 , SQL_TRANSACTION_READ_COMMITTED => 0x00000002 # SQL_TXN_READ_COMMITTED
1327 , SQL_TRANSACTION_REPEATABLE_READ => 0x00000004 # SQL_TXN_REPEATABLE_READ
1328 , SQL_TRANSACTION_SERIALIZABLE => 0x00000008 # SQL_TXN_SERIALIZABLE
1329 };
1330 8 $ReturnValues{SQL_DEFAULT_TRANSACTION_ISOLATION} = $ReturnValues{SQL_TRANSACTION_ISOLATION_OPTION};
1331  
1332 $ReturnValues{SQL_TXN_ISOLATION_OPTION} =
1333 {
1334 8 SQL_TXN_READ_UNCOMMITTED => 0x00000001
1335 , SQL_TXN_READ_COMMITTED => 0x00000002
1336 , SQL_TXN_REPEATABLE_READ => 0x00000004
1337 , SQL_TXN_SERIALIZABLE => 0x00000008
1338 };
1339 8 $ReturnValues{SQL_DEFAULT_TXN_ISOLATION} = $ReturnValues{SQL_TXN_ISOLATION_OPTION};
1340  
1341 $ReturnValues{SQL_TXN_VERSIONING} =
1342 {
1343 8 SQL_TXN_VERSIONING => 0x00000010
1344 };
1345 $ReturnValues{SQL_UNION} =
1346 {
1347 8 SQL_U_UNION => 0x00000001
1348 , SQL_U_UNION_ALL => 0x00000002
1349 };
1350 $ReturnValues{SQL_UNION_STATEMENT} =
1351 {
1352 8 SQL_US_UNION => 0x00000001 # SQL_U_UNION
1353 , SQL_US_UNION_ALL => 0x00000002 # SQL_U_UNION_ALL
1354 };
1355  
1356 8 1;
1357  
1358 =head1 TODO
1359  
1360 Corrections?
1361 SQL_NULL_COLLATION: ODBC vs ANSI
1362 Unique values for $ReturnValues{...}?, e.g. SQL_FILE_USAGE
1363  
1364 =cut
« blib/lib/DBI/Const/GetInfo/ANSI.pm ↑ Summary blib/lib/DBI/Const/GetInfoType.pm »