1 | /**
|
---|
2 | * This file has no copyright assigned and is placed in the Public Domain.
|
---|
3 | * This file is part of the mingw-w64 runtime package.
|
---|
4 | * No warranty is given; refer to the file DISCLAIMER.PD within this package.
|
---|
5 | */
|
---|
6 | #ifndef __SQL
|
---|
7 | #define __SQL
|
---|
8 |
|
---|
9 | #ifndef ODBCVER
|
---|
10 | #define ODBCVER 0x0351
|
---|
11 | #endif
|
---|
12 |
|
---|
13 | #include <sqltypes.h>
|
---|
14 |
|
---|
15 | #ifdef __cplusplus
|
---|
16 | extern "C" {
|
---|
17 | #endif
|
---|
18 |
|
---|
19 | #define SQL_NULL_DATA (-1)
|
---|
20 | #define SQL_DATA_AT_EXEC (-2)
|
---|
21 |
|
---|
22 | #define SQL_SUCCESS 0
|
---|
23 | #define SQL_SUCCESS_WITH_INFO 1
|
---|
24 | #if (ODBCVER >= 0x0300)
|
---|
25 | #define SQL_NO_DATA 100
|
---|
26 | #endif
|
---|
27 | #define SQL_ERROR (-1)
|
---|
28 | #define SQL_INVALID_HANDLE (-2)
|
---|
29 |
|
---|
30 | #define SQL_STILL_EXECUTING 2
|
---|
31 | #define SQL_NEED_DATA 99
|
---|
32 |
|
---|
33 | #define SQL_SUCCEEDED(rc) (((rc)&(~1))==0)
|
---|
34 |
|
---|
35 | #define SQL_NTS (-3)
|
---|
36 | #define SQL_NTSL (__MSABI_LONG(-3))
|
---|
37 |
|
---|
38 | #define SQL_MAX_MESSAGE_LENGTH 512
|
---|
39 |
|
---|
40 | #if (ODBCVER >= 0x0300)
|
---|
41 | #define SQL_DATE_LEN 10
|
---|
42 | #define SQL_TIME_LEN 8
|
---|
43 | #define SQL_TIMESTAMP_LEN 19
|
---|
44 | #endif
|
---|
45 |
|
---|
46 | #if (ODBCVER >= 0x0300)
|
---|
47 | #define SQL_HANDLE_ENV 1
|
---|
48 | #define SQL_HANDLE_DBC 2
|
---|
49 | #define SQL_HANDLE_STMT 3
|
---|
50 | #define SQL_HANDLE_DESC 4
|
---|
51 | #endif
|
---|
52 |
|
---|
53 | #if (ODBCVER >= 0x0300)
|
---|
54 | #define SQL_ATTR_OUTPUT_NTS 10001
|
---|
55 | #endif
|
---|
56 |
|
---|
57 | #if (ODBCVER >= 0x0300)
|
---|
58 | #define SQL_ATTR_AUTO_IPD 10001
|
---|
59 | #define SQL_ATTR_METADATA_ID 10014
|
---|
60 | #endif
|
---|
61 |
|
---|
62 | #if (ODBCVER >= 0x0300)
|
---|
63 | #define SQL_ATTR_APP_ROW_DESC 10010
|
---|
64 | #define SQL_ATTR_APP_PARAM_DESC 10011
|
---|
65 | #define SQL_ATTR_IMP_ROW_DESC 10012
|
---|
66 | #define SQL_ATTR_IMP_PARAM_DESC 10013
|
---|
67 | #define SQL_ATTR_CURSOR_SCROLLABLE (-1)
|
---|
68 | #define SQL_ATTR_CURSOR_SENSITIVITY (-2)
|
---|
69 | #endif
|
---|
70 |
|
---|
71 | #if (ODBCVER >= 0x0300)
|
---|
72 | #define SQL_NONSCROLLABLE 0
|
---|
73 | #define SQL_SCROLLABLE 1
|
---|
74 | #endif
|
---|
75 |
|
---|
76 | #if (ODBCVER >= 0x0300)
|
---|
77 | #define SQL_DESC_COUNT 1001
|
---|
78 | #define SQL_DESC_TYPE 1002
|
---|
79 | #define SQL_DESC_LENGTH 1003
|
---|
80 | #define SQL_DESC_OCTET_LENGTH_PTR 1004
|
---|
81 | #define SQL_DESC_PRECISION 1005
|
---|
82 | #define SQL_DESC_SCALE 1006
|
---|
83 | #define SQL_DESC_DATETIME_INTERVAL_CODE 1007
|
---|
84 | #define SQL_DESC_NULLABLE 1008
|
---|
85 | #define SQL_DESC_INDICATOR_PTR 1009
|
---|
86 | #define SQL_DESC_DATA_PTR 1010
|
---|
87 | #define SQL_DESC_NAME 1011
|
---|
88 | #define SQL_DESC_UNNAMED 1012
|
---|
89 | #define SQL_DESC_OCTET_LENGTH 1013
|
---|
90 | #define SQL_DESC_ALLOC_TYPE 1099
|
---|
91 | #endif
|
---|
92 |
|
---|
93 | #if (ODBCVER >= 0x0300)
|
---|
94 | #define SQL_DIAG_RETURNCODE 1
|
---|
95 | #define SQL_DIAG_NUMBER 2
|
---|
96 | #define SQL_DIAG_ROW_COUNT 3
|
---|
97 | #define SQL_DIAG_SQLSTATE 4
|
---|
98 | #define SQL_DIAG_NATIVE 5
|
---|
99 | #define SQL_DIAG_MESSAGE_TEXT 6
|
---|
100 | #define SQL_DIAG_DYNAMIC_FUNCTION 7
|
---|
101 | #define SQL_DIAG_CLASS_ORIGIN 8
|
---|
102 | #define SQL_DIAG_SUBCLASS_ORIGIN 9
|
---|
103 | #define SQL_DIAG_CONNECTION_NAME 10
|
---|
104 | #define SQL_DIAG_SERVER_NAME 11
|
---|
105 | #define SQL_DIAG_DYNAMIC_FUNCTION_CODE 12
|
---|
106 | #endif
|
---|
107 |
|
---|
108 | #if (ODBCVER >= 0x0300)
|
---|
109 | #define SQL_DIAG_ALTER_DOMAIN 3
|
---|
110 | #define SQL_DIAG_ALTER_TABLE 4
|
---|
111 | #define SQL_DIAG_CALL 7
|
---|
112 | #define SQL_DIAG_CREATE_ASSERTION 6
|
---|
113 | #define SQL_DIAG_CREATE_CHARACTER_SET 8
|
---|
114 | #define SQL_DIAG_CREATE_COLLATION 10
|
---|
115 | #define SQL_DIAG_CREATE_DOMAIN 23
|
---|
116 | #define SQL_DIAG_CREATE_INDEX (-1)
|
---|
117 | #define SQL_DIAG_CREATE_SCHEMA 64
|
---|
118 | #define SQL_DIAG_CREATE_TABLE 77
|
---|
119 | #define SQL_DIAG_CREATE_TRANSLATION 79
|
---|
120 | #define SQL_DIAG_CREATE_VIEW 84
|
---|
121 | #define SQL_DIAG_DELETE_WHERE 19
|
---|
122 | #define SQL_DIAG_DROP_ASSERTION 24
|
---|
123 | #define SQL_DIAG_DROP_CHARACTER_SET 25
|
---|
124 | #define SQL_DIAG_DROP_COLLATION 26
|
---|
125 | #define SQL_DIAG_DROP_DOMAIN 27
|
---|
126 | #define SQL_DIAG_DROP_INDEX (-2)
|
---|
127 | #define SQL_DIAG_DROP_SCHEMA 31
|
---|
128 | #define SQL_DIAG_DROP_TABLE 32
|
---|
129 | #define SQL_DIAG_DROP_TRANSLATION 33
|
---|
130 | #define SQL_DIAG_DROP_VIEW 36
|
---|
131 | #define SQL_DIAG_DYNAMIC_DELETE_CURSOR 38
|
---|
132 | #define SQL_DIAG_DYNAMIC_UPDATE_CURSOR 81
|
---|
133 | #define SQL_DIAG_GRANT 48
|
---|
134 | #define SQL_DIAG_INSERT 50
|
---|
135 | #define SQL_DIAG_REVOKE 59
|
---|
136 | #define SQL_DIAG_SELECT_CURSOR 85
|
---|
137 | #define SQL_DIAG_UNKNOWN_STATEMENT 0
|
---|
138 | #define SQL_DIAG_UPDATE_WHERE 82
|
---|
139 | #endif
|
---|
140 |
|
---|
141 | #define SQL_UNKNOWN_TYPE 0
|
---|
142 | #define SQL_CHAR 1
|
---|
143 | #define SQL_NUMERIC 2
|
---|
144 | #define SQL_DECIMAL 3
|
---|
145 | #define SQL_INTEGER 4
|
---|
146 | #define SQL_SMALLINT 5
|
---|
147 | #define SQL_FLOAT 6
|
---|
148 | #define SQL_REAL 7
|
---|
149 | #define SQL_DOUBLE 8
|
---|
150 | #if (ODBCVER >= 0x0300)
|
---|
151 | #define SQL_DATETIME 9
|
---|
152 | #endif
|
---|
153 | #define SQL_VARCHAR 12
|
---|
154 |
|
---|
155 | #if (ODBCVER >= 0x0300)
|
---|
156 | #define SQL_TYPE_DATE 91
|
---|
157 | #define SQL_TYPE_TIME 92
|
---|
158 | #define SQL_TYPE_TIMESTAMP 93
|
---|
159 | #endif
|
---|
160 |
|
---|
161 | #if (ODBCVER >= 0x0300)
|
---|
162 | #define SQL_UNSPECIFIED 0
|
---|
163 | #define SQL_INSENSITIVE 1
|
---|
164 | #define SQL_SENSITIVE 2
|
---|
165 | #endif
|
---|
166 |
|
---|
167 | #define SQL_ALL_TYPES 0
|
---|
168 |
|
---|
169 | #if (ODBCVER >= 0x0300)
|
---|
170 | #define SQL_DEFAULT 99
|
---|
171 | #endif
|
---|
172 |
|
---|
173 | #if (ODBCVER >= 0x0300)
|
---|
174 | #define SQL_ARD_TYPE (-99)
|
---|
175 | #endif
|
---|
176 |
|
---|
177 | #if (ODBCVER >= 0x0300)
|
---|
178 | #define SQL_CODE_DATE 1
|
---|
179 | #define SQL_CODE_TIME 2
|
---|
180 | #define SQL_CODE_TIMESTAMP 3
|
---|
181 | #endif
|
---|
182 |
|
---|
183 | #if (ODBCVER >= 0x0300)
|
---|
184 | #define SQL_FALSE 0
|
---|
185 | #define SQL_TRUE 1
|
---|
186 | #endif
|
---|
187 |
|
---|
188 | #define SQL_NO_NULLS 0
|
---|
189 | #define SQL_NULLABLE 1
|
---|
190 |
|
---|
191 | #define SQL_NULLABLE_UNKNOWN 2
|
---|
192 |
|
---|
193 | #if (ODBCVER >= 0x0300)
|
---|
194 | #define SQL_PRED_NONE 0
|
---|
195 | #define SQL_PRED_CHAR 1
|
---|
196 | #define SQL_PRED_BASIC 2
|
---|
197 | #endif
|
---|
198 |
|
---|
199 | #if (ODBCVER >= 0x0300)
|
---|
200 | #define SQL_NAMED 0
|
---|
201 | #define SQL_UNNAMED 1
|
---|
202 | #endif
|
---|
203 |
|
---|
204 | #if (ODBCVER >= 0x0300)
|
---|
205 | #define SQL_DESC_ALLOC_AUTO 1
|
---|
206 | #define SQL_DESC_ALLOC_USER 2
|
---|
207 | #endif
|
---|
208 |
|
---|
209 | #define SQL_CLOSE 0
|
---|
210 | #define SQL_DROP 1
|
---|
211 | #define SQL_UNBIND 2
|
---|
212 | #define SQL_RESET_PARAMS 3
|
---|
213 |
|
---|
214 | #define SQL_FETCH_NEXT 1
|
---|
215 | #define SQL_FETCH_FIRST 2
|
---|
216 |
|
---|
217 | #define SQL_FETCH_LAST 3
|
---|
218 | #define SQL_FETCH_PRIOR 4
|
---|
219 | #define SQL_FETCH_ABSOLUTE 5
|
---|
220 | #define SQL_FETCH_RELATIVE 6
|
---|
221 |
|
---|
222 | #define SQL_COMMIT 0
|
---|
223 | #define SQL_ROLLBACK 1
|
---|
224 |
|
---|
225 | #define SQL_NULL_HENV 0
|
---|
226 | #define SQL_NULL_HDBC 0
|
---|
227 | #define SQL_NULL_HSTMT 0
|
---|
228 | #if (ODBCVER >= 0x0300)
|
---|
229 | #define SQL_NULL_HDESC 0
|
---|
230 | #endif
|
---|
231 |
|
---|
232 | #if (ODBCVER >= 0x0300)
|
---|
233 | #define SQL_NULL_HANDLE __MSABI_LONG(0)
|
---|
234 | #endif
|
---|
235 |
|
---|
236 | #define SQL_SCOPE_CURROW 0
|
---|
237 | #define SQL_SCOPE_TRANSACTION 1
|
---|
238 | #define SQL_SCOPE_SESSION 2
|
---|
239 |
|
---|
240 | #define SQL_PC_UNKNOWN 0
|
---|
241 | #if (ODBCVER >= 0x0300)
|
---|
242 | #define SQL_PC_NON_PSEUDO 1
|
---|
243 | #endif
|
---|
244 | #define SQL_PC_PSEUDO 2
|
---|
245 |
|
---|
246 | #if (ODBCVER >= 0x0300)
|
---|
247 | #define SQL_ROW_IDENTIFIER 1
|
---|
248 | #endif
|
---|
249 |
|
---|
250 | #define SQL_INDEX_UNIQUE 0
|
---|
251 | #define SQL_INDEX_ALL 1
|
---|
252 |
|
---|
253 | #define SQL_INDEX_CLUSTERED 1
|
---|
254 | #define SQL_INDEX_HASHED 2
|
---|
255 | #define SQL_INDEX_OTHER 3
|
---|
256 |
|
---|
257 | #define SQL_API_SQLALLOCCONNECT 1
|
---|
258 | #define SQL_API_SQLALLOCENV 2
|
---|
259 | #if (ODBCVER >= 0x0300)
|
---|
260 | #define SQL_API_SQLALLOCHANDLE 1001
|
---|
261 | #endif
|
---|
262 | #define SQL_API_SQLALLOCSTMT 3
|
---|
263 | #define SQL_API_SQLBINDCOL 4
|
---|
264 | #if (ODBCVER >= 0x0300)
|
---|
265 | #define SQL_API_SQLBINDPARAM 1002
|
---|
266 | #endif
|
---|
267 | #define SQL_API_SQLCANCEL 5
|
---|
268 | #if (ODBCVER >= 0x0300)
|
---|
269 | #define SQL_API_SQLCLOSECURSOR 1003
|
---|
270 | #define SQL_API_SQLCOLATTRIBUTE 6
|
---|
271 | #endif
|
---|
272 | #define SQL_API_SQLCOLUMNS 40
|
---|
273 | #define SQL_API_SQLCONNECT 7
|
---|
274 | #if (ODBCVER >= 0x0300)
|
---|
275 | #define SQL_API_SQLCOPYDESC 1004
|
---|
276 | #endif
|
---|
277 | #define SQL_API_SQLDATASOURCES 57
|
---|
278 | #define SQL_API_SQLDESCRIBECOL 8
|
---|
279 | #define SQL_API_SQLDISCONNECT 9
|
---|
280 | #if (ODBCVER >= 0x0300)
|
---|
281 | #define SQL_API_SQLENDTRAN 1005
|
---|
282 | #endif
|
---|
283 | #define SQL_API_SQLERROR 10
|
---|
284 | #define SQL_API_SQLEXECDIRECT 11
|
---|
285 | #define SQL_API_SQLEXECUTE 12
|
---|
286 | #define SQL_API_SQLFETCH 13
|
---|
287 | #if (ODBCVER >= 0x0300)
|
---|
288 | #define SQL_API_SQLFETCHSCROLL 1021
|
---|
289 | #endif
|
---|
290 | #define SQL_API_SQLFREECONNECT 14
|
---|
291 | #define SQL_API_SQLFREEENV 15
|
---|
292 | #if (ODBCVER >= 0x0300)
|
---|
293 | #define SQL_API_SQLFREEHANDLE 1006
|
---|
294 | #endif
|
---|
295 | #define SQL_API_SQLFREESTMT 16
|
---|
296 | #if (ODBCVER >= 0x0300)
|
---|
297 | #define SQL_API_SQLGETCONNECTATTR 1007
|
---|
298 | #endif
|
---|
299 | #define SQL_API_SQLGETCONNECTOPTION 42
|
---|
300 | #define SQL_API_SQLGETCURSORNAME 17
|
---|
301 | #define SQL_API_SQLGETDATA 43
|
---|
302 | #if (ODBCVER >= 0x0300)
|
---|
303 | #define SQL_API_SQLGETDESCFIELD 1008
|
---|
304 | #define SQL_API_SQLGETDESCREC 1009
|
---|
305 | #define SQL_API_SQLGETDIAGFIELD 1010
|
---|
306 | #define SQL_API_SQLGETDIAGREC 1011
|
---|
307 | #define SQL_API_SQLGETENVATTR 1012
|
---|
308 | #endif
|
---|
309 | #define SQL_API_SQLGETFUNCTIONS 44
|
---|
310 | #define SQL_API_SQLGETINFO 45
|
---|
311 | #if (ODBCVER >= 0x0300)
|
---|
312 | #define SQL_API_SQLGETSTMTATTR 1014
|
---|
313 | #endif
|
---|
314 | #define SQL_API_SQLGETSTMTOPTION 46
|
---|
315 | #define SQL_API_SQLGETTYPEINFO 47
|
---|
316 | #define SQL_API_SQLNUMRESULTCOLS 18
|
---|
317 | #define SQL_API_SQLPARAMDATA 48
|
---|
318 | #define SQL_API_SQLPREPARE 19
|
---|
319 | #define SQL_API_SQLPUTDATA 49
|
---|
320 | #define SQL_API_SQLROWCOUNT 20
|
---|
321 | #if (ODBCVER >= 0x0300)
|
---|
322 | #define SQL_API_SQLSETCONNECTATTR 1016
|
---|
323 | #endif
|
---|
324 | #define SQL_API_SQLSETCONNECTOPTION 50
|
---|
325 | #define SQL_API_SQLSETCURSORNAME 21
|
---|
326 | #if (ODBCVER >= 0x0300)
|
---|
327 | #define SQL_API_SQLSETDESCFIELD 1017
|
---|
328 | #define SQL_API_SQLSETDESCREC 1018
|
---|
329 | #define SQL_API_SQLSETENVATTR 1019
|
---|
330 | #endif
|
---|
331 | #define SQL_API_SQLSETPARAM 22
|
---|
332 | #if (ODBCVER >= 0x0300)
|
---|
333 | #define SQL_API_SQLSETSTMTATTR 1020
|
---|
334 | #endif
|
---|
335 | #define SQL_API_SQLSETSTMTOPTION 51
|
---|
336 | #define SQL_API_SQLSPECIALCOLUMNS 52
|
---|
337 | #define SQL_API_SQLSTATISTICS 53
|
---|
338 | #define SQL_API_SQLTABLES 54
|
---|
339 | #define SQL_API_SQLTRANSACT 23
|
---|
340 |
|
---|
341 | #if (ODBCVER >= 0x0300)
|
---|
342 | #define SQL_MAX_DRIVER_CONNECTIONS 0
|
---|
343 | #define SQL_MAXIMUM_DRIVER_CONNECTIONS SQL_MAX_DRIVER_CONNECTIONS
|
---|
344 | #define SQL_MAX_CONCURRENT_ACTIVITIES 1
|
---|
345 | #define SQL_MAXIMUM_CONCURRENT_ACTIVITIES SQL_MAX_CONCURRENT_ACTIVITIES
|
---|
346 | #endif
|
---|
347 | #define SQL_DATA_SOURCE_NAME 2
|
---|
348 | #define SQL_FETCH_DIRECTION 8
|
---|
349 | #define SQL_SERVER_NAME 13
|
---|
350 | #define SQL_SEARCH_PATTERN_ESCAPE 14
|
---|
351 | #define SQL_DBMS_NAME 17
|
---|
352 | #define SQL_DBMS_VER 18
|
---|
353 | #define SQL_ACCESSIBLE_TABLES 19
|
---|
354 | #define SQL_ACCESSIBLE_PROCEDURES 20
|
---|
355 | #define SQL_CURSOR_COMMIT_BEHAVIOR 23
|
---|
356 | #define SQL_DATA_SOURCE_READ_ONLY 25
|
---|
357 | #define SQL_DEFAULT_TXN_ISOLATION 26
|
---|
358 | #define SQL_IDENTIFIER_CASE 28
|
---|
359 | #define SQL_IDENTIFIER_QUOTE_CHAR 29
|
---|
360 | #define SQL_MAX_COLUMN_NAME_LEN 30
|
---|
361 | #define SQL_MAXIMUM_COLUMN_NAME_LENGTH SQL_MAX_COLUMN_NAME_LEN
|
---|
362 | #define SQL_MAX_CURSOR_NAME_LEN 31
|
---|
363 | #define SQL_MAXIMUM_CURSOR_NAME_LENGTH SQL_MAX_CURSOR_NAME_LEN
|
---|
364 | #define SQL_MAX_SCHEMA_NAME_LEN 32
|
---|
365 | #define SQL_MAXIMUM_SCHEMA_NAME_LENGTH SQL_MAX_SCHEMA_NAME_LEN
|
---|
366 | #define SQL_MAX_CATALOG_NAME_LEN 34
|
---|
367 | #define SQL_MAXIMUM_CATALOG_NAME_LENGTH SQL_MAX_CATALOG_NAME_LEN
|
---|
368 | #define SQL_MAX_TABLE_NAME_LEN 35
|
---|
369 | #define SQL_SCROLL_CONCURRENCY 43
|
---|
370 | #define SQL_TXN_CAPABLE 46
|
---|
371 | #define SQL_TRANSACTION_CAPABLE SQL_TXN_CAPABLE
|
---|
372 | #define SQL_USER_NAME 47
|
---|
373 | #define SQL_TXN_ISOLATION_OPTION 72
|
---|
374 | #define SQL_TRANSACTION_ISOLATION_OPTION SQL_TXN_ISOLATION_OPTION
|
---|
375 | #define SQL_INTEGRITY 73
|
---|
376 | #define SQL_GETDATA_EXTENSIONS 81
|
---|
377 | #define SQL_NULL_COLLATION 85
|
---|
378 | #define SQL_ALTER_TABLE 86
|
---|
379 | #define SQL_ORDER_BY_COLUMNS_IN_SELECT 90
|
---|
380 | #define SQL_SPECIAL_CHARACTERS 94
|
---|
381 | #define SQL_MAX_COLUMNS_IN_GROUP_BY 97
|
---|
382 | #define SQL_MAXIMUM_COLUMNS_IN_GROUP_BY SQL_MAX_COLUMNS_IN_GROUP_BY
|
---|
383 | #define SQL_MAX_COLUMNS_IN_INDEX 98
|
---|
384 | #define SQL_MAXIMUM_COLUMNS_IN_INDEX SQL_MAX_COLUMNS_IN_INDEX
|
---|
385 | #define SQL_MAX_COLUMNS_IN_ORDER_BY 99
|
---|
386 | #define SQL_MAXIMUM_COLUMNS_IN_ORDER_BY SQL_MAX_COLUMNS_IN_ORDER_BY
|
---|
387 | #define SQL_MAX_COLUMNS_IN_SELECT 100
|
---|
388 | #define SQL_MAXIMUM_COLUMNS_IN_SELECT SQL_MAX_COLUMNS_IN_SELECT
|
---|
389 | #define SQL_MAX_COLUMNS_IN_TABLE 101
|
---|
390 | #define SQL_MAX_INDEX_SIZE 102
|
---|
391 | #define SQL_MAXIMUM_INDEX_SIZE SQL_MAX_INDEX_SIZE
|
---|
392 | #define SQL_MAX_ROW_SIZE 104
|
---|
393 | #define SQL_MAXIMUM_ROW_SIZE SQL_MAX_ROW_SIZE
|
---|
394 | #define SQL_MAX_STATEMENT_LEN 105
|
---|
395 | #define SQL_MAXIMUM_STATEMENT_LENGTH SQL_MAX_STATEMENT_LEN
|
---|
396 | #define SQL_MAX_TABLES_IN_SELECT 106
|
---|
397 | #define SQL_MAXIMUM_TABLES_IN_SELECT SQL_MAX_TABLES_IN_SELECT
|
---|
398 | #define SQL_MAX_USER_NAME_LEN 107
|
---|
399 | #define SQL_MAXIMUM_USER_NAME_LENGTH SQL_MAX_USER_NAME_LEN
|
---|
400 | #if (ODBCVER >= 0x0300)
|
---|
401 | #define SQL_OJ_CAPABILITIES 115
|
---|
402 | #define SQL_OUTER_JOIN_CAPABILITIES SQL_OJ_CAPABILITIES
|
---|
403 | #endif
|
---|
404 |
|
---|
405 | #if (ODBCVER >= 0x0300)
|
---|
406 | #define SQL_XOPEN_CLI_YEAR 10000
|
---|
407 | #define SQL_CURSOR_SENSITIVITY 10001
|
---|
408 | #define SQL_DESCRIBE_PARAMETER 10002
|
---|
409 | #define SQL_CATALOG_NAME 10003
|
---|
410 | #define SQL_COLLATION_SEQ 10004
|
---|
411 | #define SQL_MAX_IDENTIFIER_LEN 10005
|
---|
412 | #define SQL_MAXIMUM_IDENTIFIER_LENGTH SQL_MAX_IDENTIFIER_LEN
|
---|
413 | #endif
|
---|
414 |
|
---|
415 | #if (ODBCVER >= 0x0200)
|
---|
416 | #define SQL_AT_ADD_COLUMN __MSABI_LONG(0x00000001)
|
---|
417 | #define SQL_AT_DROP_COLUMN __MSABI_LONG(0x00000002)
|
---|
418 | #endif
|
---|
419 |
|
---|
420 | #if (ODBCVER >= 0x0300)
|
---|
421 | #define SQL_AT_ADD_CONSTRAINT __MSABI_LONG(0x00000008)
|
---|
422 | #endif
|
---|
423 |
|
---|
424 | #if (ODBCVER >= 0x0300)
|
---|
425 | #define SQL_AM_NONE 0
|
---|
426 | #define SQL_AM_CONNECTION 1
|
---|
427 | #define SQL_AM_STATEMENT 2
|
---|
428 | #endif
|
---|
429 |
|
---|
430 | #define SQL_CB_DELETE 0
|
---|
431 | #define SQL_CB_CLOSE 1
|
---|
432 | #define SQL_CB_PRESERVE 2
|
---|
433 |
|
---|
434 | #define SQL_FD_FETCH_NEXT __MSABI_LONG(0x00000001)
|
---|
435 | #define SQL_FD_FETCH_FIRST __MSABI_LONG(0x00000002)
|
---|
436 | #define SQL_FD_FETCH_LAST __MSABI_LONG(0x00000004)
|
---|
437 | #define SQL_FD_FETCH_PRIOR __MSABI_LONG(0x00000008)
|
---|
438 | #define SQL_FD_FETCH_ABSOLUTE __MSABI_LONG(0x00000010)
|
---|
439 | #define SQL_FD_FETCH_RELATIVE __MSABI_LONG(0x00000020)
|
---|
440 |
|
---|
441 | #define SQL_GD_ANY_COLUMN __MSABI_LONG(0x00000001)
|
---|
442 | #define SQL_GD_ANY_ORDER __MSABI_LONG(0x00000002)
|
---|
443 |
|
---|
444 | #define SQL_IC_UPPER 1
|
---|
445 | #define SQL_IC_LOWER 2
|
---|
446 | #define SQL_IC_SENSITIVE 3
|
---|
447 | #define SQL_IC_MIXED 4
|
---|
448 |
|
---|
449 | #if (ODBCVER >= 0x0201)
|
---|
450 | #define SQL_OJ_LEFT __MSABI_LONG(0x00000001)
|
---|
451 | #define SQL_OJ_RIGHT __MSABI_LONG(0x00000002)
|
---|
452 | #define SQL_OJ_FULL __MSABI_LONG(0x00000004)
|
---|
453 | #define SQL_OJ_NESTED __MSABI_LONG(0x00000008)
|
---|
454 | #define SQL_OJ_NOT_ORDERED __MSABI_LONG(0x00000010)
|
---|
455 | #define SQL_OJ_INNER __MSABI_LONG(0x00000020)
|
---|
456 | #define SQL_OJ_ALL_COMPARISON_OPS __MSABI_LONG(0x00000040)
|
---|
457 | #endif
|
---|
458 |
|
---|
459 | #define SQL_SCCO_READ_ONLY __MSABI_LONG(0x00000001)
|
---|
460 | #define SQL_SCCO_LOCK __MSABI_LONG(0x00000002)
|
---|
461 | #define SQL_SCCO_OPT_ROWVER __MSABI_LONG(0x00000004)
|
---|
462 | #define SQL_SCCO_OPT_VALUES __MSABI_LONG(0x00000008)
|
---|
463 |
|
---|
464 | #define SQL_TC_NONE 0
|
---|
465 | #define SQL_TC_DML 1
|
---|
466 | #define SQL_TC_ALL 2
|
---|
467 | #define SQL_TC_DDL_COMMIT 3
|
---|
468 | #define SQL_TC_DDL_IGNORE 4
|
---|
469 |
|
---|
470 | #define SQL_TXN_READ_UNCOMMITTED __MSABI_LONG(0x00000001)
|
---|
471 | #define SQL_TRANSACTION_READ_UNCOMMITTED SQL_TXN_READ_UNCOMMITTED
|
---|
472 | #define SQL_TXN_READ_COMMITTED __MSABI_LONG(0x00000002)
|
---|
473 | #define SQL_TRANSACTION_READ_COMMITTED SQL_TXN_READ_COMMITTED
|
---|
474 | #define SQL_TXN_REPEATABLE_READ __MSABI_LONG(0x00000004)
|
---|
475 | #define SQL_TRANSACTION_REPEATABLE_READ SQL_TXN_REPEATABLE_READ
|
---|
476 | #define SQL_TXN_SERIALIZABLE __MSABI_LONG(0x00000008)
|
---|
477 | #define SQL_TRANSACTION_SERIALIZABLE SQL_TXN_SERIALIZABLE
|
---|
478 |
|
---|
479 | #define SQL_NC_HIGH 0
|
---|
480 | #define SQL_NC_LOW 1
|
---|
481 |
|
---|
482 | #ifndef RC_INVOKED
|
---|
483 | SQLRETURN SQL_API SQLAllocConnect(SQLHENV EnvironmentHandle,SQLHDBC *ConnectionHandle);
|
---|
484 | SQLRETURN SQL_API SQLAllocEnv(SQLHENV *EnvironmentHandle);
|
---|
485 | #if (ODBCVER >= 0x0300)
|
---|
486 | SQLRETURN SQL_API SQLAllocHandle(SQLSMALLINT HandleType,SQLHANDLE InputHandle,SQLHANDLE *OutputHandle);
|
---|
487 | #endif
|
---|
488 | SQLRETURN SQL_API SQLAllocStmt(SQLHDBC ConnectionHandle,SQLHSTMT *StatementHandle);
|
---|
489 | SQLRETURN SQL_API SQLBindCol(SQLHSTMT StatementHandle,SQLUSMALLINT ColumnNumber,SQLSMALLINT TargetType,SQLPOINTER TargetValue,SQLLEN BufferLength,SQLLEN *StrLen_or_Ind);
|
---|
490 | #if (ODBCVER >= 0x0300)
|
---|
491 | SQLRETURN SQL_API SQLBindParam(SQLHSTMT StatementHandle,SQLUSMALLINT ParameterNumber,SQLSMALLINT ValueType,SQLSMALLINT ParameterType,SQLULEN LengthPrecision,SQLSMALLINT ParameterScale,SQLPOINTER ParameterValue,SQLLEN *StrLen_or_Ind);
|
---|
492 | #endif
|
---|
493 | SQLRETURN SQL_API SQLCancel(SQLHSTMT StatementHandle);
|
---|
494 | #if (ODBCVER >= 0x0300)
|
---|
495 | SQLRETURN SQL_API SQLCloseCursor(SQLHSTMT StatementHandle);
|
---|
496 | #ifdef _WIN64
|
---|
497 | SQLRETURN SQL_API SQLColAttribute(SQLHSTMT StatementHandle,SQLUSMALLINT ColumnNumber,SQLUSMALLINT FieldIdentifier,SQLPOINTER CharacterAttribute,SQLSMALLINT BufferLength,SQLSMALLINT *StringLength,SQLLEN *NumericAttribute);
|
---|
498 | #else
|
---|
499 | SQLRETURN SQL_API SQLColAttribute(SQLHSTMT StatementHandle,SQLUSMALLINT ColumnNumber,SQLUSMALLINT FieldIdentifier,SQLPOINTER CharacterAttribute,SQLSMALLINT BufferLength,SQLSMALLINT *StringLength,SQLPOINTER NumericAttribute);
|
---|
500 | #endif
|
---|
501 | #endif
|
---|
502 | SQLRETURN SQL_API SQLColumns(SQLHSTMT StatementHandle,SQLCHAR *CatalogName,SQLSMALLINT NameLength1,SQLCHAR *SchemaName,SQLSMALLINT NameLength2,SQLCHAR *TableName,SQLSMALLINT NameLength3,SQLCHAR *ColumnName,SQLSMALLINT NameLength4);
|
---|
503 | SQLRETURN SQL_API SQLConnect(SQLHDBC ConnectionHandle,SQLCHAR *ServerName,SQLSMALLINT NameLength1,SQLCHAR *UserName,SQLSMALLINT NameLength2,SQLCHAR *Authentication,SQLSMALLINT NameLength3);
|
---|
504 | #if (ODBCVER >= 0x0300)
|
---|
505 | SQLRETURN SQL_API SQLCopyDesc(SQLHDESC SourceDescHandle,SQLHDESC TargetDescHandle);
|
---|
506 | #endif
|
---|
507 | SQLRETURN SQL_API SQLDataSources(SQLHENV EnvironmentHandle,SQLUSMALLINT Direction,SQLCHAR *ServerName,SQLSMALLINT BufferLength1,SQLSMALLINT *NameLength1,SQLCHAR *Description,SQLSMALLINT BufferLength2,SQLSMALLINT *NameLength2);
|
---|
508 | SQLRETURN SQL_API SQLDescribeCol(SQLHSTMT StatementHandle,SQLUSMALLINT ColumnNumber,SQLCHAR *ColumnName,SQLSMALLINT BufferLength,SQLSMALLINT *NameLength,SQLSMALLINT *DataType,SQLULEN *ColumnSize,SQLSMALLINT *DecimalDigits,SQLSMALLINT *Nullable);
|
---|
509 | SQLRETURN SQL_API SQLDisconnect(SQLHDBC ConnectionHandle);
|
---|
510 | #if (ODBCVER >= 0x0300)
|
---|
511 | SQLRETURN SQL_API SQLEndTran(SQLSMALLINT HandleType,SQLHANDLE Handle,SQLSMALLINT CompletionType);
|
---|
512 | #endif
|
---|
513 | SQLRETURN SQL_API SQLError(SQLHENV EnvironmentHandle,SQLHDBC ConnectionHandle,SQLHSTMT StatementHandle,SQLCHAR *Sqlstate,SQLINTEGER *NativeError,SQLCHAR *MessageText,SQLSMALLINT BufferLength,SQLSMALLINT *TextLength);
|
---|
514 | SQLRETURN SQL_API SQLExecDirect(SQLHSTMT StatementHandle,SQLCHAR *StatementText,SQLINTEGER TextLength);
|
---|
515 | SQLRETURN SQL_API SQLExecute(SQLHSTMT StatementHandle);
|
---|
516 | SQLRETURN SQL_API SQLFetch(SQLHSTMT StatementHandle);
|
---|
517 | #if (ODBCVER >= 0x0300)
|
---|
518 | SQLRETURN SQL_API SQLFetchScroll(SQLHSTMT StatementHandle,SQLSMALLINT FetchOrientation,SQLLEN FetchOffset);
|
---|
519 | #endif
|
---|
520 | SQLRETURN SQL_API SQLFreeConnect(SQLHDBC ConnectionHandle);
|
---|
521 | SQLRETURN SQL_API SQLFreeEnv(SQLHENV EnvironmentHandle);
|
---|
522 | #if (ODBCVER >= 0x0300)
|
---|
523 | SQLRETURN SQL_API SQLFreeHandle(SQLSMALLINT HandleType,SQLHANDLE Handle);
|
---|
524 | #endif
|
---|
525 | SQLRETURN SQL_API SQLFreeStmt(SQLHSTMT StatementHandle,SQLUSMALLINT Option);
|
---|
526 | #if (ODBCVER >= 0x0300)
|
---|
527 | SQLRETURN SQL_API SQLGetConnectAttr(SQLHDBC ConnectionHandle,SQLINTEGER Attribute,SQLPOINTER Value,SQLINTEGER BufferLength,SQLINTEGER *StringLength);
|
---|
528 | #endif
|
---|
529 | SQLRETURN SQL_API SQLGetConnectOption(SQLHDBC ConnectionHandle,SQLUSMALLINT Option,SQLPOINTER Value);
|
---|
530 | SQLRETURN SQL_API SQLGetCursorName(SQLHSTMT StatementHandle,SQLCHAR *CursorName,SQLSMALLINT BufferLength,SQLSMALLINT *NameLength);
|
---|
531 | SQLRETURN SQL_API SQLGetData(SQLHSTMT StatementHandle,SQLUSMALLINT ColumnNumber,SQLSMALLINT TargetType,SQLPOINTER TargetValue,SQLLEN BufferLength,SQLLEN *StrLen_or_Ind);
|
---|
532 | #if (ODBCVER >= 0x0300)
|
---|
533 | SQLRETURN SQL_API SQLGetDescField(SQLHDESC DescriptorHandle,SQLSMALLINT RecNumber,SQLSMALLINT FieldIdentifier,SQLPOINTER Value,SQLINTEGER BufferLength,SQLINTEGER *StringLength);
|
---|
534 | SQLRETURN SQL_API SQLGetDescRec(SQLHDESC DescriptorHandle,SQLSMALLINT RecNumber,SQLCHAR *Name,SQLSMALLINT BufferLength,SQLSMALLINT *StringLength,SQLSMALLINT *Type,SQLSMALLINT *SubType,SQLLEN *Length,SQLSMALLINT *Precision,SQLSMALLINT *Scale,SQLSMALLINT *Nullable);
|
---|
535 | SQLRETURN SQL_API SQLGetDiagField(SQLSMALLINT HandleType,SQLHANDLE Handle,SQLSMALLINT RecNumber,SQLSMALLINT DiagIdentifier,SQLPOINTER DiagInfo,SQLSMALLINT BufferLength,SQLSMALLINT *StringLength);
|
---|
536 | SQLRETURN SQL_API SQLGetDiagRec(SQLSMALLINT HandleType,SQLHANDLE Handle,SQLSMALLINT RecNumber,SQLCHAR *Sqlstate,SQLINTEGER *NativeError,SQLCHAR *MessageText,SQLSMALLINT BufferLength,SQLSMALLINT *TextLength);
|
---|
537 | SQLRETURN SQL_API SQLGetEnvAttr(SQLHENV EnvironmentHandle,SQLINTEGER Attribute,SQLPOINTER Value,SQLINTEGER BufferLength,SQLINTEGER *StringLength);
|
---|
538 | #endif
|
---|
539 | SQLRETURN SQL_API SQLGetFunctions(SQLHDBC ConnectionHandle,SQLUSMALLINT FunctionId,SQLUSMALLINT *Supported);
|
---|
540 | SQLRETURN SQL_API SQLGetInfo(SQLHDBC ConnectionHandle,SQLUSMALLINT InfoType,SQLPOINTER InfoValue,SQLSMALLINT BufferLength,SQLSMALLINT *StringLength);
|
---|
541 | #if (ODBCVER >= 0x0300)
|
---|
542 | SQLRETURN SQL_API SQLGetStmtAttr(SQLHSTMT StatementHandle,SQLINTEGER Attribute,SQLPOINTER Value,SQLINTEGER BufferLength,SQLINTEGER *StringLength);
|
---|
543 | #endif
|
---|
544 | SQLRETURN SQL_API SQLGetStmtOption(SQLHSTMT StatementHandle,SQLUSMALLINT Option,SQLPOINTER Value);
|
---|
545 | SQLRETURN SQL_API SQLGetTypeInfo(SQLHSTMT StatementHandle,SQLSMALLINT DataType);
|
---|
546 | SQLRETURN SQL_API SQLNumResultCols(SQLHSTMT StatementHandle,SQLSMALLINT *ColumnCount);
|
---|
547 | SQLRETURN SQL_API SQLParamData(SQLHSTMT StatementHandle,SQLPOINTER *Value);
|
---|
548 | SQLRETURN SQL_API SQLPrepare(SQLHSTMT StatementHandle,SQLCHAR *StatementText,SQLINTEGER TextLength);
|
---|
549 | SQLRETURN SQL_API SQLPutData(SQLHSTMT StatementHandle,SQLPOINTER Data,SQLLEN StrLen_or_Ind);
|
---|
550 | SQLRETURN SQL_API SQLRowCount(SQLHSTMT StatementHandle,SQLLEN *RowCount);
|
---|
551 | #if (ODBCVER >= 0x0300)
|
---|
552 | SQLRETURN SQL_API SQLSetConnectAttr(SQLHDBC ConnectionHandle,SQLINTEGER Attribute,SQLPOINTER Value,SQLINTEGER StringLength);
|
---|
553 | #endif
|
---|
554 | SQLRETURN SQL_API SQLSetConnectOption(SQLHDBC ConnectionHandle,SQLUSMALLINT Option,SQLULEN Value);
|
---|
555 | SQLRETURN SQL_API SQLSetCursorName(SQLHSTMT StatementHandle,SQLCHAR *CursorName,SQLSMALLINT NameLength);
|
---|
556 | #if (ODBCVER >= 0x0300)
|
---|
557 | SQLRETURN SQL_API SQLSetDescField(SQLHDESC DescriptorHandle,SQLSMALLINT RecNumber,SQLSMALLINT FieldIdentifier,SQLPOINTER Value,SQLINTEGER BufferLength);
|
---|
558 | SQLRETURN SQL_API SQLSetDescRec(SQLHDESC DescriptorHandle,SQLSMALLINT RecNumber,SQLSMALLINT Type,SQLSMALLINT SubType,SQLLEN Length,SQLSMALLINT Precision,SQLSMALLINT Scale,SQLPOINTER Data,SQLLEN *StringLength,SQLLEN *Indicator);
|
---|
559 | SQLRETURN SQL_API SQLSetEnvAttr(SQLHENV EnvironmentHandle,SQLINTEGER Attribute,SQLPOINTER Value,SQLINTEGER StringLength);
|
---|
560 | #endif
|
---|
561 | SQLRETURN SQL_API SQLSetParam(SQLHSTMT StatementHandle,SQLUSMALLINT ParameterNumber,SQLSMALLINT ValueType,SQLSMALLINT ParameterType,SQLULEN LengthPrecision,SQLSMALLINT ParameterScale,SQLPOINTER ParameterValue,SQLLEN *StrLen_or_Ind);
|
---|
562 | #if (ODBCVER >= 0x0300)
|
---|
563 | SQLRETURN SQL_API SQLSetStmtAttr(SQLHSTMT StatementHandle,SQLINTEGER Attribute,SQLPOINTER Value,SQLINTEGER StringLength);
|
---|
564 | #endif
|
---|
565 | SQLRETURN SQL_API SQLSetStmtOption(SQLHSTMT StatementHandle,SQLUSMALLINT Option,SQLULEN Value);
|
---|
566 | SQLRETURN SQL_API SQLSpecialColumns(SQLHSTMT StatementHandle,SQLUSMALLINT IdentifierType,SQLCHAR *CatalogName,SQLSMALLINT NameLength1,SQLCHAR *SchemaName,SQLSMALLINT NameLength2,SQLCHAR *TableName,SQLSMALLINT NameLength3,SQLUSMALLINT Scope,SQLUSMALLINT Nullable);
|
---|
567 | SQLRETURN SQL_API SQLStatistics(SQLHSTMT StatementHandle,SQLCHAR *CatalogName,SQLSMALLINT NameLength1,SQLCHAR *SchemaName,SQLSMALLINT NameLength2,SQLCHAR *TableName,SQLSMALLINT NameLength3,SQLUSMALLINT Unique,SQLUSMALLINT Reserved);
|
---|
568 | SQLRETURN SQL_API SQLTables(SQLHSTMT StatementHandle,SQLCHAR *CatalogName,SQLSMALLINT NameLength1,SQLCHAR *SchemaName,SQLSMALLINT NameLength2,SQLCHAR *TableName,SQLSMALLINT NameLength3,SQLCHAR *TableType,SQLSMALLINT NameLength4);
|
---|
569 | SQLRETURN SQL_API SQLTransact(SQLHENV EnvironmentHandle,SQLHDBC ConnectionHandle,SQLUSMALLINT CompletionType);
|
---|
570 | #endif
|
---|
571 |
|
---|
572 | #ifdef __cplusplus
|
---|
573 | }
|
---|
574 | #endif
|
---|
575 | #endif
|
---|