← Index
NYTProf Performance Profile   « block view • line view • sub view »
For /usr/share/koha/opac/cgi-bin/opac/opac-search.pl
  Run on Tue Oct 15 11:58:52 2013
Reported on Tue Oct 15 12:02:06 2013

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