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