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