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