← Index
NYTProf Performance Profile   « line view »
For svc/members/upsert
  Run on Tue Jan 13 11:50:22 2015
Reported on Tue Jan 13 12:09:51 2015

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