1/*****************************************************
2 * sqlext.h
3 *
4 * These should be consistent with the MS version.
5 *
6 *****************************************************/
7#ifndef __SQLEXT_H
8#define __SQLEXT_H
9
10
11/* BEGIN - unixODBC ONLY (programs like ODBCConfig and DataManager use these) */
12
13/* COLUMNS IN SQLTables() RESULT SET */
14#define SQLTables_TABLE_CATALOG 1
15#define SQLTables_TABLE_SCHEM 2
16#define SQLTables_TABLE_NAME 3
17#define SQLTables_TABLE_TYPE 4
18#define SQLTables_REMARKS 5
19
20/* COLUMNS IN SQLColumns() RESULT SET */
21#define SQLColumns_TABLE_CAT 1
22#define SQLColumns_TABLE_SCHEM 2
23#define SQLColumns_TABLE_NAME 3
24#define SQLColumns_COLUMN_NAME 4
25#define SQLColumns_DATA_TYPE 5
26#define SQLColumns_TYPE_NAME 6
27#define SQLColumns_COLUMN_SIZE 7
28#define SQLColumns_BUFFER_LENGTH 8
29#define SQLColumns_DECIMAL_DIGITS 9
30#define SQLColumns_NUM_PREC_RADIX 10
31#define SQLColumns_NULLABLE 11
32#define SQLColumns_REMARKS 12
33#define SQLColumns_COLUMN_DEF 13
34#define SQLColumns_SQL_DATA_TYPE 14
35#define SQLColumns_SQL_DATETIME_SUB 15
36#define SQLColumns_CHAR_OCTET_LENGTH 16
37#define SQLColumns_ORDINAL_POSITION 17
38#define SQLColumns_IS_NULLABLE 18
39
40/* END - unixODBC ONLY */
41
42#ifndef __SQL_H
43#include "sql.h"
44#endif
45
46#ifdef __cplusplus
47extern "C" { /* Assume C declarations for C++ */
48#endif
49
50/* generally useful constants */
51#define SQL_SPEC_MAJOR 3 /* Major version of specification */
52#define SQL_SPEC_MINOR 52 /* Minor version of specification */
53#define SQL_SPEC_STRING "03.52" /* String constant for version */
54
55#define SQL_SQLSTATE_SIZE 5 /* size of SQLSTATE */
56#define SQL_MAX_DSN_LENGTH 32 /* maximum data source name size */
57
58#define SQL_MAX_OPTION_STRING_LENGTH 256
59
60/* return code SQL_NO_DATA_FOUND is the same as SQL_NO_DATA */
61#if (ODBCVER < 0x0300)
62#define SQL_NO_DATA_FOUND 100
63#else
64#define SQL_NO_DATA_FOUND SQL_NO_DATA
65#endif
66
67/* an end handle type */
68#if (ODBCVER >= 0x0300)
69#define SQL_HANDLE_SENV 5
70#endif /* ODBCVER >= 0x0300 */
71
72/* env attribute */
73#if (ODBCVER >= 0x0300)
74#define SQL_ATTR_ODBC_VERSION 200
75#define SQL_ATTR_CONNECTION_POOLING 201
76#define SQL_ATTR_CP_MATCH 202
77
78/* unixODBC additions */
79#define SQL_ATTR_UNIXODBC_SYSPATH 65001
80#define SQL_ATTR_UNIXODBC_VERSION 65002
81#define SQL_ATTR_UNIXODBC_ENVATTR 65003
82#endif /* ODBCVER >= 0x0300 */
83
84#if (ODBCVER >= 0x0300)
85/* values for SQL_ATTR_CONNECTION_POOLING */
86#define SQL_CP_OFF 0UL
87#define SQL_CP_ONE_PER_DRIVER 1UL
88#define SQL_CP_ONE_PER_HENV 2UL
89#define SQL_CP_DEFAULT SQL_CP_OFF
90
91/* values for SQL_ATTR_CP_MATCH */
92#define SQL_CP_STRICT_MATCH 0UL
93#define SQL_CP_RELAXED_MATCH 1UL
94#define SQL_CP_MATCH_DEFAULT SQL_CP_STRICT_MATCH
95
96/* values for SQL_ATTR_ODBC_VERSION */
97#define SQL_OV_ODBC2 2UL
98#define SQL_OV_ODBC3 3UL
99#endif /* ODBCVER >= 0x0300 */
100
101#if (ODBCVER >= 0x0380)
102/* new values for SQL_ATTR_ODBC_VERSION */
103/* From ODBC 3.8 onwards, we should use <major version> * 100 + <minor version> */
104#define SQL_OV_ODBC3_80 380UL
105#endif /* ODBCVER >= 0x0380 */
106
107/* connection attributes */
108#define SQL_ACCESS_MODE 101
109#define SQL_AUTOCOMMIT 102
110#define SQL_LOGIN_TIMEOUT 103
111#define SQL_OPT_TRACE 104
112#define SQL_OPT_TRACEFILE 105
113#define SQL_TRANSLATE_DLL 106
114#define SQL_TRANSLATE_OPTION 107
115#define SQL_TXN_ISOLATION 108
116#define SQL_CURRENT_QUALIFIER 109
117#define SQL_ODBC_CURSORS 110
118#define SQL_QUIET_MODE 111
119#define SQL_PACKET_SIZE 112
120
121/* connection attributes with new names */
122#if (ODBCVER >= 0x0300)
123#define SQL_ATTR_ACCESS_MODE SQL_ACCESS_MODE
124#define SQL_ATTR_AUTOCOMMIT SQL_AUTOCOMMIT
125#define SQL_ATTR_CONNECTION_TIMEOUT 113
126#define SQL_ATTR_CURRENT_CATALOG SQL_CURRENT_QUALIFIER
127#define SQL_ATTR_DISCONNECT_BEHAVIOR 114
128#define SQL_ATTR_ENLIST_IN_DTC 1207
129#define SQL_ATTR_ENLIST_IN_XA 1208
130#define SQL_ATTR_LOGIN_TIMEOUT SQL_LOGIN_TIMEOUT
131#define SQL_ATTR_ODBC_CURSORS SQL_ODBC_CURSORS
132#define SQL_ATTR_PACKET_SIZE SQL_PACKET_SIZE
133#define SQL_ATTR_QUIET_MODE SQL_QUIET_MODE
134#define SQL_ATTR_TRACE SQL_OPT_TRACE
135#define SQL_ATTR_TRACEFILE SQL_OPT_TRACEFILE
136#define SQL_ATTR_TRANSLATE_LIB SQL_TRANSLATE_DLL
137#define SQL_ATTR_TRANSLATE_OPTION SQL_TRANSLATE_OPTION
138#define SQL_ATTR_TXN_ISOLATION SQL_TXN_ISOLATION
139#endif /* ODBCVER >= 0x0300 */
140
141#define SQL_ATTR_CONNECTION_DEAD 1209 /* GetConnectAttr only */
142
143#define SQL_ATTR_DRIVER_THREADING 1028 /* Driver threading level */
144
145#if (ODBCVER >= 0x0351)
146/* ODBC Driver Manager sets this connection attribute to a unicode driver
147 (which supports SQLConnectW) when the application is an ANSI application
148 (which calls SQLConnect, SQLDriverConnect, or SQLBrowseConnect).
149 This is SetConnectAttr only and application does not set this attribute
150 This attribute was introduced because some unicode driver's some APIs may
151 need to behave differently on ANSI or Unicode applications. A unicode
152 driver, which has same behavior for both ANSI or Unicode applications,
153 should return SQL_ERROR when the driver manager sets this connection
154 attribute. When a unicode driver returns SQL_SUCCESS on this attribute,
155 the driver manager treates ANSI and Unicode connections differently in
156 connection pooling.
157*/
158#define SQL_ATTR_ANSI_APP 115
159#endif
160
161#if (ODBCVER >= 0x0380)
162#define SQL_ATTR_RESET_CONNECTION 116
163#define SQL_ATTR_ASYNC_DBC_FUNCTIONS_ENABLE 117
164#endif
165
166/* SQL_CONNECT_OPT_DRVR_START is not meaningful for 3.0 driver */
167#if (ODBCVER < 0x0300)
168#define SQL_CONNECT_OPT_DRVR_START 1000
169#endif /* ODBCVER < 0x0300 */
170
171#if (ODBCVER < 0x0300)
172#define SQL_CONN_OPT_MAX SQL_PACKET_SIZE
173#define SQL_CONN_OPT_MIN SQL_ACCESS_MODE
174#endif /* ODBCVER < 0x0300 */
175
176/* SQL_ACCESS_MODE options */
177#define SQL_MODE_READ_WRITE 0UL
178#define SQL_MODE_READ_ONLY 1UL
179#define SQL_MODE_DEFAULT SQL_MODE_READ_WRITE
180
181/* SQL_AUTOCOMMIT options */
182#define SQL_AUTOCOMMIT_OFF 0UL
183#define SQL_AUTOCOMMIT_ON 1UL
184#define SQL_AUTOCOMMIT_DEFAULT SQL_AUTOCOMMIT_ON
185
186/* SQL_LOGIN_TIMEOUT options */
187#define SQL_LOGIN_TIMEOUT_DEFAULT 15UL
188
189/* SQL_OPT_TRACE options */
190#define SQL_OPT_TRACE_OFF 0UL
191#define SQL_OPT_TRACE_ON 1UL
192#define SQL_OPT_TRACE_DEFAULT SQL_OPT_TRACE_OFF
193#ifdef _WINDOWS_
194#define SQL_OPT_TRACE_FILE_DEFAULT "\\temp\\SQL.LOG"
195#else
196#define SQL_OPT_TRACE_FILE_DEFAULT "/tmp/SQL.LOG"
197#endif
198
199/* SQL_ODBC_CURSORS options */
200#define SQL_CUR_USE_IF_NEEDED 0UL
201#define SQL_CUR_USE_ODBC 1UL
202#define SQL_CUR_USE_DRIVER 2UL
203#define SQL_CUR_DEFAULT SQL_CUR_USE_DRIVER
204
205#if (ODBCVER >= 0x0300)
206/* values for SQL_ATTR_DISCONNECT_BEHAVIOR */
207#define SQL_DB_RETURN_TO_POOL 0UL
208#define SQL_DB_DISCONNECT 1UL
209#define SQL_DB_DEFAULT SQL_DB_RETURN_TO_POOL
210
211/* values for SQL_ATTR_ENLIST_IN_DTC */
212#define SQL_DTC_DONE 0L
213#endif /* ODBCVER >= 0x0300 */
214
215/* values for SQL_ATTR_CONNECTION_DEAD */
216#define SQL_CD_TRUE 1L /* Connection is closed/dead */
217#define SQL_CD_FALSE 0L /* Connection is open/available */
218
219/* values for SQL_ATTR_ANSI_APP */
220#if (ODBCVER >= 0x0351)
221#define SQL_AA_TRUE 1L /* the application is an ANSI app */
222#define SQL_AA_FALSE 0L /* the application is a Unicode app */
223#endif
224
225/* values for SQL_ATTR_RESET_CONNECTION */
226#if (ODBCVER >= 0x0380)
227#define SQL_RESET_CONNECTION_YES 1UL
228#endif
229
230/* values for SQL_ATTR_ASYNC_DBC_FUNCTIONS_ENABLE */
231#if (ODBCVER >= 0x0380)
232#define SQL_ASYNC_DBC_ENABLE_ON 1UL
233#define SQL_ASYNC_DBC_ENABLE_OFF 0UL
234#define SQL_ASYNC_DBC_ENABLE_DEFAULT SQL_ASYNC_DBC_ENABLE_OFF
235#endif
236
237/* statement attributes */
238#define SQL_QUERY_TIMEOUT 0
239#define SQL_MAX_ROWS 1
240#define SQL_NOSCAN 2
241#define SQL_MAX_LENGTH 3
242#define SQL_ASYNC_ENABLE 4 /* same as SQL_ATTR_ASYNC_ENABLE */
243#define SQL_BIND_TYPE 5
244#define SQL_CURSOR_TYPE 6
245#define SQL_CONCURRENCY 7
246#define SQL_KEYSET_SIZE 8
247#define SQL_ROWSET_SIZE 9
248#define SQL_SIMULATE_CURSOR 10
249#define SQL_RETRIEVE_DATA 11
250#define SQL_USE_BOOKMARKS 12
251#define SQL_GET_BOOKMARK 13 /* GetStmtOption Only */
252#define SQL_ROW_NUMBER 14 /* GetStmtOption Only */
253
254/* statement attributes for ODBC 3.0 */
255#if (ODBCVER >= 0x0300)
256#define SQL_ATTR_ASYNC_ENABLE 4
257#define SQL_ATTR_CONCURRENCY SQL_CONCURRENCY
258#define SQL_ATTR_CURSOR_TYPE SQL_CURSOR_TYPE
259#define SQL_ATTR_ENABLE_AUTO_IPD 15
260#define SQL_ATTR_FETCH_BOOKMARK_PTR 16
261#define SQL_ATTR_KEYSET_SIZE SQL_KEYSET_SIZE
262#define SQL_ATTR_MAX_LENGTH SQL_MAX_LENGTH
263#define SQL_ATTR_MAX_ROWS SQL_MAX_ROWS
264#define SQL_ATTR_NOSCAN SQL_NOSCAN
265#define SQL_ATTR_PARAM_BIND_OFFSET_PTR 17
266#define SQL_ATTR_PARAM_BIND_TYPE 18
267#define SQL_ATTR_PARAM_OPERATION_PTR 19
268#define SQL_ATTR_PARAM_STATUS_PTR 20
269#define SQL_ATTR_PARAMS_PROCESSED_PTR 21
270#define SQL_ATTR_PARAMSET_SIZE 22
271#define SQL_ATTR_QUERY_TIMEOUT SQL_QUERY_TIMEOUT
272#define SQL_ATTR_RETRIEVE_DATA SQL_RETRIEVE_DATA
273#define SQL_ATTR_ROW_BIND_OFFSET_PTR 23
274#define SQL_ATTR_ROW_BIND_TYPE SQL_BIND_TYPE
275#define SQL_ATTR_ROW_NUMBER SQL_ROW_NUMBER /*GetStmtAttr*/
276#define SQL_ATTR_ROW_OPERATION_PTR 24
277#define SQL_ATTR_ROW_STATUS_PTR 25
278#define SQL_ATTR_ROWS_FETCHED_PTR 26
279#define SQL_ATTR_ROW_ARRAY_SIZE 27
280#define SQL_ATTR_SIMULATE_CURSOR SQL_SIMULATE_CURSOR
281#define SQL_ATTR_USE_BOOKMARKS SQL_USE_BOOKMARKS
282
283#endif /* ODBCVER >= 0x0300 */
284
285#if (ODBCVER >= 0x0380)
286#define SQL_ATTR_ASYNC_STMT_EVENT 29
287#endif /* ODBCVER >= 0x0380 */
288
289#if (ODBCVER < 0x0300)
290#define SQL_STMT_OPT_MAX SQL_ROW_NUMBER
291#define SQL_STMT_OPT_MIN SQL_QUERY_TIMEOUT
292#endif /* ODBCVER < 0x0300 */
293
294/* New defines for SEARCHABLE column in SQLGetTypeInfo */
295
296#if (ODBCVER >= 0x0300)
297#define SQL_COL_PRED_CHAR SQL_LIKE_ONLY
298#define SQL_COL_PRED_BASIC SQL_ALL_EXCEPT_LIKE
299#endif /* ODBCVER >= 0x0300 */
300
301
302
303/* whether an attribute is a pointer or not */
304#if (ODBCVER >= 0x0300)
305#define SQL_IS_POINTER (-4)
306#define SQL_IS_UINTEGER (-5)
307#define SQL_IS_INTEGER (-6)
308#define SQL_IS_USMALLINT (-7)
309#define SQL_IS_SMALLINT (-8)
310#endif /* ODBCVER >= 0x0300 */
311
312/* the value of SQL_ATTR_PARAM_BIND_TYPE */
313#if (ODBCVER >= 0x0300)
314#define SQL_PARAM_BIND_BY_COLUMN 0UL
315#define SQL_PARAM_BIND_TYPE_DEFAULT SQL_PARAM_BIND_BY_COLUMN
316#endif /* ODBCVER >= 0x0300 */
317
318/* SQL_QUERY_TIMEOUT options */
319#define SQL_QUERY_TIMEOUT_DEFAULT 0UL
320
321/* SQL_MAX_ROWS options */
322#define SQL_MAX_ROWS_DEFAULT 0UL
323
324/* SQL_NOSCAN options */
325#define SQL_NOSCAN_OFF 0UL /* 1.0 FALSE */
326#define SQL_NOSCAN_ON 1UL /* 1.0 TRUE */
327#define SQL_NOSCAN_DEFAULT SQL_NOSCAN_OFF
328
329/* SQL_MAX_LENGTH options */
330#define SQL_MAX_LENGTH_DEFAULT 0UL
331
332/* values for SQL_ATTR_ASYNC_ENABLE */
333#define SQL_ASYNC_ENABLE_OFF 0UL
334#define SQL_ASYNC_ENABLE_ON 1UL
335#define SQL_ASYNC_ENABLE_DEFAULT SQL_ASYNC_ENABLE_OFF
336
337/* SQL_BIND_TYPE options */
338#define SQL_BIND_BY_COLUMN 0UL
339#define SQL_BIND_TYPE_DEFAULT SQL_BIND_BY_COLUMN /* Default value */
340
341/* SQL_CONCURRENCY options */
342#define SQL_CONCUR_READ_ONLY 1
343#define SQL_CONCUR_LOCK 2
344#define SQL_CONCUR_ROWVER 3
345#define SQL_CONCUR_VALUES 4
346#define SQL_CONCUR_DEFAULT SQL_CONCUR_READ_ONLY /* Default value */
347
348/* SQL_CURSOR_TYPE options */
349#define SQL_CURSOR_FORWARD_ONLY 0UL
350#define SQL_CURSOR_KEYSET_DRIVEN 1UL
351#define SQL_CURSOR_DYNAMIC 2UL
352#define SQL_CURSOR_STATIC 3UL
353#define SQL_CURSOR_TYPE_DEFAULT SQL_CURSOR_FORWARD_ONLY /* Default value */
354
355/* SQL_ROWSET_SIZE options */
356#define SQL_ROWSET_SIZE_DEFAULT 1UL
357
358/* SQL_KEYSET_SIZE options */
359#define SQL_KEYSET_SIZE_DEFAULT 0UL
360
361/* SQL_SIMULATE_CURSOR options */
362#define SQL_SC_NON_UNIQUE 0UL
363#define SQL_SC_TRY_UNIQUE 1UL
364#define SQL_SC_UNIQUE 2UL
365
366/* SQL_RETRIEVE_DATA options */
367#define SQL_RD_OFF 0UL
368#define SQL_RD_ON 1UL
369#define SQL_RD_DEFAULT SQL_RD_ON
370
371/* SQL_USE_BOOKMARKS options */
372#define SQL_UB_OFF 0UL
373#define SQL_UB_ON 01UL
374#define SQL_UB_DEFAULT SQL_UB_OFF
375
376/* New values for SQL_USE_BOOKMARKS attribute */
377#if (ODBCVER >= 0x0300)
378#define SQL_UB_FIXED SQL_UB_ON
379#define SQL_UB_VARIABLE 2UL
380#endif /* ODBCVER >= 0x0300 */
381
382/* extended descriptor field */
383#if (ODBCVER >= 0x0300)
384#define SQL_DESC_ARRAY_SIZE 20
385#define SQL_DESC_ARRAY_STATUS_PTR 21
386#define SQL_DESC_AUTO_UNIQUE_VALUE SQL_COLUMN_AUTO_INCREMENT
387#define SQL_DESC_BASE_COLUMN_NAME 22
388#define SQL_DESC_BASE_TABLE_NAME 23
389#define SQL_DESC_BIND_OFFSET_PTR 24
390#define SQL_DESC_BIND_TYPE 25
391#define SQL_DESC_CASE_SENSITIVE SQL_COLUMN_CASE_SENSITIVE
392#define SQL_DESC_CATALOG_NAME SQL_COLUMN_QUALIFIER_NAME
393#define SQL_DESC_CONCISE_TYPE SQL_COLUMN_TYPE
394#define SQL_DESC_DATETIME_INTERVAL_PRECISION 26
395#define SQL_DESC_DISPLAY_SIZE SQL_COLUMN_DISPLAY_SIZE
396#define SQL_DESC_FIXED_PREC_SCALE SQL_COLUMN_MONEY
397#define SQL_DESC_LABEL SQL_COLUMN_LABEL
398#define SQL_DESC_LITERAL_PREFIX 27
399#define SQL_DESC_LITERAL_SUFFIX 28
400#define SQL_DESC_LOCAL_TYPE_NAME 29
401#define SQL_DESC_MAXIMUM_SCALE 30
402#define SQL_DESC_MINIMUM_SCALE 31
403#define SQL_DESC_NUM_PREC_RADIX 32
404#define SQL_DESC_PARAMETER_TYPE 33
405#define SQL_DESC_ROWS_PROCESSED_PTR 34
406#if (ODBCVER >= 0x0350)
407#define SQL_DESC_ROWVER 35
408#endif /* ODBCVER >= 0x0350 */
409#define SQL_DESC_SCHEMA_NAME SQL_COLUMN_OWNER_NAME
410#define SQL_DESC_SEARCHABLE SQL_COLUMN_SEARCHABLE
411#define SQL_DESC_TYPE_NAME SQL_COLUMN_TYPE_NAME
412#define SQL_DESC_TABLE_NAME SQL_COLUMN_TABLE_NAME
413#define SQL_DESC_UNSIGNED SQL_COLUMN_UNSIGNED
414#define SQL_DESC_UPDATABLE SQL_COLUMN_UPDATABLE
415#endif /* ODBCVER >= 0x0300 */
416
417
418/* defines for diagnostics fields */
419#if (ODBCVER >= 0x0300)
420#define SQL_DIAG_CURSOR_ROW_COUNT (-1249)
421#define SQL_DIAG_ROW_NUMBER (-1248)
422#define SQL_DIAG_COLUMN_NUMBER (-1247)
423#endif /* ODBCVER >= 0x0300 */
424
425/* SQL extended datatypes */
426#define SQL_DATE 9
427#if (ODBCVER >= 0x0300)
428#define SQL_INTERVAL 10
429#endif /* ODBCVER >= 0x0300 */
430#define SQL_TIME 10
431#define SQL_TIMESTAMP 11
432#define SQL_LONGVARCHAR (-1)
433#define SQL_BINARY (-2)
434#define SQL_VARBINARY (-3)
435#define SQL_LONGVARBINARY (-4)
436#define SQL_BIGINT (-5)
437#define SQL_TINYINT (-6)
438#define SQL_BIT (-7)
439#if (ODBCVER >= 0x0350)
440#define SQL_GUID (-11)
441#endif /* ODBCVER >= 0x0350 */
442
443#if (ODBCVER >= 0x0300)
444/* interval code */
445#define SQL_CODE_YEAR 1
446#define SQL_CODE_MONTH 2
447#define SQL_CODE_DAY 3
448#define SQL_CODE_HOUR 4
449#define SQL_CODE_MINUTE 5
450#define SQL_CODE_SECOND 6
451#define SQL_CODE_YEAR_TO_MONTH 7
452#define SQL_CODE_DAY_TO_HOUR 8
453#define SQL_CODE_DAY_TO_MINUTE 9
454#define SQL_CODE_DAY_TO_SECOND 10
455#define SQL_CODE_HOUR_TO_MINUTE 11
456#define SQL_CODE_HOUR_TO_SECOND 12
457#define SQL_CODE_MINUTE_TO_SECOND 13
458
459#define SQL_INTERVAL_YEAR (100 + SQL_CODE_YEAR)
460#define SQL_INTERVAL_MONTH (100 + SQL_CODE_MONTH)
461#define SQL_INTERVAL_DAY (100 + SQL_CODE_DAY)
462#define SQL_INTERVAL_HOUR (100 + SQL_CODE_HOUR)
463#define SQL_INTERVAL_MINUTE (100 + SQL_CODE_MINUTE)
464#define SQL_INTERVAL_SECOND (100 + SQL_CODE_SECOND)
465#define SQL_INTERVAL_YEAR_TO_MONTH (100 + SQL_CODE_YEAR_TO_MONTH)
466#define SQL_INTERVAL_DAY_TO_HOUR (100 + SQL_CODE_DAY_TO_HOUR)
467#define SQL_INTERVAL_DAY_TO_MINUTE (100 + SQL_CODE_DAY_TO_MINUTE)
468#define SQL_INTERVAL_DAY_TO_SECOND (100 + SQL_CODE_DAY_TO_SECOND)
469#define SQL_INTERVAL_HOUR_TO_MINUTE (100 + SQL_CODE_HOUR_TO_MINUTE)
470#define SQL_INTERVAL_HOUR_TO_SECOND (100 + SQL_CODE_HOUR_TO_SECOND)
471#define SQL_INTERVAL_MINUTE_TO_SECOND (100 + SQL_CODE_MINUTE_TO_SECOND)
472
473#else
474#define SQL_INTERVAL_YEAR (-80)
475#define SQL_INTERVAL_MONTH (-81)
476#define SQL_INTERVAL_YEAR_TO_MONTH (-82)
477#define SQL_INTERVAL_DAY (-83)
478#define SQL_INTERVAL_HOUR (-84)
479#define SQL_INTERVAL_MINUTE (-85)
480#define SQL_INTERVAL_SECOND (-86)
481#define SQL_INTERVAL_DAY_TO_HOUR (-87)
482#define SQL_INTERVAL_DAY_TO_MINUTE (-88)
483#define SQL_INTERVAL_DAY_TO_SECOND (-89)
484#define SQL_INTERVAL_HOUR_TO_MINUTE (-90)
485#define SQL_INTERVAL_HOUR_TO_SECOND (-91)
486#define SQL_INTERVAL_MINUTE_TO_SECOND (-92)
487#endif /* ODBCVER >= 0x0300 */
488
489
490#if (ODBCVER <= 0x0300)
491#define SQL_UNICODE (-95)
492#define SQL_UNICODE_VARCHAR (-96)
493#define SQL_UNICODE_LONGVARCHAR (-97)
494#define SQL_UNICODE_CHAR SQL_UNICODE
495#else
496/* The previous definitions for SQL_UNICODE_ are historical and obsolete */
497
498#define SQL_UNICODE SQL_WCHAR
499#define SQL_UNICODE_VARCHAR SQL_WVARCHAR
500#define SQL_UNICODE_LONGVARCHAR SQL_WLONGVARCHAR
501#define SQL_UNICODE_CHAR SQL_WCHAR
502#endif
503
504#if (ODBCVER < 0x0300)
505#define SQL_TYPE_DRIVER_START SQL_INTERVAL_YEAR
506#define SQL_TYPE_DRIVER_END SQL_UNICODE_LONGVARCHAR
507#endif /* ODBCVER < 0x0300 */
508
509/* C datatype to SQL datatype mapping SQL types
510 ------------------- */
511#define SQL_C_CHAR SQL_CHAR /* CHAR, VARCHAR, DECIMAL, NUMERIC */
512#define SQL_C_LONG SQL_INTEGER /* INTEGER */
513#define SQL_C_SHORT SQL_SMALLINT /* SMALLINT */
514#define SQL_C_FLOAT SQL_REAL /* REAL */
515#define SQL_C_DOUBLE SQL_DOUBLE /* FLOAT, DOUBLE */
516#if (ODBCVER >= 0x0300)
517#define SQL_C_NUMERIC SQL_NUMERIC
518#endif /* ODBCVER >= 0x0300 */
519#define SQL_C_DEFAULT 99
520
521#define SQL_SIGNED_OFFSET (-20)
522#define SQL_UNSIGNED_OFFSET (-22)
523
524/* C datatype to SQL datatype mapping */
525#define SQL_C_DATE SQL_DATE
526#define SQL_C_TIME SQL_TIME
527#define SQL_C_TIMESTAMP SQL_TIMESTAMP
528#if (ODBCVER >= 0x0300)
529#define SQL_C_TYPE_DATE SQL_TYPE_DATE
530#define SQL_C_TYPE_TIME SQL_TYPE_TIME
531#define SQL_C_TYPE_TIMESTAMP SQL_TYPE_TIMESTAMP
532#define SQL_C_INTERVAL_YEAR SQL_INTERVAL_YEAR
533#define SQL_C_INTERVAL_MONTH SQL_INTERVAL_MONTH
534#define SQL_C_INTERVAL_DAY SQL_INTERVAL_DAY
535#define SQL_C_INTERVAL_HOUR SQL_INTERVAL_HOUR
536#define SQL_C_INTERVAL_MINUTE SQL_INTERVAL_MINUTE
537#define SQL_C_INTERVAL_SECOND SQL_INTERVAL_SECOND
538#define SQL_C_INTERVAL_YEAR_TO_MONTH SQL_INTERVAL_YEAR_TO_MONTH
539#define SQL_C_INTERVAL_DAY_TO_HOUR SQL_INTERVAL_DAY_TO_HOUR
540#define SQL_C_INTERVAL_DAY_TO_MINUTE SQL_INTERVAL_DAY_TO_MINUTE
541#define SQL_C_INTERVAL_DAY_TO_SECOND SQL_INTERVAL_DAY_TO_SECOND
542#define SQL_C_INTERVAL_HOUR_TO_MINUTE SQL_INTERVAL_HOUR_TO_MINUTE
543#define SQL_C_INTERVAL_HOUR_TO_SECOND SQL_INTERVAL_HOUR_TO_SECOND
544#define SQL_C_INTERVAL_MINUTE_TO_SECOND SQL_INTERVAL_MINUTE_TO_SECOND
545#endif /* ODBCVER >= 0x0300 */
546#define SQL_C_BINARY SQL_BINARY
547#define SQL_C_BIT SQL_BIT
548#if (ODBCVER >= 0x0300)
549#define SQL_C_SBIGINT (SQL_BIGINT+SQL_SIGNED_OFFSET) /* SIGNED BIGINT */
550#define SQL_C_UBIGINT (SQL_BIGINT+SQL_UNSIGNED_OFFSET) /* UNSIGNED BIGINT */
551#endif /* ODBCVER >= 0x0300 */
552#define SQL_C_TINYINT SQL_TINYINT
553#define SQL_C_SLONG (SQL_C_LONG+SQL_SIGNED_OFFSET) /* SIGNED INTEGER */
554#define SQL_C_SSHORT (SQL_C_SHORT+SQL_SIGNED_OFFSET) /* SIGNED SMALLINT */
555#define SQL_C_STINYINT (SQL_TINYINT+SQL_SIGNED_OFFSET) /* SIGNED TINYINT */
556#define SQL_C_ULONG (SQL_C_LONG+SQL_UNSIGNED_OFFSET) /* UNSIGNED INTEGER*/
557#define SQL_C_USHORT (SQL_C_SHORT+SQL_UNSIGNED_OFFSET) /* UNSIGNED SMALLINT*/
558#define SQL_C_UTINYINT (SQL_TINYINT+SQL_UNSIGNED_OFFSET) /* UNSIGNED TINYINT*/
559
560#if (ODBCVER >= 0x0300) && (SIZEOF_LONG_INT == 8) && !defined(BUILD_LEGACY_64_BIT_MODE)
561#define SQL_C_BOOKMARK SQL_C_UBIGINT /* BOOKMARK */
562#else
563#define SQL_C_BOOKMARK SQL_C_ULONG /* BOOKMARK */
564#endif
565
566#if (ODBCVER >= 0x0350)
567#define SQL_C_GUID SQL_GUID
568#endif /* ODBCVER >= 0x0350 */
569
570#define SQL_TYPE_NULL 0
571#if (ODBCVER < 0x0300)
572#define SQL_TYPE_MIN SQL_BIT
573#define SQL_TYPE_MAX SQL_VARCHAR
574#endif
575
576/* base value of driver-specific C-Type (max is 0x7fff) */
577/* define driver-specific C-Type, named as SQL_DRIVER_C_TYPE_BASE, */
578/* SQL_DRIVER_C_TYPE_BASE+1, SQL_DRIVER_C_TYPE_BASE+2, etc. */
579#if (ODBCVER >= 0x380)
580#define SQL_DRIVER_C_TYPE_BASE 0x4000
581#endif
582
583/* base value of driver-specific fields/attributes (max are 0x7fff [16-bit] or 0x00007fff [32-bit]) */
584/* define driver-specific SQL-Type, named as SQL_DRIVER_SQL_TYPE_BASE, */
585/* SQL_DRIVER_SQL_TYPE_BASE+1, SQL_DRIVER_SQL_TYPE_BASE+2, etc. */
586/* */
587/* Please note that there is no runtime change in this version of DM. */
588/* However, we suggest that driver manufacturers adhere to this range */
589/* as future versions of the DM may enforce these constraints */
590#if (ODBCVER >= 0x380)
591#define SQL_DRIVER_SQL_TYPE_BASE 0x4000
592#define SQL_DRIVER_DESC_FIELD_BASE 0x4000
593#define SQL_DRIVER_DIAG_FIELD_BASE 0x4000
594#define SQL_DRIVER_INFO_TYPE_BASE 0x4000
595#define SQL_DRIVER_CONN_ATTR_BASE 0x00004000
596#define SQL_DRIVER_STMT_ATTR_BASE 0x00004000
597#endif
598
599#if (ODBCVER >= 0x0300)
600#define SQL_C_VARBOOKMARK SQL_C_BINARY
601#endif /* ODBCVER >= 0x0300 */
602
603/* define for SQL_DIAG_ROW_NUMBER and SQL_DIAG_COLUMN_NUMBER */
604#if (ODBCVER >= 0x0300)
605#define SQL_NO_ROW_NUMBER (-1)
606#define SQL_NO_COLUMN_NUMBER (-1)
607#define SQL_ROW_NUMBER_UNKNOWN (-2)
608#define SQL_COLUMN_NUMBER_UNKNOWN (-2)
609#endif
610
611/* SQLBindParameter extensions */
612#define SQL_DEFAULT_PARAM (-5)
613#define SQL_IGNORE (-6)
614#if (ODBCVER >= 0x0300)
615#define SQL_COLUMN_IGNORE SQL_IGNORE
616#endif /* ODBCVER >= 0x0300 */
617#define SQL_LEN_DATA_AT_EXEC_OFFSET (-100)
618#define SQL_LEN_DATA_AT_EXEC(length) (-(length)+SQL_LEN_DATA_AT_EXEC_OFFSET)
619
620/* binary length for driver specific attributes */
621#define SQL_LEN_BINARY_ATTR_OFFSET (-100)
622#define SQL_LEN_BINARY_ATTR(length) (-(length)+SQL_LEN_BINARY_ATTR_OFFSET)
623
624/* Defines used by Driver Manager when mapping SQLSetParam to SQLBindParameter
625*/
626#define SQL_PARAM_TYPE_DEFAULT SQL_PARAM_INPUT_OUTPUT
627#define SQL_SETPARAM_VALUE_MAX (-1L)
628
629/* SQLColAttributes defines */
630#define SQL_COLUMN_COUNT 0
631#define SQL_COLUMN_NAME 1
632#define SQL_COLUMN_TYPE 2
633#define SQL_COLUMN_LENGTH 3
634#define SQL_COLUMN_PRECISION 4
635#define SQL_COLUMN_SCALE 5
636#define SQL_COLUMN_DISPLAY_SIZE 6
637#define SQL_COLUMN_NULLABLE 7
638#define SQL_COLUMN_UNSIGNED 8
639#define SQL_COLUMN_MONEY 9
640#define SQL_COLUMN_UPDATABLE 10
641#define SQL_COLUMN_AUTO_INCREMENT 11
642#define SQL_COLUMN_CASE_SENSITIVE 12
643#define SQL_COLUMN_SEARCHABLE 13
644#define SQL_COLUMN_TYPE_NAME 14
645#define SQL_COLUMN_TABLE_NAME 15
646#define SQL_COLUMN_OWNER_NAME 16
647#define SQL_COLUMN_QUALIFIER_NAME 17
648#define SQL_COLUMN_LABEL 18
649#define SQL_COLATT_OPT_MAX SQL_COLUMN_LABEL
650#if (ODBCVER < 0x0300)
651#define SQL_COLUMN_DRIVER_START 1000
652#endif /* ODBCVER < 0x0300 */
653
654#define SQL_COLATT_OPT_MIN SQL_COLUMN_COUNT
655
656/* SQLColAttributes subdefines for SQL_COLUMN_UPDATABLE */
657#define SQL_ATTR_READONLY 0
658#define SQL_ATTR_WRITE 1
659#define SQL_ATTR_READWRITE_UNKNOWN 2
660
661/* SQLColAttributes subdefines for SQL_COLUMN_SEARCHABLE */
662/* These are also used by SQLGetInfo */
663#define SQL_UNSEARCHABLE 0
664#define SQL_LIKE_ONLY 1
665#define SQL_ALL_EXCEPT_LIKE 2
666#define SQL_SEARCHABLE 3
667#define SQL_PRED_SEARCHABLE SQL_SEARCHABLE
668
669
670/* Special return values for SQLGetData */
671#define SQL_NO_TOTAL (-4)
672
673/********************************************/
674/* SQLGetFunctions: additional values for */
675/* fFunction to represent functions that */
676/* are not in the X/Open spec. */
677/********************************************/
678
679#if (ODBCVER >= 0x0300)
680#define SQL_API_SQLALLOCHANDLESTD 73
681#define SQL_API_SQLBULKOPERATIONS 24
682#endif /* ODBCVER >= 0x0300 */
683#define SQL_API_SQLBINDPARAMETER 72
684#define SQL_API_SQLBROWSECONNECT 55
685#define SQL_API_SQLCOLATTRIBUTES 6
686#define SQL_API_SQLCOLUMNPRIVILEGES 56
687#define SQL_API_SQLDESCRIBEPARAM 58
688#define SQL_API_SQLDRIVERCONNECT 41
689#define SQL_API_SQLDRIVERS 71
690#define SQL_API_SQLEXTENDEDFETCH 59
691#define SQL_API_SQLFOREIGNKEYS 60
692#define SQL_API_SQLMORERESULTS 61
693#define SQL_API_SQLNATIVESQL 62
694#define SQL_API_SQLNUMPARAMS 63
695#define SQL_API_SQLPARAMOPTIONS 64
696#define SQL_API_SQLPRIMARYKEYS 65
697#define SQL_API_SQLPROCEDURECOLUMNS 66
698#define SQL_API_SQLPROCEDURES 67
699#define SQL_API_SQLSETPOS 68
700#define SQL_API_SQLSETSCROLLOPTIONS 69
701#define SQL_API_SQLTABLEPRIVILEGES 70
702
703/*-------------------------------------------*/
704/* SQL_EXT_API_LAST is not useful with ODBC */
705/* version 3.0 because some of the values */
706/* from X/Open are in the 10000 range. */
707/*-------------------------------------------*/
708
709#if (ODBCVER < 0x0300)
710#define SQL_EXT_API_LAST SQL_API_SQLBINDPARAMETER
711#define SQL_NUM_FUNCTIONS 23
712#define SQL_EXT_API_START 40
713#define SQL_NUM_EXTENSIONS (SQL_EXT_API_LAST-SQL_EXT_API_START+1)
714#endif
715
716/*--------------------------------------------*/
717/* SQL_API_ALL_FUNCTIONS returns an array */
718/* of 'booleans' representing whether a */
719/* function is implemented by the driver. */
720/* */
721/* CAUTION: Only functions defined in ODBC */
722/* version 2.0 and earlier are returned, the */
723/* new high-range function numbers defined by */
724/* X/Open break this scheme. See the new */
725/* method -- SQL_API_ODBC3_ALL_FUNCTIONS */
726/*--------------------------------------------*/
727
728#define SQL_API_ALL_FUNCTIONS 0 /* See CAUTION above */
729
730/*----------------------------------------------*/
731/* 2.X drivers export a dummy function with */
732/* ordinal number SQL_API_LOADBYORDINAL to speed*/
733/* loading under the windows operating system. */
734/* */
735/* CAUTION: Loading by ordinal is not supported */
736/* for 3.0 and above drivers. */
737/*----------------------------------------------*/
738
739#define SQL_API_LOADBYORDINAL 199 /* See CAUTION above */
740
741/*----------------------------------------------*/
742/* SQL_API_ODBC3_ALL_FUNCTIONS */
743/* This returns a bitmap, which allows us to */
744/* handle the higher-valued function numbers. */
745/* Use SQL_FUNC_EXISTS(bitmap,function_number) */
746/* to determine if the function exists. */
747/*----------------------------------------------*/
748
749
750#if (ODBCVER >= 0x0300)
751#define SQL_API_ODBC3_ALL_FUNCTIONS 999
752#define SQL_API_ODBC3_ALL_FUNCTIONS_SIZE 250 /* array of 250 words */
753
754
755#define SQL_FUNC_EXISTS(pfExists, uwAPI) ((*(((UWORD*) (pfExists)) + ((uwAPI) >> 4)) & (1 << ((uwAPI) & 0x000F)) ) ? SQL_TRUE : SQL_FALSE )
756
757#endif /* ODBCVER >= 0x0300 */
758
759
760/************************************************/
761/* Extended definitions for SQLGetInfo */
762/************************************************/
763
764/*---------------------------------*/
765/* Values in ODBC 2.0 that are not */
766/* in the X/Open spec */
767/*---------------------------------*/
768
769#define SQL_INFO_FIRST 0
770#define SQL_ACTIVE_CONNECTIONS 0 /* MAX_DRIVER_CONNECTIONS */
771#define SQL_ACTIVE_STATEMENTS 1 /* MAX_CONCURRENT_ACTIVITIES */
772#define SQL_DRIVER_HDBC 3
773#define SQL_DRIVER_HENV 4
774#define SQL_DRIVER_HSTMT 5
775#define SQL_DRIVER_NAME 6
776#define SQL_DRIVER_VER 7
777#define SQL_ODBC_API_CONFORMANCE 9
778#define SQL_ODBC_VER 10
779#define SQL_ROW_UPDATES 11
780#define SQL_ODBC_SAG_CLI_CONFORMANCE 12
781#define SQL_ODBC_SQL_CONFORMANCE 15
782#define SQL_PROCEDURES 21
783#define SQL_CONCAT_NULL_BEHAVIOR 22
784#define SQL_CURSOR_ROLLBACK_BEHAVIOR 24
785#define SQL_EXPRESSIONS_IN_ORDERBY 27
786#define SQL_MAX_OWNER_NAME_LEN 32 /* MAX_SCHEMA_NAME_LEN */
787#define SQL_MAX_PROCEDURE_NAME_LEN 33
788#define SQL_MAX_QUALIFIER_NAME_LEN 34 /* MAX_CATALOG_NAME_LEN */
789#define SQL_MULT_RESULT_SETS 36
790#define SQL_MULTIPLE_ACTIVE_TXN 37
791#define SQL_OUTER_JOINS 38
792#define SQL_OWNER_TERM 39
793#define SQL_PROCEDURE_TERM 40
794#define SQL_QUALIFIER_NAME_SEPARATOR 41
795#define SQL_QUALIFIER_TERM 42
796#define SQL_SCROLL_OPTIONS 44
797#define SQL_TABLE_TERM 45
798#define SQL_CONVERT_FUNCTIONS 48
799#define SQL_NUMERIC_FUNCTIONS 49
800#define SQL_STRING_FUNCTIONS 50
801#define SQL_SYSTEM_FUNCTIONS 51
802#define SQL_TIMEDATE_FUNCTIONS 52
803#define SQL_CONVERT_BIGINT 53
804#define SQL_CONVERT_BINARY 54
805#define SQL_CONVERT_BIT 55
806#define SQL_CONVERT_CHAR 56
807#define SQL_CONVERT_DATE 57
808#define SQL_CONVERT_DECIMAL 58
809#define SQL_CONVERT_DOUBLE 59
810#define SQL_CONVERT_FLOAT 60
811#define SQL_CONVERT_INTEGER 61
812#define SQL_CONVERT_LONGVARCHAR 62
813#define SQL_CONVERT_NUMERIC 63
814#define SQL_CONVERT_REAL 64
815#define SQL_CONVERT_SMALLINT 65
816#define SQL_CONVERT_TIME 66
817#define SQL_CONVERT_TIMESTAMP 67
818#define SQL_CONVERT_TINYINT 68
819#define SQL_CONVERT_VARBINARY 69
820#define SQL_CONVERT_VARCHAR 70
821#define SQL_CONVERT_LONGVARBINARY 71
822#define SQL_CONVERT_GUID 173
823#define SQL_ODBC_SQL_OPT_IEF 73 /* SQL_INTEGRITY */
824#define SQL_CORRELATION_NAME 74
825#define SQL_NON_NULLABLE_COLUMNS 75
826#define SQL_DRIVER_HLIB 76
827#define SQL_DRIVER_ODBC_VER 77
828#define SQL_LOCK_TYPES 78
829#define SQL_POS_OPERATIONS 79
830#define SQL_POSITIONED_STATEMENTS 80
831#define SQL_BOOKMARK_PERSISTENCE 82
832#define SQL_STATIC_SENSITIVITY 83
833#define SQL_FILE_USAGE 84
834#define SQL_COLUMN_ALIAS 87
835#define SQL_GROUP_BY 88
836#define SQL_KEYWORDS 89
837#define SQL_OWNER_USAGE 91
838#define SQL_QUALIFIER_USAGE 92
839#define SQL_QUOTED_IDENTIFIER_CASE 93
840#define SQL_SUBQUERIES 95
841#define SQL_UNION 96
842#define SQL_MAX_ROW_SIZE_INCLUDES_LONG 103
843#define SQL_MAX_CHAR_LITERAL_LEN 108
844#define SQL_TIMEDATE_ADD_INTERVALS 109
845#define SQL_TIMEDATE_DIFF_INTERVALS 110
846#define SQL_NEED_LONG_DATA_LEN 111
847#define SQL_MAX_BINARY_LITERAL_LEN 112
848#define SQL_LIKE_ESCAPE_CLAUSE 113
849#define SQL_QUALIFIER_LOCATION 114
850
851#if (ODBCVER >= 0x0201 && ODBCVER < 0x0300)
852#ifndef SQL_OJ_CAPABILITIES
853#define SQL_OJ_CAPABILITIES 65003 /* Temp value until ODBC 3.0 */
854#endif
855#endif /* ODBCVER >= 0x0201 && ODBCVER < 0x0300 */
856
857/*----------------------------------------------*/
858/* SQL_INFO_LAST and SQL_INFO_DRIVER_START are */
859/* not useful anymore, because X/Open has */
860/* values in the 10000 range. You */
861/* must contact X/Open directly to get a range */
862/* of numbers for driver-specific values. */
863/*----------------------------------------------*/
864
865#if (ODBCVER < 0x0300)
866#define SQL_INFO_LAST SQL_QUALIFIER_LOCATION
867#define SQL_INFO_DRIVER_START 1000
868#endif /* ODBCVER < 0x0300 */
869
870/*-----------------------------------------------*/
871/* ODBC 3.0 SQLGetInfo values that are not part */
872/* of the X/Open standard at this time. X/Open */
873/* standard values are in sql.h. */
874/*-----------------------------------------------*/
875
876#if (ODBCVER >= 0x0300)
877#define SQL_ACTIVE_ENVIRONMENTS 116
878#define SQL_ALTER_DOMAIN 117
879
880#define SQL_SQL_CONFORMANCE 118
881#define SQL_DATETIME_LITERALS 119
882
883#define SQL_ASYNC_MODE 10021 /* new X/Open spec */
884#define SQL_BATCH_ROW_COUNT 120
885#define SQL_BATCH_SUPPORT 121
886#define SQL_CATALOG_LOCATION SQL_QUALIFIER_LOCATION
887#define SQL_CATALOG_NAME_SEPARATOR SQL_QUALIFIER_NAME_SEPARATOR
888#define SQL_CATALOG_TERM SQL_QUALIFIER_TERM
889#define SQL_CATALOG_USAGE SQL_QUALIFIER_USAGE
890#define SQL_CONVERT_WCHAR 122
891#define SQL_CONVERT_INTERVAL_DAY_TIME 123
892#define SQL_CONVERT_INTERVAL_YEAR_MONTH 124
893#define SQL_CONVERT_WLONGVARCHAR 125
894#define SQL_CONVERT_WVARCHAR 126
895#define SQL_CREATE_ASSERTION 127
896#define SQL_CREATE_CHARACTER_SET 128
897#define SQL_CREATE_COLLATION 129
898#define SQL_CREATE_DOMAIN 130
899#define SQL_CREATE_SCHEMA 131
900#define SQL_CREATE_TABLE 132
901#define SQL_CREATE_TRANSLATION 133
902#define SQL_CREATE_VIEW 134
903#define SQL_DRIVER_HDESC 135
904#define SQL_DROP_ASSERTION 136
905#define SQL_DROP_CHARACTER_SET 137
906#define SQL_DROP_COLLATION 138
907#define SQL_DROP_DOMAIN 139
908#define SQL_DROP_SCHEMA 140
909#define SQL_DROP_TABLE 141
910#define SQL_DROP_TRANSLATION 142
911#define SQL_DROP_VIEW 143
912#define SQL_DYNAMIC_CURSOR_ATTRIBUTES1 144
913#define SQL_DYNAMIC_CURSOR_ATTRIBUTES2 145
914#define SQL_FORWARD_ONLY_CURSOR_ATTRIBUTES1 146
915#define SQL_FORWARD_ONLY_CURSOR_ATTRIBUTES2 147
916#define SQL_INDEX_KEYWORDS 148
917#define SQL_INFO_SCHEMA_VIEWS 149
918#define SQL_KEYSET_CURSOR_ATTRIBUTES1 150
919#define SQL_KEYSET_CURSOR_ATTRIBUTES2 151
920#define SQL_MAX_ASYNC_CONCURRENT_STATEMENTS 10022 /* new X/Open spec */
921#define SQL_ODBC_INTERFACE_CONFORMANCE 152
922#define SQL_PARAM_ARRAY_ROW_COUNTS 153
923#define SQL_PARAM_ARRAY_SELECTS 154
924#define SQL_SCHEMA_TERM SQL_OWNER_TERM
925#define SQL_SCHEMA_USAGE SQL_OWNER_USAGE
926#define SQL_SQL92_DATETIME_FUNCTIONS 155
927#define SQL_SQL92_FOREIGN_KEY_DELETE_RULE 156
928#define SQL_SQL92_FOREIGN_KEY_UPDATE_RULE 157
929#define SQL_SQL92_GRANT 158
930#define SQL_SQL92_NUMERIC_VALUE_FUNCTIONS 159
931#define SQL_SQL92_PREDICATES 160
932#define SQL_SQL92_RELATIONAL_JOIN_OPERATORS 161
933#define SQL_SQL92_REVOKE 162
934#define SQL_SQL92_ROW_VALUE_CONSTRUCTOR 163
935#define SQL_SQL92_STRING_FUNCTIONS 164
936#define SQL_SQL92_VALUE_EXPRESSIONS 165
937#define SQL_STANDARD_CLI_CONFORMANCE 166
938#define SQL_STATIC_CURSOR_ATTRIBUTES1 167
939#define SQL_STATIC_CURSOR_ATTRIBUTES2 168
940
941#define SQL_AGGREGATE_FUNCTIONS 169
942#define SQL_DDL_INDEX 170
943#define SQL_DM_VER 171
944#define SQL_INSERT_STATEMENT 172
945#define SQL_UNION_STATEMENT SQL_UNION
946#endif /* ODBCVER >= 0x0300 */
947
948#if (ODBCVER >= 0x0380)
949/* Info Types */
950#define SQL_ASYNC_DBC_FUNCTIONS 10023
951#endif
952
953#define SQL_DRIVER_AWARE_POOLING_SUPPORTED 10024
954
955#if (ODBCVER >= 0x0380)
956#define SQL_ASYNC_NOTIFICATION 10025
957
958/* Possible values for SQL_ASYNC_NOTIFICATION */
959#define SQL_ASYNC_NOTIFICATION_NOT_CAPABLE 0x00000000L
960#define SQL_ASYNC_NOTIFICATION_CAPABLE 0x00000001L
961#endif /* ODBCVER >= 0x0380 */
962
963#define SQL_DTC_TRANSITION_COST 1750
964
965/* SQL_ALTER_TABLE bitmasks */
966#if (ODBCVER >= 0x0300)
967/* the following 5 bitmasks are defined in sql.h
968*#define SQL_AT_ADD_COLUMN 0x00000001L
969*#define SQL_AT_DROP_COLUMN 0x00000002L
970*#define SQL_AT_ADD_CONSTRAINT 0x00000008L
971*/
972#define SQL_AT_ADD_COLUMN_SINGLE 0x00000020L
973#define SQL_AT_ADD_COLUMN_DEFAULT 0x00000040L
974#define SQL_AT_ADD_COLUMN_COLLATION 0x00000080L
975#define SQL_AT_SET_COLUMN_DEFAULT 0x00000100L
976#define SQL_AT_DROP_COLUMN_DEFAULT 0x00000200L
977#define SQL_AT_DROP_COLUMN_CASCADE 0x00000400L
978#define SQL_AT_DROP_COLUMN_RESTRICT 0x00000800L
979#define SQL_AT_ADD_TABLE_CONSTRAINT 0x00001000L
980#define SQL_AT_DROP_TABLE_CONSTRAINT_CASCADE 0x00002000L
981#define SQL_AT_DROP_TABLE_CONSTRAINT_RESTRICT 0x00004000L
982#define SQL_AT_CONSTRAINT_NAME_DEFINITION 0x00008000L
983#define SQL_AT_CONSTRAINT_INITIALLY_DEFERRED 0x00010000L
984#define SQL_AT_CONSTRAINT_INITIALLY_IMMEDIATE 0x00020000L
985#define SQL_AT_CONSTRAINT_DEFERRABLE 0x00040000L
986#define SQL_AT_CONSTRAINT_NON_DEFERRABLE 0x00080000L
987#endif /* ODBCVER >= 0x0300 */
988
989/* SQL_CONVERT_* return value bitmasks */
990
991#define SQL_CVT_CHAR 0x00000001L
992#define SQL_CVT_NUMERIC 0x00000002L
993#define SQL_CVT_DECIMAL 0x00000004L
994#define SQL_CVT_INTEGER 0x00000008L
995#define SQL_CVT_SMALLINT 0x00000010L
996#define SQL_CVT_FLOAT 0x00000020L
997#define SQL_CVT_REAL 0x00000040L
998#define SQL_CVT_DOUBLE 0x00000080L
999#define SQL_CVT_VARCHAR 0x00000100L
1000#define SQL_CVT_LONGVARCHAR 0x00000200L
1001#define SQL_CVT_BINARY 0x00000400L
1002#define SQL_CVT_VARBINARY 0x00000800L
1003#define SQL_CVT_BIT 0x00001000L
1004#define SQL_CVT_TINYINT 0x00002000L
1005#define SQL_CVT_BIGINT 0x00004000L
1006#define SQL_CVT_DATE 0x00008000L
1007#define SQL_CVT_TIME 0x00010000L
1008#define SQL_CVT_TIMESTAMP 0x00020000L
1009#define SQL_CVT_LONGVARBINARY 0x00040000L
1010#if (ODBCVER >= 0x0300)
1011#define SQL_CVT_INTERVAL_YEAR_MONTH 0x00080000L
1012#define SQL_CVT_INTERVAL_DAY_TIME 0x00100000L
1013#define SQL_CVT_WCHAR 0x00200000L
1014#define SQL_CVT_WLONGVARCHAR 0x00400000L
1015#define SQL_CVT_WVARCHAR 0x00800000L
1016#define SQL_CVT_GUID 0x01000000L
1017
1018#endif /* ODBCVER >= 0x0300 */
1019
1020
1021/* SQL_CONVERT_FUNCTIONS functions */
1022#define SQL_FN_CVT_CONVERT 0x00000001L
1023#if (ODBCVER >= 0x0300)
1024#define SQL_FN_CVT_CAST 0x00000002L
1025#endif /* ODBCVER >= 0x0300 */
1026
1027
1028/* SQL_STRING_FUNCTIONS functions */
1029
1030#define SQL_FN_STR_CONCAT 0x00000001L
1031#define SQL_FN_STR_INSERT 0x00000002L
1032#define SQL_FN_STR_LEFT 0x00000004L
1033#define SQL_FN_STR_LTRIM 0x00000008L
1034#define SQL_FN_STR_LENGTH 0x00000010L
1035#define SQL_FN_STR_LOCATE 0x00000020L
1036#define SQL_FN_STR_LCASE 0x00000040L
1037#define SQL_FN_STR_REPEAT 0x00000080L
1038#define SQL_FN_STR_REPLACE 0x00000100L
1039#define SQL_FN_STR_RIGHT 0x00000200L
1040#define SQL_FN_STR_RTRIM 0x00000400L
1041#define SQL_FN_STR_SUBSTRING 0x00000800L
1042#define SQL_FN_STR_UCASE 0x00001000L
1043#define SQL_FN_STR_ASCII 0x00002000L
1044#define SQL_FN_STR_CHAR 0x00004000L
1045#define SQL_FN_STR_DIFFERENCE 0x00008000L
1046#define SQL_FN_STR_LOCATE_2 0x00010000L
1047#define SQL_FN_STR_SOUNDEX 0x00020000L
1048#define SQL_FN_STR_SPACE 0x00040000L
1049#if (ODBCVER >= 0x0300)
1050#define SQL_FN_STR_BIT_LENGTH 0x00080000L
1051#define SQL_FN_STR_CHAR_LENGTH 0x00100000L
1052#define SQL_FN_STR_CHARACTER_LENGTH 0x00200000L
1053#define SQL_FN_STR_OCTET_LENGTH 0x00400000L
1054#define SQL_FN_STR_POSITION 0x00800000L
1055#endif /* ODBCVER >= 0x0300 */
1056
1057/* SQL_SQL92_STRING_FUNCTIONS */
1058#if (ODBCVER >= 0x0300)
1059#define SQL_SSF_CONVERT 0x00000001L
1060#define SQL_SSF_LOWER 0x00000002L
1061#define SQL_SSF_UPPER 0x00000004L
1062#define SQL_SSF_SUBSTRING 0x00000008L
1063#define SQL_SSF_TRANSLATE 0x00000010L
1064#define SQL_SSF_TRIM_BOTH 0x00000020L
1065#define SQL_SSF_TRIM_LEADING 0x00000040L
1066#define SQL_SSF_TRIM_TRAILING 0x00000080L
1067#endif /* ODBCVER >= 0x0300 */
1068
1069/* SQL_NUMERIC_FUNCTIONS functions */
1070
1071#define SQL_FN_NUM_ABS 0x00000001L
1072#define SQL_FN_NUM_ACOS 0x00000002L
1073#define SQL_FN_NUM_ASIN 0x00000004L
1074#define SQL_FN_NUM_ATAN 0x00000008L
1075#define SQL_FN_NUM_ATAN2 0x00000010L
1076#define SQL_FN_NUM_CEILING 0x00000020L
1077#define SQL_FN_NUM_COS 0x00000040L
1078#define SQL_FN_NUM_COT 0x00000080L
1079#define SQL_FN_NUM_EXP 0x00000100L
1080#define SQL_FN_NUM_FLOOR 0x00000200L
1081#define SQL_FN_NUM_LOG 0x00000400L
1082#define SQL_FN_NUM_MOD 0x00000800L
1083#define SQL_FN_NUM_SIGN 0x00001000L
1084#define SQL_FN_NUM_SIN 0x00002000L
1085#define SQL_FN_NUM_SQRT 0x00004000L
1086#define SQL_FN_NUM_TAN 0x00008000L
1087#define SQL_FN_NUM_PI 0x00010000L
1088#define SQL_FN_NUM_RAND 0x00020000L
1089#define SQL_FN_NUM_DEGREES 0x00040000L
1090#define SQL_FN_NUM_LOG10 0x00080000L
1091#define SQL_FN_NUM_POWER 0x00100000L
1092#define SQL_FN_NUM_RADIANS 0x00200000L
1093#define SQL_FN_NUM_ROUND 0x00400000L
1094#define SQL_FN_NUM_TRUNCATE 0x00800000L
1095
1096/* SQL_SQL92_NUMERIC_VALUE_FUNCTIONS */
1097#if (ODBCVER >= 0x0300)
1098#define SQL_SNVF_BIT_LENGTH 0x00000001L
1099#define SQL_SNVF_CHAR_LENGTH 0x00000002L
1100#define SQL_SNVF_CHARACTER_LENGTH 0x00000004L
1101#define SQL_SNVF_EXTRACT 0x00000008L
1102#define SQL_SNVF_OCTET_LENGTH 0x00000010L
1103#define SQL_SNVF_POSITION 0x00000020L
1104#endif /* ODBCVER >= 0x0300 */
1105
1106/* SQL_TIMEDATE_FUNCTIONS functions */
1107
1108#define SQL_FN_TD_NOW 0x00000001L
1109#define SQL_FN_TD_CURDATE 0x00000002L
1110#define SQL_FN_TD_DAYOFMONTH 0x00000004L
1111#define SQL_FN_TD_DAYOFWEEK 0x00000008L
1112#define SQL_FN_TD_DAYOFYEAR 0x00000010L
1113#define SQL_FN_TD_MONTH 0x00000020L
1114#define SQL_FN_TD_QUARTER 0x00000040L
1115#define SQL_FN_TD_WEEK 0x00000080L
1116#define SQL_FN_TD_YEAR 0x00000100L
1117#define SQL_FN_TD_CURTIME 0x00000200L
1118#define SQL_FN_TD_HOUR 0x00000400L
1119#define SQL_FN_TD_MINUTE 0x00000800L
1120#define SQL_FN_TD_SECOND 0x00001000L
1121#define SQL_FN_TD_TIMESTAMPADD 0x00002000L
1122#define SQL_FN_TD_TIMESTAMPDIFF 0x00004000L
1123#define SQL_FN_TD_DAYNAME 0x00008000L
1124#define SQL_FN_TD_MONTHNAME 0x00010000L
1125#if (ODBCVER >= 0x0300)
1126#define SQL_FN_TD_CURRENT_DATE 0x00020000L
1127#define SQL_FN_TD_CURRENT_TIME 0x00040000L
1128#define SQL_FN_TD_CURRENT_TIMESTAMP 0x00080000L
1129#define SQL_FN_TD_EXTRACT 0x00100000L
1130#endif /* ODBCVER >= 0x0300 */
1131
1132/* SQL_SQL92_DATETIME_FUNCTIONS */
1133#if (ODBCVER >= 0x0300)
1134#define SQL_SDF_CURRENT_DATE 0x00000001L
1135#define SQL_SDF_CURRENT_TIME 0x00000002L
1136#define SQL_SDF_CURRENT_TIMESTAMP 0x00000004L
1137#endif /* ODBCVER >= 0x0300 */
1138
1139/* SQL_SYSTEM_FUNCTIONS functions */
1140
1141#define SQL_FN_SYS_USERNAME 0x00000001L
1142#define SQL_FN_SYS_DBNAME 0x00000002L
1143#define SQL_FN_SYS_IFNULL 0x00000004L
1144
1145/* SQL_TIMEDATE_ADD_INTERVALS and SQL_TIMEDATE_DIFF_INTERVALS functions */
1146
1147#define SQL_FN_TSI_FRAC_SECOND 0x00000001L
1148#define SQL_FN_TSI_SECOND 0x00000002L
1149#define SQL_FN_TSI_MINUTE 0x00000004L
1150#define SQL_FN_TSI_HOUR 0x00000008L
1151#define SQL_FN_TSI_DAY 0x00000010L
1152#define SQL_FN_TSI_WEEK 0x00000020L
1153#define SQL_FN_TSI_MONTH 0x00000040L
1154#define SQL_FN_TSI_QUARTER 0x00000080L
1155#define SQL_FN_TSI_YEAR 0x00000100L
1156
1157/* bitmasks for SQL_DYNAMIC_CURSOR_ATTRIBUTES1,
1158 * SQL_FORWARD_ONLY_CURSOR_ATTRIBUTES1,
1159 * SQL_KEYSET_CURSOR_ATTRIBUTES1, and SQL_STATIC_CURSOR_ATTRIBUTES1
1160 */
1161#if (ODBCVER >= 0x0300)
1162/* supported SQLFetchScroll FetchOrientation's */
1163#define SQL_CA1_NEXT 0x00000001L
1164#define SQL_CA1_ABSOLUTE 0x00000002L
1165#define SQL_CA1_RELATIVE 0x00000004L
1166#define SQL_CA1_BOOKMARK 0x00000008L
1167
1168/* supported SQLSetPos LockType's */
1169#define SQL_CA1_LOCK_NO_CHANGE 0x00000040L
1170#define SQL_CA1_LOCK_EXCLUSIVE 0x00000080L
1171#define SQL_CA1_LOCK_UNLOCK 0x00000100L
1172
1173/* supported SQLSetPos Operations */
1174#define SQL_CA1_POS_POSITION 0x00000200L
1175#define SQL_CA1_POS_UPDATE 0x00000400L
1176#define SQL_CA1_POS_DELETE 0x00000800L
1177#define SQL_CA1_POS_REFRESH 0x00001000L
1178
1179/* positioned updates and deletes */
1180#define SQL_CA1_POSITIONED_UPDATE 0x00002000L
1181#define SQL_CA1_POSITIONED_DELETE 0x00004000L
1182#define SQL_CA1_SELECT_FOR_UPDATE 0x00008000L
1183
1184/* supported SQLBulkOperations operations */
1185#define SQL_CA1_BULK_ADD 0x00010000L
1186#define SQL_CA1_BULK_UPDATE_BY_BOOKMARK 0x00020000L
1187#define SQL_CA1_BULK_DELETE_BY_BOOKMARK 0x00040000L
1188#define SQL_CA1_BULK_FETCH_BY_BOOKMARK 0x00080000L
1189#endif /* ODBCVER >= 0x0300 */
1190
1191/* bitmasks for SQL_DYNAMIC_CURSOR_ATTRIBUTES2,
1192 * SQL_FORWARD_ONLY_CURSOR_ATTRIBUTES2,
1193 * SQL_KEYSET_CURSOR_ATTRIBUTES2, and SQL_STATIC_CURSOR_ATTRIBUTES2
1194 */
1195#if (ODBCVER >= 0x0300)
1196/* supported values for SQL_ATTR_SCROLL_CONCURRENCY */
1197#define SQL_CA2_READ_ONLY_CONCURRENCY 0x00000001L
1198#define SQL_CA2_LOCK_CONCURRENCY 0x00000002L
1199#define SQL_CA2_OPT_ROWVER_CONCURRENCY 0x00000004L
1200#define SQL_CA2_OPT_VALUES_CONCURRENCY 0x00000008L
1201
1202/* sensitivity of the cursor to its own inserts, deletes, and updates */
1203#define SQL_CA2_SENSITIVITY_ADDITIONS 0x00000010L
1204#define SQL_CA2_SENSITIVITY_DELETIONS 0x00000020L
1205#define SQL_CA2_SENSITIVITY_UPDATES 0x00000040L
1206
1207/* semantics of SQL_ATTR_MAX_ROWS */
1208#define SQL_CA2_MAX_ROWS_SELECT 0x00000080L
1209#define SQL_CA2_MAX_ROWS_INSERT 0x00000100L
1210#define SQL_CA2_MAX_ROWS_DELETE 0x00000200L
1211#define SQL_CA2_MAX_ROWS_UPDATE 0x00000400L
1212#define SQL_CA2_MAX_ROWS_CATALOG 0x00000800L
1213#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)
1214
1215/* semantics of SQL_DIAG_CURSOR_ROW_COUNT */
1216#define SQL_CA2_CRC_EXACT 0x00001000L
1217#define SQL_CA2_CRC_APPROXIMATE 0x00002000L
1218
1219/* the kinds of positioned statements that can be simulated */
1220#define SQL_CA2_SIMULATE_NON_UNIQUE 0x00004000L
1221#define SQL_CA2_SIMULATE_TRY_UNIQUE 0x00008000L
1222#define SQL_CA2_SIMULATE_UNIQUE 0x00010000L
1223#endif /* ODBCVER >= 0x0300 */
1224
1225/* SQL_ODBC_API_CONFORMANCE values */
1226
1227#define SQL_OAC_NONE 0x0000
1228#define SQL_OAC_LEVEL1 0x0001
1229#define SQL_OAC_LEVEL2 0x0002
1230
1231/* SQL_ODBC_SAG_CLI_CONFORMANCE values */
1232
1233#define SQL_OSCC_NOT_COMPLIANT 0x0000
1234#define SQL_OSCC_COMPLIANT 0x0001
1235
1236/* SQL_ODBC_SQL_CONFORMANCE values */
1237
1238#define SQL_OSC_MINIMUM 0x0000
1239#define SQL_OSC_CORE 0x0001
1240#define SQL_OSC_EXTENDED 0x0002
1241
1242
1243/* SQL_CONCAT_NULL_BEHAVIOR values */
1244
1245#define SQL_CB_NULL 0x0000
1246#define SQL_CB_NON_NULL 0x0001
1247
1248/* SQL_SCROLL_OPTIONS masks */
1249
1250#define SQL_SO_FORWARD_ONLY 0x00000001L
1251#define SQL_SO_KEYSET_DRIVEN 0x00000002L
1252#define SQL_SO_DYNAMIC 0x00000004L
1253#define SQL_SO_MIXED 0x00000008L
1254#define SQL_SO_STATIC 0x00000010L
1255
1256/* SQL_FETCH_DIRECTION masks */
1257
1258/* SQL_FETCH_RESUME is no longer supported
1259#define SQL_FD_FETCH_RESUME 0x00000040L
1260*/
1261#define SQL_FD_FETCH_BOOKMARK 0x00000080L
1262
1263/* SQL_TXN_ISOLATION_OPTION masks */
1264/* SQL_TXN_VERSIONING is no longer supported
1265#define SQL_TXN_VERSIONING 0x00000010L
1266*/
1267
1268/* SQL_CORRELATION_NAME values */
1269
1270#define SQL_CN_NONE 0x0000
1271#define SQL_CN_DIFFERENT 0x0001
1272#define SQL_CN_ANY 0x0002
1273
1274/* SQL_NON_NULLABLE_COLUMNS values */
1275
1276#define SQL_NNC_NULL 0x0000
1277#define SQL_NNC_NON_NULL 0x0001
1278
1279/* SQL_NULL_COLLATION values */
1280
1281#define SQL_NC_START 0x0002
1282#define SQL_NC_END 0x0004
1283
1284/* SQL_FILE_USAGE values */
1285
1286#define SQL_FILE_NOT_SUPPORTED 0x0000
1287#define SQL_FILE_TABLE 0x0001
1288#define SQL_FILE_QUALIFIER 0x0002
1289#define SQL_FILE_CATALOG SQL_FILE_QUALIFIER /* ODBC 3.0 */
1290
1291
1292/* SQL_GETDATA_EXTENSIONS values */
1293
1294#define SQL_GD_BLOCK 0x00000004L
1295#define SQL_GD_BOUND 0x00000008L
1296#if (ODBCVER >= 0x0380)
1297 #define SQL_GD_OUTPUT_PARAMS 0x00000010L
1298#endif
1299
1300/* SQL_POSITIONED_STATEMENTS masks */
1301
1302#define SQL_PS_POSITIONED_DELETE 0x00000001L
1303#define SQL_PS_POSITIONED_UPDATE 0x00000002L
1304#define SQL_PS_SELECT_FOR_UPDATE 0x00000004L
1305
1306/* SQL_GROUP_BY values */
1307
1308#define SQL_GB_NOT_SUPPORTED 0x0000
1309#define SQL_GB_GROUP_BY_EQUALS_SELECT 0x0001
1310#define SQL_GB_GROUP_BY_CONTAINS_SELECT 0x0002
1311#define SQL_GB_NO_RELATION 0x0003
1312#if (ODBCVER >= 0x0300)
1313#define SQL_GB_COLLATE 0x0004
1314
1315#endif /* ODBCVER >= 0x0300 */
1316
1317/* SQL_OWNER_USAGE masks */
1318
1319#define SQL_OU_DML_STATEMENTS 0x00000001L
1320#define SQL_OU_PROCEDURE_INVOCATION 0x00000002L
1321#define SQL_OU_TABLE_DEFINITION 0x00000004L
1322#define SQL_OU_INDEX_DEFINITION 0x00000008L
1323#define SQL_OU_PRIVILEGE_DEFINITION 0x00000010L
1324
1325/* SQL_SCHEMA_USAGE masks */
1326#if (ODBCVER >= 0x0300)
1327#define SQL_SU_DML_STATEMENTS SQL_OU_DML_STATEMENTS
1328#define SQL_SU_PROCEDURE_INVOCATION SQL_OU_PROCEDURE_INVOCATION
1329#define SQL_SU_TABLE_DEFINITION SQL_OU_TABLE_DEFINITION
1330#define SQL_SU_INDEX_DEFINITION SQL_OU_INDEX_DEFINITION
1331#define SQL_SU_PRIVILEGE_DEFINITION SQL_OU_PRIVILEGE_DEFINITION
1332#endif /* ODBCVER >= 0x0300 */
1333
1334/* SQL_QUALIFIER_USAGE masks */
1335
1336#define SQL_QU_DML_STATEMENTS 0x00000001L
1337#define SQL_QU_PROCEDURE_INVOCATION 0x00000002L
1338#define SQL_QU_TABLE_DEFINITION 0x00000004L
1339#define SQL_QU_INDEX_DEFINITION 0x00000008L
1340#define SQL_QU_PRIVILEGE_DEFINITION 0x00000010L
1341
1342#if (ODBCVER >= 0x0300)
1343/* SQL_CATALOG_USAGE masks */
1344#define SQL_CU_DML_STATEMENTS SQL_QU_DML_STATEMENTS
1345#define SQL_CU_PROCEDURE_INVOCATION SQL_QU_PROCEDURE_INVOCATION
1346#define SQL_CU_TABLE_DEFINITION SQL_QU_TABLE_DEFINITION
1347#define SQL_CU_INDEX_DEFINITION SQL_QU_INDEX_DEFINITION
1348#define SQL_CU_PRIVILEGE_DEFINITION SQL_QU_PRIVILEGE_DEFINITION
1349#endif /* ODBCVER >= 0x0300 */
1350
1351/* SQL_SUBQUERIES masks */
1352
1353#define SQL_SQ_COMPARISON 0x00000001L
1354#define SQL_SQ_EXISTS 0x00000002L
1355#define SQL_SQ_IN 0x00000004L
1356#define SQL_SQ_QUANTIFIED 0x00000008L
1357#define SQL_SQ_CORRELATED_SUBQUERIES 0x00000010L
1358
1359/* SQL_UNION masks */
1360
1361#define SQL_U_UNION 0x00000001L
1362#define SQL_U_UNION_ALL 0x00000002L
1363
1364/* SQL_BOOKMARK_PERSISTENCE values */
1365
1366#define SQL_BP_CLOSE 0x00000001L
1367#define SQL_BP_DELETE 0x00000002L
1368#define SQL_BP_DROP 0x00000004L
1369#define SQL_BP_TRANSACTION 0x00000008L
1370#define SQL_BP_UPDATE 0x00000010L
1371#define SQL_BP_OTHER_HSTMT 0x00000020L
1372#define SQL_BP_SCROLL 0x00000040L
1373
1374/* SQL_STATIC_SENSITIVITY values */
1375
1376#define SQL_SS_ADDITIONS 0x00000001L
1377#define SQL_SS_DELETIONS 0x00000002L
1378#define SQL_SS_UPDATES 0x00000004L
1379
1380/* SQL_VIEW values */
1381#define SQL_CV_CREATE_VIEW 0x00000001L
1382#define SQL_CV_CHECK_OPTION 0x00000002L
1383#define SQL_CV_CASCADED 0x00000004L
1384#define SQL_CV_LOCAL 0x00000008L
1385
1386/* SQL_LOCK_TYPES masks */
1387
1388#define SQL_LCK_NO_CHANGE 0x00000001L
1389#define SQL_LCK_EXCLUSIVE 0x00000002L
1390#define SQL_LCK_UNLOCK 0x00000004L
1391
1392/* SQL_POS_OPERATIONS masks */
1393
1394#define SQL_POS_POSITION 0x00000001L
1395#define SQL_POS_REFRESH 0x00000002L
1396#define SQL_POS_UPDATE 0x00000004L
1397#define SQL_POS_DELETE 0x00000008L
1398#define SQL_POS_ADD 0x00000010L
1399
1400/* SQL_QUALIFIER_LOCATION values */
1401
1402#define SQL_QL_START 0x0001
1403#define SQL_QL_END 0x0002
1404
1405/* Here start return values for ODBC 3.0 SQLGetInfo */
1406
1407#if (ODBCVER >= 0x0300)
1408/* SQL_AGGREGATE_FUNCTIONS bitmasks */
1409#define SQL_AF_AVG 0x00000001L
1410#define SQL_AF_COUNT 0x00000002L
1411#define SQL_AF_MAX 0x00000004L
1412#define SQL_AF_MIN 0x00000008L
1413#define SQL_AF_SUM 0x00000010L
1414#define SQL_AF_DISTINCT 0x00000020L
1415#define SQL_AF_ALL 0x00000040L
1416
1417/* SQL_SQL_CONFORMANCE bit masks */
1418#define SQL_SC_SQL92_ENTRY 0x00000001L
1419#define SQL_SC_FIPS127_2_TRANSITIONAL 0x00000002L
1420#define SQL_SC_SQL92_INTERMEDIATE 0x00000004L
1421#define SQL_SC_SQL92_FULL 0x00000008L
1422
1423/* SQL_DATETIME_LITERALS masks */
1424#define SQL_DL_SQL92_DATE 0x00000001L
1425#define SQL_DL_SQL92_TIME 0x00000002L
1426#define SQL_DL_SQL92_TIMESTAMP 0x00000004L
1427#define SQL_DL_SQL92_INTERVAL_YEAR 0x00000008L
1428#define SQL_DL_SQL92_INTERVAL_MONTH 0x00000010L
1429#define SQL_DL_SQL92_INTERVAL_DAY 0x00000020L
1430#define SQL_DL_SQL92_INTERVAL_HOUR 0x00000040L
1431#define SQL_DL_SQL92_INTERVAL_MINUTE 0x00000080L
1432#define SQL_DL_SQL92_INTERVAL_SECOND 0x00000100L
1433#define SQL_DL_SQL92_INTERVAL_YEAR_TO_MONTH 0x00000200L
1434#define SQL_DL_SQL92_INTERVAL_DAY_TO_HOUR 0x00000400L
1435#define SQL_DL_SQL92_INTERVAL_DAY_TO_MINUTE 0x00000800L
1436#define SQL_DL_SQL92_INTERVAL_DAY_TO_SECOND 0x00001000L
1437#define SQL_DL_SQL92_INTERVAL_HOUR_TO_MINUTE 0x00002000L
1438#define SQL_DL_SQL92_INTERVAL_HOUR_TO_SECOND 0x00004000L
1439#define SQL_DL_SQL92_INTERVAL_MINUTE_TO_SECOND 0x00008000L
1440
1441/* SQL_CATALOG_LOCATION values */
1442#define SQL_CL_START SQL_QL_START
1443#define SQL_CL_END SQL_QL_END
1444
1445/* values for SQL_BATCH_ROW_COUNT */
1446#define SQL_BRC_PROCEDURES 0x0000001
1447#define SQL_BRC_EXPLICIT 0x0000002
1448#define SQL_BRC_ROLLED_UP 0x0000004
1449
1450/* bitmasks for SQL_BATCH_SUPPORT */
1451#define SQL_BS_SELECT_EXPLICIT 0x00000001L
1452#define SQL_BS_ROW_COUNT_EXPLICIT 0x00000002L
1453#define SQL_BS_SELECT_PROC 0x00000004L
1454#define SQL_BS_ROW_COUNT_PROC 0x00000008L
1455
1456/* Values for SQL_PARAM_ARRAY_ROW_COUNTS getinfo */
1457#define SQL_PARC_BATCH 1
1458#define SQL_PARC_NO_BATCH 2
1459
1460/* values for SQL_PARAM_ARRAY_SELECTS */
1461#define SQL_PAS_BATCH 1
1462#define SQL_PAS_NO_BATCH 2
1463#define SQL_PAS_NO_SELECT 3
1464
1465/* Bitmasks for SQL_INDEX_KEYWORDS */
1466#define SQL_IK_NONE 0x00000000L
1467#define SQL_IK_ASC 0x00000001L
1468#define SQL_IK_DESC 0x00000002L
1469#define SQL_IK_ALL (SQL_IK_ASC | SQL_IK_DESC)
1470
1471/* Bitmasks for SQL_INFO_SCHEMA_VIEWS */
1472
1473#define SQL_ISV_ASSERTIONS 0x00000001L
1474#define SQL_ISV_CHARACTER_SETS 0x00000002L
1475#define SQL_ISV_CHECK_CONSTRAINTS 0x00000004L
1476#define SQL_ISV_COLLATIONS 0x00000008L
1477#define SQL_ISV_COLUMN_DOMAIN_USAGE 0x00000010L
1478#define SQL_ISV_COLUMN_PRIVILEGES 0x00000020L
1479#define SQL_ISV_COLUMNS 0x00000040L
1480#define SQL_ISV_CONSTRAINT_COLUMN_USAGE 0x00000080L
1481#define SQL_ISV_CONSTRAINT_TABLE_USAGE 0x00000100L
1482#define SQL_ISV_DOMAIN_CONSTRAINTS 0x00000200L
1483#define SQL_ISV_DOMAINS 0x00000400L
1484#define SQL_ISV_KEY_COLUMN_USAGE 0x00000800L
1485#define SQL_ISV_REFERENTIAL_CONSTRAINTS 0x00001000L
1486#define SQL_ISV_SCHEMATA 0x00002000L
1487#define SQL_ISV_SQL_LANGUAGES 0x00004000L
1488#define SQL_ISV_TABLE_CONSTRAINTS 0x00008000L
1489#define SQL_ISV_TABLE_PRIVILEGES 0x00010000L
1490#define SQL_ISV_TABLES 0x00020000L
1491#define SQL_ISV_TRANSLATIONS 0x00040000L
1492#define SQL_ISV_USAGE_PRIVILEGES 0x00080000L
1493#define SQL_ISV_VIEW_COLUMN_USAGE 0x00100000L
1494#define SQL_ISV_VIEW_TABLE_USAGE 0x00200000L
1495#define SQL_ISV_VIEWS 0x00400000L
1496
1497/* Bitmasks for SQL_ASYNC_MODE */
1498
1499#define SQL_AM_NONE 0
1500#define SQL_AM_CONNECTION 1
1501#define SQL_AM_STATEMENT 2
1502
1503/* Bitmasks for SQL_ALTER_DOMAIN */
1504#define SQL_AD_CONSTRAINT_NAME_DEFINITION 0x00000001L
1505#define SQL_AD_ADD_DOMAIN_CONSTRAINT 0x00000002L
1506#define SQL_AD_DROP_DOMAIN_CONSTRAINT 0x00000004L
1507#define SQL_AD_ADD_DOMAIN_DEFAULT 0x00000008L
1508#define SQL_AD_DROP_DOMAIN_DEFAULT 0x00000010L
1509#define SQL_AD_ADD_CONSTRAINT_INITIALLY_DEFERRED 0x00000020L
1510#define SQL_AD_ADD_CONSTRAINT_INITIALLY_IMMEDIATE 0x00000040L
1511#define SQL_AD_ADD_CONSTRAINT_DEFERRABLE 0x00000080L
1512#define SQL_AD_ADD_CONSTRAINT_NON_DEFERRABLE 0x00000100L
1513
1514
1515/* SQL_CREATE_SCHEMA bitmasks */
1516#define SQL_CS_CREATE_SCHEMA 0x00000001L
1517#define SQL_CS_AUTHORIZATION 0x00000002L
1518#define SQL_CS_DEFAULT_CHARACTER_SET 0x00000004L
1519
1520/* SQL_CREATE_TRANSLATION bitmasks */
1521#define SQL_CTR_CREATE_TRANSLATION 0x00000001L
1522
1523/* SQL_CREATE_ASSERTION bitmasks */
1524#define SQL_CA_CREATE_ASSERTION 0x00000001L
1525#define SQL_CA_CONSTRAINT_INITIALLY_DEFERRED 0x00000010L
1526#define SQL_CA_CONSTRAINT_INITIALLY_IMMEDIATE 0x00000020L
1527#define SQL_CA_CONSTRAINT_DEFERRABLE 0x00000040L
1528#define SQL_CA_CONSTRAINT_NON_DEFERRABLE 0x00000080L
1529
1530/* SQL_CREATE_CHARACTER_SET bitmasks */
1531#define SQL_CCS_CREATE_CHARACTER_SET 0x00000001L
1532#define SQL_CCS_COLLATE_CLAUSE 0x00000002L
1533#define SQL_CCS_LIMITED_COLLATION 0x00000004L
1534
1535/* SQL_CREATE_COLLATION bitmasks */
1536#define SQL_CCOL_CREATE_COLLATION 0x00000001L
1537
1538/* SQL_CREATE_DOMAIN bitmasks */
1539#define SQL_CDO_CREATE_DOMAIN 0x00000001L
1540#define SQL_CDO_DEFAULT 0x00000002L
1541#define SQL_CDO_CONSTRAINT 0x00000004L
1542#define SQL_CDO_COLLATION 0x00000008L
1543#define SQL_CDO_CONSTRAINT_NAME_DEFINITION 0x00000010L
1544#define SQL_CDO_CONSTRAINT_INITIALLY_DEFERRED 0x00000020L
1545#define SQL_CDO_CONSTRAINT_INITIALLY_IMMEDIATE 0x00000040L
1546#define SQL_CDO_CONSTRAINT_DEFERRABLE 0x00000080L
1547#define SQL_CDO_CONSTRAINT_NON_DEFERRABLE 0x00000100L
1548
1549/* SQL_CREATE_TABLE bitmasks */
1550#define SQL_CT_CREATE_TABLE 0x00000001L
1551#define SQL_CT_COMMIT_PRESERVE 0x00000002L
1552#define SQL_CT_COMMIT_DELETE 0x00000004L
1553#define SQL_CT_GLOBAL_TEMPORARY 0x00000008L
1554#define SQL_CT_LOCAL_TEMPORARY 0x00000010L
1555#define SQL_CT_CONSTRAINT_INITIALLY_DEFERRED 0x00000020L
1556#define SQL_CT_CONSTRAINT_INITIALLY_IMMEDIATE 0x00000040L
1557#define SQL_CT_CONSTRAINT_DEFERRABLE 0x00000080L
1558#define SQL_CT_CONSTRAINT_NON_DEFERRABLE 0x00000100L
1559#define SQL_CT_COLUMN_CONSTRAINT 0x00000200L
1560#define SQL_CT_COLUMN_DEFAULT 0x00000400L
1561#define SQL_CT_COLUMN_COLLATION 0x00000800L
1562#define SQL_CT_TABLE_CONSTRAINT 0x00001000L
1563#define SQL_CT_CONSTRAINT_NAME_DEFINITION 0x00002000L
1564
1565/* SQL_DDL_INDEX bitmasks */
1566#define SQL_DI_CREATE_INDEX 0x00000001L
1567#define SQL_DI_DROP_INDEX 0x00000002L
1568
1569/* SQL_DROP_COLLATION bitmasks */
1570#define SQL_DC_DROP_COLLATION 0x00000001L
1571
1572/* SQL_DROP_DOMAIN bitmasks */
1573#define SQL_DD_DROP_DOMAIN 0x00000001L
1574#define SQL_DD_RESTRICT 0x00000002L
1575#define SQL_DD_CASCADE 0x00000004L
1576
1577/* SQL_DROP_SCHEMA bitmasks */
1578#define SQL_DS_DROP_SCHEMA 0x00000001L
1579#define SQL_DS_RESTRICT 0x00000002L
1580#define SQL_DS_CASCADE 0x00000004L
1581
1582/* SQL_DROP_CHARACTER_SET bitmasks */
1583#define SQL_DCS_DROP_CHARACTER_SET 0x00000001L
1584
1585/* SQL_DROP_ASSERTION bitmasks */
1586#define SQL_DA_DROP_ASSERTION 0x00000001L
1587
1588/* SQL_DROP_TABLE bitmasks */
1589#define SQL_DT_DROP_TABLE 0x00000001L
1590#define SQL_DT_RESTRICT 0x00000002L
1591#define SQL_DT_CASCADE 0x00000004L
1592
1593/* SQL_DROP_TRANSLATION bitmasks */
1594#define SQL_DTR_DROP_TRANSLATION 0x00000001L
1595
1596/* SQL_DROP_VIEW bitmasks */
1597#define SQL_DV_DROP_VIEW 0x00000001L
1598#define SQL_DV_RESTRICT 0x00000002L
1599#define SQL_DV_CASCADE 0x00000004L
1600
1601/* SQL_INSERT_STATEMENT bitmasks */
1602#define SQL_IS_INSERT_LITERALS 0x00000001L
1603#define SQL_IS_INSERT_SEARCHED 0x00000002L
1604#define SQL_IS_SELECT_INTO 0x00000004L
1605
1606/* SQL_ODBC_INTERFACE_CONFORMANCE values */
1607#define SQL_OIC_CORE 1UL
1608#define SQL_OIC_LEVEL1 2UL
1609#define SQL_OIC_LEVEL2 3UL
1610
1611/* SQL_SQL92_FOREIGN_KEY_DELETE_RULE bitmasks */
1612#define SQL_SFKD_CASCADE 0x00000001L
1613#define SQL_SFKD_NO_ACTION 0x00000002L
1614#define SQL_SFKD_SET_DEFAULT 0x00000004L
1615#define SQL_SFKD_SET_NULL 0x00000008L
1616
1617/* SQL_SQL92_FOREIGN_KEY_UPDATE_RULE bitmasks */
1618#define SQL_SFKU_CASCADE 0x00000001L
1619#define SQL_SFKU_NO_ACTION 0x00000002L
1620#define SQL_SFKU_SET_DEFAULT 0x00000004L
1621#define SQL_SFKU_SET_NULL 0x00000008L
1622
1623/* SQL_SQL92_GRANT bitmasks */
1624#define SQL_SG_USAGE_ON_DOMAIN 0x00000001L
1625#define SQL_SG_USAGE_ON_CHARACTER_SET 0x00000002L
1626#define SQL_SG_USAGE_ON_COLLATION 0x00000004L
1627#define SQL_SG_USAGE_ON_TRANSLATION 0x00000008L
1628#define SQL_SG_WITH_GRANT_OPTION 0x00000010L
1629#define SQL_SG_DELETE_TABLE 0x00000020L
1630#define SQL_SG_INSERT_TABLE 0x00000040L
1631#define SQL_SG_INSERT_COLUMN 0x00000080L
1632#define SQL_SG_REFERENCES_TABLE 0x00000100L
1633#define SQL_SG_REFERENCES_COLUMN 0x00000200L
1634#define SQL_SG_SELECT_TABLE 0x00000400L
1635#define SQL_SG_UPDATE_TABLE 0x00000800L
1636#define SQL_SG_UPDATE_COLUMN 0x00001000L
1637
1638/* SQL_SQL92_PREDICATES bitmasks */
1639#define SQL_SP_EXISTS 0x00000001L
1640#define SQL_SP_ISNOTNULL 0x00000002L
1641#define SQL_SP_ISNULL 0x00000004L
1642#define SQL_SP_MATCH_FULL 0x00000008L
1643#define SQL_SP_MATCH_PARTIAL 0x00000010L
1644#define SQL_SP_MATCH_UNIQUE_FULL 0x00000020L
1645#define SQL_SP_MATCH_UNIQUE_PARTIAL 0x00000040L
1646#define SQL_SP_OVERLAPS 0x00000080L
1647#define SQL_SP_UNIQUE 0x00000100L
1648#define SQL_SP_LIKE 0x00000200L
1649#define SQL_SP_IN 0x00000400L
1650#define SQL_SP_BETWEEN 0x00000800L
1651#define SQL_SP_COMPARISON 0x00001000L
1652#define SQL_SP_QUANTIFIED_COMPARISON 0x00002000L
1653
1654/* SQL_SQL92_RELATIONAL_JOIN_OPERATORS bitmasks */
1655#define SQL_SRJO_CORRESPONDING_CLAUSE 0x00000001L
1656#define SQL_SRJO_CROSS_JOIN 0x00000002L
1657#define SQL_SRJO_EXCEPT_JOIN 0x00000004L
1658#define SQL_SRJO_FULL_OUTER_JOIN 0x00000008L
1659#define SQL_SRJO_INNER_JOIN 0x00000010L
1660#define SQL_SRJO_INTERSECT_JOIN 0x00000020L
1661#define SQL_SRJO_LEFT_OUTER_JOIN 0x00000040L
1662#define SQL_SRJO_NATURAL_JOIN 0x00000080L
1663#define SQL_SRJO_RIGHT_OUTER_JOIN 0x00000100L
1664#define SQL_SRJO_UNION_JOIN 0x00000200L
1665
1666/* SQL_SQL92_REVOKE bitmasks */
1667#define SQL_SR_USAGE_ON_DOMAIN 0x00000001L
1668#define SQL_SR_USAGE_ON_CHARACTER_SET 0x00000002L
1669#define SQL_SR_USAGE_ON_COLLATION 0x00000004L
1670#define SQL_SR_USAGE_ON_TRANSLATION 0x00000008L
1671#define SQL_SR_GRANT_OPTION_FOR 0x00000010L
1672#define SQL_SR_CASCADE 0x00000020L
1673#define SQL_SR_RESTRICT 0x00000040L
1674#define SQL_SR_DELETE_TABLE 0x00000080L
1675#define SQL_SR_INSERT_TABLE 0x00000100L
1676#define SQL_SR_INSERT_COLUMN 0x00000200L
1677#define SQL_SR_REFERENCES_TABLE 0x00000400L
1678#define SQL_SR_REFERENCES_COLUMN 0x00000800L
1679#define SQL_SR_SELECT_TABLE 0x00001000L
1680#define SQL_SR_UPDATE_TABLE 0x00002000L
1681#define SQL_SR_UPDATE_COLUMN 0x00004000L
1682
1683/* SQL_SQL92_ROW_VALUE_CONSTRUCTOR bitmasks */
1684#define SQL_SRVC_VALUE_EXPRESSION 0x00000001L
1685#define SQL_SRVC_NULL 0x00000002L
1686#define SQL_SRVC_DEFAULT 0x00000004L
1687#define SQL_SRVC_ROW_SUBQUERY 0x00000008L
1688
1689/* SQL_SQL92_VALUE_EXPRESSIONS bitmasks */
1690#define SQL_SVE_CASE 0x00000001L
1691#define SQL_SVE_CAST 0x00000002L
1692#define SQL_SVE_COALESCE 0x00000004L
1693#define SQL_SVE_NULLIF 0x00000008L
1694
1695/* SQL_STANDARD_CLI_CONFORMANCE bitmasks */
1696#define SQL_SCC_XOPEN_CLI_VERSION1 0x00000001L
1697#define SQL_SCC_ISO92_CLI 0x00000002L
1698
1699/* SQL_UNION_STATEMENT bitmasks */
1700#define SQL_US_UNION SQL_U_UNION
1701#define SQL_US_UNION_ALL SQL_U_UNION_ALL
1702
1703/* values for SQL_DRIVER_AWARE_POOLING_SUPPORTED */
1704#define SQL_DRIVER_AWARE_POOLING_NOT_CAPABLE 0x00000000L
1705#define SQL_DRIVER_AWARE_POOLING_CAPABLE 0x00000001L
1706#endif /* ODBCVER >= 0x0300 */
1707
1708/* SQL_DTC_TRANSITION_COST bitmasks */
1709#define SQL_DTC_ENLIST_EXPENSIVE 0x00000001L
1710#define SQL_DTC_UNENLIST_EXPENSIVE 0x00000002L
1711
1712#if (ODBCVER >= 0x0380)
1713/* possible values for SQL_ASYNC_DBC_FUNCTIONS */
1714#define SQL_ASYNC_DBC_NOT_CAPABLE 0x00000000L
1715#define SQL_ASYNC_DBC_CAPABLE 0x00000001L
1716#endif
1717
1718/* additional SQLDataSources fetch directions */
1719#if (ODBCVER >= 0x0300)
1720#define SQL_FETCH_FIRST_USER 31
1721#define SQL_FETCH_FIRST_SYSTEM 32
1722#endif /* ODBCVER >= 0x0300 */
1723
1724
1725/* Defines for SQLSetPos */
1726#define SQL_ENTIRE_ROWSET 0
1727
1728/* Operations in SQLSetPos */
1729#define SQL_POSITION 0 /* 1.0 FALSE */
1730#define SQL_REFRESH 1 /* 1.0 TRUE */
1731#define SQL_UPDATE 2
1732#define SQL_DELETE 3
1733
1734/* Operations in SQLBulkOperations */
1735#define SQL_ADD 4
1736#define SQL_SETPOS_MAX_OPTION_VALUE SQL_ADD
1737#if (ODBCVER >= 0x0300)
1738#define SQL_UPDATE_BY_BOOKMARK 5
1739#define SQL_DELETE_BY_BOOKMARK 6
1740#define SQL_FETCH_BY_BOOKMARK 7
1741
1742#endif /* ODBCVER >= 0x0300 */
1743
1744/* Lock options in SQLSetPos */
1745#define SQL_LOCK_NO_CHANGE 0 /* 1.0 FALSE */
1746#define SQL_LOCK_EXCLUSIVE 1 /* 1.0 TRUE */
1747#define SQL_LOCK_UNLOCK 2
1748
1749#define SQL_SETPOS_MAX_LOCK_VALUE SQL_LOCK_UNLOCK
1750
1751/* Macros for SQLSetPos */
1752#define SQL_POSITION_TO(hstmt,irow) SQLSetPos(hstmt,irow,SQL_POSITION,SQL_LOCK_NO_CHANGE)
1753#define SQL_LOCK_RECORD(hstmt,irow,fLock) SQLSetPos(hstmt,irow,SQL_POSITION,fLock)
1754#define SQL_REFRESH_RECORD(hstmt,irow,fLock) SQLSetPos(hstmt,irow,SQL_REFRESH,fLock)
1755#define SQL_UPDATE_RECORD(hstmt,irow) SQLSetPos(hstmt,irow,SQL_UPDATE,SQL_LOCK_NO_CHANGE)
1756#define SQL_DELETE_RECORD(hstmt,irow) SQLSetPos(hstmt,irow,SQL_DELETE,SQL_LOCK_NO_CHANGE)
1757#define SQL_ADD_RECORD(hstmt,irow) SQLSetPos(hstmt,irow,SQL_ADD,SQL_LOCK_NO_CHANGE)
1758
1759/* Column types and scopes in SQLSpecialColumns. */
1760#define SQL_BEST_ROWID 1
1761#define SQL_ROWVER 2
1762
1763/* Defines for SQLSpecialColumns (returned in the result set)
1764 SQL_PC_UNKNOWN and SQL_PC_PSEUDO are defined in sql.h */
1765#define SQL_PC_NOT_PSEUDO 1
1766
1767/* Defines for SQLStatistics */
1768#define SQL_QUICK 0
1769#define SQL_ENSURE 1
1770
1771/* Defines for SQLStatistics (returned in the result set)
1772 SQL_INDEX_CLUSTERED, SQL_INDEX_HASHED, and SQL_INDEX_OTHER are
1773 defined in sql.h */
1774#define SQL_TABLE_STAT 0
1775
1776
1777/* Defines for SQLTables */
1778#if (ODBCVER >= 0x0300)
1779#define SQL_ALL_CATALOGS "%"
1780#define SQL_ALL_SCHEMAS "%"
1781#define SQL_ALL_TABLE_TYPES "%"
1782#endif /* ODBCVER >= 0x0300 */
1783
1784/* Options for SQLDriverConnect */
1785#define SQL_DRIVER_NOPROMPT 0
1786#define SQL_DRIVER_COMPLETE 1
1787#define SQL_DRIVER_PROMPT 2
1788#define SQL_DRIVER_COMPLETE_REQUIRED 3
1789
1790SQLRETURN SQL_API SQLDriverConnect(
1791 SQLHDBC hdbc,
1792 SQLHWND hwnd,
1793 SQLCHAR *szConnStrIn,
1794 SQLSMALLINT cbConnStrIn,
1795 SQLCHAR *szConnStrOut,
1796 SQLSMALLINT cbConnStrOutMax,
1797 SQLSMALLINT *pcbConnStrOut,
1798 SQLUSMALLINT fDriverCompletion);
1799
1800/* Level 2 Functions */
1801
1802/* SQLExtendedFetch "fFetchType" values */
1803#define SQL_FETCH_BOOKMARK 8
1804
1805/* SQLExtendedFetch "rgfRowStatus" element values */
1806#define SQL_ROW_SUCCESS 0
1807#define SQL_ROW_DELETED 1
1808#define SQL_ROW_UPDATED 2
1809#define SQL_ROW_NOROW 3
1810#define SQL_ROW_ADDED 4
1811#define SQL_ROW_ERROR 5
1812#if (ODBCVER >= 0x0300)
1813#define SQL_ROW_SUCCESS_WITH_INFO 6
1814#define SQL_ROW_PROCEED 0
1815#define SQL_ROW_IGNORE 1
1816#endif
1817
1818/* value for SQL_DESC_ARRAY_STATUS_PTR */
1819#if (ODBCVER >= 0x0300)
1820#define SQL_PARAM_SUCCESS 0
1821#define SQL_PARAM_SUCCESS_WITH_INFO 6
1822#define SQL_PARAM_ERROR 5
1823#define SQL_PARAM_UNUSED 7
1824#define SQL_PARAM_DIAG_UNAVAILABLE 1
1825
1826#define SQL_PARAM_PROCEED 0
1827#define SQL_PARAM_IGNORE 1
1828#endif /* ODBCVER >= 0x0300 */
1829
1830/* Defines for SQLForeignKeys (UPDATE_RULE and DELETE_RULE) */
1831#define SQL_CASCADE 0
1832#define SQL_RESTRICT 1
1833#define SQL_SET_NULL 2
1834#if (ODBCVER >= 0x0250)
1835#define SQL_NO_ACTION 3
1836#define SQL_SET_DEFAULT 4
1837#endif /* ODBCVER >= 0x0250 */
1838
1839#if (ODBCVER >= 0x0300)
1840/* Note that the following are in a different column of SQLForeignKeys than */
1841/* the previous #defines. These are for DEFERRABILITY. */
1842
1843#define SQL_INITIALLY_DEFERRED 5
1844#define SQL_INITIALLY_IMMEDIATE 6
1845#define SQL_NOT_DEFERRABLE 7
1846
1847#endif /* ODBCVER >= 0x0300 */
1848
1849/* Defines for SQLBindParameter and
1850 SQLProcedureColumns (returned in the result set) */
1851#define SQL_PARAM_TYPE_UNKNOWN 0
1852#define SQL_PARAM_INPUT 1
1853#define SQL_PARAM_INPUT_OUTPUT 2
1854#define SQL_RESULT_COL 3
1855#define SQL_PARAM_OUTPUT 4
1856#define SQL_RETURN_VALUE 5
1857#if (ODBCVER >= 0x0380)
1858 #define SQL_PARAM_INPUT_OUTPUT_STREAM 8
1859 #define SQL_PARAM_OUTPUT_STREAM 16
1860#endif
1861
1862
1863/* Defines for SQLProcedures (returned in the result set) */
1864#define SQL_PT_UNKNOWN 0
1865#define SQL_PT_PROCEDURE 1
1866#define SQL_PT_FUNCTION 2
1867
1868/* This define is too large for RC */
1869#define SQL_ODBC_KEYWORDS "ABSOLUTE,ACTION,ADA,ADD,ALL,ALLOCATE,ALTER,AND,ANY,ARE,AS,"\
1870"ASC,ASSERTION,AT,AUTHORIZATION,AVG,"\
1871"BEGIN,BETWEEN,BIT,BIT_LENGTH,BOTH,BY,CASCADE,CASCADED,CASE,CAST,CATALOG,"\
1872"CHAR,CHAR_LENGTH,CHARACTER,CHARACTER_LENGTH,CHECK,CLOSE,COALESCE,"\
1873"COLLATE,COLLATION,COLUMN,COMMIT,CONNECT,CONNECTION,CONSTRAINT,"\
1874"CONSTRAINTS,CONTINUE,CONVERT,CORRESPONDING,COUNT,CREATE,CROSS,CURRENT,"\
1875"CURRENT_DATE,CURRENT_TIME,CURRENT_TIMESTAMP,CURRENT_USER,CURSOR,"\
1876"DATE,DAY,DEALLOCATE,DEC,DECIMAL,DECLARE,DEFAULT,DEFERRABLE,"\
1877"DEFERRED,DELETE,DESC,DESCRIBE,DESCRIPTOR,DIAGNOSTICS,DISCONNECT,"\
1878"DISTINCT,DOMAIN,DOUBLE,DROP,"\
1879"ELSE,END,END-EXEC,ESCAPE,EXCEPT,EXCEPTION,EXEC,EXECUTE,"\
1880"EXISTS,EXTERNAL,EXTRACT,"\
1881"FALSE,FETCH,FIRST,FLOAT,FOR,FOREIGN,FORTRAN,FOUND,FROM,FULL,"\
1882"GET,GLOBAL,GO,GOTO,GRANT,GROUP,HAVING,HOUR,"\
1883"IDENTITY,IMMEDIATE,IN,INCLUDE,INDEX,INDICATOR,INITIALLY,INNER,"\
1884"INPUT,INSENSITIVE,INSERT,INT,INTEGER,INTERSECT,INTERVAL,INTO,IS,ISOLATION,"\
1885"JOIN,KEY,LANGUAGE,LAST,LEADING,LEFT,LEVEL,LIKE,LOCAL,LOWER,"\
1886"MATCH,MAX,MIN,MINUTE,MODULE,MONTH,"\
1887"NAMES,NATIONAL,NATURAL,NCHAR,NEXT,NO,NONE,NOT,NULL,NULLIF,NUMERIC,"\
1888"OCTET_LENGTH,OF,ON,ONLY,OPEN,OPTION,OR,ORDER,OUTER,OUTPUT,OVERLAPS,"\
1889"PAD,PARTIAL,PASCAL,PLI,POSITION,PRECISION,PREPARE,PRESERVE,"\
1890"PRIMARY,PRIOR,PRIVILEGES,PROCEDURE,PUBLIC,"\
1891"READ,REAL,REFERENCES,RELATIVE,RESTRICT,REVOKE,RIGHT,ROLLBACK,ROWS"\
1892"SCHEMA,SCROLL,SECOND,SECTION,SELECT,SESSION,SESSION_USER,SET,SIZE,"\
1893"SMALLINT,SOME,SPACE,SQL,SQLCA,SQLCODE,SQLERROR,SQLSTATE,SQLWARNING,"\
1894"SUBSTRING,SUM,SYSTEM_USER,"\
1895"TABLE,TEMPORARY,THEN,TIME,TIMESTAMP,TIMEZONE_HOUR,TIMEZONE_MINUTE,"\
1896"TO,TRAILING,TRANSACTION,TRANSLATE,TRANSLATION,TRIM,TRUE,"\
1897"UNION,UNIQUE,UNKNOWN,UPDATE,UPPER,USAGE,USER,USING,"\
1898"VALUE,VALUES,VARCHAR,VARYING,VIEW,WHEN,WHENEVER,WHERE,WITH,WORK,WRITE,"\
1899"YEAR,ZONE"
1900
1901SQLRETURN SQL_API SQLBrowseConnect(
1902 SQLHDBC hdbc,
1903 SQLCHAR *szConnStrIn,
1904 SQLSMALLINT cbConnStrIn,
1905 SQLCHAR *szConnStrOut,
1906 SQLSMALLINT cbConnStrOutMax,
1907 SQLSMALLINT *pcbConnStrOut);
1908
1909#if (ODBCVER >= 0x0300)
1910SQLRETURN SQL_API SQLBulkOperations(
1911 SQLHSTMT StatementHandle,
1912 SQLSMALLINT Operation);
1913#endif /* ODBCVER >= 0x0300 */
1914
1915SQLRETURN SQL_API SQLColAttributes(
1916 SQLHSTMT hstmt,
1917 SQLUSMALLINT icol,
1918 SQLUSMALLINT fDescType,
1919 SQLPOINTER rgbDesc,
1920 SQLSMALLINT cbDescMax,
1921 SQLSMALLINT *pcbDesc,
1922 SQLLEN *pfDesc);
1923
1924SQLRETURN SQL_API SQLColumnPrivileges(
1925 SQLHSTMT hstmt,
1926 SQLCHAR *szCatalogName,
1927 SQLSMALLINT cbCatalogName,
1928 SQLCHAR *szSchemaName,
1929 SQLSMALLINT cbSchemaName,
1930 SQLCHAR *szTableName,
1931 SQLSMALLINT cbTableName,
1932 SQLCHAR *szColumnName,
1933 SQLSMALLINT cbColumnName);
1934
1935SQLRETURN SQL_API SQLDescribeParam(
1936 SQLHSTMT hstmt,
1937 SQLUSMALLINT ipar,
1938 SQLSMALLINT *pfSqlType,
1939 SQLULEN *pcbParamDef,
1940 SQLSMALLINT *pibScale,
1941 SQLSMALLINT *pfNullable);
1942
1943SQLRETURN SQL_API SQLExtendedFetch(
1944 SQLHSTMT hstmt,
1945 SQLUSMALLINT fFetchType,
1946 SQLLEN irow,
1947 SQLULEN *pcrow,
1948 SQLUSMALLINT *rgfRowStatus);
1949
1950SQLRETURN SQL_API SQLForeignKeys(
1951 SQLHSTMT hstmt,
1952 SQLCHAR *szPkCatalogName,
1953 SQLSMALLINT cbPkCatalogName,
1954 SQLCHAR *szPkSchemaName,
1955 SQLSMALLINT cbPkSchemaName,
1956 SQLCHAR *szPkTableName,
1957 SQLSMALLINT cbPkTableName,
1958 SQLCHAR *szFkCatalogName,
1959 SQLSMALLINT cbFkCatalogName,
1960 SQLCHAR *szFkSchemaName,
1961 SQLSMALLINT cbFkSchemaName,
1962 SQLCHAR *szFkTableName,
1963 SQLSMALLINT cbFkTableName);
1964
1965SQLRETURN SQL_API SQLMoreResults(
1966 SQLHSTMT hstmt);
1967
1968SQLRETURN SQL_API SQLNativeSql(
1969 SQLHDBC hdbc,
1970 SQLCHAR *szSqlStrIn,
1971 SQLINTEGER cbSqlStrIn,
1972 SQLCHAR *szSqlStr,
1973 SQLINTEGER cbSqlStrMax,
1974 SQLINTEGER *pcbSqlStr);
1975
1976SQLRETURN SQL_API SQLNumParams(
1977 SQLHSTMT hstmt,
1978 SQLSMALLINT *pcpar);
1979
1980SQLRETURN SQL_API SQLParamOptions(
1981 SQLHSTMT hstmt,
1982 SQLULEN crow,
1983 SQLULEN *pirow);
1984
1985SQLRETURN SQL_API SQLPrimaryKeys(
1986 SQLHSTMT hstmt,
1987 SQLCHAR *szCatalogName,
1988 SQLSMALLINT cbCatalogName,
1989 SQLCHAR *szSchemaName,
1990 SQLSMALLINT cbSchemaName,
1991 SQLCHAR *szTableName,
1992 SQLSMALLINT cbTableName);
1993
1994SQLRETURN SQL_API SQLProcedureColumns(
1995 SQLHSTMT hstmt,
1996 SQLCHAR *szCatalogName,
1997 SQLSMALLINT cbCatalogName,
1998 SQLCHAR *szSchemaName,
1999 SQLSMALLINT cbSchemaName,
2000 SQLCHAR *szProcName,
2001 SQLSMALLINT cbProcName,
2002 SQLCHAR *szColumnName,
2003 SQLSMALLINT cbColumnName);
2004
2005SQLRETURN SQL_API SQLProcedures(
2006 SQLHSTMT hstmt,
2007 SQLCHAR *szCatalogName,
2008 SQLSMALLINT cbCatalogName,
2009 SQLCHAR *szSchemaName,
2010 SQLSMALLINT cbSchemaName,
2011 SQLCHAR *szProcName,
2012 SQLSMALLINT cbProcName);
2013
2014SQLRETURN SQL_API SQLSetPos(
2015 SQLHSTMT hstmt,
2016 SQLSETPOSIROW irow,
2017 SQLUSMALLINT fOption,
2018 SQLUSMALLINT fLock);
2019
2020SQLRETURN SQL_API SQLTablePrivileges(
2021 SQLHSTMT hstmt,
2022 SQLCHAR *szCatalogName,
2023 SQLSMALLINT cbCatalogName,
2024 SQLCHAR *szSchemaName,
2025 SQLSMALLINT cbSchemaName,
2026 SQLCHAR *szTableName,
2027 SQLSMALLINT cbTableName);
2028
2029SQLRETURN SQL_API SQLDrivers(
2030 SQLHENV henv,
2031 SQLUSMALLINT fDirection,
2032 SQLCHAR *szDriverDesc,
2033 SQLSMALLINT cbDriverDescMax,
2034 SQLSMALLINT *pcbDriverDesc,
2035 SQLCHAR *szDriverAttributes,
2036 SQLSMALLINT cbDrvrAttrMax,
2037 SQLSMALLINT *pcbDrvrAttr);
2038
2039SQLRETURN SQL_API SQLBindParameter(
2040 SQLHSTMT hstmt,
2041 SQLUSMALLINT ipar,
2042 SQLSMALLINT fParamType,
2043 SQLSMALLINT fCType,
2044 SQLSMALLINT fSqlType,
2045 SQLULEN cbColDef,
2046 SQLSMALLINT ibScale,
2047 SQLPOINTER rgbValue,
2048 SQLLEN cbValueMax,
2049 SQLLEN *pcbValue);
2050
2051/*---------------------------------------------------------*/
2052/* SQLAllocHandleStd is implemented to make SQLAllocHandle */
2053/* compatible with X/Open standard. an application should */
2054/* not call SQLAllocHandleStd directly */
2055/*---------------------------------------------------------*/
2056#ifdef ODBC_STD
2057#define SQLAllocHandle SQLAllocHandleStd
2058#define SQLAllocEnv(phenv) SQLAllocHandleStd(SQL_HANDLE_ENV, SQL_NULL_HANDLE, phenv)
2059
2060/* Internal type subcodes */
2061#define SQL_YEAR SQL_CODE_YEAR
2062#define SQL_MONTH SQL_CODE_MONTH
2063#define SQL_DAY SQL_CODE_DAY
2064#define SQL_HOUR SQL_CODE_HOUR
2065#define SQL_MINUTE SQL_CODE_MINUTE
2066#define SQL_SECOND SQL_CODE_SECOND
2067#define SQL_YEAR_TO_MONTH SQL_CODE_YEAR_TO_MONTH
2068#define SQL_DAY_TO_HOUR SQL_CODE_DAY_TO_HOUR
2069#define SQL_DAY_TO_MINUTE SQL_CODE_DAY_TO_MINUTE
2070#define SQL_DAY_TO_SECOND SQL_CODE_DAY_TO_SECOND
2071#define SQL_HOUR_TO_MINUTE SQL_CODE_HOUR_TO_MINUTE
2072#define SQL_HOUR_TO_SECOND SQL_CODE_HOUR_TO_SECOND
2073#define SQL_MINUTE_TO_SECOND SQL_CODE_MINUTE_TO_SECOND
2074#endif /* ODBC_STD */
2075
2076#if (ODBCVER >= 0x0300)
2077SQLRETURN SQL_API SQLAllocHandleStd(
2078 SQLSMALLINT fHandleType,
2079 SQLHANDLE hInput,
2080 SQLHANDLE *phOutput);
2081#endif
2082
2083/* Deprecated defines from prior versions of ODBC */
2084#define SQL_DATABASE_NAME 16 /* Use SQLGetConnectOption/SQL_CURRENT_QUALIFIER */
2085#define SQL_FD_FETCH_PREV SQL_FD_FETCH_PRIOR
2086#define SQL_FETCH_PREV SQL_FETCH_PRIOR
2087#define SQL_CONCUR_TIMESTAMP SQL_CONCUR_ROWVER
2088#define SQL_SCCO_OPT_TIMESTAMP SQL_SCCO_OPT_ROWVER
2089#define SQL_CC_DELETE SQL_CB_DELETE
2090#define SQL_CR_DELETE SQL_CB_DELETE
2091#define SQL_CC_CLOSE SQL_CB_CLOSE
2092#define SQL_CR_CLOSE SQL_CB_CLOSE
2093#define SQL_CC_PRESERVE SQL_CB_PRESERVE
2094#define SQL_CR_PRESERVE SQL_CB_PRESERVE
2095/* SQL_FETCH_RESUME is not supported by 2.0+ drivers
2096#define SQL_FETCH_RESUME 7
2097*/
2098#define SQL_SCROLL_FORWARD_ONLY 0L /*-SQL_CURSOR_FORWARD_ONLY */
2099#define SQL_SCROLL_KEYSET_DRIVEN (-1L) /*-SQL_CURSOR_KEYSET_DRIVEN */
2100#define SQL_SCROLL_DYNAMIC (-2L) /*-SQL_CURSOR_DYNAMIC */
2101#define SQL_SCROLL_STATIC (-3L) /*-SQL_CURSOR_STATIC */
2102
2103/* Deprecated functions from prior versions of ODBC */
2104SQLRETURN SQL_API SQLSetScrollOptions( /* Use SQLSetStmtOptions */
2105 SQLHSTMT hstmt,
2106 SQLUSMALLINT fConcurrency,
2107 SQLLEN crowKeyset,
2108 SQLUSMALLINT crowRowset);
2109
2110/*!
2111 * \defgroup Tracing.
2112 *
2113 * unixODBC implements a slight variation of the tracing mechanism used
2114 * on MS platforms. The unixODBC method loses the ability to produce trace
2115 * output for invalid handles but gains the following;
2116 *
2117 * - better concurrency
2118 * - allows tracing to be turned on/off and configured at finer granularity
2119 * - hopefully; better performance
2120 *
2121 * unixODBC provides a cross-platform helper library called 'trace' and an
2122 * example/default trace plugin called 'odbctrac'. Those writing an ODBC
2123 * driver can use the 'trace' helper library (a static library). Those wanting
2124 * to create custom trace output can implement a different version of the
2125 * 'odbctrac' plugin.
2126 *
2127 * The text file driver (odbctxt) included with unixODBC is an example of a
2128 * driver using the 'trace' helper library.
2129 *
2130 * The 'trace' library and the example plugin 'odbctrac' are designed to be
2131 * portable on all platforms where unixODBC is available and on MS platforms.
2132 * This will allow drivers using 'trace' and 'odbctrac' plugin to equilly
2133 * portable. On MS platforms - this compliments traditional tracing (mostly
2134 * just used by the Driver Manager).
2135 *
2136 * \sa trace
2137 * odbctxt
2138 * odbctrac
2139 */
2140/*@{*/
2141#define TRACE_VERSION 1000 /*!< Version of trace API */
2142#ifdef UNICODE
2143RETCODE TraceOpenLogFile(SQLPOINTER,LPWSTR,LPWSTR,DWORD); /*!< open a trace log file */
2144#else
2145RETCODE TraceOpenLogFile(SQLPOINTER,LPSTR,LPSTR,DWORD); /*!< open a trace log file */
2146#endif
2147RETCODE TraceCloseLogFile(SQLPOINTER); /*!< Request to close a trace log */
2148SQLRETURN TraceReturn(SQLPOINTER,SQLRETURN); /*!< Call to produce trace output upon function return. */
2149DWORD TraceVersion(void); /*!< Returns trace API version */
2150
2151/* Functions for Visual Studio Analyzer*/
2152/* to turn on/off tracing or VS events, call TraceVSControl by setting or clearing the following bits */
2153#define TRACE_ON 0x00000001L
2154#define TRACE_VS_EVENT_ON 0x00000002L
2155
2156RETCODE TraceVSControl(DWORD);
2157
2158/* the flags in ODBC_VS_ARGS */
2159#define ODBC_VS_FLAG_UNICODE_ARG 0x00000001L /* the argument is unicode */
2160#define ODBC_VS_FLAG_UNICODE_COR 0x00000002L /* the correlation is unicode */
2161#define ODBC_VS_FLAG_RETCODE 0x00000004L /* RetCode field is set */
2162#define ODBC_VS_FLAG_STOP 0x00000008L /* Stop firing visual studio analyzer events */
2163
2164typedef struct tagODBC_VS_ARGS {
2165#ifdef GUID_DEFINED
2166 const GUID *pguidEvent; /* the GUID for event */
2167#else
2168 const void *pguidEvent; /* the GUID for event */
2169#endif
2170 DWORD dwFlags; /* flags for the call */
2171 union {
2172 WCHAR *wszArg;
2173 CHAR *szArg;
2174 }u1;
2175 union {
2176 WCHAR *wszCorrelation;
2177 CHAR *szCorrelation;
2178 }u2;
2179 RETCODE RetCode;
2180} ODBC_VS_ARGS, *PODBC_VS_ARGS;
2181
2182void FireVSDebugEvent(PODBC_VS_ARGS);
2183/*@}*/
2184
2185#ifdef __cplusplus
2186}
2187#endif
2188
2189/*
2190 * connection pooling retry times
2191 */
2192
2193BOOL ODBCSetTryWaitValue ( DWORD dwValue );
2194#ifdef __cplusplus
2195DWORD ODBCGetTryWaitValue ( );
2196#else
2197DWORD ODBCGetTryWaitValue ( void );
2198#endif
2199
2200#ifndef __SQLUCODE_H
2201#include "sqlucode.h"
2202#endif
2203
2204#endif
2205

source code of include/sqlext.h