← Index
NYTProf Performance Profile   « block view • line view • sub view »
For ddd2.pl
  Run on Tue May 25 16:52:24 2010
Reported on Tue May 25 16:56:58 2010

File /project/perl/lib/DBI/Const/GetInfo/ODBC.pm
Statements Executed 131
Statement Execution Time 2.16ms
Call graph for these subroutines as a Graphviz dot language file.
Line State
ments
Time
on line
Calls Time
in subs
Code
1# $Id: ODBC.pm 8696 2007-01-24 23:12:38Z 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
15DBI::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
23Information requested by GetInfo().
24
25The 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
37my
38170µs120µs$VERSION = sprintf("2.%06d", q$Revision: 8696 $ =~ /(\d+)/o);
# spent 20µs making 1 call to DBI::Const::GetInfo::ODBC::CORE:match
39
40
411189µ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
263See: mk:@MSITStore:X:\dm\cli\mdac\sdk26\Docs\odbc.chm::/htm/odbcsqlgetinfo.htm
264
265 => : alias
266 => !!! : edited
267
268=cut
269
2701188µ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
492See: sql.h, sqlext.h
493Edited:
494 SQL_TXN_ISOLATION_OPTION
495
496=cut
497
498115µ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};
508115µ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};
520129µ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};
54118µs$ReturnValues{SQL_ASYNC_MODE} =
542{
543 SQL_AM_NONE => 0
544, SQL_AM_CONNECTION => 1
545, SQL_AM_STATEMENT => 2
546, SQL_AM_NONE => 0
547, SQL_AM_CONNECTION => 1
548, SQL_AM_STATEMENT => 2
549};
550110µs$ReturnValues{SQL_ATTR_MAX_ROWS} =
551{
552 SQL_CA2_MAX_ROWS_SELECT => 0x00000080
553, SQL_CA2_MAX_ROWS_INSERT => 0x00000100
554, SQL_CA2_MAX_ROWS_DELETE => 0x00000200
555, SQL_CA2_MAX_ROWS_UPDATE => 0x00000400
556, SQL_CA2_MAX_ROWS_CATALOG => 0x00000800
557# SQL_CA2_MAX_ROWS_AFFECTS_ALL =>
558};
559110µs$ReturnValues{SQL_ATTR_SCROLL_CONCURRENCY} =
560{
561 SQL_CA2_READ_ONLY_CONCURRENCY => 0x00000001
562, SQL_CA2_LOCK_CONCURRENCY => 0x00000002
563, SQL_CA2_OPT_ROWVER_CONCURRENCY => 0x00000004
564, SQL_CA2_OPT_VALUES_CONCURRENCY => 0x00000008
565, SQL_CA2_SENSITIVITY_ADDITIONS => 0x00000010
566, SQL_CA2_SENSITIVITY_DELETIONS => 0x00000020
567, SQL_CA2_SENSITIVITY_UPDATES => 0x00000040
568};
56918µs$ReturnValues{SQL_BATCH_ROW_COUNT} =
570{
571 SQL_BRC_PROCEDURES => 0x0000001
572, SQL_BRC_EXPLICIT => 0x0000002
573, SQL_BRC_ROLLED_UP => 0x0000004
574};
575114µs$ReturnValues{SQL_BATCH_SUPPORT} =
576{
577 SQL_BS_SELECT_EXPLICIT => 0x00000001
578, SQL_BS_ROW_COUNT_EXPLICIT => 0x00000002
579, SQL_BS_SELECT_PROC => 0x00000004
580, SQL_BS_ROW_COUNT_PROC => 0x00000008
581};
582113µs$ReturnValues{SQL_BOOKMARK_PERSISTENCE} =
583{
584 SQL_BP_CLOSE => 0x00000001
585, SQL_BP_DELETE => 0x00000002
586, SQL_BP_DROP => 0x00000004
587, SQL_BP_TRANSACTION => 0x00000008
588, SQL_BP_UPDATE => 0x00000010
589, SQL_BP_OTHER_HSTMT => 0x00000020
590, SQL_BP_SCROLL => 0x00000040
591};
59216µs$ReturnValues{SQL_CATALOG_LOCATION} =
593{
594 SQL_CL_START => 0x0001 # SQL_QL_START
595, SQL_CL_END => 0x0002 # SQL_QL_END
596};
59719µs$ReturnValues{SQL_CATALOG_USAGE} =
598{
599 SQL_CU_DML_STATEMENTS => 0x00000001 # SQL_QU_DML_STATEMENTS
600, SQL_CU_PROCEDURE_INVOCATION => 0x00000002 # SQL_QU_PROCEDURE_INVOCATION
601, SQL_CU_TABLE_DEFINITION => 0x00000004 # SQL_QU_TABLE_DEFINITION
602, SQL_CU_INDEX_DEFINITION => 0x00000008 # SQL_QU_INDEX_DEFINITION
603, SQL_CU_PRIVILEGE_DEFINITION => 0x00000010 # SQL_QU_PRIVILEGE_DEFINITION
604};
60516µs$ReturnValues{SQL_CONCAT_NULL_BEHAVIOR} =
606{
607 SQL_CB_NULL => 0x0000
608, SQL_CB_NON_NULL => 0x0001
609};
610125µs$ReturnValues{SQL_CONVERT_} =
611{
612 SQL_CVT_CHAR => 0x00000001
613, SQL_CVT_NUMERIC => 0x00000002
614, SQL_CVT_DECIMAL => 0x00000004
615, SQL_CVT_INTEGER => 0x00000008
616, SQL_CVT_SMALLINT => 0x00000010
617, SQL_CVT_FLOAT => 0x00000020
618, SQL_CVT_REAL => 0x00000040
619, SQL_CVT_DOUBLE => 0x00000080
620, SQL_CVT_VARCHAR => 0x00000100
621, SQL_CVT_LONGVARCHAR => 0x00000200
622, SQL_CVT_BINARY => 0x00000400
623, SQL_CVT_VARBINARY => 0x00000800
624, SQL_CVT_BIT => 0x00001000
625, SQL_CVT_TINYINT => 0x00002000
626, SQL_CVT_BIGINT => 0x00004000
627, SQL_CVT_DATE => 0x00008000
628, SQL_CVT_TIME => 0x00010000
629, SQL_CVT_TIMESTAMP => 0x00020000
630, SQL_CVT_LONGVARBINARY => 0x00040000
631, SQL_CVT_INTERVAL_YEAR_MONTH => 0x00080000
632, SQL_CVT_INTERVAL_DAY_TIME => 0x00100000
633, SQL_CVT_WCHAR => 0x00200000
634, SQL_CVT_WLONGVARCHAR => 0x00400000
635, SQL_CVT_WVARCHAR => 0x00800000
636, SQL_CVT_GUID => 0x01000000
637};
63815µs$ReturnValues{SQL_CONVERT_BIGINT } = $ReturnValues{SQL_CONVERT_};
63914µs$ReturnValues{SQL_CONVERT_BINARY } = $ReturnValues{SQL_CONVERT_};
64015µs$ReturnValues{SQL_CONVERT_BIT } = $ReturnValues{SQL_CONVERT_};
64114µs$ReturnValues{SQL_CONVERT_CHAR } = $ReturnValues{SQL_CONVERT_};
64215µs$ReturnValues{SQL_CONVERT_DATE } = $ReturnValues{SQL_CONVERT_};
64314µs$ReturnValues{SQL_CONVERT_DECIMAL } = $ReturnValues{SQL_CONVERT_};
64414µs$ReturnValues{SQL_CONVERT_DOUBLE } = $ReturnValues{SQL_CONVERT_};
64514µs$ReturnValues{SQL_CONVERT_FLOAT } = $ReturnValues{SQL_CONVERT_};
64615µs$ReturnValues{SQL_CONVERT_GUID } = $ReturnValues{SQL_CONVERT_};
64715µs$ReturnValues{SQL_CONVERT_INTEGER } = $ReturnValues{SQL_CONVERT_};
64815µs$ReturnValues{SQL_CONVERT_INTERVAL_DAY_TIME } = $ReturnValues{SQL_CONVERT_};
64915µs$ReturnValues{SQL_CONVERT_INTERVAL_YEAR_MONTH} = $ReturnValues{SQL_CONVERT_};
65015µs$ReturnValues{SQL_CONVERT_LONGVARBINARY } = $ReturnValues{SQL_CONVERT_};
65115µs$ReturnValues{SQL_CONVERT_LONGVARCHAR } = $ReturnValues{SQL_CONVERT_};
65215µs$ReturnValues{SQL_CONVERT_NUMERIC } = $ReturnValues{SQL_CONVERT_};
65315µs$ReturnValues{SQL_CONVERT_REAL } = $ReturnValues{SQL_CONVERT_};
65415µs$ReturnValues{SQL_CONVERT_SMALLINT } = $ReturnValues{SQL_CONVERT_};
65515µs$ReturnValues{SQL_CONVERT_TIME } = $ReturnValues{SQL_CONVERT_};
656122µs$ReturnValues{SQL_CONVERT_TIMESTAMP } = $ReturnValues{SQL_CONVERT_};
65715µs$ReturnValues{SQL_CONVERT_TINYINT } = $ReturnValues{SQL_CONVERT_};
65814µs$ReturnValues{SQL_CONVERT_VARBINARY } = $ReturnValues{SQL_CONVERT_};
65914µs$ReturnValues{SQL_CONVERT_VARCHAR } = $ReturnValues{SQL_CONVERT_};
66015µs$ReturnValues{SQL_CONVERT_WCHAR } = $ReturnValues{SQL_CONVERT_};
66115µs$ReturnValues{SQL_CONVERT_WLONGVARCHAR } = $ReturnValues{SQL_CONVERT_};
66215µs$ReturnValues{SQL_CONVERT_WVARCHAR } = $ReturnValues{SQL_CONVERT_};
663
66418µs$ReturnValues{SQL_CONVERT_FUNCTIONS} =
665{
666 SQL_FN_CVT_CONVERT => 0x00000001
667, SQL_FN_CVT_CAST => 0x00000002
668};
66917µs$ReturnValues{SQL_CORRELATION_NAME} =
670{
671 SQL_CN_NONE => 0x0000
672, SQL_CN_DIFFERENT => 0x0001
673, SQL_CN_ANY => 0x0002
674};
675112µs$ReturnValues{SQL_CREATE_ASSERTION} =
676{
677 SQL_CA_CREATE_ASSERTION => 0x00000001
678, SQL_CA_CONSTRAINT_INITIALLY_DEFERRED => 0x00000010
679, SQL_CA_CONSTRAINT_INITIALLY_IMMEDIATE => 0x00000020
680, SQL_CA_CONSTRAINT_DEFERRABLE => 0x00000040
681, SQL_CA_CONSTRAINT_NON_DEFERRABLE => 0x00000080
682};
683116µs$ReturnValues{SQL_CREATE_CHARACTER_SET} =
684{
685 SQL_CCS_CREATE_CHARACTER_SET => 0x00000001
686, SQL_CCS_COLLATE_CLAUSE => 0x00000002
687, SQL_CCS_LIMITED_COLLATION => 0x00000004
688};
68916µs$ReturnValues{SQL_CREATE_COLLATION} =
690{
691 SQL_CCOL_CREATE_COLLATION => 0x00000001
692};
693117µs$ReturnValues{SQL_CREATE_DOMAIN} =
694{
695 SQL_CDO_CREATE_DOMAIN => 0x00000001
696, SQL_CDO_DEFAULT => 0x00000002
697, SQL_CDO_CONSTRAINT => 0x00000004
698, SQL_CDO_COLLATION => 0x00000008
699, SQL_CDO_CONSTRAINT_NAME_DEFINITION => 0x00000010
700, SQL_CDO_CONSTRAINT_INITIALLY_DEFERRED => 0x00000020
701, SQL_CDO_CONSTRAINT_INITIALLY_IMMEDIATE => 0x00000040
702, SQL_CDO_CONSTRAINT_DEFERRABLE => 0x00000080
703, SQL_CDO_CONSTRAINT_NON_DEFERRABLE => 0x00000100
704};
70518µs$ReturnValues{SQL_CREATE_SCHEMA} =
706{
707 SQL_CS_CREATE_SCHEMA => 0x00000001
708, SQL_CS_AUTHORIZATION => 0x00000002
709, SQL_CS_DEFAULT_CHARACTER_SET => 0x00000004
710};
711118µs$ReturnValues{SQL_CREATE_TABLE} =
712{
713 SQL_CT_CREATE_TABLE => 0x00000001
714, SQL_CT_COMMIT_PRESERVE => 0x00000002
715, SQL_CT_COMMIT_DELETE => 0x00000004
716, SQL_CT_GLOBAL_TEMPORARY => 0x00000008
717, SQL_CT_LOCAL_TEMPORARY => 0x00000010
718, SQL_CT_CONSTRAINT_INITIALLY_DEFERRED => 0x00000020
719, SQL_CT_CONSTRAINT_INITIALLY_IMMEDIATE => 0x00000040
720, SQL_CT_CONSTRAINT_DEFERRABLE => 0x00000080
721, SQL_CT_CONSTRAINT_NON_DEFERRABLE => 0x00000100
722, SQL_CT_COLUMN_CONSTRAINT => 0x00000200
723, SQL_CT_COLUMN_DEFAULT => 0x00000400
724, SQL_CT_COLUMN_COLLATION => 0x00000800
725, SQL_CT_TABLE_CONSTRAINT => 0x00001000
726, SQL_CT_CONSTRAINT_NAME_DEFINITION => 0x00002000
727};
72816µs$ReturnValues{SQL_CREATE_TRANSLATION} =
729{
730 SQL_CTR_CREATE_TRANSLATION => 0x00000001
731};
73218µs$ReturnValues{SQL_CREATE_VIEW} =
733{
734 SQL_CV_CREATE_VIEW => 0x00000001
735, SQL_CV_CHECK_OPTION => 0x00000002
736, SQL_CV_CASCADED => 0x00000004
737, SQL_CV_LOCAL => 0x00000008
738};
73917µs$ReturnValues{SQL_CURSOR_COMMIT_BEHAVIOR} =
740{
741 SQL_CB_DELETE => 0
742, SQL_CB_CLOSE => 1
743, SQL_CB_PRESERVE => 2
744};
74515µs$ReturnValues{SQL_CURSOR_ROLLBACK_BEHAVIOR} = $ReturnValues{SQL_CURSOR_COMMIT_BEHAVIOR};
746
747117µs$ReturnValues{SQL_CURSOR_SENSITIVITY} =
748{
749 SQL_UNSPECIFIED => 0
750, SQL_INSENSITIVE => 1
751, SQL_SENSITIVE => 2
752};
753119µs$ReturnValues{SQL_DATETIME_LITERALS} =
754{
755 SQL_DL_SQL92_DATE => 0x00000001
756, SQL_DL_SQL92_TIME => 0x00000002
757, SQL_DL_SQL92_TIMESTAMP => 0x00000004
758, SQL_DL_SQL92_INTERVAL_YEAR => 0x00000008
759, SQL_DL_SQL92_INTERVAL_MONTH => 0x00000010
760, SQL_DL_SQL92_INTERVAL_DAY => 0x00000020
761, SQL_DL_SQL92_INTERVAL_HOUR => 0x00000040
762, SQL_DL_SQL92_INTERVAL_MINUTE => 0x00000080
763, SQL_DL_SQL92_INTERVAL_SECOND => 0x00000100
764, SQL_DL_SQL92_INTERVAL_YEAR_TO_MONTH => 0x00000200
765, SQL_DL_SQL92_INTERVAL_DAY_TO_HOUR => 0x00000400
766, SQL_DL_SQL92_INTERVAL_DAY_TO_MINUTE => 0x00000800
767, SQL_DL_SQL92_INTERVAL_DAY_TO_SECOND => 0x00001000
768, SQL_DL_SQL92_INTERVAL_HOUR_TO_MINUTE => 0x00002000
769, SQL_DL_SQL92_INTERVAL_HOUR_TO_SECOND => 0x00004000
770, SQL_DL_SQL92_INTERVAL_MINUTE_TO_SECOND => 0x00008000
771};
77218µs$ReturnValues{SQL_DDL_INDEX} =
773{
774 SQL_DI_CREATE_INDEX => 0x00000001
775, SQL_DI_DROP_INDEX => 0x00000002
776};
77719µs$ReturnValues{SQL_DIAG_CURSOR_ROW_COUNT} =
778{
779 SQL_CA2_CRC_EXACT => 0x00001000
780, SQL_CA2_CRC_APPROXIMATE => 0x00002000
781, SQL_CA2_SIMULATE_NON_UNIQUE => 0x00004000
782, SQL_CA2_SIMULATE_TRY_UNIQUE => 0x00008000
783, SQL_CA2_SIMULATE_UNIQUE => 0x00010000
784};
78516µs$ReturnValues{SQL_DROP_ASSERTION} =
786{
787 SQL_DA_DROP_ASSERTION => 0x00000001
788};
78916µs$ReturnValues{SQL_DROP_CHARACTER_SET} =
790{
791 SQL_DCS_DROP_CHARACTER_SET => 0x00000001
792};
79317µs$ReturnValues{SQL_DROP_COLLATION} =
794{
795 SQL_DC_DROP_COLLATION => 0x00000001
796};
79718µs$ReturnValues{SQL_DROP_DOMAIN} =
798{
799 SQL_DD_DROP_DOMAIN => 0x00000001
800, SQL_DD_RESTRICT => 0x00000002
801, SQL_DD_CASCADE => 0x00000004
802};
80317µs$ReturnValues{SQL_DROP_SCHEMA} =
804{
805 SQL_DS_DROP_SCHEMA => 0x00000001
806, SQL_DS_RESTRICT => 0x00000002
807, SQL_DS_CASCADE => 0x00000004
808};
80917µs$ReturnValues{SQL_DROP_TABLE} =
810{
811 SQL_DT_DROP_TABLE => 0x00000001
812, SQL_DT_RESTRICT => 0x00000002
813, SQL_DT_CASCADE => 0x00000004
814};
81515µs$ReturnValues{SQL_DROP_TRANSLATION} =
816{
817 SQL_DTR_DROP_TRANSLATION => 0x00000001
818};
81917µs$ReturnValues{SQL_DROP_VIEW} =
820{
821 SQL_DV_DROP_VIEW => 0x00000001
822, SQL_DV_RESTRICT => 0x00000002
823, SQL_DV_CASCADE => 0x00000004
824};
825129µs$ReturnValues{SQL_CURSOR_ATTRIBUTES1} =
826{
827 SQL_CA1_NEXT => 0x00000001
828, SQL_CA1_ABSOLUTE => 0x00000002
829, SQL_CA1_RELATIVE => 0x00000004
830, SQL_CA1_BOOKMARK => 0x00000008
831, SQL_CA1_LOCK_NO_CHANGE => 0x00000040
832, SQL_CA1_LOCK_EXCLUSIVE => 0x00000080
833, SQL_CA1_LOCK_UNLOCK => 0x00000100
834, SQL_CA1_POS_POSITION => 0x00000200
835, SQL_CA1_POS_UPDATE => 0x00000400
836, SQL_CA1_POS_DELETE => 0x00000800
837, SQL_CA1_POS_REFRESH => 0x00001000
838, SQL_CA1_POSITIONED_UPDATE => 0x00002000
839, SQL_CA1_POSITIONED_DELETE => 0x00004000
840, SQL_CA1_SELECT_FOR_UPDATE => 0x00008000
841, SQL_CA1_BULK_ADD => 0x00010000
842, SQL_CA1_BULK_UPDATE_BY_BOOKMARK => 0x00020000
843, SQL_CA1_BULK_DELETE_BY_BOOKMARK => 0x00040000
844, SQL_CA1_BULK_FETCH_BY_BOOKMARK => 0x00080000
845};
84614µs$ReturnValues{ SQL_DYNAMIC_CURSOR_ATTRIBUTES1} = $ReturnValues{SQL_CURSOR_ATTRIBUTES1};
847112µs$ReturnValues{SQL_FORWARD_ONLY_CURSOR_ATTRIBUTES1} = $ReturnValues{SQL_CURSOR_ATTRIBUTES1};
84815µs$ReturnValues{ SQL_KEYSET_CURSOR_ATTRIBUTES1} = $ReturnValues{SQL_CURSOR_ATTRIBUTES1};
84915µs$ReturnValues{ SQL_STATIC_CURSOR_ATTRIBUTES1} = $ReturnValues{SQL_CURSOR_ATTRIBUTES1};
850
851117µs$ReturnValues{SQL_CURSOR_ATTRIBUTES2} =
852{
853 SQL_CA2_READ_ONLY_CONCURRENCY => 0x00000001
854, SQL_CA2_LOCK_CONCURRENCY => 0x00000002
855, SQL_CA2_OPT_ROWVER_CONCURRENCY => 0x00000004
856, SQL_CA2_OPT_VALUES_CONCURRENCY => 0x00000008
857, SQL_CA2_SENSITIVITY_ADDITIONS => 0x00000010
858, SQL_CA2_SENSITIVITY_DELETIONS => 0x00000020
859, SQL_CA2_SENSITIVITY_UPDATES => 0x00000040
860, SQL_CA2_MAX_ROWS_SELECT => 0x00000080
861, SQL_CA2_MAX_ROWS_INSERT => 0x00000100
862, SQL_CA2_MAX_ROWS_DELETE => 0x00000200
863, SQL_CA2_MAX_ROWS_UPDATE => 0x00000400
864, SQL_CA2_MAX_ROWS_CATALOG => 0x00000800
865, SQL_CA2_CRC_EXACT => 0x00001000
866, SQL_CA2_CRC_APPROXIMATE => 0x00002000
867, SQL_CA2_SIMULATE_NON_UNIQUE => 0x00004000
868, SQL_CA2_SIMULATE_TRY_UNIQUE => 0x00008000
869, SQL_CA2_SIMULATE_UNIQUE => 0x00010000
870};
87115µs$ReturnValues{ SQL_DYNAMIC_CURSOR_ATTRIBUTES2} = $ReturnValues{SQL_CURSOR_ATTRIBUTES2};
87215µs$ReturnValues{SQL_FORWARD_ONLY_CURSOR_ATTRIBUTES2} = $ReturnValues{SQL_CURSOR_ATTRIBUTES2};
87315µs$ReturnValues{ SQL_KEYSET_CURSOR_ATTRIBUTES2} = $ReturnValues{SQL_CURSOR_ATTRIBUTES2};
87414µs$ReturnValues{ SQL_STATIC_CURSOR_ATTRIBUTES2} = $ReturnValues{SQL_CURSOR_ATTRIBUTES2};
875
876114µs$ReturnValues{SQL_FETCH_DIRECTION} =
877{
878 SQL_FD_FETCH_NEXT => 0x00000001
879, SQL_FD_FETCH_FIRST => 0x00000002
880, SQL_FD_FETCH_LAST => 0x00000004
881, SQL_FD_FETCH_PRIOR => 0x00000008
882, SQL_FD_FETCH_ABSOLUTE => 0x00000010
883, SQL_FD_FETCH_RELATIVE => 0x00000020
884, SQL_FD_FETCH_RESUME => 0x00000040
885, SQL_FD_FETCH_BOOKMARK => 0x00000080
886};
88718µs$ReturnValues{SQL_FILE_USAGE} =
888{
889 SQL_FILE_NOT_SUPPORTED => 0x0000
890, SQL_FILE_TABLE => 0x0001
891, SQL_FILE_QUALIFIER => 0x0002
892, SQL_FILE_CATALOG => 0x0002 # SQL_FILE_QUALIFIER
893};
89418µs$ReturnValues{SQL_GETDATA_EXTENSIONS} =
895{
896 SQL_GD_ANY_COLUMN => 0x00000001
897, SQL_GD_ANY_ORDER => 0x00000002
898, SQL_GD_BLOCK => 0x00000004
899, SQL_GD_BOUND => 0x00000008
900};
901110µs$ReturnValues{SQL_GROUP_BY} =
902{
903 SQL_GB_NOT_SUPPORTED => 0x0000
904, SQL_GB_GROUP_BY_EQUALS_SELECT => 0x0001
905, SQL_GB_GROUP_BY_CONTAINS_SELECT => 0x0002
906, SQL_GB_NO_RELATION => 0x0003
907, SQL_GB_COLLATE => 0x0004
908};
90917µs$ReturnValues{SQL_IDENTIFIER_CASE} =
910{
911 SQL_IC_UPPER => 1
912, SQL_IC_LOWER => 2
913, SQL_IC_SENSITIVE => 3
914, SQL_IC_MIXED => 4
915};
91618µs$ReturnValues{SQL_INDEX_KEYWORDS} =
917{
918 SQL_IK_NONE => 0x00000000
919, SQL_IK_ASC => 0x00000001
920, SQL_IK_DESC => 0x00000002
921# SQL_IK_ALL =>
922};
923126µs$ReturnValues{SQL_INFO_SCHEMA_VIEWS} =
924{
925 SQL_ISV_ASSERTIONS => 0x00000001
926, SQL_ISV_CHARACTER_SETS => 0x00000002
927, SQL_ISV_CHECK_CONSTRAINTS => 0x00000004
928, SQL_ISV_COLLATIONS => 0x00000008
929, SQL_ISV_COLUMN_DOMAIN_USAGE => 0x00000010
930, SQL_ISV_COLUMN_PRIVILEGES => 0x00000020
931, SQL_ISV_COLUMNS => 0x00000040
932, SQL_ISV_CONSTRAINT_COLUMN_USAGE => 0x00000080
933, SQL_ISV_CONSTRAINT_TABLE_USAGE => 0x00000100
934, SQL_ISV_DOMAIN_CONSTRAINTS => 0x00000200
935, SQL_ISV_DOMAINS => 0x00000400
936, SQL_ISV_KEY_COLUMN_USAGE => 0x00000800
937, SQL_ISV_REFERENTIAL_CONSTRAINTS => 0x00001000
938, SQL_ISV_SCHEMATA => 0x00002000
939, SQL_ISV_SQL_LANGUAGES => 0x00004000
940, SQL_ISV_TABLE_CONSTRAINTS => 0x00008000
941, SQL_ISV_TABLE_PRIVILEGES => 0x00010000
942, SQL_ISV_TABLES => 0x00020000
943, SQL_ISV_TRANSLATIONS => 0x00040000
944, SQL_ISV_USAGE_PRIVILEGES => 0x00080000
945, SQL_ISV_VIEW_COLUMN_USAGE => 0x00100000
946, SQL_ISV_VIEW_TABLE_USAGE => 0x00200000
947, SQL_ISV_VIEWS => 0x00400000
948};
94917µs$ReturnValues{SQL_INSERT_STATEMENT} =
950{
951 SQL_IS_INSERT_LITERALS => 0x00000001
952, SQL_IS_INSERT_SEARCHED => 0x00000002
953, SQL_IS_SELECT_INTO => 0x00000004
954};
95517µs$ReturnValues{SQL_LOCK_TYPES} =
956{
957 SQL_LCK_NO_CHANGE => 0x00000001
958, SQL_LCK_EXCLUSIVE => 0x00000002
959, SQL_LCK_UNLOCK => 0x00000004
960};
96117µs$ReturnValues{SQL_NON_NULLABLE_COLUMNS} =
962{
963 SQL_NNC_NULL => 0x0000
964, SQL_NNC_NON_NULL => 0x0001
965};
96617µs$ReturnValues{SQL_NULL_COLLATION} =
967{
968 SQL_NC_HIGH => 0
969, SQL_NC_LOW => 1
970, SQL_NC_START => 0x0002
971, SQL_NC_END => 0x0004
972};
973128µs$ReturnValues{SQL_NUMERIC_FUNCTIONS} =
974{
975 SQL_FN_NUM_ABS => 0x00000001
976, SQL_FN_NUM_ACOS => 0x00000002
977, SQL_FN_NUM_ASIN => 0x00000004
978, SQL_FN_NUM_ATAN => 0x00000008
979, SQL_FN_NUM_ATAN2 => 0x00000010
980, SQL_FN_NUM_CEILING => 0x00000020
981, SQL_FN_NUM_COS => 0x00000040
982, SQL_FN_NUM_COT => 0x00000080
983, SQL_FN_NUM_EXP => 0x00000100
984, SQL_FN_NUM_FLOOR => 0x00000200
985, SQL_FN_NUM_LOG => 0x00000400
986, SQL_FN_NUM_MOD => 0x00000800
987, SQL_FN_NUM_SIGN => 0x00001000
988, SQL_FN_NUM_SIN => 0x00002000
989, SQL_FN_NUM_SQRT => 0x00004000
990, SQL_FN_NUM_TAN => 0x00008000
991, SQL_FN_NUM_PI => 0x00010000
992, SQL_FN_NUM_RAND => 0x00020000
993, SQL_FN_NUM_DEGREES => 0x00040000
994, SQL_FN_NUM_LOG10 => 0x00080000
995, SQL_FN_NUM_POWER => 0x00100000
996, SQL_FN_NUM_RADIANS => 0x00200000
997, SQL_FN_NUM_ROUND => 0x00400000
998, SQL_FN_NUM_TRUNCATE => 0x00800000
999};
100017µs$ReturnValues{SQL_ODBC_API_CONFORMANCE} =
1001{
1002 SQL_OAC_NONE => 0x0000
1003, SQL_OAC_LEVEL1 => 0x0001
1004, SQL_OAC_LEVEL2 => 0x0002
1005};
100617µs$ReturnValues{SQL_ODBC_INTERFACE_CONFORMANCE} =
1007{
1008 SQL_OIC_CORE => 1
1009, SQL_OIC_LEVEL1 => 2
1010, SQL_OIC_LEVEL2 => 3
1011};
101216µs$ReturnValues{SQL_ODBC_SAG_CLI_CONFORMANCE} =
1013{
1014 SQL_OSCC_NOT_COMPLIANT => 0x0000
1015, SQL_OSCC_COMPLIANT => 0x0001
1016};
101719µs$ReturnValues{SQL_ODBC_SQL_CONFORMANCE} =
1018{
1019 SQL_OSC_MINIMUM => 0x0000
1020, SQL_OSC_CORE => 0x0001
1021, SQL_OSC_EXTENDED => 0x0002
1022};
1023110µs$ReturnValues{SQL_OJ_CAPABILITIES} =
1024{
1025 SQL_OJ_LEFT => 0x00000001
1026, SQL_OJ_RIGHT => 0x00000002
1027, SQL_OJ_FULL => 0x00000004
1028, SQL_OJ_NESTED => 0x00000008
1029, SQL_OJ_NOT_ORDERED => 0x00000010
1030, SQL_OJ_INNER => 0x00000020
1031, SQL_OJ_ALL_COMPARISON_OPS => 0x00000040
1032};
1033110µs$ReturnValues{SQL_OWNER_USAGE} =
1034{
1035 SQL_OU_DML_STATEMENTS => 0x00000001
1036, SQL_OU_PROCEDURE_INVOCATION => 0x00000002
1037, SQL_OU_TABLE_DEFINITION => 0x00000004
1038, SQL_OU_INDEX_DEFINITION => 0x00000008
1039, SQL_OU_PRIVILEGE_DEFINITION => 0x00000010
1040};
104116µs$ReturnValues{SQL_PARAM_ARRAY_ROW_COUNTS} =
1042{
1043 SQL_PARC_BATCH => 1
1044, SQL_PARC_NO_BATCH => 2
1045};
104618µs$ReturnValues{SQL_PARAM_ARRAY_SELECTS} =
1047{
1048 SQL_PAS_BATCH => 1
1049, SQL_PAS_NO_BATCH => 2
1050, SQL_PAS_NO_SELECT => 3
1051};
105217µs$ReturnValues{SQL_POSITIONED_STATEMENTS} =
1053{
1054 SQL_PS_POSITIONED_DELETE => 0x00000001
1055, SQL_PS_POSITIONED_UPDATE => 0x00000002
1056, SQL_PS_SELECT_FOR_UPDATE => 0x00000004
1057};
105819µs$ReturnValues{SQL_POS_OPERATIONS} =
1059{
1060 SQL_POS_POSITION => 0x00000001
1061, SQL_POS_REFRESH => 0x00000002
1062, SQL_POS_UPDATE => 0x00000004
1063, SQL_POS_DELETE => 0x00000008
1064, SQL_POS_ADD => 0x00000010
1065};
106616µs$ReturnValues{SQL_QUALIFIER_LOCATION} =
1067{
1068 SQL_QL_START => 0x0001
1069, SQL_QL_END => 0x0002
1070};
1071110µs$ReturnValues{SQL_QUALIFIER_USAGE} =
1072{
1073 SQL_QU_DML_STATEMENTS => 0x00000001
1074, SQL_QU_PROCEDURE_INVOCATION => 0x00000002
1075, SQL_QU_TABLE_DEFINITION => 0x00000004
1076, SQL_QU_INDEX_DEFINITION => 0x00000008
1077, SQL_QU_PRIVILEGE_DEFINITION => 0x00000010
1078};
107915µs$ReturnValues{SQL_QUOTED_IDENTIFIER_CASE} = $ReturnValues{SQL_IDENTIFIER_CASE};
1080
1081110µs$ReturnValues{SQL_SCHEMA_USAGE} =
1082{
1083 SQL_SU_DML_STATEMENTS => 0x00000001 # SQL_OU_DML_STATEMENTS
1084, SQL_SU_PROCEDURE_INVOCATION => 0x00000002 # SQL_OU_PROCEDURE_INVOCATION
1085, SQL_SU_TABLE_DEFINITION => 0x00000004 # SQL_OU_TABLE_DEFINITION
1086, SQL_SU_INDEX_DEFINITION => 0x00000008 # SQL_OU_INDEX_DEFINITION
1087, SQL_SU_PRIVILEGE_DEFINITION => 0x00000010 # SQL_OU_PRIVILEGE_DEFINITION
1088};
108918µs$ReturnValues{SQL_SCROLL_CONCURRENCY} =
1090{
1091 SQL_SCCO_READ_ONLY => 0x00000001
1092, SQL_SCCO_LOCK => 0x00000002
1093, SQL_SCCO_OPT_ROWVER => 0x00000004
1094, SQL_SCCO_OPT_VALUES => 0x00000008
1095};
1096116µs$ReturnValues{SQL_SCROLL_OPTIONS} =
1097{
1098 SQL_SO_FORWARD_ONLY => 0x00000001
1099, SQL_SO_KEYSET_DRIVEN => 0x00000002
1100, SQL_SO_DYNAMIC => 0x00000004
1101, SQL_SO_MIXED => 0x00000008
1102, SQL_SO_STATIC => 0x00000010
1103};
1104113µs$ReturnValues{SQL_SQL92_DATETIME_FUNCTIONS} =
1105{
1106 SQL_SDF_CURRENT_DATE => 0x00000001
1107, SQL_SDF_CURRENT_TIME => 0x00000002
1108, SQL_SDF_CURRENT_TIMESTAMP => 0x00000004
1109};
1110110µs$ReturnValues{SQL_SQL92_FOREIGN_KEY_DELETE_RULE} =
1111{
1112 SQL_SFKD_CASCADE => 0x00000001
1113, SQL_SFKD_NO_ACTION => 0x00000002
1114, SQL_SFKD_SET_DEFAULT => 0x00000004
1115, SQL_SFKD_SET_NULL => 0x00000008
1116};
111719µs$ReturnValues{SQL_SQL92_FOREIGN_KEY_UPDATE_RULE} =
1118{
1119 SQL_SFKU_CASCADE => 0x00000001
1120, SQL_SFKU_NO_ACTION => 0x00000002
1121, SQL_SFKU_SET_DEFAULT => 0x00000004
1122, SQL_SFKU_SET_NULL => 0x00000008
1123};
1124127µs$ReturnValues{SQL_SQL92_GRANT} =
1125{
1126 SQL_SG_USAGE_ON_DOMAIN => 0x00000001
1127, SQL_SG_USAGE_ON_CHARACTER_SET => 0x00000002
1128, SQL_SG_USAGE_ON_COLLATION => 0x00000004
1129, SQL_SG_USAGE_ON_TRANSLATION => 0x00000008
1130, SQL_SG_WITH_GRANT_OPTION => 0x00000010
1131, SQL_SG_DELETE_TABLE => 0x00000020
1132, SQL_SG_INSERT_TABLE => 0x00000040
1133, SQL_SG_INSERT_COLUMN => 0x00000080
1134, SQL_SG_REFERENCES_TABLE => 0x00000100
1135, SQL_SG_REFERENCES_COLUMN => 0x00000200
1136, SQL_SG_SELECT_TABLE => 0x00000400
1137, SQL_SG_UPDATE_TABLE => 0x00000800
1138, SQL_SG_UPDATE_COLUMN => 0x00001000
1139};
1140110µs$ReturnValues{SQL_SQL92_NUMERIC_VALUE_FUNCTIONS} =
1141{
1142 SQL_SNVF_BIT_LENGTH => 0x00000001
1143, SQL_SNVF_CHAR_LENGTH => 0x00000002
1144, SQL_SNVF_CHARACTER_LENGTH => 0x00000004
1145, SQL_SNVF_EXTRACT => 0x00000008
1146, SQL_SNVF_OCTET_LENGTH => 0x00000010
1147, SQL_SNVF_POSITION => 0x00000020
1148};
1149119µs$ReturnValues{SQL_SQL92_PREDICATES} =
1150{
1151 SQL_SP_EXISTS => 0x00000001
1152, SQL_SP_ISNOTNULL => 0x00000002
1153, SQL_SP_ISNULL => 0x00000004
1154, SQL_SP_MATCH_FULL => 0x00000008
1155, SQL_SP_MATCH_PARTIAL => 0x00000010
1156, SQL_SP_MATCH_UNIQUE_FULL => 0x00000020
1157, SQL_SP_MATCH_UNIQUE_PARTIAL => 0x00000040
1158, SQL_SP_OVERLAPS => 0x00000080
1159, SQL_SP_UNIQUE => 0x00000100
1160, SQL_SP_LIKE => 0x00000200
1161, SQL_SP_IN => 0x00000400
1162, SQL_SP_BETWEEN => 0x00000800
1163, SQL_SP_COMPARISON => 0x00001000
1164, SQL_SP_QUANTIFIED_COMPARISON => 0x00002000
1165};
1166113µs$ReturnValues{SQL_SQL92_RELATIONAL_JOIN_OPERATORS} =
1167{
1168 SQL_SRJO_CORRESPONDING_CLAUSE => 0x00000001
1169, SQL_SRJO_CROSS_JOIN => 0x00000002
1170, SQL_SRJO_EXCEPT_JOIN => 0x00000004
1171, SQL_SRJO_FULL_OUTER_JOIN => 0x00000008
1172, SQL_SRJO_INNER_JOIN => 0x00000010
1173, SQL_SRJO_INTERSECT_JOIN => 0x00000020
1174, SQL_SRJO_LEFT_OUTER_JOIN => 0x00000040
1175, SQL_SRJO_NATURAL_JOIN => 0x00000080
1176, SQL_SRJO_RIGHT_OUTER_JOIN => 0x00000100
1177, SQL_SRJO_UNION_JOIN => 0x00000200
1178};
1179117µs$ReturnValues{SQL_SQL92_REVOKE} =
1180{
1181 SQL_SR_USAGE_ON_DOMAIN => 0x00000001
1182, SQL_SR_USAGE_ON_CHARACTER_SET => 0x00000002
1183, SQL_SR_USAGE_ON_COLLATION => 0x00000004
1184, SQL_SR_USAGE_ON_TRANSLATION => 0x00000008
1185, SQL_SR_GRANT_OPTION_FOR => 0x00000010
1186, SQL_SR_CASCADE => 0x00000020
1187, SQL_SR_RESTRICT => 0x00000040
1188, SQL_SR_DELETE_TABLE => 0x00000080
1189, SQL_SR_INSERT_TABLE => 0x00000100
1190, SQL_SR_INSERT_COLUMN => 0x00000200
1191, SQL_SR_REFERENCES_TABLE => 0x00000400
1192, SQL_SR_REFERENCES_COLUMN => 0x00000800
1193, SQL_SR_SELECT_TABLE => 0x00001000
1194, SQL_SR_UPDATE_TABLE => 0x00002000
1195, SQL_SR_UPDATE_COLUMN => 0x00004000
1196};
119717µs$ReturnValues{SQL_SQL92_ROW_VALUE_CONSTRUCTOR} =
1198{
1199 SQL_SRVC_VALUE_EXPRESSION => 0x00000001
1200, SQL_SRVC_NULL => 0x00000002
1201, SQL_SRVC_DEFAULT => 0x00000004
1202, SQL_SRVC_ROW_SUBQUERY => 0x00000008
1203};
1204111µs$ReturnValues{SQL_SQL92_STRING_FUNCTIONS} =
1205{
1206 SQL_SSF_CONVERT => 0x00000001
1207, SQL_SSF_LOWER => 0x00000002
1208, SQL_SSF_UPPER => 0x00000004
1209, SQL_SSF_SUBSTRING => 0x00000008
1210, SQL_SSF_TRANSLATE => 0x00000010
1211, SQL_SSF_TRIM_BOTH => 0x00000020
1212, SQL_SSF_TRIM_LEADING => 0x00000040
1213, SQL_SSF_TRIM_TRAILING => 0x00000080
1214};
121517µs$ReturnValues{SQL_SQL92_VALUE_EXPRESSIONS} =
1216{
1217 SQL_SVE_CASE => 0x00000001
1218, SQL_SVE_CAST => 0x00000002
1219, SQL_SVE_COALESCE => 0x00000004
1220, SQL_SVE_NULLIF => 0x00000008
1221};
122218µs$ReturnValues{SQL_SQL_CONFORMANCE} =
1223{
1224 SQL_SC_SQL92_ENTRY => 0x00000001
1225, SQL_SC_FIPS127_2_TRANSITIONAL => 0x00000002
1226, SQL_SC_SQL92_INTERMEDIATE => 0x00000004
1227, SQL_SC_SQL92_FULL => 0x00000008
1228};
122918µs$ReturnValues{SQL_STANDARD_CLI_CONFORMANCE} =
1230{
1231 SQL_SCC_XOPEN_CLI_VERSION1 => 0x00000001
1232, SQL_SCC_ISO92_CLI => 0x00000002
1233};
123416µs$ReturnValues{SQL_STATIC_SENSITIVITY} =
1235{
1236 SQL_SS_ADDITIONS => 0x00000001
1237, SQL_SS_DELETIONS => 0x00000002
1238, SQL_SS_UPDATES => 0x00000004
1239};
1240126µs$ReturnValues{SQL_STRING_FUNCTIONS} =
1241{
1242 SQL_FN_STR_CONCAT => 0x00000001
1243, SQL_FN_STR_INSERT => 0x00000002
1244, SQL_FN_STR_LEFT => 0x00000004
1245, SQL_FN_STR_LTRIM => 0x00000008
1246, SQL_FN_STR_LENGTH => 0x00000010
1247, SQL_FN_STR_LOCATE => 0x00000020
1248, SQL_FN_STR_LCASE => 0x00000040
1249, SQL_FN_STR_REPEAT => 0x00000080
1250, SQL_FN_STR_REPLACE => 0x00000100
1251, SQL_FN_STR_RIGHT => 0x00000200
1252, SQL_FN_STR_RTRIM => 0x00000400
1253, SQL_FN_STR_SUBSTRING => 0x00000800
1254, SQL_FN_STR_UCASE => 0x00001000
1255, SQL_FN_STR_ASCII => 0x00002000
1256, SQL_FN_STR_CHAR => 0x00004000
1257, SQL_FN_STR_DIFFERENCE => 0x00008000
1258, SQL_FN_STR_LOCATE_2 => 0x00010000
1259, SQL_FN_STR_SOUNDEX => 0x00020000
1260, SQL_FN_STR_SPACE => 0x00040000
1261, SQL_FN_STR_BIT_LENGTH => 0x00080000
1262, SQL_FN_STR_CHAR_LENGTH => 0x00100000
1263, SQL_FN_STR_CHARACTER_LENGTH => 0x00200000
1264, SQL_FN_STR_OCTET_LENGTH => 0x00400000
1265, SQL_FN_STR_POSITION => 0x00800000
1266};
1267110µs$ReturnValues{SQL_SUBQUERIES} =
1268{
1269 SQL_SQ_COMPARISON => 0x00000001
1270, SQL_SQ_EXISTS => 0x00000002
1271, SQL_SQ_IN => 0x00000004
1272, SQL_SQ_QUANTIFIED => 0x00000008
1273, SQL_SQ_CORRELATED_SUBQUERIES => 0x00000010
1274};
1275110µs$ReturnValues{SQL_SYSTEM_FUNCTIONS} =
1276{
1277 SQL_FN_SYS_USERNAME => 0x00000001
1278, SQL_FN_SYS_DBNAME => 0x00000002
1279, SQL_FN_SYS_IFNULL => 0x00000004
1280};
1281111µs$ReturnValues{SQL_TIMEDATE_ADD_INTERVALS} =
1282{
1283 SQL_FN_TSI_FRAC_SECOND => 0x00000001
1284, SQL_FN_TSI_SECOND => 0x00000002
1285, SQL_FN_TSI_MINUTE => 0x00000004
1286, SQL_FN_TSI_HOUR => 0x00000008
1287, SQL_FN_TSI_DAY => 0x00000010
1288, SQL_FN_TSI_WEEK => 0x00000020
1289, SQL_FN_TSI_MONTH => 0x00000040
1290, SQL_FN_TSI_QUARTER => 0x00000080
1291, SQL_FN_TSI_YEAR => 0x00000100
1292};
1293122µs$ReturnValues{SQL_TIMEDATE_FUNCTIONS} =
1294{
1295 SQL_FN_TD_NOW => 0x00000001
1296, SQL_FN_TD_CURDATE => 0x00000002
1297, SQL_FN_TD_DAYOFMONTH => 0x00000004
1298, SQL_FN_TD_DAYOFWEEK => 0x00000008
1299, SQL_FN_TD_DAYOFYEAR => 0x00000010
1300, SQL_FN_TD_MONTH => 0x00000020
1301, SQL_FN_TD_QUARTER => 0x00000040
1302, SQL_FN_TD_WEEK => 0x00000080
1303, SQL_FN_TD_YEAR => 0x00000100
1304, SQL_FN_TD_CURTIME => 0x00000200
1305, SQL_FN_TD_HOUR => 0x00000400
1306, SQL_FN_TD_MINUTE => 0x00000800
1307, SQL_FN_TD_SECOND => 0x00001000
1308, SQL_FN_TD_TIMESTAMPADD => 0x00002000
1309, SQL_FN_TD_TIMESTAMPDIFF => 0x00004000
1310, SQL_FN_TD_DAYNAME => 0x00008000
1311, SQL_FN_TD_MONTHNAME => 0x00010000
1312, SQL_FN_TD_CURRENT_DATE => 0x00020000
1313, SQL_FN_TD_CURRENT_TIME => 0x00040000
1314, SQL_FN_TD_CURRENT_TIMESTAMP => 0x00080000
1315, SQL_FN_TD_EXTRACT => 0x00100000
1316};
131719µs$ReturnValues{SQL_TXN_CAPABLE} =
1318{
1319 SQL_TC_NONE => 0
1320, SQL_TC_DML => 1
1321, SQL_TC_ALL => 2
1322, SQL_TC_DDL_COMMIT => 3
1323, SQL_TC_DDL_IGNORE => 4
1324};
132517µs$ReturnValues{SQL_TRANSACTION_ISOLATION_OPTION} =
1326{
1327 SQL_TRANSACTION_READ_UNCOMMITTED => 0x00000001 # SQL_TXN_READ_UNCOMMITTED
1328, SQL_TRANSACTION_READ_COMMITTED => 0x00000002 # SQL_TXN_READ_COMMITTED
1329, SQL_TRANSACTION_REPEATABLE_READ => 0x00000004 # SQL_TXN_REPEATABLE_READ
1330, SQL_TRANSACTION_SERIALIZABLE => 0x00000008 # SQL_TXN_SERIALIZABLE
1331};
1332113µs$ReturnValues{SQL_DEFAULT_TRANSACTION_ISOLATION} = $ReturnValues{SQL_TRANSACTION_ISOLATION_OPTION};
1333
133419µs$ReturnValues{SQL_TXN_ISOLATION_OPTION} =
1335{
1336 SQL_TXN_READ_UNCOMMITTED => 0x00000001
1337, SQL_TXN_READ_COMMITTED => 0x00000002
1338, SQL_TXN_REPEATABLE_READ => 0x00000004
1339, SQL_TXN_SERIALIZABLE => 0x00000008
1340};
134115µs$ReturnValues{SQL_DEFAULT_TXN_ISOLATION} = $ReturnValues{SQL_TXN_ISOLATION_OPTION};
1342
134316µs$ReturnValues{SQL_TXN_VERSIONING} =
1344{
1345 SQL_TXN_VERSIONING => 0x00000010
1346};
134716µs$ReturnValues{SQL_UNION} =
1348{
1349 SQL_U_UNION => 0x00000001
1350, SQL_U_UNION_ALL => 0x00000002
1351};
1352112µs$ReturnValues{SQL_UNION_STATEMENT} =
1353{
1354 SQL_US_UNION => 0x00000001 # SQL_U_UNION
1355, SQL_US_UNION_ALL => 0x00000002 # SQL_U_UNION_ALL
1356};
1357
13581516µs1;
1359
1360=head1 TODO
1361
1362 Corrections?
1363 SQL_NULL_COLLATION: ODBC vs ANSI
1364 Unique values for $ReturnValues{...}?, e.g. SQL_FILE_USAGE
1365
1366=cut