git.oblomov.eu Git - wine/blob - include/sqlext.h

   1 /*
   2  * MS SQL Extension definitions
   3  */
   4 #ifndef __SQLEXT_H
   5 #define __SQLEXT_H
   6
   7 #include "sql.h"
   8
   9 #ifdef __cplusplus
  10 extern "C" {
  11 #endif
  12
  13 #define SQL_SPEC_MAJOR     3
  14 #define SQL_SPEC_MINOR     51
  15 #define SQL_SPEC_STRING   "03.51"
  16
  17 #define SQL_SQLSTATE_SIZE       5
  18 #define SQL_MAX_DSN_LENGTH      32
  19
  20 #define SQL_MAX_OPTION_STRING_LENGTH    256
  21
  22 #if (ODBCVER < 0x0300)
  23 #define SQL_NO_DATA_FOUND       100
  24 #else
  25 #define SQL_NO_DATA_FOUND       SQL_NO_DATA
  26 #endif
  27
  28 #if (ODBCVER >= 0x0300)
  29 #define SQL_HANDLE_SENV         5
  30 #endif
  31
  32 #if (ODBCVER >= 0x0300)
  33 #define SQL_ATTR_ODBC_VERSION                           200
  34 #define SQL_ATTR_CONNECTION_POOLING                     201
  35 #define SQL_ATTR_CP_MATCH                                       202
  36 #endif
  37
  38 #if (ODBCVER >= 0x0300)
  39 #define SQL_CP_OFF                                                      0UL
  40 #define SQL_CP_ONE_PER_DRIVER                           1UL
  41 #define SQL_CP_ONE_PER_HENV                                     2UL
  42 #define SQL_CP_DEFAULT                                          SQL_CP_OFF
  43
  44 #define SQL_CP_STRICT_MATCH                                     0UL
  45 #define SQL_CP_RELAXED_MATCH                            1UL
  46 #define SQL_CP_MATCH_DEFAULT                            SQL_CP_STRICT_MATCH
  47
  48 #define SQL_OV_ODBC2                                            2UL
  49 #define SQL_OV_ODBC3                                            3UL
  50 #endif
  51
  52 #define SQL_ACCESS_MODE                 101
  53 #define SQL_AUTOCOMMIT                  102
  54 #define SQL_LOGIN_TIMEOUT               103
  55 #define SQL_OPT_TRACE                   104
  56 #define SQL_OPT_TRACEFILE               105
  57 #define SQL_TRANSLATE_DLL               106
  58 #define SQL_TRANSLATE_OPTION            107
  59 #define SQL_TXN_ISOLATION               108
  60 #define SQL_CURRENT_QUALIFIER           109
  61 #define SQL_ODBC_CURSORS                110
  62 #define SQL_QUIET_MODE                  111
  63 #define SQL_PACKET_SIZE                 112
  64
  65 #if (ODBCVER >= 0x0300)
  66 #define SQL_ATTR_ACCESS_MODE            SQL_ACCESS_MODE
  67 #define SQL_ATTR_AUTOCOMMIT                     SQL_AUTOCOMMIT
  68 #define SQL_ATTR_CONNECTION_TIMEOUT     113
  69 #define SQL_ATTR_CURRENT_CATALOG        SQL_CURRENT_QUALIFIER
  70 #define SQL_ATTR_DISCONNECT_BEHAVIOR    114
  71 #define SQL_ATTR_ENLIST_IN_DTC          1207
  72 #define SQL_ATTR_ENLIST_IN_XA           1208
  73 #define SQL_ATTR_LOGIN_TIMEOUT          SQL_LOGIN_TIMEOUT
  74 #define SQL_ATTR_ODBC_CURSORS           SQL_ODBC_CURSORS
  75 #define SQL_ATTR_PACKET_SIZE            SQL_PACKET_SIZE
  76 #define SQL_ATTR_QUIET_MODE                     SQL_QUIET_MODE
  77 #define SQL_ATTR_TRACE                          SQL_OPT_TRACE
  78 #define SQL_ATTR_TRACEFILE                      SQL_OPT_TRACEFILE
  79 #define SQL_ATTR_TRANSLATE_LIB          SQL_TRANSLATE_DLL
  80 #define SQL_ATTR_TRANSLATE_OPTION       SQL_TRANSLATE_OPTION
  81 #define SQL_ATTR_TXN_ISOLATION          SQL_TXN_ISOLATION
  82 #endif
  83
  84 #define SQL_ATTR_CONNECTION_DEAD        1209
  85
  86 #if (ODBCVER >= 0x0351)
  87 #define SQL_ATTR_ANSI_APP                       115
  88 #endif
  89
  90 #if (ODBCVER < 0x0300)
  91 #define SQL_CONNECT_OPT_DRVR_START      1000
  92 #endif
  93
  94 #if (ODBCVER < 0x0300)
  95 #define SQL_CONN_OPT_MAX                SQL_PACKET_SIZE
  96 #define SQL_CONN_OPT_MIN                SQL_ACCESS_MODE
  97 #endif
  98
  99 #define SQL_MODE_READ_WRITE             0UL
 100 #define SQL_MODE_READ_ONLY              1UL
 101 #define SQL_MODE_DEFAULT                SQL_MODE_READ_WRITE
 102
 103 #define SQL_AUTOCOMMIT_OFF              0UL
 104 #define SQL_AUTOCOMMIT_ON               1UL
 105 #define SQL_AUTOCOMMIT_DEFAULT          SQL_AUTOCOMMIT_ON
 106
 107 #define SQL_LOGIN_TIMEOUT_DEFAULT       15UL
 108
 109 #define SQL_OPT_TRACE_OFF               0UL
 110 #define SQL_OPT_TRACE_ON                1UL
 111 #define SQL_OPT_TRACE_DEFAULT           SQL_OPT_TRACE_OFF
 112 #define SQL_OPT_TRACE_FILE_DEFAULT      "\\SQL.LOG"
 113
 114 #define SQL_CUR_USE_IF_NEEDED           0UL
 115 #define SQL_CUR_USE_ODBC                1UL
 116 #define SQL_CUR_USE_DRIVER              2UL
 117 #define SQL_CUR_DEFAULT                 SQL_CUR_USE_DRIVER
 118
 119 #if (ODBCVER >= 0x0300)
 120 #define SQL_DB_RETURN_TO_POOL                   0UL
 121 #define SQL_DB_DISCONNECT                               1UL
 122 #define SQL_DB_DEFAULT                                  SQL_DB_RETURN_TO_POOL
 123
 124 #define SQL_DTC_DONE                                    0L
 125 #endif
 126
 127 #define SQL_CD_TRUE                                     1L
 128 #define SQL_CD_FALSE                                    0L
 129
 130 #if (ODBCVER >= 0x0351)
 131 #define SQL_AA_TRUE                                     1L
 132 #define SQL_AA_FALSE                                    0L
 133 #endif
 134
 135 #define SQL_QUERY_TIMEOUT               0
 136 #define SQL_MAX_ROWS                    1
 137 #define SQL_NOSCAN                      2
 138 #define SQL_MAX_LENGTH                  3
 139 #define SQL_ASYNC_ENABLE                4
 140 #define SQL_BIND_TYPE                   5
 141 #define SQL_CURSOR_TYPE                 6
 142 #define SQL_CONCURRENCY                 7
 143 #define SQL_KEYSET_SIZE                 8
 144 #define SQL_ROWSET_SIZE                 9
 145 #define SQL_SIMULATE_CURSOR             10
 146 #define SQL_RETRIEVE_DATA               11
 147 #define SQL_USE_BOOKMARKS               12
 148 #define SQL_GET_BOOKMARK                13
 149 #define SQL_ROW_NUMBER                  14
 150
 151 #if (ODBCVER >= 0x0300)
 152 #define SQL_ATTR_ASYNC_ENABLE                           4
 153 #define SQL_ATTR_CONCURRENCY                            SQL_CONCURRENCY
 154 #define SQL_ATTR_CURSOR_TYPE                            SQL_CURSOR_TYPE
 155 #define SQL_ATTR_ENABLE_AUTO_IPD                        15
 156 #define SQL_ATTR_FETCH_BOOKMARK_PTR                     16
 157 #define SQL_ATTR_KEYSET_SIZE                            SQL_KEYSET_SIZE
 158 #define SQL_ATTR_MAX_LENGTH                             SQL_MAX_LENGTH
 159 #define SQL_ATTR_MAX_ROWS                               SQL_MAX_ROWS
 160 #define SQL_ATTR_NOSCAN                                 SQL_NOSCAN
 161 #define SQL_ATTR_PARAM_BIND_OFFSET_PTR                  17
 162 #define SQL_ATTR_PARAM_BIND_TYPE                        18
 163 #define SQL_ATTR_PARAM_OPERATION_PTR                    19
 164 #define SQL_ATTR_PARAM_STATUS_PTR                       20
 165 #define SQL_ATTR_PARAMS_PROCESSED_PTR                   21
 166 #define SQL_ATTR_RETRIEVE_DATA                          SQL_RETRIEVE_DATA
 167 #define SQL_ATTR_ROW_BIND_OFFSET_PTR                    23
 168 #define SQL_ATTR_ROW_BIND_TYPE                          SQL_BIND_TYPE
 169 #define SQL_ATTR_ROW_NUMBER                             SQL_ROW_NUMBER
 170 #define SQL_ATTR_ROW_OPERATION_PTR                      24
 171 #define SQL_ATTR_ROW_STATUS_PTR                         25
 172 #define SQL_ATTR_ROWS_FETCHED_PTR                       26
 173 #define SQL_ATTR_ROW_ARRAY_SIZE                         27
 174 #define SQL_ATTR_SIMULATE_CURSOR                        SQL_SIMULATE_CURSOR
 175 #define SQL_ATTR_USE_BOOKMARKS                          SQL_USE_BOOKMARKS
 176
 177 #endif
 178
 179 #if (ODBCVER < 0x0300)
 180 #define SQL_STMT_OPT_MAX                SQL_ROW_NUMBER
 181 #define SQL_STMT_OPT_MIN        SQL_QUERY_TIMEOUT
 182 #endif
 183
 184 #if (ODBCVER >= 0x0300)
 185 #define SQL_COL_PRED_CHAR               SQL_LIKE_ONLY
 186 #define SQL_COL_PRED_BASIC              SQL_ALL_EXCEPT_LIKE
 187 #endif
 188
 189 #if (ODBCVER >= 0x0300)
 190 #define SQL_IS_POINTER                                                  (-4)
 191 #define SQL_IS_UINTEGER                                                 (-5)
 192 #define SQL_IS_INTEGER                                                  (-6)
 193 #define SQL_IS_USMALLINT                                                (-7)
 194 #define SQL_IS_SMALLINT                                                 (-8)
 195 #endif
 196
 197 #if (ODBCVER >= 0x0300)
 198 #define SQL_PARAM_BIND_BY_COLUMN                        0UL
 199 #define SQL_PARAM_BIND_TYPE_DEFAULT                     SQL_PARAM_BIND_BY_COLUMN
 200 #endif
 201
 202 #define SQL_QUERY_TIMEOUT_DEFAULT       0UL
 203
 204 #define SQL_MAX_ROWS_DEFAULT            0UL
 205
 206 #define SQL_NOSCAN_OFF                  0UL
 207 #define SQL_NOSCAN_ON                   1UL
 208 #define SQL_NOSCAN_DEFAULT              SQL_NOSCAN_OFF
 209
 210 #define SQL_MAX_LENGTH_DEFAULT          0UL
 211
 212 #define SQL_ASYNC_ENABLE_OFF                    0UL
 213 #define SQL_ASYNC_ENABLE_ON                             1UL
 214 #define SQL_ASYNC_ENABLE_DEFAULT        SQL_ASYNC_ENABLE_OFF
 215
 216 #define SQL_BIND_BY_COLUMN              0UL
 217 #define SQL_BIND_TYPE_DEFAULT           SQL_BIND_BY_COLUMN
 218
 219 #define SQL_CONCUR_READ_ONLY            1
 220 #define SQL_CONCUR_LOCK                 2
 221 #define SQL_CONCUR_ROWVER               3
 222 #define SQL_CONCUR_VALUES               4
 223 #define SQL_CONCUR_DEFAULT              SQL_CONCUR_READ_ONLY
 224
 225 #define SQL_CURSOR_FORWARD_ONLY         0UL
 226 #define SQL_CURSOR_KEYSET_DRIVEN        1UL
 227 #define SQL_CURSOR_DYNAMIC              2UL
 228 #define SQL_CURSOR_STATIC               3UL
 229 #define SQL_CURSOR_TYPE_DEFAULT         SQL_CURSOR_FORWARD_ONLY
 230
 231 #define SQL_ROWSET_SIZE_DEFAULT         1UL
 232
 233 #define SQL_KEYSET_SIZE_DEFAULT         0UL
 234
 235 #define SQL_SC_NON_UNIQUE               0UL
 236 #define SQL_SC_TRY_UNIQUE               1UL
 237 #define SQL_SC_UNIQUE                   2UL
 238
 239 #define SQL_RD_OFF                      0UL
 240 #define SQL_RD_ON                       1UL
 241 #define SQL_RD_DEFAULT                  SQL_RD_ON
 242
 243 #define SQL_UB_OFF                      0UL
 244 #define SQL_UB_ON                       01UL
 245 #define SQL_UB_DEFAULT                  SQL_UB_OFF
 246
 247 #if (ODBCVER >= 0x0300)
 248 #define SQL_UB_FIXED                                    SQL_UB_ON
 249 #define SQL_UB_VARIABLE                                 2UL
 250 #endif
 251
 252 #if (ODBCVER >= 0x0300)
 253 #define SQL_DESC_ARRAY_SIZE                                     20
 254 #define SQL_DESC_ARRAY_STATUS_PTR                               21
 255 #define SQL_DESC_AUTO_UNIQUE_VALUE                              SQL_COLUMN_AUTO_INCREMENT
 256 #define SQL_DESC_BASE_COLUMN_NAME                               22
 257 #define SQL_DESC_BASE_TABLE_NAME                                23
 258 #define SQL_DESC_BIND_OFFSET_PTR                                24
 259 #define SQL_DESC_BIND_TYPE                                      25
 260 #define SQL_DESC_CASE_SENSITIVE                                 SQL_COLUMN_CASE_SENSITIVE
 261 #define SQL_DESC_CATALOG_NAME                                   SQL_COLUMN_QUALIFIER_NAME
 262 #define SQL_DESC_CONCISE_TYPE                                   SQL_COLUMN_TYPE
 263 #define SQL_DESC_DATETIME_INTERVAL_PRECISION                    26
 264 #define SQL_DESC_DISPLAY_SIZE                                   SQL_COLUMN_DISPLAY_SIZE
 265 #define SQL_DESC_FIXED_PREC_SCALE                               SQL_COLUMN_MONEY
 266 #define SQL_DESC_LABEL                                          SQL_COLUMN_LABEL
 267 #define SQL_DESC_LITERAL_PREFIX                                 27
 268 #define SQL_DESC_LITERAL_SUFFIX                                 28
 269 #define SQL_DESC_LOCAL_TYPE_NAME                                29
 270 #define SQL_DESC_MAXIMUM_SCALE                                  30
 271 #define SQL_DESC_MINIMUM_SCALE                                  31
 272 #define SQL_DESC_NUM_PREC_RADIX                                 32
 273 #define SQL_DESC_PARAMETER_TYPE                                 33
 274 #define SQL_DESC_ROWS_PROCESSED_PTR                             34
 275 #if (ODBCVER >= 0x0350)
 276 #define SQL_DESC_ROWVER                                         35
 277 #endif
 278 #define SQL_DESC_SCHEMA_NAME                                    SQL_COLUMN_OWNER_NAME
 279 #define SQL_DESC_SEARCHABLE                                     SQL_COLUMN_SEARCHABLE
 280 #define SQL_DESC_TYPE_NAME                                      SQL_COLUMN_TYPE_NAME
 281 #define SQL_DESC_TABLE_NAME                                     SQL_COLUMN_TABLE_NAME
 282 #define SQL_DESC_UNSIGNED                                       SQL_COLUMN_UNSIGNED
 283 #define SQL_DESC_UPDATABLE                                      SQL_COLUMN_UPDATABLE
 284 #endif
 285
 286 #if (ODBCVER >= 0x0300)
 287 #define SQL_DIAG_CURSOR_ROW_COUNT                       (-1249)
 288 #define SQL_DIAG_ROW_NUMBER                             (-1248)
 289 #define SQL_DIAG_COLUMN_NUMBER                          (-1247)
 290 #endif
 291
 292 #define SQL_DATE                                9
 293 #if (ODBCVER >= 0x0300)
 294 #define SQL_INTERVAL                            10
 295 #endif
 296 #define SQL_TIME                                10
 297 #define SQL_TIMESTAMP                           11
 298 #define SQL_LONGVARCHAR                         (-1)
 299 #define SQL_BINARY                              (-2)
 300 #define SQL_VARBINARY                           (-3)
 301 #define SQL_LONGVARBINARY                       (-4)
 302 #define SQL_BIGINT                              (-5)
 303 #define SQL_TINYINT                             (-6)
 304 #define SQL_BIT                                 (-7)
 305 #if (ODBCVER >= 0x0350)
 306 #define SQL_GUID                                (-11)
 307 #endif
 308
 309 #if (ODBCVER >= 0x0300)
 310 #define SQL_CODE_YEAR                           1
 311 #define SQL_CODE_MONTH                          2
 312 #define SQL_CODE_DAY                            3
 313 #define SQL_CODE_HOUR                           4
 314 #define SQL_CODE_MINUTE                         5
 315 #define SQL_CODE_SECOND                         6
 316 #define SQL_CODE_YEAR_TO_MONTH                  7
 317 #define SQL_CODE_DAY_TO_HOUR                    8
 318 #define SQL_CODE_DAY_TO_MINUTE                  9
 319 #define SQL_CODE_DAY_TO_SECOND                  10
 320 #define SQL_CODE_HOUR_TO_MINUTE                 11
 321 #define SQL_CODE_HOUR_TO_SECOND                 12
 322 #define SQL_CODE_MINUTE_TO_SECOND               13
 323
 324 #define SQL_INTERVAL_YEAR                       (100 + SQL_CODE_YEAR)
 325 #define SQL_INTERVAL_MONTH                      (100 + SQL_CODE_MONTH)
 326 #define SQL_INTERVAL_DAY                        (100 + SQL_CODE_DAY)
 327 #define SQL_INTERVAL_HOUR                       (100 + SQL_CODE_HOUR)
 328 #define SQL_INTERVAL_MINUTE                     (100 + SQL_CODE_MINUTE)
 329 #define SQL_INTERVAL_SECOND                     (100 + SQL_CODE_SECOND)
 330 #define SQL_INTERVAL_YEAR_TO_MONTH              (100 + SQL_CODE_YEAR_TO_MONTH)
 331 #define SQL_INTERVAL_DAY_TO_HOUR                (100 + SQL_CODE_DAY_TO_HOUR)
 332 #define SQL_INTERVAL_DAY_TO_MINUTE              (100 + SQL_CODE_DAY_TO_MINUTE)
 333 #define SQL_INTERVAL_DAY_TO_SECOND              (100 + SQL_CODE_DAY_TO_SECOND)
 334 #define SQL_INTERVAL_HOUR_TO_MINUTE             (100 + SQL_CODE_HOUR_TO_MINUTE)
 335 #define SQL_INTERVAL_HOUR_TO_SECOND             (100 + SQL_CODE_HOUR_TO_SECOND)
 336 #define SQL_INTERVAL_MINUTE_TO_SECOND           (100 + SQL_CODE_MINUTE_TO_SECOND)
 337
 338 #else
 339 #define SQL_INTERVAL_YEAR                       (-80)
 340 #define SQL_INTERVAL_MONTH                      (-81)
 341 #define SQL_INTERVAL_YEAR_TO_MONTH              (-82)
 342 #define SQL_INTERVAL_DAY                        (-83)
 343 #define SQL_INTERVAL_HOUR                       (-84)
 344 #define SQL_INTERVAL_MINUTE                     (-85)
 345 #define SQL_INTERVAL_SECOND                     (-86)
 346 #define SQL_INTERVAL_DAY_TO_HOUR                (-87)
 347 #define SQL_INTERVAL_DAY_TO_MINUTE              (-88)
 348 #define SQL_INTERVAL_DAY_TO_SECOND              (-89)
 349 #define SQL_INTERVAL_HOUR_TO_MINUTE             (-90)
 350 #define SQL_INTERVAL_HOUR_TO_SECOND             (-91)
 351 #define SQL_INTERVAL_MINUTE_TO_SECOND           (-92)
 352 #endif
 353
 354
 355 #if (ODBCVER <= 0x0300)
 356 #define SQL_UNICODE                             (-95)
 357 #define SQL_UNICODE_VARCHAR                     (-96)
 358 #define SQL_UNICODE_LONGVARCHAR                 (-97)
 359 #define SQL_UNICODE_CHAR                        SQL_UNICODE
 360 #else
 361
 362 #define SQL_UNICODE                     SQL_WCHAR
 363 #define SQL_UNICODE_VARCHAR             SQL_WVARCHAR
 364 #define SQL_UNICODE_LONGVARCHAR SQL_WLONGVARCHAR
 365 #define SQL_UNICODE_CHAR                SQL_WCHAR
 366 #endif
 367
 368 #if (ODBCVER < 0x0300)
 369 #define SQL_TYPE_DRIVER_START                   SQL_INTERVAL_YEAR
 370 #define SQL_TYPE_DRIVER_END                     SQL_UNICODE_LONGVARCHAR
 371 #endif
 372
 373 #define SQL_C_CHAR    SQL_CHAR
 374 #define SQL_C_LONG    SQL_INTEGER
 375 #define SQL_C_SHORT   SQL_SMALLINT
 376 #define SQL_C_FLOAT   SQL_REAL
 377 #define SQL_C_DOUBLE  SQL_DOUBLE
 378 #if (ODBCVER >= 0x0300)
 379 #define SQL_C_NUMERIC           SQL_NUMERIC
 380 #endif
 381 #define SQL_C_DEFAULT 99
 382
 383 #define SQL_SIGNED_OFFSET       (-20)
 384 #define SQL_UNSIGNED_OFFSET     (-22)
 385
 386 #define SQL_C_DATE       SQL_DATE
 387 #define SQL_C_TIME       SQL_TIME
 388 #define SQL_C_TIMESTAMP  SQL_TIMESTAMP
 389 #if (ODBCVER >= 0x0300)
 390 #define SQL_C_TYPE_DATE                         SQL_TYPE_DATE
 391 #define SQL_C_TYPE_TIME                         SQL_TYPE_TIME
 392 #define SQL_C_TYPE_TIMESTAMP                    SQL_TYPE_TIMESTAMP
 393 #define SQL_C_INTERVAL_YEAR                     SQL_INTERVAL_YEAR
 394 #define SQL_C_INTERVAL_MONTH                    SQL_INTERVAL_MONTH
 395 #define SQL_C_INTERVAL_DAY                      SQL_INTERVAL_DAY
 396 #define SQL_C_INTERVAL_HOUR                     SQL_INTERVAL_HOUR
 397 #define SQL_C_INTERVAL_MINUTE                   SQL_INTERVAL_MINUTE
 398 #define SQL_C_INTERVAL_SECOND                   SQL_INTERVAL_SECOND
 399 #define SQL_C_INTERVAL_YEAR_TO_MONTH            SQL_INTERVAL_YEAR_TO_MONTH
 400 #define SQL_C_INTERVAL_DAY_TO_HOUR              SQL_INTERVAL_DAY_TO_HOUR
 401 #define SQL_C_INTERVAL_DAY_TO_MINUTE            SQL_INTERVAL_DAY_TO_MINUTE
 402 #define SQL_C_INTERVAL_DAY_TO_SECOND            SQL_INTERVAL_DAY_TO_SECOND
 403 #define SQL_C_INTERVAL_HOUR_TO_MINUTE           SQL_INTERVAL_HOUR_TO_MINUTE
 404 #define SQL_C_INTERVAL_HOUR_TO_SECOND           SQL_INTERVAL_HOUR_TO_SECOND
 405 #define SQL_C_INTERVAL_MINUTE_TO_SECOND         SQL_INTERVAL_MINUTE_TO_SECOND
 406 #endif
 407 #define SQL_C_BINARY     SQL_BINARY
 408 #define SQL_C_BIT        SQL_BIT
 409 #if (ODBCVER >= 0x0300)
 410 #define SQL_C_SBIGINT   (SQL_BIGINT+SQL_SIGNED_OFFSET)
 411 #define SQL_C_UBIGINT   (SQL_BIGINT+SQL_UNSIGNED_OFFSET)
 412 #endif
 413 #define SQL_C_TINYINT    SQL_TINYINT
 414 #define SQL_C_SLONG      (SQL_C_LONG+SQL_SIGNED_OFFSET)
 415 #define SQL_C_SSHORT     (SQL_C_SHORT+SQL_SIGNED_OFFSET)
 416 #define SQL_C_STINYINT   (SQL_TINYINT+SQL_SIGNED_OFFSET)
 417 #define SQL_C_ULONG      (SQL_C_LONG+SQL_UNSIGNED_OFFSET)
 418 #define SQL_C_USHORT     (SQL_C_SHORT+SQL_UNSIGNED_OFFSET)
 419 #define SQL_C_UTINYINT   (SQL_TINYINT+SQL_UNSIGNED_OFFSET)
 420 #define SQL_C_BOOKMARK   SQL_C_ULONG
 421
 422 #if (ODBCVER >= 0x0350)
 423 #define SQL_C_GUID      SQL_GUID
 424 #endif
 425
 426 #define SQL_TYPE_NULL                   0
 427 #if (ODBCVER < 0x0300)
 428 #define SQL_TYPE_MIN                    SQL_BIT
 429 #define SQL_TYPE_MAX                    SQL_VARCHAR
 430 #endif
 431
 432 #if (ODBCVER >= 0x0300)
 433 #define SQL_C_VARBOOKMARK               SQL_C_BINARY
 434 #endif
 435
 436 #if (ODBCVER >= 0x0300)
 437 #define SQL_NO_ROW_NUMBER                                       (-1)
 438 #define SQL_NO_COLUMN_NUMBER                                    (-1)
 439 #define SQL_ROW_NUMBER_UNKNOWN                                  (-2)
 440 #define SQL_COLUMN_NUMBER_UNKNOWN                               (-2)
 441 #endif
 442
 443 #define SQL_DEFAULT_PARAM            (-5)
 444 #define SQL_IGNORE                   (-6)
 445 #if (ODBCVER >= 0x0300)
 446 #define SQL_COLUMN_IGNORE               SQL_IGNORE
 447 #endif
 448 #define SQL_LEN_DATA_AT_EXEC_OFFSET  (-100)
 449 #define SQL_LEN_DATA_AT_EXEC(length) (-(length)+SQL_LEN_DATA_AT_EXEC_OFFSET)
 450
 451 #define SQL_LEN_BINARY_ATTR_OFFSET       (-100)
 452 #define SQL_LEN_BINARY_ATTR(length)      (-(length)+SQL_LEN_BINARY_ATTR_OFFSET)
 453
 454 #define SQL_PARAM_TYPE_DEFAULT           SQL_PARAM_INPUT_OUTPUT
 455 #define SQL_SETPARAM_VALUE_MAX           (-1L)
 456
 457 #define SQL_COLUMN_COUNT                0
 458 #define SQL_COLUMN_NAME                 1
 459 #define SQL_COLUMN_TYPE                 2
 460 #define SQL_COLUMN_LENGTH               3
 461 #define SQL_COLUMN_PRECISION            4
 462 #define SQL_COLUMN_SCALE                5
 463 #define SQL_COLUMN_DISPLAY_SIZE         6
 464 #define SQL_COLUMN_NULLABLE             7
 465 #define SQL_COLUMN_UNSIGNED             8
 466 #define SQL_COLUMN_MONEY                9
 467 #define SQL_COLUMN_UPDATABLE            10
 468 #define SQL_COLUMN_AUTO_INCREMENT       11
 469 #define SQL_COLUMN_CASE_SENSITIVE       12
 470 #define SQL_COLUMN_SEARCHABLE           13
 471 #define SQL_COLUMN_TYPE_NAME            14
 472 #define SQL_COLUMN_TABLE_NAME           15
 473 #define SQL_COLUMN_OWNER_NAME           16
 474 #define SQL_COLUMN_QUALIFIER_NAME       17
 475 #define SQL_COLUMN_LABEL                18
 476 #define SQL_COLATT_OPT_MAX              SQL_COLUMN_LABEL
 477 #if (ODBCVER < 0x0300)
 478 #define SQL_COLUMN_DRIVER_START         1000
 479 #endif
 480
 481 #define SQL_COLATT_OPT_MIN              SQL_COLUMN_COUNT
 482
 483 #define SQL_ATTR_READONLY               0
 484 #define SQL_ATTR_WRITE                  1
 485 #define SQL_ATTR_READWRITE_UNKNOWN      2
 486
 487 #define SQL_UNSEARCHABLE                0
 488 #define SQL_LIKE_ONLY                   1
 489 #define SQL_ALL_EXCEPT_LIKE             2
 490 #define SQL_SEARCHABLE                  3
 491 #define SQL_PRED_SEARCHABLE                             SQL_SEARCHABLE
 492
 493
 494 #define SQL_NO_TOTAL                    (-4)
 495
 496 #if (ODBCVER >= 0x0300)
 497 #define SQL_API_SQLALLOCHANDLESTD       73
 498 #define SQL_API_SQLBULKOPERATIONS       24
 499 #endif
 500 #define SQL_API_SQLBINDPARAMETER    72
 501 #define SQL_API_SQLBROWSECONNECT    55
 502 #define SQL_API_SQLCOLATTRIBUTES    6
 503 #define SQL_API_SQLCOLUMNPRIVILEGES 56
 504 #define SQL_API_SQLDESCRIBEPARAM    58
 505 #define SQL_API_SQLDRIVERCONNECT        41
 506 #define SQL_API_SQLDRIVERS          71
 507 #define SQL_API_SQLEXTENDEDFETCH    59
 508 #define SQL_API_SQLFOREIGNKEYS      60
 509 #define SQL_API_SQLMORERESULTS      61
 510 #define SQL_API_SQLNATIVESQL        62
 511 #define SQL_API_SQLNUMPARAMS        63
 512 #define SQL_API_SQLPARAMOPTIONS     64
 513 #define SQL_API_SQLPRIMARYKEYS      65
 514 #define SQL_API_SQLPROCEDURECOLUMNS 66
 515 #define SQL_API_SQLPROCEDURES       67
 516 #define SQL_API_SQLSETPOS           68
 517 #define SQL_API_SQLSETSCROLLOPTIONS 69
 518 #define SQL_API_SQLTABLEPRIVILEGES  70
 519
 520 #if (ODBCVER < 0x0300)
 521 #define SQL_EXT_API_LAST            SQL_API_SQLBINDPARAMETER
 522 #define SQL_NUM_FUNCTIONS           23
 523 #define SQL_EXT_API_START           40
 524 #define SQL_NUM_EXTENSIONS (SQL_EXT_API_LAST-SQL_EXT_API_START+1)
 525 #endif
 526
 527 #define SQL_API_ALL_FUNCTIONS       0
 528
 529 #define SQL_API_LOADBYORDINAL       199
 530
 531 #if (ODBCVER >= 0x0300)
 532 #define SQL_API_ODBC3_ALL_FUNCTIONS             999
 533 #define SQL_API_ODBC3_ALL_FUNCTIONS_SIZE        250
 534
 535
 536 #define SQL_FUNC_EXISTS(pfExists, uwAPI) ((*(((UWORD*) (pfExists)) + ((uwAPI) >> 4)) & (1 << ((uwAPI) & 0x000F)) ) ? SQL_TRUE : SQL_FALSE )
 537
 538 #endif
 539
 540 #define SQL_INFO_FIRST                       0
 541 #define SQL_ACTIVE_CONNECTIONS               0
 542 #define SQL_ACTIVE_STATEMENTS                1
 543 #define SQL_DRIVER_HDBC                      3
 544 #define SQL_DRIVER_HENV                      4
 545 #define SQL_DRIVER_HSTMT                     5
 546 #define SQL_DRIVER_NAME                      6
 547 #define SQL_DRIVER_VER                       7
 548 #define SQL_ODBC_API_CONFORMANCE             9
 549 #define SQL_ODBC_VER                        10
 550 #define SQL_ROW_UPDATES                     11
 551 #define SQL_ODBC_SAG_CLI_CONFORMANCE        12
 552 #define SQL_ODBC_SQL_CONFORMANCE            15
 553 #define SQL_PROCEDURES                      21
 554 #define SQL_CONCAT_NULL_BEHAVIOR            22
 555 #define SQL_CURSOR_ROLLBACK_BEHAVIOR        24
 556 #define SQL_EXPRESSIONS_IN_ORDERBY          27
 557 #define SQL_MAX_OWNER_NAME_LEN              32
 558 #define SQL_MAX_PROCEDURE_NAME_LEN          33
 559 #define SQL_MAX_QUALIFIER_NAME_LEN          34
 560 #define SQL_MULT_RESULT_SETS                36
 561 #define SQL_MULTIPLE_ACTIVE_TXN             37
 562 #define SQL_OUTER_JOINS                     38
 563 #define SQL_OWNER_TERM                      39
 564 #define SQL_PROCEDURE_TERM                  40
 565 #define SQL_QUALIFIER_NAME_SEPARATOR        41
 566 #define SQL_QUALIFIER_TERM                  42
 567 #define SQL_SCROLL_OPTIONS                  44
 568 #define SQL_TABLE_TERM                      45
 569 #define SQL_CONVERT_FUNCTIONS               48
 570 #define SQL_NUMERIC_FUNCTIONS               49
 571 #define SQL_STRING_FUNCTIONS                50
 572 #define SQL_SYSTEM_FUNCTIONS                51
 573 #define SQL_TIMEDATE_FUNCTIONS              52
 574 #define SQL_CONVERT_BIGINT                  53
 575 #define SQL_CONVERT_BINARY                  54
 576 #define SQL_CONVERT_BIT                     55
 577 #define SQL_CONVERT_CHAR                    56
 578 #define SQL_CONVERT_DATE                    57
 579 #define SQL_CONVERT_DECIMAL                 58
 580 #define SQL_CONVERT_DOUBLE                  59
 581 #define SQL_CONVERT_FLOAT                   60
 582 #define SQL_CONVERT_INTEGER                 61
 583 #define SQL_CONVERT_LONGVARCHAR             62
 584 #define SQL_CONVERT_NUMERIC                 63
 585 #define SQL_CONVERT_REAL                    64
 586 #define SQL_CONVERT_SMALLINT                65
 587 #define SQL_CONVERT_TIME                    66
 588 #define SQL_CONVERT_TIMESTAMP               67
 589 #define SQL_CONVERT_TINYINT                 68
 590 #define SQL_CONVERT_VARBINARY               69
 591 #define SQL_CONVERT_VARCHAR                 70
 592 #define SQL_CONVERT_LONGVARBINARY           71
 593 #define SQL_ODBC_SQL_OPT_IEF                73
 594 #define SQL_CORRELATION_NAME                74
 595 #define SQL_NON_NULLABLE_COLUMNS            75
 596 #define SQL_DRIVER_HLIB                     76
 597 #define SQL_DRIVER_ODBC_VER                 77
 598 #define SQL_LOCK_TYPES                      78
 599 #define SQL_POS_OPERATIONS                  79
 600 #define SQL_POSITIONED_STATEMENTS           80
 601 #define SQL_BOOKMARK_PERSISTENCE            82
 602 #define SQL_STATIC_SENSITIVITY              83
 603 #define SQL_FILE_USAGE                      84
 604 #define SQL_COLUMN_ALIAS                    87
 605 #define SQL_GROUP_BY                        88
 606 #define SQL_KEYWORDS                        89
 607 #define SQL_OWNER_USAGE                     91
 608 #define SQL_QUALIFIER_USAGE                 92
 609 #define SQL_QUOTED_IDENTIFIER_CASE          93
 610 #define SQL_SUBQUERIES                      95
 611 #define SQL_UNION                           96
 612 #define SQL_MAX_ROW_SIZE_INCLUDES_LONG      103
 613 #define SQL_MAX_CHAR_LITERAL_LEN            108
 614 #define SQL_TIMEDATE_ADD_INTERVALS          109
 615 #define SQL_TIMEDATE_DIFF_INTERVALS         110
 616 #define SQL_NEED_LONG_DATA_LEN              111
 617 #define SQL_MAX_BINARY_LITERAL_LEN          112
 618 #define SQL_LIKE_ESCAPE_CLAUSE              113
 619 #define SQL_QUALIFIER_LOCATION              114
 620
 621 #if (ODBCVER >= 0x0201 && ODBCVER < 0x0300)
 622 #define SQL_OJ_CAPABILITIES         65003
 623 #endif
 624
 625 #if (ODBCVER < 0x0300)
 626 #define SQL_INFO_LAST                                                   SQL_QUALIFIER_LOCATION
 627 #define SQL_INFO_DRIVER_START                                           1000
 628 #endif
 629
 630 #if (ODBCVER >= 0x0300)
 631 #define SQL_ACTIVE_ENVIRONMENTS                                         116
 632 #define SQL_ALTER_DOMAIN                                                117
 633
 634 #define SQL_SQL_CONFORMANCE                                             118
 635 #define SQL_DATETIME_LITERALS                                           119
 636
 637 #define SQL_ASYNC_MODE                                                  10021
 638 #define SQL_BATCH_ROW_COUNT                                             120
 639 #define SQL_BATCH_SUPPORT                                               121
 640 #define SQL_CATALOG_LOCATION                                            SQL_QUALIFIER_LOCATION
 641 #define SQL_CATALOG_NAME_SEPARATOR                                      SQL_QUALIFIER_NAME_SEPARATOR
 642 #define SQL_CATALOG_TERM                                                SQL_QUALIFIER_TERM
 643 #define SQL_CATALOG_USAGE                                               SQL_QUALIFIER_USAGE
 644 #define SQL_CONVERT_WCHAR                                               122
 645 #define SQL_CONVERT_INTERVAL_DAY_TIME                                   123
 646 #define SQL_CONVERT_INTERVAL_YEAR_MONTH                                 124
 647 #define SQL_CONVERT_WLONGVARCHAR                                        125
 648 #define SQL_CONVERT_WVARCHAR                                            126
 649 #define SQL_CREATE_ASSERTION                                            127
 650 #define SQL_CREATE_CHARACTER_SET                                        128
 651 #define SQL_CREATE_COLLATION                                            129
 652 #define SQL_CREATE_DOMAIN                                               130
 653 #define SQL_CREATE_SCHEMA                                               131
 654 #define SQL_CREATE_TABLE                                                132
 655 #define SQL_CREATE_TRANSLATION                                          133
 656 #define SQL_CREATE_VIEW                                                 134
 657 #define SQL_DRIVER_HDESC                                                135
 658 #define SQL_DROP_ASSERTION                                              136
 659 #define SQL_DROP_CHARACTER_SET                                          137
 660 #define SQL_DROP_COLLATION                                              138
 661 #define SQL_DROP_DOMAIN                                                 139
 662 #define SQL_DROP_SCHEMA                                                 140
 663 #define SQL_DROP_TABLE                                                  141
 664 #define SQL_DROP_TRANSLATION                                            142
 665 #define SQL_DROP_VIEW                                                   143
 666 #define SQL_DYNAMIC_CURSOR_ATTRIBUTES1                  144
 667 #define SQL_DYNAMIC_CURSOR_ATTRIBUTES2                  145
 668 #define SQL_FORWARD_ONLY_CURSOR_ATTRIBUTES1             146
 669 #define SQL_FORWARD_ONLY_CURSOR_ATTRIBUTES2             147
 670 #define SQL_INDEX_KEYWORDS                              148
 671 #define SQL_INFO_SCHEMA_VIEWS                           149
 672 #define SQL_KEYSET_CURSOR_ATTRIBUTES1                   150
 673 #define SQL_KEYSET_CURSOR_ATTRIBUTES2                   151
 674 #define SQL_MAX_ASYNC_CONCURRENT_STATEMENTS             10022
 675 #define SQL_ODBC_INTERFACE_CONFORMANCE                  152
 676 #define SQL_PARAM_ARRAY_ROW_COUNTS                      153
 677 #define SQL_PARAM_ARRAY_SELECTS                         154
 678 #define SQL_SCHEMA_TERM                                 SQL_OWNER_TERM
 679 #define SQL_SCHEMA_USAGE                                SQL_OWNER_USAGE
 680 #define SQL_SQL92_DATETIME_FUNCTIONS                    155
 681 #define SQL_SQL92_FOREIGN_KEY_DELETE_RULE               156
 682 #define SQL_SQL92_FOREIGN_KEY_UPDATE_RULE               157
 683 #define SQL_SQL92_GRANT                                 158
 684 #define SQL_SQL92_NUMERIC_VALUE_FUNCTIONS               159
 685 #define SQL_SQL92_PREDICATES                            160
 686 #define SQL_SQL92_RELATIONAL_JOIN_OPERATORS             161
 687 #define SQL_SQL92_REVOKE                                162
 688 #define SQL_SQL92_ROW_VALUE_CONSTRUCTOR                 163
 689 #define SQL_SQL92_STRING_FUNCTIONS                      164
 690 #define SQL_SQL92_VALUE_EXPRESSIONS                     165
 691 #define SQL_STANDARD_CLI_CONFORMANCE                    166
 692 #define SQL_STATIC_CURSOR_ATTRIBUTES1                   167
 693 #define SQL_STATIC_CURSOR_ATTRIBUTES2                   168
 694
 695 #define SQL_AGGREGATE_FUNCTIONS                         169
 696 #define SQL_DDL_INDEX                                   170
 697 #define SQL_DM_VER                                      171
 698 #define SQL_INSERT_STATEMENT                            172
 699 #define SQL_UNION_STATEMENT                             SQL_UNION
 700 #endif
 701
 702 #define SQL_DTC_TRANSITION_COST                         1750
 703
 704 #if (ODBCVER >= 0x0300)
 705
 706 #define SQL_AT_ADD_COLUMN_SINGLE                                0x00000020L
 707 #define SQL_AT_ADD_COLUMN_DEFAULT                               0x00000040L
 708 #define SQL_AT_ADD_COLUMN_COLLATION                             0x00000080L
 709 #define SQL_AT_SET_COLUMN_DEFAULT                               0x00000100L
 710 #define SQL_AT_DROP_COLUMN_DEFAULT                              0x00000200L
 711 #define SQL_AT_DROP_COLUMN_CASCADE                              0x00000400L
 712 #define SQL_AT_DROP_COLUMN_RESTRICT                             0x00000800L
 713 #define SQL_AT_ADD_TABLE_CONSTRAINT                             0x00001000L
 714 #define SQL_AT_DROP_TABLE_CONSTRAINT_CASCADE                    0x00002000L
 715 #define SQL_AT_DROP_TABLE_CONSTRAINT_RESTRICT                   0x00004000L
 716 #define SQL_AT_CONSTRAINT_NAME_DEFINITION                       0x00008000L
 717 #define SQL_AT_CONSTRAINT_INITIALLY_DEFERRED                    0x00010000L
 718 #define SQL_AT_CONSTRAINT_INITIALLY_IMMEDIATE                   0x00020000L
 719 #define SQL_AT_CONSTRAINT_DEFERRABLE                            0x00040000L
 720 #define SQL_AT_CONSTRAINT_NON_DEFERRABLE                        0x00080000L
 721 #endif
 722
 723 #define SQL_CVT_CHAR                        0x00000001L
 724 #define SQL_CVT_NUMERIC                     0x00000002L
 725 #define SQL_CVT_DECIMAL                     0x00000004L
 726 #define SQL_CVT_INTEGER                     0x00000008L
 727 #define SQL_CVT_SMALLINT                    0x00000010L
 728 #define SQL_CVT_FLOAT                       0x00000020L
 729 #define SQL_CVT_REAL                        0x00000040L
 730 #define SQL_CVT_DOUBLE                      0x00000080L
 731 #define SQL_CVT_VARCHAR                     0x00000100L
 732 #define SQL_CVT_LONGVARCHAR                 0x00000200L
 733 #define SQL_CVT_BINARY                      0x00000400L
 734 #define SQL_CVT_VARBINARY                   0x00000800L
 735 #define SQL_CVT_BIT                         0x00001000L
 736 #define SQL_CVT_TINYINT                     0x00002000L
 737 #define SQL_CVT_BIGINT                      0x00004000L
 738 #define SQL_CVT_DATE                        0x00008000L
 739 #define SQL_CVT_TIME                        0x00010000L
 740 #define SQL_CVT_TIMESTAMP                   0x00020000L
 741 #define SQL_CVT_LONGVARBINARY               0x00040000L
 742 #if (ODBCVER >= 0x0300)
 743 #define SQL_CVT_INTERVAL_YEAR_MONTH     0x00080000L
 744 #define SQL_CVT_INTERVAL_DAY_TIME       0x00100000L
 745 #define SQL_CVT_WCHAR                   0x00200000L
 746 #define SQL_CVT_WLONGVARCHAR            0x00400000L
 747 #define SQL_CVT_WVARCHAR                0x00800000L
 748
 749 #endif
 750
 751
 752 #define SQL_FN_CVT_CONVERT              0x00000001L
 753 #if (ODBCVER >= 0x0300)
 754 #define SQL_FN_CVT_CAST                 0x00000002L
 755 #endif
 756
 757 #define SQL_FN_STR_CONCAT                   0x00000001L
 758 #define SQL_FN_STR_INSERT                   0x00000002L
 759 #define SQL_FN_STR_LEFT                     0x00000004L
 760 #define SQL_FN_STR_LTRIM                    0x00000008L
 761 #define SQL_FN_STR_LENGTH                   0x00000010L
 762 #define SQL_FN_STR_LOCATE                   0x00000020L
 763 #define SQL_FN_STR_LCASE                    0x00000040L
 764 #define SQL_FN_STR_REPEAT                   0x00000080L
 765 #define SQL_FN_STR_REPLACE                  0x00000100L
 766 #define SQL_FN_STR_RIGHT                    0x00000200L
 767 #define SQL_FN_STR_RTRIM                    0x00000400L
 768 #define SQL_FN_STR_SUBSTRING                0x00000800L
 769 #define SQL_FN_STR_UCASE                    0x00001000L
 770 #define SQL_FN_STR_ASCII                    0x00002000L
 771 #define SQL_FN_STR_CHAR                     0x00004000L
 772 #define SQL_FN_STR_DIFFERENCE               0x00008000L
 773 #define SQL_FN_STR_LOCATE_2                 0x00010000L
 774 #define SQL_FN_STR_SOUNDEX                  0x00020000L
 775 #define SQL_FN_STR_SPACE                    0x00040000L
 776 #if (ODBCVER >= 0x0300)
 777 #define SQL_FN_STR_BIT_LENGTH                   0x00080000L
 778 #define SQL_FN_STR_CHAR_LENGTH                  0x00100000L
 779 #define SQL_FN_STR_CHARACTER_LENGTH             0x00200000L
 780 #define SQL_FN_STR_OCTET_LENGTH                 0x00400000L
 781 #define SQL_FN_STR_POSITION                     0x00800000L
 782 #endif
 783
 784 #if (ODBCVER >= 0x0300)
 785 #define SQL_SSF_CONVERT                                 0x00000001L
 786 #define SQL_SSF_LOWER                                   0x00000002L
 787 #define SQL_SSF_UPPER                                   0x00000004L
 788 #define SQL_SSF_SUBSTRING                               0x00000008L
 789 #define SQL_SSF_TRANSLATE                               0x00000010L
 790 #define SQL_SSF_TRIM_BOTH                               0x00000020L
 791 #define SQL_SSF_TRIM_LEADING                            0x00000040L
 792 #define SQL_SSF_TRIM_TRAILING                           0x00000080L
 793 #endif
 794
 795 #define SQL_FN_NUM_ABS                      0x00000001L
 796 #define SQL_FN_NUM_ACOS                     0x00000002L
 797 #define SQL_FN_NUM_ASIN                     0x00000004L
 798 #define SQL_FN_NUM_ATAN                     0x00000008L
 799 #define SQL_FN_NUM_ATAN2                    0x00000010L
 800 #define SQL_FN_NUM_CEILING                  0x00000020L
 801 #define SQL_FN_NUM_COS                      0x00000040L
 802 #define SQL_FN_NUM_COT                      0x00000080L
 803 #define SQL_FN_NUM_EXP                      0x00000100L
 804 #define SQL_FN_NUM_FLOOR                    0x00000200L
 805 #define SQL_FN_NUM_LOG                      0x00000400L
 806 #define SQL_FN_NUM_MOD                      0x00000800L
 807 #define SQL_FN_NUM_SIGN                     0x00001000L
 808 #define SQL_FN_NUM_SIN                      0x00002000L
 809 #define SQL_FN_NUM_SQRT                     0x00004000L
 810 #define SQL_FN_NUM_TAN                      0x00008000L
 811 #define SQL_FN_NUM_PI                       0x00010000L
 812 #define SQL_FN_NUM_RAND                     0x00020000L
 813 #define SQL_FN_NUM_DEGREES                  0x00040000L
 814 #define SQL_FN_NUM_LOG10                    0x00080000L
 815 #define SQL_FN_NUM_POWER                    0x00100000L
 816 #define SQL_FN_NUM_RADIANS                  0x00200000L
 817 #define SQL_FN_NUM_ROUND                    0x00400000L
 818 #define SQL_FN_NUM_TRUNCATE                 0x00800000L
 819
 820 #if (ODBCVER >= 0x0300)
 821 #define SQL_SNVF_BIT_LENGTH                             0x00000001L
 822 #define SQL_SNVF_CHAR_LENGTH                            0x00000002L
 823 #define SQL_SNVF_CHARACTER_LENGTH                       0x00000004L
 824 #define SQL_SNVF_EXTRACT                                0x00000008L
 825 #define SQL_SNVF_OCTET_LENGTH                           0x00000010L
 826 #define SQL_SNVF_POSITION                               0x00000020L
 827 #endif
 828
 829 #define SQL_FN_TD_NOW                       0x00000001L
 830 #define SQL_FN_TD_CURDATE                   0x00000002L
 831 #define SQL_FN_TD_DAYOFMONTH                0x00000004L
 832 #define SQL_FN_TD_DAYOFWEEK                 0x00000008L
 833 #define SQL_FN_TD_DAYOFYEAR                 0x00000010L
 834 #define SQL_FN_TD_MONTH                     0x00000020L
 835 #define SQL_FN_TD_QUARTER                   0x00000040L
 836 #define SQL_FN_TD_WEEK                      0x00000080L
 837 #define SQL_FN_TD_YEAR                      0x00000100L
 838 #define SQL_FN_TD_CURTIME                   0x00000200L
 839 #define SQL_FN_TD_HOUR                      0x00000400L
 840 #define SQL_FN_TD_MINUTE                    0x00000800L
 841 #define SQL_FN_TD_SECOND                    0x00001000L
 842 #define SQL_FN_TD_TIMESTAMPADD              0x00002000L
 843 #define SQL_FN_TD_TIMESTAMPDIFF             0x00004000L
 844 #define SQL_FN_TD_DAYNAME                   0x00008000L
 845 #define SQL_FN_TD_MONTHNAME                 0x00010000L
 846 #if (ODBCVER >= 0x0300)
 847 #define SQL_FN_TD_CURRENT_DATE                          0x00020000L
 848 #define SQL_FN_TD_CURRENT_TIME                          0x00040000L
 849 #define SQL_FN_TD_CURRENT_TIMESTAMP                     0x00080000L
 850 #define SQL_FN_TD_EXTRACT                               0x00100000L
 851 #endif
 852
 853 #if (ODBCVER >= 0x0300)
 854 #define SQL_SDF_CURRENT_DATE                            0x00000001L
 855 #define SQL_SDF_CURRENT_TIME                            0x00000002L
 856 #define SQL_SDF_CURRENT_TIMESTAMP                       0x00000004L
 857 #endif
 858
 859 #define SQL_FN_SYS_USERNAME                 0x00000001L
 860 #define SQL_FN_SYS_DBNAME                   0x00000002L
 861 #define SQL_FN_SYS_IFNULL                   0x00000004L
 862
 863 #define SQL_FN_TSI_FRAC_SECOND              0x00000001L
 864 #define SQL_FN_TSI_SECOND                   0x00000002L
 865 #define SQL_FN_TSI_MINUTE                   0x00000004L
 866 #define SQL_FN_TSI_HOUR                     0x00000008L
 867 #define SQL_FN_TSI_DAY                      0x00000010L
 868 #define SQL_FN_TSI_WEEK                     0x00000020L
 869 #define SQL_FN_TSI_MONTH                    0x00000040L
 870 #define SQL_FN_TSI_QUARTER                  0x00000080L
 871 #define SQL_FN_TSI_YEAR                     0x00000100L
 872
 873 #if (ODBCVER >= 0x0300)
 874 #define SQL_CA1_NEXT                                    0x00000001L
 875 #define SQL_CA1_ABSOLUTE                                0x00000002L
 876 #define SQL_CA1_RELATIVE                                0x00000004L
 877 #define SQL_CA1_BOOKMARK                                0x00000008L
 878
 879 #define SQL_CA1_LOCK_NO_CHANGE                          0x00000040L
 880 #define SQL_CA1_LOCK_EXCLUSIVE                          0x00000080L
 881 #define SQL_CA1_LOCK_UNLOCK                             0x00000100L
 882
 883 #define SQL_CA1_POS_POSITION                            0x00000200L
 884 #define SQL_CA1_POS_UPDATE                              0x00000400L
 885 #define SQL_CA1_POS_DELETE                              0x00000800L
 886 #define SQL_CA1_POS_REFRESH                             0x00001000L
 887
 888 #define SQL_CA1_POSITIONED_UPDATE                       0x00002000L
 889 #define SQL_CA1_POSITIONED_DELETE                       0x00004000L
 890 #define SQL_CA1_SELECT_FOR_UPDATE                       0x00008000L
 891
 892 #define SQL_CA1_BULK_ADD                        0x00010000L
 893 #define SQL_CA1_BULK_UPDATE_BY_BOOKMARK         0x00020000L
 894 #define SQL_CA1_BULK_DELETE_BY_BOOKMARK         0x00040000L
 895 #define SQL_CA1_BULK_FETCH_BY_BOOKMARK          0x00080000L
 896 #endif
 897
 898 #if (ODBCVER >= 0x0300)
 899 #define SQL_CA2_READ_ONLY_CONCURRENCY           0x00000001L
 900 #define SQL_CA2_LOCK_CONCURRENCY                0x00000002L
 901 #define SQL_CA2_OPT_ROWVER_CONCURRENCY          0x00000004L
 902 #define SQL_CA2_OPT_VALUES_CONCURRENCY          0x00000008L
 903
 904 #define SQL_CA2_SENSITIVITY_ADDITIONS           0x00000010L
 905 #define SQL_CA2_SENSITIVITY_DELETIONS           0x00000020L
 906 #define SQL_CA2_SENSITIVITY_UPDATES             0x00000040L
 907
 908 #define SQL_CA2_MAX_ROWS_SELECT                 0x00000080L
 909 #define SQL_CA2_MAX_ROWS_INSERT                 0x00000100L
 910 #define SQL_CA2_MAX_ROWS_DELETE                 0x00000200L
 911 #define SQL_CA2_MAX_ROWS_UPDATE                 0x00000400L
 912 #define SQL_CA2_MAX_ROWS_CATALOG                0x00000800L
 913 #define SQL_CA2_MAX_ROWS_AFFECTS_ALL            (SQL_CA2_MAX_ROWS_SELECT | SQL_CA2_MAX_ROWS_INSERT | SQL_CA2_MAX_ROWS_DELETE | SQL_CA2_MAX_ROWS_UPDATE | SQL_CA2_MAX_ROWS_CATALOG)
 914
 915 #define SQL_CA2_CRC_EXACT                       0x00001000L
 916 #define SQL_CA2_CRC_APPROXIMATE                 0x00002000L
 917
 918 #define SQL_CA2_SIMULATE_NON_UNIQUE             0x00004000L
 919 #define SQL_CA2_SIMULATE_TRY_UNIQUE             0x00008000L
 920 #define SQL_CA2_SIMULATE_UNIQUE                 0x00010000L
 921 #endif
 922
 923 #define SQL_OAC_NONE                        0x0000
 924 #define SQL_OAC_LEVEL1                      0x0001
 925 #define SQL_OAC_LEVEL2                      0x0002
 926
 927 #define SQL_OSCC_NOT_COMPLIANT              0x0000
 928 #define SQL_OSCC_COMPLIANT                  0x0001
 929
 930 #define SQL_OSC_MINIMUM                     0x0000
 931 #define SQL_OSC_CORE                        0x0001
 932 #define SQL_OSC_EXTENDED                    0x0002
 933
 934 #define SQL_CB_NULL                         0x0000
 935 #define SQL_CB_NON_NULL                     0x0001
 936
 937 #define SQL_SO_FORWARD_ONLY                 0x00000001L
 938 #define SQL_SO_KEYSET_DRIVEN                0x00000002L
 939 #define SQL_SO_DYNAMIC                      0x00000004L
 940 #define SQL_SO_MIXED                        0x00000008L
 941 #define SQL_SO_STATIC                       0x00000010L
 942
 943 #define SQL_FD_FETCH_BOOKMARK               0x00000080L
 944
 945 #define SQL_CN_NONE                         0x0000
 946 #define SQL_CN_DIFFERENT                    0x0001
 947 #define SQL_CN_ANY                          0x0002
 948
 949 #define SQL_NNC_NULL                        0x0000
 950 #define SQL_NNC_NON_NULL                    0x0001
 951
 952 #define SQL_NC_START                        0x0002
 953 #define SQL_NC_END                          0x0004
 954
 955 #define SQL_FILE_NOT_SUPPORTED              0x0000
 956 #define SQL_FILE_TABLE                      0x0001
 957 #define SQL_FILE_QUALIFIER                  0x0002
 958 #define SQL_FILE_CATALOG                SQL_FILE_QUALIFIER
 959
 960 #define SQL_GD_BLOCK                        0x00000004L
 961 #define SQL_GD_BOUND                        0x00000008L
 962
 963 #define SQL_PS_POSITIONED_DELETE            0x00000001L
 964 #define SQL_PS_POSITIONED_UPDATE            0x00000002L
 965 #define SQL_PS_SELECT_FOR_UPDATE            0x00000004L
 966
 967 #define SQL_GB_NOT_SUPPORTED                0x0000
 968 #define SQL_GB_GROUP_BY_EQUALS_SELECT       0x0001
 969 #define SQL_GB_GROUP_BY_CONTAINS_SELECT     0x0002
 970 #define SQL_GB_NO_RELATION                  0x0003
 971 #if (ODBCVER >= 0x0300)
 972 #define SQL_GB_COLLATE                  0x0004
 973
 974 #endif
 975
 976 #define SQL_OU_DML_STATEMENTS               0x00000001L
 977 #define SQL_OU_PROCEDURE_INVOCATION         0x00000002L
 978 #define SQL_OU_TABLE_DEFINITION             0x00000004L
 979 #define SQL_OU_INDEX_DEFINITION             0x00000008L
 980 #define SQL_OU_PRIVILEGE_DEFINITION         0x00000010L
 981
 982 #if (ODBCVER >= 0x0300)
 983 #define SQL_SU_DML_STATEMENTS                   SQL_OU_DML_STATEMENTS
 984 #define SQL_SU_PROCEDURE_INVOCATION             SQL_OU_PROCEDURE_INVOCATION
 985 #define SQL_SU_TABLE_DEFINITION                 SQL_OU_TABLE_DEFINITION
 986 #define SQL_SU_INDEX_DEFINITION                 SQL_OU_INDEX_DEFINITION
 987 #define SQL_SU_PRIVILEGE_DEFINITION             SQL_OU_PRIVILEGE_DEFINITION
 988 #endif
 989
 990 #define SQL_QU_DML_STATEMENTS               0x00000001L
 991 #define SQL_QU_PROCEDURE_INVOCATION         0x00000002L
 992 #define SQL_QU_TABLE_DEFINITION             0x00000004L
 993 #define SQL_QU_INDEX_DEFINITION             0x00000008L
 994 #define SQL_QU_PRIVILEGE_DEFINITION         0x00000010L
 995
 996 #if (ODBCVER >= 0x0300)
 997 #define SQL_CU_DML_STATEMENTS                   SQL_QU_DML_STATEMENTS
 998 #define SQL_CU_PROCEDURE_INVOCATION             SQL_QU_PROCEDURE_INVOCATION
 999 #define SQL_CU_TABLE_DEFINITION                 SQL_QU_TABLE_DEFINITION
1000 #define SQL_CU_INDEX_DEFINITION                 SQL_QU_INDEX_DEFINITION
1001 #define SQL_CU_PRIVILEGE_DEFINITION             SQL_QU_PRIVILEGE_DEFINITION
1002 #endif
1003
1004 #define SQL_SQ_COMPARISON                   0x00000001L
1005 #define SQL_SQ_EXISTS                       0x00000002L
1006 #define SQL_SQ_IN                           0x00000004L
1007 #define SQL_SQ_QUANTIFIED                   0x00000008L
1008 #define SQL_SQ_CORRELATED_SUBQUERIES        0x00000010L
1009
1010 #define SQL_U_UNION                         0x00000001L
1011 #define SQL_U_UNION_ALL                     0x00000002L
1012
1013 #define SQL_BP_CLOSE                        0x00000001L
1014 #define SQL_BP_DELETE                       0x00000002L
1015 #define SQL_BP_DROP                         0x00000004L
1016 #define SQL_BP_TRANSACTION                  0x00000008L
1017 #define SQL_BP_UPDATE                       0x00000010L
1018 #define SQL_BP_OTHER_HSTMT                  0x00000020L
1019 #define SQL_BP_SCROLL                       0x00000040L
1020
1021 #define SQL_SS_ADDITIONS                    0x00000001L
1022 #define SQL_SS_DELETIONS                    0x00000002L
1023 #define SQL_SS_UPDATES                      0x00000004L
1024
1025 #define SQL_CV_CREATE_VIEW                                      0x00000001L
1026 #define SQL_CV_CHECK_OPTION                                     0x00000002L
1027 #define SQL_CV_CASCADED                                         0x00000004L
1028 #define SQL_CV_LOCAL                                            0x00000008L
1029
1030 #define SQL_LCK_NO_CHANGE                   0x00000001L
1031 #define SQL_LCK_EXCLUSIVE                   0x00000002L
1032 #define SQL_LCK_UNLOCK                      0x00000004L
1033
1034 #define SQL_POS_POSITION                    0x00000001L
1035 #define SQL_POS_REFRESH                     0x00000002L
1036 #define SQL_POS_UPDATE                      0x00000004L
1037 #define SQL_POS_DELETE                      0x00000008L
1038 #define SQL_POS_ADD                         0x00000010L
1039
1040 #define SQL_QL_START                        0x0001
1041 #define SQL_QL_END                          0x0002
1042
1043 #if (ODBCVER >= 0x0300)
1044 #define SQL_AF_AVG                                              0x00000001L
1045 #define SQL_AF_COUNT                                    0x00000002L
1046 #define SQL_AF_MAX                                              0x00000004L
1047 #define SQL_AF_MIN                                              0x00000008L
1048 #define SQL_AF_SUM                                              0x00000010L
1049 #define SQL_AF_DISTINCT                                 0x00000020L
1050 #define SQL_AF_ALL                                              0x00000040L
1051
1052 #define SQL_SC_SQL92_ENTRY                              0x00000001L
1053 #define SQL_SC_FIPS127_2_TRANSITIONAL   0x00000002L
1054 #define SQL_SC_SQL92_INTERMEDIATE               0x00000004L
1055 #define SQL_SC_SQL92_FULL                               0x00000008L
1056
1057 #define SQL_DL_SQL92_DATE                                               0x00000001L
1058 #define SQL_DL_SQL92_TIME                                               0x00000002L
1059 #define SQL_DL_SQL92_TIMESTAMP                                  0x00000004L
1060 #define SQL_DL_SQL92_INTERVAL_YEAR                              0x00000008L
1061 #define SQL_DL_SQL92_INTERVAL_MONTH                             0x00000010L
1062 #define SQL_DL_SQL92_INTERVAL_DAY                               0x00000020L
1063 #define SQL_DL_SQL92_INTERVAL_HOUR                              0x00000040L
1064 #define SQL_DL_SQL92_INTERVAL_MINUTE                    0x00000080L
1065 #define SQL_DL_SQL92_INTERVAL_SECOND                    0x00000100L
1066 #define SQL_DL_SQL92_INTERVAL_YEAR_TO_MONTH             0x00000200L
1067 #define SQL_DL_SQL92_INTERVAL_DAY_TO_HOUR               0x00000400L
1068 #define SQL_DL_SQL92_INTERVAL_DAY_TO_MINUTE             0x00000800L
1069 #define SQL_DL_SQL92_INTERVAL_DAY_TO_SECOND             0x00001000L
1070 #define SQL_DL_SQL92_INTERVAL_HOUR_TO_MINUTE    0x00002000L
1071 #define SQL_DL_SQL92_INTERVAL_HOUR_TO_SECOND    0x00004000L
1072 #define SQL_DL_SQL92_INTERVAL_MINUTE_TO_SECOND  0x00008000L
1073
1074 #define SQL_CL_START                                            SQL_QL_START
1075 #define SQL_CL_END                                                      SQL_QL_END
1076
1077 #define SQL_BRC_PROCEDURES                      0x0000001
1078 #define SQL_BRC_EXPLICIT                        0x0000002
1079 #define SQL_BRC_ROLLED_UP                       0x0000004
1080
1081 #define SQL_BS_SELECT_EXPLICIT                          0x00000001L
1082 #define SQL_BS_ROW_COUNT_EXPLICIT                       0x00000002L
1083 #define SQL_BS_SELECT_PROC                                      0x00000004L
1084 #define SQL_BS_ROW_COUNT_PROC                           0x00000008L
1085
1086 #define SQL_PARC_BATCH          1
1087 #define SQL_PARC_NO_BATCH       2
1088
1089 #define SQL_PAS_BATCH                           1
1090 #define SQL_PAS_NO_BATCH                        2
1091 #define SQL_PAS_NO_SELECT                       3
1092
1093 #define SQL_IK_NONE                                                     0x00000000L
1094 #define SQL_IK_ASC                                                      0x00000001L
1095 #define SQL_IK_DESC                                                     0x00000002L
1096 #define SQL_IK_ALL                                                      (SQL_IK_ASC | SQL_IK_DESC)
1097
1098 #define SQL_ISV_ASSERTIONS                                      0x00000001L
1099 #define SQL_ISV_CHARACTER_SETS                          0x00000002L
1100 #define SQL_ISV_CHECK_CONSTRAINTS                       0x00000004L
1101 #define SQL_ISV_COLLATIONS                                      0x00000008L
1102 #define SQL_ISV_COLUMN_DOMAIN_USAGE                     0x00000010L
1103 #define SQL_ISV_COLUMN_PRIVILEGES                       0x00000020L
1104 #define SQL_ISV_COLUMNS                                         0x00000040L
1105 #define SQL_ISV_CONSTRAINT_COLUMN_USAGE         0x00000080L
1106 #define SQL_ISV_CONSTRAINT_TABLE_USAGE          0x00000100L
1107 #define SQL_ISV_DOMAIN_CONSTRAINTS                      0x00000200L
1108 #define SQL_ISV_DOMAINS                                         0x00000400L
1109 #define SQL_ISV_KEY_COLUMN_USAGE                        0x00000800L
1110 #define SQL_ISV_REFERENTIAL_CONSTRAINTS         0x00001000L
1111 #define SQL_ISV_SCHEMATA                                        0x00002000L
1112 #define SQL_ISV_SQL_LANGUAGES                           0x00004000L
1113 #define SQL_ISV_TABLE_CONSTRAINTS                       0x00008000L
1114 #define SQL_ISV_TABLE_PRIVILEGES                        0x00010000L
1115 #define SQL_ISV_TABLES                                          0x00020000L
1116 #define SQL_ISV_TRANSLATIONS                            0x00040000L
1117 #define SQL_ISV_USAGE_PRIVILEGES                        0x00080000L
1118 #define SQL_ISV_VIEW_COLUMN_USAGE                       0x00100000L
1119 #define SQL_ISV_VIEW_TABLE_USAGE                        0x00200000L
1120 #define SQL_ISV_VIEWS                                           0x00400000L
1121
1122 #define SQL_AM_NONE                     0
1123 #define SQL_AM_CONNECTION       1
1124 #define SQL_AM_STATEMENT        2
1125
1126 #define SQL_AD_CONSTRAINT_NAME_DEFINITION                       0x00000001L
1127 #define SQL_AD_ADD_DOMAIN_CONSTRAINT                            0x00000002L
1128 #define SQL_AD_DROP_DOMAIN_CONSTRAINT                           0x00000004L
1129 #define SQL_AD_ADD_DOMAIN_DEFAULT                               0x00000008L
1130 #define SQL_AD_DROP_DOMAIN_DEFAULT                              0x00000010L
1131 #define SQL_AD_ADD_CONSTRAINT_INITIALLY_DEFERRED        0x00000020L
1132 #define SQL_AD_ADD_CONSTRAINT_INITIALLY_IMMEDIATE       0x00000040L
1133 #define SQL_AD_ADD_CONSTRAINT_DEFERRABLE                        0x00000080L
1134 #define SQL_AD_ADD_CONSTRAINT_NON_DEFERRABLE            0x00000100L
1135
1136 #define SQL_CS_CREATE_SCHEMA                            0x00000001L
1137 #define SQL_CS_AUTHORIZATION                            0x00000002L
1138 #define SQL_CS_DEFAULT_CHARACTER_SET            0x00000004L
1139
1140 #define SQL_CTR_CREATE_TRANSLATION                      0x00000001L
1141
1142 #define SQL_CA_CREATE_ASSERTION                                 0x00000001L
1143 #define SQL_CA_CONSTRAINT_INITIALLY_DEFERRED    0x00000010L
1144 #define SQL_CA_CONSTRAINT_INITIALLY_IMMEDIATE   0x00000020L
1145 #define SQL_CA_CONSTRAINT_DEFERRABLE                    0x00000040L
1146 #define SQL_CA_CONSTRAINT_NON_DEFERRABLE                0x00000080L
1147
1148 #define SQL_CCS_CREATE_CHARACTER_SET            0x00000001L
1149 #define SQL_CCS_COLLATE_CLAUSE                          0x00000002L
1150 #define SQL_CCS_LIMITED_COLLATION                       0x00000004L
1151
1152 #define SQL_CCOL_CREATE_COLLATION                       0x00000001L
1153
1154 #define SQL_CDO_CREATE_DOMAIN                                   0x00000001L
1155 #define SQL_CDO_DEFAULT                                                 0x00000002L
1156 #define SQL_CDO_CONSTRAINT                                              0x00000004L
1157 #define SQL_CDO_COLLATION                                               0x00000008L
1158 #define SQL_CDO_CONSTRAINT_NAME_DEFINITION              0x00000010L
1159 #define SQL_CDO_CONSTRAINT_INITIALLY_DEFERRED   0x00000020L
1160 #define SQL_CDO_CONSTRAINT_INITIALLY_IMMEDIATE  0x00000040L
1161 #define SQL_CDO_CONSTRAINT_DEFERRABLE                   0x00000080L
1162 #define SQL_CDO_CONSTRAINT_NON_DEFERRABLE               0x00000100L
1163
1164 #define SQL_CT_CREATE_TABLE                                             0x00000001L
1165 #define SQL_CT_COMMIT_PRESERVE                                  0x00000002L
1166 #define SQL_CT_COMMIT_DELETE                                    0x00000004L
1167 #define SQL_CT_GLOBAL_TEMPORARY                                 0x00000008L
1168 #define SQL_CT_LOCAL_TEMPORARY                                  0x00000010L
1169 #define SQL_CT_CONSTRAINT_INITIALLY_DEFERRED    0x00000020L
1170 #define SQL_CT_CONSTRAINT_INITIALLY_IMMEDIATE   0x00000040L
1171 #define SQL_CT_CONSTRAINT_DEFERRABLE                    0x00000080L
1172 #define SQL_CT_CONSTRAINT_NON_DEFERRABLE                0x00000100L
1173 #define SQL_CT_COLUMN_CONSTRAINT                                0x00000200L
1174 #define SQL_CT_COLUMN_DEFAULT                                   0x00000400L
1175 #define SQL_CT_COLUMN_COLLATION                                 0x00000800L
1176 #define SQL_CT_TABLE_CONSTRAINT                                 0x00001000L
1177 #define SQL_CT_CONSTRAINT_NAME_DEFINITION               0x00002000L
1178
1179 #define SQL_DI_CREATE_INDEX                                             0x00000001L
1180 #define SQL_DI_DROP_INDEX                                               0x00000002L
1181
1182 #define SQL_DC_DROP_COLLATION                                   0x00000001L
1183
1184 #define SQL_DD_DROP_DOMAIN                                              0x00000001L
1185 #define SQL_DD_RESTRICT                                                 0x00000002L
1186 #define SQL_DD_CASCADE                                                  0x00000004L
1187
1188 #define SQL_DS_DROP_SCHEMA                                              0x00000001L
1189 #define SQL_DS_RESTRICT                                                 0x00000002L
1190 #define SQL_DS_CASCADE                                                  0x00000004L
1191
1192 #define SQL_DCS_DROP_CHARACTER_SET                              0x00000001L
1193
1194 #define SQL_DA_DROP_ASSERTION                                   0x00000001L
1195
1196 #define SQL_DT_DROP_TABLE                                               0x00000001L
1197 #define SQL_DT_RESTRICT                                                 0x00000002L
1198 #define SQL_DT_CASCADE                                                  0x00000004L
1199
1200 #define SQL_DTR_DROP_TRANSLATION                                0x00000001L
1201
1202 #define SQL_DV_DROP_VIEW                                                0x00000001L
1203 #define SQL_DV_RESTRICT                                                 0x00000002L
1204 #define SQL_DV_CASCADE                                                  0x00000004L
1205
1206 #define SQL_IS_INSERT_LITERALS                                  0x00000001L
1207 #define SQL_IS_INSERT_SEARCHED                                  0x00000002L
1208 #define SQL_IS_SELECT_INTO                                              0x00000004L
1209
1210 #define SQL_OIC_CORE                                                    1UL
1211 #define SQL_OIC_LEVEL1                                                  2UL
1212 #define SQL_OIC_LEVEL2                                                  3UL
1213
1214 #define SQL_SFKD_CASCADE                                                0x00000001L
1215 #define SQL_SFKD_NO_ACTION                                              0x00000002L
1216 #define SQL_SFKD_SET_DEFAULT                                    0x00000004L
1217 #define SQL_SFKD_SET_NULL                                               0x00000008L
1218
1219 #define SQL_SFKU_CASCADE                                                0x00000001L
1220 #define SQL_SFKU_NO_ACTION                                              0x00000002L
1221 #define SQL_SFKU_SET_DEFAULT                                    0x00000004L
1222 #define SQL_SFKU_SET_NULL                                               0x00000008L
1223
1224 #define SQL_SG_USAGE_ON_DOMAIN                                  0x00000001L
1225 #define SQL_SG_USAGE_ON_CHARACTER_SET                   0x00000002L
1226 #define SQL_SG_USAGE_ON_COLLATION                               0x00000004L
1227 #define SQL_SG_USAGE_ON_TRANSLATION                             0x00000008L
1228 #define SQL_SG_WITH_GRANT_OPTION                                0x00000010L
1229 #define SQL_SG_DELETE_TABLE                                             0x00000020L
1230 #define SQL_SG_INSERT_TABLE                                             0x00000040L
1231 #define SQL_SG_INSERT_COLUMN                                    0x00000080L
1232 #define SQL_SG_REFERENCES_TABLE                                 0x00000100L
1233 #define SQL_SG_REFERENCES_COLUMN                                0x00000200L
1234 #define SQL_SG_SELECT_TABLE                                             0x00000400L
1235 #define SQL_SG_UPDATE_TABLE                                             0x00000800L
1236 #define SQL_SG_UPDATE_COLUMN                                    0x00001000L
1237
1238 #define SQL_SP_EXISTS                                                   0x00000001L
1239 #define SQL_SP_ISNOTNULL                                                0x00000002L
1240 #define SQL_SP_ISNULL                                                   0x00000004L
1241 #define SQL_SP_MATCH_FULL                                               0x00000008L
1242 #define SQL_SP_MATCH_PARTIAL                                    0x00000010L
1243 #define SQL_SP_MATCH_UNIQUE_FULL                                0x00000020L
1244 #define SQL_SP_MATCH_UNIQUE_PARTIAL                             0x00000040L
1245 #define SQL_SP_OVERLAPS                                                 0x00000080L
1246 #define SQL_SP_UNIQUE                                                   0x00000100L
1247 #define SQL_SP_LIKE                                                             0x00000200L
1248 #define SQL_SP_IN                                                               0x00000400L
1249 #define SQL_SP_BETWEEN                                                  0x00000800L
1250 #define SQL_SP_COMPARISON                                               0x00001000L
1251 #define SQL_SP_QUANTIFIED_COMPARISON                    0x00002000L
1252
1253 #define SQL_SRJO_CORRESPONDING_CLAUSE                   0x00000001L
1254 #define SQL_SRJO_CROSS_JOIN                                             0x00000002L
1255 #define SQL_SRJO_EXCEPT_JOIN                                    0x00000004L
1256 #define SQL_SRJO_FULL_OUTER_JOIN                                0x00000008L
1257 #define SQL_SRJO_INNER_JOIN                                             0x00000010L
1258 #define SQL_SRJO_INTERSECT_JOIN                                 0x00000020L
1259 #define SQL_SRJO_LEFT_OUTER_JOIN                                0x00000040L
1260 #define SQL_SRJO_NATURAL_JOIN                                   0x00000080L
1261 #define SQL_SRJO_RIGHT_OUTER_JOIN                               0x00000100L
1262 #define SQL_SRJO_UNION_JOIN                                             0x00000200L
1263
1264 #define SQL_SR_USAGE_ON_DOMAIN                                  0x00000001L
1265 #define SQL_SR_USAGE_ON_CHARACTER_SET                   0x00000002L
1266 #define SQL_SR_USAGE_ON_COLLATION                               0x00000004L
1267 #define SQL_SR_USAGE_ON_TRANSLATION                             0x00000008L
1268 #define SQL_SR_GRANT_OPTION_FOR                                 0x00000010L
1269 #define SQL_SR_CASCADE                                                  0x00000020L
1270 #define SQL_SR_RESTRICT                                                 0x00000040L
1271 #define SQL_SR_DELETE_TABLE                                             0x00000080L
1272 #define SQL_SR_INSERT_TABLE                                             0x00000100L
1273 #define SQL_SR_INSERT_COLUMN                                    0x00000200L
1274 #define SQL_SR_REFERENCES_TABLE                                 0x00000400L
1275 #define SQL_SR_REFERENCES_COLUMN                                0x00000800L
1276 #define SQL_SR_SELECT_TABLE                                             0x00001000L
1277 #define SQL_SR_UPDATE_TABLE                                             0x00002000L
1278 #define SQL_SR_UPDATE_COLUMN                                    0x00004000L
1279
1280 #define SQL_SRVC_VALUE_EXPRESSION                               0x00000001L
1281 #define SQL_SRVC_NULL                                                   0x00000002L
1282 #define SQL_SRVC_DEFAULT                                                0x00000004L
1283 #define SQL_SRVC_ROW_SUBQUERY                                   0x00000008L
1284
1285 #define SQL_SVE_CASE                                                    0x00000001L
1286 #define SQL_SVE_CAST                                                    0x00000002L
1287 #define SQL_SVE_COALESCE                                                0x00000004L
1288 #define SQL_SVE_NULLIF                                                  0x00000008L
1289
1290 #define SQL_SCC_XOPEN_CLI_VERSION1                              0x00000001L
1291 #define SQL_SCC_ISO92_CLI                                               0x00000002L
1292
1293 #define SQL_US_UNION                                                    SQL_U_UNION
1294 #define SQL_US_UNION_ALL                                                SQL_U_UNION_ALL
1295
1296 #endif
1297
1298 #define SQL_DTC_ENLIST_EXPENSIVE                                0x00000001L
1299 #define SQL_DTC_UNENLIST_EXPENSIVE                              0x00000002L
1300
1301 #if (ODBCVER >= 0x0300)
1302 #define SQL_FETCH_FIRST_USER                            31
1303 #define SQL_FETCH_FIRST_SYSTEM                          32
1304 #endif
1305
1306 #define SQL_ENTIRE_ROWSET            0
1307
1308 #define SQL_POSITION                 0
1309 #define SQL_REFRESH                  1
1310 #define SQL_UPDATE                   2
1311 #define SQL_DELETE                   3
1312
1313 #define SQL_ADD                      4
1314 #define SQL_SETPOS_MAX_OPTION_VALUE                     SQL_ADD
1315 #if (ODBCVER >= 0x0300)
1316 #define SQL_UPDATE_BY_BOOKMARK           5
1317 #define SQL_DELETE_BY_BOOKMARK           6
1318 #define SQL_FETCH_BY_BOOKMARK            7
1319
1320 #endif
1321
1322 #define SQL_LOCK_NO_CHANGE           0
1323 #define SQL_LOCK_EXCLUSIVE           1
1324 #define SQL_LOCK_UNLOCK              2
1325
1326 #define SQL_SETPOS_MAX_LOCK_VALUE               SQL_LOCK_UNLOCK
1327
1328 #define SQL_POSITION_TO(hstmt,irow) SQLSetPos(hstmt,irow,SQL_POSITION,SQL_LOCK_NO_CHANGE)
1329 #define SQL_LOCK_RECORD(hstmt,irow,fLock) SQLSetPos(hstmt,irow,SQL_POSITION,fLock)
1330 #define SQL_REFRESH_RECORD(hstmt,irow,fLock) SQLSetPos(hstmt,irow,SQL_REFRESH,fLock)
1331 #define SQL_UPDATE_RECORD(hstmt,irow) SQLSetPos(hstmt,irow,SQL_UPDATE,SQL_LOCK_NO_CHANGE)
1332 #define SQL_DELETE_RECORD(hstmt,irow) SQLSetPos(hstmt,irow,SQL_DELETE,SQL_LOCK_NO_CHANGE)
1333 #define SQL_ADD_RECORD(hstmt,irow) SQLSetPos(hstmt,irow,SQL_ADD,SQL_LOCK_NO_CHANGE)
1334
1335 #define SQL_BEST_ROWID                  1
1336 #define SQL_ROWVER                      2
1337
1338 #define SQL_PC_NOT_PSEUDO               1
1339
1340 #define SQL_QUICK                       0
1341 #define SQL_ENSURE                      1
1342
1343 #define SQL_TABLE_STAT                  0
1344
1345 #if (ODBCVER >= 0x0300)
1346 #define SQL_ALL_CATALOGS                                "%"
1347 #define SQL_ALL_SCHEMAS                                 "%"
1348 #define SQL_ALL_TABLE_TYPES                             "%"
1349 #endif  /* ODBCVER >= 0x0300 */
1350
1351 #define SQL_DRIVER_NOPROMPT             0
1352 #define SQL_DRIVER_COMPLETE             1
1353 #define SQL_DRIVER_PROMPT               2
1354 #define SQL_DRIVER_COMPLETE_REQUIRED    3
1355
1356 SQLRETURN WINAPI  SQLDriverConnect(
1357     SQLHDBC            hdbc,
1358     SQLHWND            hwnd,
1359     SQLCHAR               *szConnStrIn,
1360     SQLSMALLINT        cbConnStrIn,
1361     SQLCHAR           *szConnStrOut,
1362     SQLSMALLINT        cbConnStrOutMax,
1363     SQLSMALLINT           *pcbConnStrOut,
1364     SQLUSMALLINT       fDriverCompletion);
1365
1366 #define SQL_FETCH_BOOKMARK               8
1367
1368 #define SQL_ROW_SUCCESS                  0
1369 #define SQL_ROW_DELETED                  1
1370 #define SQL_ROW_UPDATED                  2
1371 #define SQL_ROW_NOROW                    3
1372 #define SQL_ROW_ADDED                    4
1373 #define SQL_ROW_ERROR                    5
1374 #if (ODBCVER >= 0x0300)
1375 #define SQL_ROW_SUCCESS_WITH_INFO                6
1376 #define SQL_ROW_PROCEED                                  0
1377 #define SQL_ROW_IGNORE                                   1
1378 #endif
1379
1380 #if (ODBCVER >= 0x0300)
1381 #define SQL_PARAM_SUCCESS                               0
1382 #define SQL_PARAM_SUCCESS_WITH_INFO             6
1383 #define SQL_PARAM_ERROR                                 5
1384 #define SQL_PARAM_UNUSED                                7
1385 #define SQL_PARAM_DIAG_UNAVAILABLE              1
1386
1387 #define SQL_PARAM_PROCEED                               0
1388 #define SQL_PARAM_IGNORE                                1
1389 #endif
1390
1391 #define SQL_CASCADE                      0
1392 #define SQL_RESTRICT                     1
1393 #define SQL_SET_NULL                     2
1394 #if (ODBCVER >= 0x0250)
1395 #define SQL_NO_ACTION                    3
1396 #define SQL_SET_DEFAULT                  4
1397 #endif
1398
1399 #if (ODBCVER >= 0x0300)
1400
1401 #define SQL_INITIALLY_DEFERRED                  5
1402 #define SQL_INITIALLY_IMMEDIATE                 6
1403 #define SQL_NOT_DEFERRABLE                      7
1404
1405 #endif
1406
1407 #define SQL_PARAM_TYPE_UNKNOWN           0
1408 #define SQL_PARAM_INPUT                  1
1409 #define SQL_PARAM_INPUT_OUTPUT           2
1410 #define SQL_RESULT_COL                   3
1411 #define SQL_PARAM_OUTPUT                 4
1412 #define SQL_RETURN_VALUE                 5
1413
1414 #define SQL_PT_UNKNOWN                   0
1415 #define SQL_PT_PROCEDURE                 1
1416 #define SQL_PT_FUNCTION                  2
1417
1418 #define SQL_ODBC_KEYWORDS "ABSOLUTE,ACTION,ADA,ADD,ALL,ALLOCATE,ALTER,AND,ANY,ARE,AS,"
1419
1420 SQLRETURN WINAPI  SQLBrowseConnect(
1421     SQLHDBC            hdbc,
1422     SQLCHAR               *szConnStrIn,
1423     SQLSMALLINT        cbConnStrIn,
1424     SQLCHAR               *szConnStrOut,
1425     SQLSMALLINT        cbConnStrOutMax,
1426     SQLSMALLINT       *pcbConnStrOut);
1427
1428 #if (ODBCVER >= 0x0300)
1429 SQLRETURN WINAPI        SQLBulkOperations(
1430         SQLHSTMT                        StatementHandle,
1431         SQLSMALLINT                     Operation);
1432 #endif
1433
1434 SQLRETURN WINAPI  SQLColAttributes(
1435     SQLHSTMT           hstmt,
1436     SQLUSMALLINT       icol,
1437     SQLUSMALLINT       fDescType,
1438     SQLPOINTER         rgbDesc,
1439     SQLSMALLINT        cbDescMax,
1440     SQLSMALLINT           *pcbDesc,
1441     SQLINTEGER            *pfDesc);
1442
1443 SQLRETURN WINAPI  SQLColumnPrivileges(
1444     SQLHSTMT           hstmt,
1445     SQLCHAR               *szCatalogName,
1446     SQLSMALLINT        cbCatalogName,
1447     SQLCHAR               *szSchemaName,
1448     SQLSMALLINT        cbSchemaName,
1449     SQLCHAR               *szTableName,
1450     SQLSMALLINT        cbTableName,
1451     SQLCHAR               *szColumnName,
1452     SQLSMALLINT        cbColumnName);
1453
1454 SQLRETURN WINAPI  SQLDescribeParam(
1455     SQLHSTMT           hstmt,
1456     SQLUSMALLINT       ipar,
1457     SQLSMALLINT           *pfSqlType,
1458     SQLUINTEGER           *pcbParamDef,
1459     SQLSMALLINT           *pibScale,
1460     SQLSMALLINT           *pfNullable);
1461
1462 SQLRETURN WINAPI  SQLExtendedFetch(
1463     SQLHSTMT           hstmt,
1464     SQLUSMALLINT       fFetchType,
1465     SQLINTEGER         irow,
1466     SQLUINTEGER           *pcrow,
1467     SQLUSMALLINT          *rgfRowStatus);
1468
1469 SQLRETURN WINAPI  SQLForeignKeys(
1470     SQLHSTMT           hstmt,
1471     SQLCHAR               *szPkCatalogName,
1472     SQLSMALLINT        cbPkCatalogName,
1473     SQLCHAR               *szPkSchemaName,
1474     SQLSMALLINT        cbPkSchemaName,
1475     SQLCHAR               *szPkTableName,
1476     SQLSMALLINT        cbPkTableName,
1477     SQLCHAR               *szFkCatalogName,
1478     SQLSMALLINT        cbFkCatalogName,
1479     SQLCHAR               *szFkSchemaName,
1480     SQLSMALLINT        cbFkSchemaName,
1481     SQLCHAR               *szFkTableName,
1482     SQLSMALLINT        cbFkTableName);
1483
1484 SQLRETURN WINAPI  SQLMoreResults(
1485     SQLHSTMT           hstmt);
1486
1487 SQLRETURN WINAPI  SQLNativeSql(
1488     SQLHDBC            hdbc,
1489     SQLCHAR               *szSqlStrIn,
1490     SQLINTEGER         cbSqlStrIn,
1491     SQLCHAR               *szSqlStr,
1492     SQLINTEGER         cbSqlStrMax,
1493     SQLINTEGER            *pcbSqlStr);
1494
1495 SQLRETURN WINAPI  SQLNumParams(
1496     SQLHSTMT           hstmt,
1497     SQLSMALLINT           *pcpar);
1498
1499 SQLRETURN WINAPI  SQLParamOptions(
1500     SQLHSTMT           hstmt,
1501     SQLUINTEGER        crow,
1502     SQLUINTEGER           *pirow);
1503
1504 SQLRETURN WINAPI  SQLPrimaryKeys(
1505     SQLHSTMT           hstmt,
1506     SQLCHAR               *szCatalogName,
1507     SQLSMALLINT        cbCatalogName,
1508     SQLCHAR               *szSchemaName,
1509     SQLSMALLINT        cbSchemaName,
1510     SQLCHAR               *szTableName,
1511     SQLSMALLINT        cbTableName);
1512
1513 SQLRETURN WINAPI  SQLProcedureColumns(
1514     SQLHSTMT           hstmt,
1515     SQLCHAR               *szCatalogName,
1516     SQLSMALLINT        cbCatalogName,
1517     SQLCHAR               *szSchemaName,
1518     SQLSMALLINT        cbSchemaName,
1519     SQLCHAR               *szProcName,
1520     SQLSMALLINT        cbProcName,
1521     SQLCHAR               *szColumnName,
1522     SQLSMALLINT        cbColumnName);
1523
1524 SQLRETURN WINAPI  SQLProcedures(
1525     SQLHSTMT           hstmt,
1526     SQLCHAR               *szCatalogName,
1527     SQLSMALLINT        cbCatalogName,
1528     SQLCHAR               *szSchemaName,
1529     SQLSMALLINT        cbSchemaName,
1530     SQLCHAR               *szProcName,
1531     SQLSMALLINT        cbProcName);
1532
1533 SQLRETURN WINAPI  SQLSetPos(
1534     SQLHSTMT           hstmt,
1535     SQLUSMALLINT       irow,
1536     SQLUSMALLINT       fOption,
1537     SQLUSMALLINT       fLock);
1538
1539 SQLRETURN WINAPI  SQLTablePrivileges(
1540     SQLHSTMT           hstmt,
1541     SQLCHAR               *szCatalogName,
1542     SQLSMALLINT        cbCatalogName,
1543     SQLCHAR               *szSchemaName,
1544     SQLSMALLINT        cbSchemaName,
1545     SQLCHAR               *szTableName,
1546     SQLSMALLINT        cbTableName);
1547
1548 SQLRETURN WINAPI  SQLDrivers(
1549     SQLHENV            henv,
1550     SQLUSMALLINT       fDirection,
1551     SQLCHAR               *szDriverDesc,
1552     SQLSMALLINT        cbDriverDescMax,
1553     SQLSMALLINT           *pcbDriverDesc,
1554     SQLCHAR               *szDriverAttributes,
1555     SQLSMALLINT        cbDrvrAttrMax,
1556     SQLSMALLINT           *pcbDrvrAttr);
1557
1558 SQLRETURN WINAPI  SQLBindParameter(
1559     SQLHSTMT           hstmt,
1560     SQLUSMALLINT       ipar,
1561     SQLSMALLINT        fParamType,
1562     SQLSMALLINT        fCType,
1563     SQLSMALLINT        fSqlType,
1564     SQLUINTEGER        cbColDef,
1565     SQLSMALLINT        ibScale,
1566     SQLPOINTER         rgbValue,
1567     SQLINTEGER         cbValueMax,
1568     SQLINTEGER            *pcbValue);
1569
1570 #ifdef ODBC_STD
1571 #define SQLAllocHandle  SQLAllocHandleStd
1572 #define SQLAllocEnv(phenv)  SQLAllocHandleStd(SQL_HANDLE_ENV, SQL_NULL_HANDLE, phenv)
1573
1574 #define SQL_YEAR                                                SQL_CODE_YEAR
1575 #define SQL_MONTH                                               SQL_CODE_MONTH
1576 #define SQL_DAY                                                 SQL_CODE_DAY
1577 #define SQL_HOUR                                                SQL_CODE_HOUR
1578 #define SQL_MINUTE                                              SQL_CODE_MINUTE
1579 #define SQL_SECOND                                              SQL_CODE_SECOND
1580 #define SQL_YEAR_TO_MONTH                               SQL_CODE_YEAR_TO_MONTH
1581 #define SQL_DAY_TO_HOUR                                 SQL_CODE_DAY_TO_HOUR
1582 #define SQL_DAY_TO_MINUTE                               SQL_CODE_DAY_TO_MINUTE
1583 #define SQL_DAY_TO_SECOND                               SQL_CODE_DAY_TO_SECOND
1584 #define SQL_HOUR_TO_MINUTE                              SQL_CODE_HOUR_TO_MINUTE
1585 #define SQL_HOUR_TO_SECOND                              SQL_CODE_HOUR_TO_SECOND
1586 #define SQL_MINUTE_TO_SECOND                    SQL_CODE_MINUTE_TO_SECOND
1587 #endif
1588
1589 #if (ODBCVER >= 0x0300)
1590 SQLRETURN WINAPI  SQLAllocHandleStd(
1591         SQLSMALLINT             fHandleType,
1592         SQLHANDLE               hInput,
1593         SQLHANDLE          *phOutput);
1594 #endif
1595
1596 #define SQL_DATABASE_NAME               16
1597 #define SQL_FD_FETCH_PREV               SQL_FD_FETCH_PRIOR
1598 #define SQL_FETCH_PREV                  SQL_FETCH_PRIOR
1599 #define SQL_CONCUR_TIMESTAMP            SQL_CONCUR_ROWVER
1600 #define SQL_SCCO_OPT_TIMESTAMP          SQL_SCCO_OPT_ROWVER
1601 #define SQL_CC_DELETE                   SQL_CB_DELETE
1602 #define SQL_CR_DELETE                   SQL_CB_DELETE
1603 #define SQL_CC_CLOSE                    SQL_CB_CLOSE
1604 #define SQL_CR_CLOSE                    SQL_CB_CLOSE
1605 #define SQL_CC_PRESERVE                 SQL_CB_PRESERVE
1606 #define SQL_CR_PRESERVE                 SQL_CB_PRESERVE
1607 #define SQL_SCROLL_FORWARD_ONLY         0L
1608 #define SQL_SCROLL_KEYSET_DRIVEN        (-1L)
1609 #define SQL_SCROLL_DYNAMIC              (-2L)
1610 #define SQL_SCROLL_STATIC               (-3L)
1611
1612 SQLRETURN WINAPI  SQLSetScrollOptions(
1613     SQLHSTMT           hstmt,
1614     SQLUSMALLINT       fConcurrency,
1615     SQLINTEGER         crowKeyset,
1616     SQLUSMALLINT       crowRowset);
1617
1618 #define         TRACE_VERSION   1000
1619
1620 RETCODE  TraceOpenLogFile(LPWSTR,LPWSTR,DWORD);
1621 RETCODE  TraceCloseLogFile();
1622 VOID     TraceReturn(RETCODE,RETCODE);
1623 DWORD    TraceVersion();
1624
1625 /*#define TRACE_ON              0x00000001L*/
1626 #define TRACE_VS_EVENT_ON       0x00000002L
1627
1628 RETCODE TraceVSControl(DWORD);
1629
1630 #define ODBC_VS_FLAG_UNICODE_ARG        0x00000001L
1631 #define ODBC_VS_FLAG_UNICODE_COR        0x00000002L
1632 #define ODBC_VS_FLAG_RETCODE            0x00000004L
1633 #define ODBC_VS_FLAG_STOP               0x00000008L
1634
1635 typedef struct tagODBC_VS_ARGS {
1636         const GUID      *pguidEvent;
1637         DWORD   dwFlags;
1638         union {
1639                 WCHAR   *wszArg;
1640                 CHAR    *szArg;
1641         } DUMMYUNIONNAME1;
1642         union {
1643                 WCHAR   *wszCorrelation;
1644                 CHAR    *szCorrelation;
1645         } DUMMYUNIONNAME2;
1646         RETCODE RetCode;
1647 } ODBC_VS_ARGS, *PODBC_VS_ARGS;
1648
1649 VOID    FireVSDebugEvent(PODBC_VS_ARGS);
1650
1651
1652 #ifdef __cplusplus
1653 }
1654 #endif
1655
1656 #endif