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 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 >= 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 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 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 | |
1790 | SQLRETURN 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 | |
1901 | SQLRETURN 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) |
1910 | SQLRETURN SQL_API SQLBulkOperations( |
1911 | SQLHSTMT StatementHandle, |
1912 | SQLSMALLINT Operation); |
1913 | #endif /* ODBCVER >= 0x0300 */ |
1914 | |
1915 | SQLRETURN 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 | |
1924 | SQLRETURN 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 | |
1935 | SQLRETURN SQL_API SQLDescribeParam( |
1936 | SQLHSTMT hstmt, |
1937 | SQLUSMALLINT ipar, |
1938 | SQLSMALLINT *pfSqlType, |
1939 | SQLULEN *pcbParamDef, |
1940 | SQLSMALLINT *pibScale, |
1941 | SQLSMALLINT *pfNullable); |
1942 | |
1943 | SQLRETURN SQL_API SQLExtendedFetch( |
1944 | SQLHSTMT hstmt, |
1945 | SQLUSMALLINT fFetchType, |
1946 | SQLLEN irow, |
1947 | SQLULEN *pcrow, |
1948 | SQLUSMALLINT *rgfRowStatus); |
1949 | |
1950 | SQLRETURN 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 | |
1965 | SQLRETURN SQL_API SQLMoreResults( |
1966 | SQLHSTMT hstmt); |
1967 | |
1968 | SQLRETURN SQL_API SQLNativeSql( |
1969 | SQLHDBC hdbc, |
1970 | SQLCHAR *szSqlStrIn, |
1971 | SQLINTEGER cbSqlStrIn, |
1972 | SQLCHAR *szSqlStr, |
1973 | SQLINTEGER cbSqlStrMax, |
1974 | SQLINTEGER *pcbSqlStr); |
1975 | |
1976 | SQLRETURN SQL_API SQLNumParams( |
1977 | SQLHSTMT hstmt, |
1978 | SQLSMALLINT *pcpar); |
1979 | |
1980 | SQLRETURN SQL_API SQLParamOptions( |
1981 | SQLHSTMT hstmt, |
1982 | SQLULEN crow, |
1983 | SQLULEN *pirow); |
1984 | |
1985 | SQLRETURN 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 | |
1994 | SQLRETURN 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 | |
2005 | SQLRETURN 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 | |
2014 | SQLRETURN SQL_API SQLSetPos( |
2015 | SQLHSTMT hstmt, |
2016 | SQLSETPOSIROW irow, |
2017 | SQLUSMALLINT fOption, |
2018 | SQLUSMALLINT fLock); |
2019 | |
2020 | SQLRETURN 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 | |
2029 | SQLRETURN 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 | |
2039 | SQLRETURN 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) |
2077 | SQLRETURN 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 */ |
2104 | SQLRETURN 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 |
2143 | RETCODE TraceOpenLogFile(SQLPOINTER,LPWSTR,LPWSTR,DWORD); /*!< open a trace log file */ |
2144 | #else |
2145 | RETCODE TraceOpenLogFile(SQLPOINTER,LPSTR,LPSTR,DWORD); /*!< open a trace log file */ |
2146 | #endif |
2147 | RETCODE TraceCloseLogFile(SQLPOINTER); /*!< Request to close a trace log */ |
2148 | SQLRETURN TraceReturn(SQLPOINTER,SQLRETURN); /*!< Call to produce trace output upon function return. */ |
2149 | DWORD 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 | |
2156 | RETCODE 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 | |
2164 | typedef 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 | |
2182 | void FireVSDebugEvent(PODBC_VS_ARGS); |
2183 | /*@}*/ |
2184 | |
2185 | #ifdef __cplusplus |
2186 | } |
2187 | #endif |
2188 | |
2189 | /* |
2190 | * connection pooling retry times |
2191 | */ |
2192 | |
2193 | BOOL ODBCSetTryWaitValue ( DWORD dwValue ); |
2194 | #ifdef __cplusplus |
2195 | DWORD ODBCGetTryWaitValue ( ); |
2196 | #else |
2197 | DWORD ODBCGetTryWaitValue ( void ); |
2198 | #endif |
2199 | |
2200 | #ifndef __SQLUCODE_H |
2201 | #include "sqlucode.h" |
2202 | #endif |
2203 | |
2204 | #endif |
2205 | |