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