comparison win32/sqlext.d @ 1:4a9dcbd9e54f

-files of 0.13 beta -fixes so that it now compiles with the current dmd version
author marton@basel.hu
date Tue, 05 Apr 2011 20:44:01 +0200
parents
children
comparison
equal deleted inserted replaced
0:586e4a649642 1:4a9dcbd9e54f
1 /***********************************************************************\
2 * sqlext.d *
3 * *
4 * Windows API header module *
5 * *
6 * Translated from MinGW Windows headers *
7 * *
8 * Placed into public domain *
9 \***********************************************************************/
10 module win32.sqlext;
11
12 /* Conversion notes:
13 The MinGW file was a horrible mess. All of the #defines were sorted alphabetically,
14 which is crazy. This file needs a lot of work.
15 In MinGW, sqlext #includes sqlucode, but sqlucode #includes sqlext,
16 creating a circular dependency!
17 */
18
19 public import win32.sql;
20 private import win32.windef;
21
22 const SQL_SPEC_MAJOR = 3;
23 const SQL_SPEC_MINOR = 51;
24 const char[] SQL_SPEC_STRING = "03.51";
25 const SQL_ACCESS_MODE = 101;
26 const SQL_ACTIVE_CONNECTIONS = 0;
27 const SQL_ACTIVE_STATEMENTS = 1;
28
29 const SQL_DATE = 9;
30 const SQL_TIME = 10;
31 const SQL_SIGNED_OFFSET = -20;
32 const SQL_TINYINT = -6;
33 const SQL_TIMESTAMP = 11;
34 const SQL_UNSIGNED_OFFSET = -22;
35
36 const SQL_ADD = 4;
37 const SQL_ALL_EXCEPT_LIKE = 2;
38
39 const SQL_API_ALL_FUNCTIONS = 0;
40 const SQL_API_SQLCOLATTRIBUTES = 6;
41 const SQL_API_SQLDRIVERCONNECT = 41;
42 const SQL_API_SQLBROWSECONNECT = 55;
43 const SQL_API_SQLCOLUMNPRIVILEGES = 56;
44 const SQL_API_SQLDESCRIBEPARAM = 58;
45 const SQL_API_SQLEXTENDEDFETCH = 59;
46 const SQL_API_SQLFOREIGNKEYS = 60;
47 const SQL_API_SQLMORERESULTS = 61;
48 const SQL_API_SQLNATIVESQL = 62;
49 const SQL_API_SQLNUMPARAMS = 63;
50 const SQL_API_SQLPARAMOPTIONS = 64;
51 const SQL_API_SQLPRIMARYKEYS = 65;
52 const SQL_API_SQLPROCEDURECOLUMNS = 66;
53 const SQL_API_SQLPROCEDURES = 67;
54 const SQL_API_SQLSETPOS = 68;
55 const SQL_API_SQLSETSCROLLOPTIONS = 69;
56 const SQL_API_SQLTABLEPRIVILEGES = 70;
57 const SQL_API_SQLDRIVERS = 71;
58 const SQL_API_SQLBINDPARAMETER = 72;
59 const SQL_API_LOADBYORDINAL = 199;
60
61 const SQL_ASYNC_ENABLE = 4;
62 const SQL_ASYNC_ENABLE_OFF = 0UL;
63 const SQL_ASYNC_ENABLE_ON = 1UL;
64 const SQL_ASYNC_ENABLE_DEFAULT = SQL_ASYNC_ENABLE_OFF;
65
66 const SQL_ATTR_CONNECTION_DEAD = 1209;
67 const SQL_ATTR_READONLY = 0;
68 const SQL_ATTR_READWRITE_UNKNOWN = 2;
69 const SQL_ATTR_WRITE = 1;
70
71 const SQL_AUTOCOMMIT = 102;
72 const SQL_AUTOCOMMIT_OFF = 0UL;
73 const SQL_AUTOCOMMIT_ON = 1UL;
74 const SQL_AUTOCOMMIT_DEFAULT = SQL_AUTOCOMMIT_ON;
75 const SQL_BEST_ROWID = 1;
76 const SQL_BIGINT = -5;
77 const SQL_BINARY = -2;
78 const SQL_BIND_BY_COLUMN = 0UL;
79 const SQL_BIND_TYPE = 5;
80 const SQL_BIND_TYPE_DEFAULT = SQL_BIND_BY_COLUMN;
81 const SQL_BIT = -7;
82
83 const SQL_BOOKMARK_PERSISTENCE = 82;
84
85 // for BOOKMARK_PERSISTENCE
86 const SQL_BP_CLOSE = 1;
87 const SQL_BP_DELETE = 2;
88 const SQL_BP_DROP = 4;
89 const SQL_BP_TRANSACTION = 8;
90 const SQL_BP_UPDATE = 16;
91 const SQL_BP_OTHER_HSTMT = 32;
92 const SQL_BP_SCROLL = 64;
93
94 const SQL_C_BINARY = SQL_BINARY;
95 const SQL_C_BIT = SQL_BIT;
96 const SQL_C_CHAR = SQL_CHAR;
97 const SQL_C_DATE = SQL_DATE;
98 const SQL_C_DOUBLE = SQL_DOUBLE;
99 const SQL_C_FLOAT = SQL_REAL;
100 const SQL_C_LONG = SQL_INTEGER;
101 const SQL_C_SHORT = SQL_SMALLINT;
102 const SQL_C_SLONG = SQL_C_LONG+SQL_SIGNED_OFFSET;
103 const SQL_C_SSHORT = SQL_C_SHORT+SQL_SIGNED_OFFSET;
104 const SQL_C_STINYINT = SQL_TINYINT+SQL_SIGNED_OFFSET;
105 const SQL_C_TIME = SQL_TIME;
106 const SQL_C_TIMESTAMP = SQL_TIMESTAMP;
107 const SQL_C_TINYINT = SQL_TINYINT;
108 const SQL_C_ULONG = SQL_C_LONG+SQL_UNSIGNED_OFFSET;
109 const SQL_C_USHORT = SQL_C_SHORT+SQL_UNSIGNED_OFFSET;
110 const SQL_C_UTINYINT = SQL_TINYINT+SQL_UNSIGNED_OFFSET;
111 const SQL_C_BOOKMARK = SQL_C_ULONG;
112 const SQL_C_DEFAULT = 99;
113
114 const SQL_CASCADE = 0;
115 const SQL_CB_NON_NULL = 1;
116 const SQL_CB_NULL = 0;
117 deprecated {
118 const SQL_CC_CLOSE = SQL_CB_CLOSE;/* deprecated */
119 const SQL_CC_DELETE = SQL_CB_DELETE;/* deprecated */
120 const SQL_CC_PRESERVE = SQL_CB_PRESERVE;/* deprecated */
121 }
122 const SQL_CD_FALSE = 0L;
123 const SQL_CD_TRUE = 1L;
124
125 const SQL_CN_ANY = 2;
126 const SQL_CN_DIFFERENT = 1;
127 const SQL_CN_NONE = 0;
128
129 const SQL_COLUMN_ALIAS = 87;
130
131 const SQL_COLUMN_COUNT = 0;
132 const SQL_COLUMN_NAME = 1;
133 const SQL_COLUMN_DISPLAY_SIZE = 6;
134 const SQL_COLUMN_LABEL = 18;
135 const SQL_COLUMN_LENGTH = 3;
136 const SQL_COLUMN_MONEY = 9;
137 const SQL_COLUMN_NULLABLE = 7;
138 const SQL_COLUMN_OWNER_NAME = 16;
139 const SQL_COLUMN_PRECISION = 4;
140 const SQL_COLUMN_QUALIFIER_NAME = 17;
141 const SQL_COLUMN_SCALE = 5;
142 const SQL_COLUMN_UNSIGNED = 8;
143 const SQL_COLUMN_UPDATABLE = 10;
144 const SQL_COLUMN_AUTO_INCREMENT = 11;
145 const SQL_COLUMN_CASE_SENSITIVE = 12;
146 const SQL_COLUMN_SEARCHABLE = 13;
147 const SQL_COLUMN_TYPE = 2;
148 const SQL_COLUMN_TYPE_NAME = 14;
149 const SQL_COLUMN_TABLE_NAME = 15;
150
151 const SQL_CONCAT_NULL_BEHAVIOR = 22;
152
153 const SQL_CONCUR_READ_ONLY = 1;
154 const SQL_CONCUR_DEFAULT = SQL_CONCUR_READ_ONLY;
155 const SQL_CONCUR_LOCK = 2;
156 const SQL_CONCUR_ROWVER = 3;
157 const SQL_CONCUR_TIMESTAMP = SQL_CONCUR_ROWVER;/* deprecated */
158 const SQL_CONCUR_VALUES = 4;
159
160 const SQL_CONCURRENCY = 7;
161 const SQL_CONVERT_BIGINT = 53;
162 const SQL_CONVERT_BINARY = 54;
163 const SQL_CONVERT_BIT = 55;
164 const SQL_CONVERT_CHAR = 56;
165 const SQL_CONVERT_DATE = 57;
166 const SQL_CONVERT_DECIMAL = 58;
167 const SQL_CONVERT_DOUBLE = 59;
168 const SQL_CONVERT_FLOAT = 60;
169 const SQL_CONVERT_FUNCTIONS = 48;
170 const SQL_CONVERT_INTEGER = 61;
171 const SQL_CONVERT_LONGVARBINARY = 71;
172 const SQL_CONVERT_LONGVARCHAR = 62;
173 const SQL_CONVERT_NUMERIC = 63;
174 const SQL_CONVERT_REAL = 64;
175 const SQL_CONVERT_SMALLINT = 65;
176 const SQL_CONVERT_TIME = 66;
177 const SQL_CONVERT_TIMESTAMP = 67;
178 const SQL_CONVERT_TINYINT = 68;
179 const SQL_CONVERT_VARBINARY = 69;
180 const SQL_CONVERT_VARCHAR = 70;
181 const SQL_CORRELATION_NAME = 74;
182 const SQL_CR_CLOSE = SQL_CB_CLOSE;/* deprecated */
183 const SQL_CR_DELETE = SQL_CB_DELETE;/* deprecated */
184 const SQL_CR_PRESERVE = SQL_CB_PRESERVE;/* deprecated */
185
186 enum : ULONG {
187 SQL_CUR_USE_IF_NEEDED = 0,
188 SQL_CUR_USE_ODBC,
189 SQL_CUR_USE_DRIVER,
190 SQL_CUR_DEFAULT = SQL_CUR_USE_DRIVER
191 }
192
193 const SQL_CURRENT_QUALIFIER = 109;
194 const SQL_CURSOR_DYNAMIC = 2UL;
195 const SQL_CURSOR_FORWARD_ONLY = 0UL;
196 const SQL_CURSOR_KEYSET_DRIVEN = 1UL;
197 const SQL_CURSOR_ROLLBACK_BEHAVIOR = 24;
198 const SQL_CURSOR_STATIC = 3UL;
199 const SQL_CURSOR_TYPE = 6;
200 const SQL_CURSOR_TYPE_DEFAULT = SQL_CURSOR_FORWARD_ONLY;
201
202 const SQL_CV_CASCADED = 0x00000004L;
203 const SQL_CV_CHECK_OPTION = 0x00000002L;
204 const SQL_CV_CREATE_VIEW = 0x00000001L;
205 const SQL_CV_LOCAL = 0x00000008L;
206 const SQL_CVT_BIGINT = 0x00004000L;
207 const SQL_CVT_BINARY = 0x00000400L;
208 const SQL_CVT_BIT = 0x00001000L;
209 const SQL_CVT_CHAR = 0x00000001L;
210 const SQL_CVT_DATE = 0x00008000L;
211 const SQL_CVT_DECIMAL = 0x00000004L;
212 const SQL_CVT_DOUBLE = 0x00000080L;
213 const SQL_CVT_FLOAT = 0x00000020L;
214 const SQL_CVT_INTEGER = 0x00000008L;
215 const SQL_CVT_LONGVARBINARY = 0x00040000L;
216 const SQL_CVT_LONGVARCHAR = 0x00000200L;
217 const SQL_CVT_NUMERIC = 0x00000002L;
218 const SQL_CVT_REAL = 0x00000040L;
219 const SQL_CVT_SMALLINT = 0x00000010L;
220 const SQL_CVT_TIME = 0x00010000L;
221 const SQL_CVT_TIMESTAMP = 0x00020000L;
222 const SQL_CVT_TINYINT = 0x00002000L;
223 const SQL_CVT_VARBINARY = 0x00000800L;
224 const SQL_CVT_VARCHAR = 0x00000100L;
225 const SQL_DATABASE_NAME = 16;/* deprecated */
226
227 const SQL_DEFAULT_PARAM = -5;
228 const SQL_DELETE = 3;
229
230 const SQL_DRIVER_COMPLETE = 1;
231 const SQL_DRIVER_COMPLETE_REQUIRED = 3;
232 const SQL_DRIVER_HDBC = 3;
233 const SQL_DRIVER_HENV = 4;
234 const SQL_DRIVER_HLIB = 76;
235 const SQL_DRIVER_HSTMT = 5;
236 const SQL_DRIVER_NAME = 6;
237 const SQL_DRIVER_NOPROMPT = 0;
238 const SQL_DRIVER_ODBC_VER = 77;
239 const SQL_DRIVER_PROMPT = 2;
240 const SQL_DRIVER_VER = 7;
241
242 const SQL_DTC_ENLIST_EXPENSIVE = 1;
243 const SQL_DTC_UNENLIST_EXPENSIVE = 2;
244 const SQL_DTC_TRANSITION_COST = 1750;
245 const SQL_ENSURE = 1;
246 const SQL_ENTIRE_ROWSET = 0;
247 const SQL_EXPRESSIONS_IN_ORDERBY = 27;
248 const SQL_FD_FETCH_BOOKMARK = 128;
249 const SQL_FD_FETCH_PREV = SQL_FD_FETCH_PRIOR;/* deprecated */
250 const SQL_FD_FETCH_RESUME = 64;
251 const SQL_FETCH_BOOKMARK = 8;
252 const SQL_FETCH_PREV = SQL_FETCH_PRIOR;/* deprecated */
253 const SQL_FETCH_RESUME = 7;/* deprecated */
254
255 const SQL_FILE_NOT_SUPPORTED = 0x0000;
256 const SQL_FILE_TABLE = 0x0001;
257 const SQL_FILE_QUALIFIER = 0x0002;
258 const SQL_FILE_CATALOG = SQL_FILE_QUALIFIER;
259 const SQL_FILE_USAGE = 84;
260
261 const SQL_FN_CVT_CONVERT = 0x00000001L;
262 const SQL_FN_NUM_ABS = 0x00000001L;
263 const SQL_FN_NUM_ACOS = 0x00000002L;
264 const SQL_FN_NUM_ASIN = 0x00000004L;
265 const SQL_FN_NUM_ATAN = 0x00000008L;
266 const SQL_FN_NUM_ATAN2 = 0x00000010L;
267 const SQL_FN_NUM_CEILING = 0x00000020L;
268 const SQL_FN_NUM_COS = 0x00000040L;
269 const SQL_FN_NUM_COT = 0x00000080L;
270 const SQL_FN_NUM_DEGREES = 0x00040000L;
271 const SQL_FN_NUM_EXP = 0x00000100L;
272 const SQL_FN_NUM_FLOOR = 0x00000200L;
273 const SQL_FN_NUM_LOG = 0x00000400L;
274 const SQL_FN_NUM_LOG10 = 0x00080000L;
275 const SQL_FN_NUM_MOD = 0x00000800L;
276 const SQL_FN_NUM_PI = 0x00010000L;
277 const SQL_FN_NUM_POWER = 0x00100000L;
278 const SQL_FN_NUM_RADIANS = 0x00200000L;
279 const SQL_FN_NUM_RAND = 0x00020000L;
280 const SQL_FN_NUM_ROUND = 0x00400000L;
281 const SQL_FN_NUM_SIGN = 0x00001000L;
282 const SQL_FN_NUM_SIN = 0x00002000L;
283 const SQL_FN_NUM_SQRT = 0x00004000L;
284 const SQL_FN_NUM_TAN = 0x00008000L;
285 const SQL_FN_NUM_TRUNCATE = 0x00800000L;
286 const SQL_FN_STR_ASCII = 0x00002000L;
287 const SQL_FN_STR_CHAR = 0x00004000L;
288 const SQL_FN_STR_CONCAT = 0x00000001L;
289 const SQL_FN_STR_DIFFERENCE = 0x00008000L;
290 const SQL_FN_STR_INSERT = 0x00000002L;
291 const SQL_FN_STR_LCASE = 0x00000040L;
292 const SQL_FN_STR_LEFT = 0x00000004L;
293 const SQL_FN_STR_LENGTH = 0x00000010L;
294 const SQL_FN_STR_LOCATE = 0x00000020L;
295 const SQL_FN_STR_LOCATE_2 = 0x00010000L;
296 const SQL_FN_STR_LTRIM = 0x00000008L;
297 const SQL_FN_STR_REPEAT = 0x00000080L;
298 const SQL_FN_STR_REPLACE = 0x00000100L;
299 const SQL_FN_STR_RIGHT = 0x00000200L;
300 const SQL_FN_STR_RTRIM = 0x00000400L;
301 const SQL_FN_STR_SOUNDEX = 0x00020000L;
302 const SQL_FN_STR_SPACE = 0x00040000L;
303 const SQL_FN_STR_SUBSTRING = 0x00000800L;
304 const SQL_FN_STR_UCASE = 0x00001000L;
305 const SQL_FN_SYS_DBNAME = 0x00000002L;
306 const SQL_FN_SYS_IFNULL = 0x00000004L;
307 const SQL_FN_SYS_USERNAME = 0x00000001L;
308 const SQL_FN_TD_CURDATE = 0x00000002L;
309 const SQL_FN_TD_CURTIME = 0x00000200L;
310 const SQL_FN_TD_DAYNAME = 0x00008000L;
311 const SQL_FN_TD_DAYOFMONTH = 0x00000004L;
312 const SQL_FN_TD_DAYOFWEEK = 0x00000008L;
313 const SQL_FN_TD_DAYOFYEAR = 0x00000010L;
314 const SQL_FN_TD_HOUR = 0x00000400L;
315 const SQL_FN_TD_MINUTE = 0x00000800L;
316 const SQL_FN_TD_MONTH = 0x00000020L;
317 const SQL_FN_TD_MONTHNAME = 0x00010000L;
318 const SQL_FN_TD_NOW = 0x00000001L;
319 const SQL_FN_TD_QUARTER = 0x00000040L;
320 const SQL_FN_TD_SECOND = 0x00001000L;
321 const SQL_FN_TD_TIMESTAMPADD = 0x00002000L;
322 const SQL_FN_TD_TIMESTAMPDIFF = 0x00004000L;
323 const SQL_FN_TD_WEEK = 0x00000080L;
324 const SQL_FN_TD_YEAR = 0x00000100L;
325 const SQL_FN_TSI_DAY = 0x00000010L;
326 const SQL_FN_TSI_FRAC_SECOND = 0x00000001L;
327 const SQL_FN_TSI_HOUR = 0x00000008L;
328 const SQL_FN_TSI_MINUTE = 0x00000004L;
329 const SQL_FN_TSI_MONTH = 0x00000040L;
330 const SQL_FN_TSI_QUARTER = 0x00000080L;
331 const SQL_FN_TSI_SECOND = 0x00000002L;
332 const SQL_FN_TSI_WEEK = 0x00000020L;
333 const SQL_FN_TSI_YEAR = 0x00000100L;
334 const SQL_GB_GROUP_BY_CONTAINS_SELECT = 2;
335 const SQL_GB_GROUP_BY_EQUALS_SELECT = 1;
336 const SQL_GB_NO_RELATION = 3;
337 const SQL_GB_NOT_SUPPORTED = 0;
338 const SQL_GD_BLOCK = 4;
339 const SQL_GD_BOUND = 8;
340 const SQL_GET_BOOKMARK = 13;
341 const SQL_GROUP_BY = 88;
342 const SQL_IGNORE = -6;
343 const SQL_INFO_FIRST = 0;
344 const SQL_KEYSET_SIZE = 8;
345 const SQL_KEYSET_SIZE_DEFAULT = 0UL;
346 const SQL_KEYWORDS = 89;
347 const SQL_LCK_EXCLUSIVE = 2;
348 const SQL_LCK_NO_CHANGE = 1;
349 const SQL_LCK_UNLOCK = 4;
350
351 const SQL_LEN_BINARY_ATTR_OFFSET = -100;
352 const SQL_LEN_DATA_AT_EXEC_OFFSET = -100;
353 //MACRO #define SQL_LEN_BINARY_ATTR(length) (-(length)+SQL_LEN_BINARY_ATTR_OFFSET)
354 //MACRO #define SQL_LEN_DATA_AT_EXEC(length) (-(length)+SQL_LEN_DATA_AT_EXEC_OFFSET)
355
356 const SQL_LIKE_ESCAPE_CLAUSE = 113;
357 const SQL_LIKE_ONLY = 1;
358 const SQL_LOCK_EXCLUSIVE = 1;
359 const SQL_LOCK_NO_CHANGE = 0;
360 const SQL_LOCK_TYPES = 78;
361 const SQL_LOCK_UNLOCK = 2;
362 const SQL_LOGIN_TIMEOUT = 103;
363 const SQL_LOGIN_TIMEOUT_DEFAULT = 15UL;
364 const SQL_LONGVARBINARY = -4;
365 const SQL_LONGVARCHAR = -1;
366 const SQL_MAX_BINARY_LITERAL_LEN = 112;
367 const SQL_MAX_CHAR_LITERAL_LEN = 108;
368 const SQL_MAX_DSN_LENGTH = 32;
369 const SQL_MAX_LENGTH = 3;
370 const SQL_MAX_LENGTH_DEFAULT = 0UL;
371 const SQL_MAX_OPTION_STRING_LENGTH = 256;
372 const SQL_MAX_OWNER_NAME_LEN = 32;
373 const SQL_MAX_PROCEDURE_NAME_LEN = 33;
374 const SQL_MAX_QUALIFIER_NAME_LEN = 34;
375 const SQL_MAX_ROW_SIZE_INCLUDES_LONG = 103;
376 const SQL_MAX_ROWS = 1;
377 const SQL_MAX_ROWS_DEFAULT = 0UL;
378
379 const SQL_MODE_READ_WRITE = 0UL;
380 const SQL_MODE_READ_ONLY = 1UL;
381 const SQL_MODE_DEFAULT = SQL_MODE_READ_WRITE;
382
383 const SQL_MULT_RESULT_SETS = 36;
384 const SQL_MULTIPLE_ACTIVE_TXN = 37;
385 const SQL_NC_END = 0x0004;
386 const SQL_NC_START = 0x0002;
387 const SQL_NEED_LONG_DATA_LEN = 111;
388 const SQL_NNC_NON_NULL = 0x0001;
389 const SQL_NNC_NULL = 0x0000;
390 const SQL_NO_TOTAL = -4;
391 const SQL_NON_NULLABLE_COLUMNS = 75;
392
393 const SQL_NOSCAN_OFF = 0UL;
394 const SQL_NOSCAN_ON = 1UL;
395 const SQL_NOSCAN = 2;
396 const SQL_NOSCAN_DEFAULT = SQL_NOSCAN_OFF;
397
398 const SQL_NUMERIC_FUNCTIONS = 49;
399 const SQL_OAC_LEVEL1 = 0x0001;
400 const SQL_OAC_LEVEL2 = 0x0002;
401 const SQL_OAC_NONE = 0x0000;
402 const SQL_ODBC_API_CONFORMANCE = 9;
403 const SQL_ODBC_CURSORS = 110;
404 const SQL_ODBC_SAG_CLI_CONFORMANCE = 12;
405 const SQL_ODBC_SQL_CONFORMANCE = 15;
406 const SQL_ODBC_SQL_OPT_IEF = 73;
407 const SQL_ODBC_VER = 10;
408 const SQL_OPT_TRACE = 104;
409
410 const SQL_OPT_TRACE_FILE_DEFAULT = "\\SQL.LOG";
411 const SQL_OPT_TRACE_OFF = 0UL;
412 const SQL_OPT_TRACE_DEFAULT = SQL_OPT_TRACE_OFF;
413 const SQL_OPT_TRACE_ON = 1UL;
414
415 const SQL_OPT_TRACEFILE = 105;
416 const SQL_OSC_CORE = 1;
417 const SQL_OSC_EXTENDED = 2;
418 const SQL_OSC_MINIMUM = 0;
419 const SQL_OSCC_COMPLIANT = 1;
420 const SQL_OSCC_NOT_COMPLIANT = 0;
421 const SQL_OU_DML_STATEMENTS = 1;
422 const SQL_OU_INDEX_DEFINITION = 8;
423 const SQL_OU_PRIVILEGE_DEFINITION = 16;
424 const SQL_OU_PROCEDURE_INVOCATION = 2;
425 const SQL_OU_TABLE_DEFINITION = 4;
426 const SQL_OUTER_JOINS = 38;
427 const SQL_OWNER_TERM = 39;
428 const SQL_OWNER_USAGE = 91;
429 const SQL_PACKET_SIZE = 112;
430 const SQL_PARAM_INPUT = 1;
431 const SQL_PARAM_INPUT_OUTPUT = 2;
432 const SQL_PARAM_OUTPUT = 4;
433 const SQL_PARAM_TYPE_DEFAULT = SQL_PARAM_INPUT_OUTPUT;
434 const SQL_PARAM_TYPE_UNKNOWN = 0;
435 const SQL_PC_NOT_PSEUDO = 1;
436 const SQL_POS_ADD = 16;
437 const SQL_POS_DELETE = 8;
438 const SQL_POS_OPERATIONS = 79;
439 const SQL_POS_POSITION = 1;
440 const SQL_POS_REFRESH = 2;
441 const SQL_POS_UPDATE = 4;
442 const SQL_POSITION = 0;
443 const SQL_POSITIONED_STATEMENTS = 80;
444 const SQL_PROCEDURE_TERM = 40;
445 const SQL_PROCEDURES = 21;
446 const SQL_PS_POSITIONED_DELETE = 1;
447 const SQL_PS_POSITIONED_UPDATE = 2;
448 const SQL_PS_SELECT_FOR_UPDATE = 4;
449 const SQL_PT_FUNCTION = 2;
450 const SQL_PT_PROCEDURE = 1;
451 const SQL_PT_UNKNOWN = 0;
452 const SQL_QL_END = 0x0002;
453 const SQL_QL_START = 0x0001;
454 const SQL_QU_DML_STATEMENTS = 1;
455 const SQL_QU_INDEX_DEFINITION = 8;
456 const SQL_QU_PRIVILEGE_DEFINITION = 16;
457 const SQL_QU_PROCEDURE_INVOCATION = 2;
458 const SQL_QU_TABLE_DEFINITION = 4;
459 const SQL_QUALIFIER_LOCATION = 114;
460 const SQL_QUALIFIER_NAME_SEPARATOR = 41;
461 const SQL_QUALIFIER_TERM = 42;
462 const SQL_QUALIFIER_USAGE = 92;
463 const SQL_QUERY_TIMEOUT = 0;
464 const SQL_QUERY_TIMEOUT_DEFAULT = 0UL;
465 const SQL_QUICK = 0;
466 const SQL_QUIET_MODE = 111;
467 const SQL_QUOTED_IDENTIFIER_CASE = 93;
468
469 const SQL_RD_OFF = 0UL;
470 const SQL_RD_ON = 1UL;
471 const SQL_RD_DEFAULT = SQL_RD_ON;
472
473 const SQL_REFRESH = 1;
474 const SQL_RESTRICT = 1;
475 const SQL_RESULT_COL = 3;
476 const SQL_RETRIEVE_DATA = 11;
477 const SQL_RETURN_VALUE = 5;
478 const SQL_ROW_ADDED = 4;
479 const SQL_ROW_DELETED = 1;
480 const SQL_ROW_ERROR = 5;
481 const SQL_ROW_NOROW = 3;
482 const SQL_ROW_NUMBER = 14;
483 const SQL_ROW_SUCCESS = 0;
484 const SQL_ROW_UPDATED = 2;
485 const SQL_ROW_UPDATES = 11;
486 const SQL_ROWSET_SIZE = 9;
487 const SQL_ROWSET_SIZE_DEFAULT = 1UL;
488 const SQL_ROWVER = 2;
489 const SQL_SC_NON_UNIQUE = 0UL;
490 const SQL_SC_TRY_UNIQUE = 1UL;
491 const SQL_SC_UNIQUE = 2UL;
492 const SQL_SCCO_OPT_TIMESTAMP = SQL_SCCO_OPT_ROWVER;/* deprecated */
493 const SQL_SCROLL_DYNAMIC = -2L;/* deprecated */
494 const SQL_SCROLL_FORWARD_ONLY = 0L;/* deprecated */
495 const SQL_SCROLL_KEYSET_DRIVEN = -1L;/* deprecated */
496 const SQL_SCROLL_OPTIONS = 44;
497 const SQL_SCROLL_STATIC = -3L;/* deprecated */
498 const SQL_SEARCHABLE = 3;
499 const SQL_SET_NULL = 2;
500 const SQL_SETPARAM_VALUE_MAX = -1L;
501 const SQL_SETPOS_MAX_LOCK_VALUE = SQL_LOCK_UNLOCK;
502 const SQL_SETPOS_MAX_OPTION_VALUE = SQL_ADD;
503 const SQL_SIMULATE_CURSOR = 10;
504 const SQL_SO_DYNAMIC = 4;
505 const SQL_SO_FORWARD_ONLY = 1;
506 const SQL_SO_KEYSET_DRIVEN = 2;
507 const SQL_SO_MIXED = 8;
508 const SQL_SO_STATIC = 16;
509 const SQL_SQ_COMPARISON = 1;
510 const SQL_SQ_CORRELATED_SUBQUERIES = 16;
511 const SQL_SQ_EXISTS = 2;
512 const SQL_SQ_IN = 4;
513 const SQL_SQ_QUANTIFIED = 8;
514 const SQL_SQLSTATE_SIZE = 5;
515 const SQL_SS_ADDITIONS = 1;
516 const SQL_SS_DELETIONS = 2;
517 const SQL_SS_UPDATES = 4;
518 const SQL_STATIC_SENSITIVITY = 83;
519 const SQL_STRING_FUNCTIONS = 50;
520 const SQL_SUBQUERIES = 95;
521 const SQL_SYSTEM_FUNCTIONS = 51;
522 const SQL_TABLE_STAT = 0;
523 const SQL_TABLE_TERM = 45;
524 const SQL_TIMEDATE_ADD_INTERVALS = 109;
525 const SQL_TIMEDATE_DIFF_INTERVALS = 110;
526 const SQL_TIMEDATE_FUNCTIONS = 52;
527 const SQL_TRANSLATE_DLL = 106;
528 const SQL_TRANSLATE_OPTION = 107;
529 const SQL_TXN_ISOLATION = 108;
530 const SQL_TXN_VERSIONING = 16;
531 const SQL_TYPE_NULL = 0;
532 const SQL_U_UNION = 1;
533 const SQL_U_UNION_ALL = 2;
534
535 const SQL_UB_OFF = 0UL;
536 const SQL_UB_DEFAULT = SQL_UB_OFF;
537 const SQL_UB_ON = 01UL;
538
539 const SQL_UNION = 96;
540 const SQL_UNSEARCHABLE = 0;
541 const SQL_UPDATE = 2;
542 const SQL_USE_BOOKMARKS = 12;
543 const SQL_VARBINARY = -3;
544
545 const SQL_COLATT_OPT_MAX = SQL_COLUMN_LABEL;
546 const SQL_COLATT_OPT_MIN = SQL_COLUMN_COUNT;
547 const SQL_PRED_SEARCHABLE = SQL_SEARCHABLE;
548
549 //MACRO #define SQL_POSITION_TO(s, r) SQLSetPos(s, r, SQL_POSITION, SQL_LOCK_NO_CHANGE)
550
551 //MACRO #define SQL_LOCK_RECORD(s, r, l) SQLSetPos(s, r, SQL_POSITION, l)
552
553 //MACRO #define SQL_REFRESH_RECORD(s, r, l) SQLSetPos(s, r, SQL_REFRESH, l)
554
555 //MACRO #define SQL_UPDATE_RECORD(s, r) SQLSetPos(s, r, SQL_UPDATE, SQL_LOCK_NO_CHANGE)
556
557 //MACRO #define SQL_DELETE_RECORD(s, r) SQLSetPos(s, r, SQL_DELETE, SQL_LOCK_NO_CHANGE)
558
559 //MACRO #define SQL_ADD_RECORD(s, r) SQLSetPos(s, r, SQL_ADD, SQL_LOCK_NO_CHANGE)
560
561
562 static if (ODBCVER < 0x0300) {
563 const SQL_CONNECT_OPT_DRVR_START = 1000;
564 const SQL_CONN_OPT_MAX = SQL_PACKET_SIZE;
565 const SQL_CONN_OPT_MIN = SQL_ACCESS_MODE;
566 const SQL_STMT_OPT_MAX = SQL_ROW_NUMBER;
567 const SQL_STMT_OPT_MIN = SQL_QUERY_TIMEOUT;
568 const SQL_TYPE_DRIVER_START = SQL_INTERVAL_YEAR;
569 const SQL_TYPE_DRIVER_END = SQL_UNICODE_LONGVARCHAR;
570 const SQL_TYPE_MIN = SQL_BIT;
571 const SQL_TYPE_MAX = SQL_VARCHAR;
572 }
573
574 static if (ODBCVER < 0x0300) {
575 const SQL_NO_DATA_FOUND = 100;
576 const SQL_INTERVAL_YEAR = -80;
577 const SQL_INTERVAL_MONTH = -81;
578 const SQL_INTERVAL_YEAR_TO_MONTH = -82;
579 const SQL_INTERVAL_DAY = -83;
580 const SQL_INTERVAL_HOUR = -84;
581 const SQL_INTERVAL_MINUTE = -85;
582 const SQL_INTERVAL_SECOND = -86;
583 const SQL_INTERVAL_DAY_TO_HOUR = -87;
584 const SQL_INTERVAL_DAY_TO_MINUTE = -88;
585 const SQL_INTERVAL_DAY_TO_SECOND = -89;
586 const SQL_INTERVAL_HOUR_TO_MINUTE = -90;
587 const SQL_INTERVAL_HOUR_TO_SECOND = -91;
588 const SQL_INTERVAL_MINUTE_TO_SECOND = -92;
589 } else {
590 const SQL_NO_DATA_FOUND = SQL_NO_DATA;
591 const SQL_CODE_YEAR = 1;
592 const SQL_CODE_MONTH = 2;
593 const SQL_CODE_DAY = 3;
594 const SQL_CODE_HOUR = 4;
595 const SQL_CODE_MINUTE = 5;
596 const SQL_CODE_SECOND = 6;
597 const SQL_CODE_YEAR_TO_MONTH = 7;
598 const SQL_CODE_DAY_TO_HOUR = 8;
599 const SQL_CODE_DAY_TO_MINUTE = 9;
600 const SQL_CODE_DAY_TO_SECOND = 10;
601 const SQL_CODE_HOUR_TO_MINUTE = 11;
602 const SQL_CODE_HOUR_TO_SECOND = 12;
603 const SQL_CODE_MINUTE_TO_SECOND = 13;
604 const SQL_INTERVAL_YEAR = 100 + SQL_CODE_YEAR;
605 const SQL_INTERVAL_MONTH = 100 + SQL_CODE_MONTH;
606 const SQL_INTERVAL_DAY = 100 + SQL_CODE_DAY;
607 const SQL_INTERVAL_HOUR = 100 + SQL_CODE_HOUR;
608 const SQL_INTERVAL_MINUTE = 100 + SQL_CODE_MINUTE;
609 const SQL_INTERVAL_SECOND = 100 + SQL_CODE_SECOND;
610 const SQL_INTERVAL_YEAR_TO_MONTH = 100 + SQL_CODE_YEAR_TO_MONTH;
611 const SQL_INTERVAL_DAY_TO_HOUR = 100 + SQL_CODE_DAY_TO_HOUR;
612 const SQL_INTERVAL_DAY_TO_MINUTE = 100 + SQL_CODE_DAY_TO_MINUTE;
613 const SQL_INTERVAL_DAY_TO_SECOND = 100 + SQL_CODE_DAY_TO_SECOND;
614 const SQL_INTERVAL_HOUR_TO_MINUTE = 100 + SQL_CODE_HOUR_TO_MINUTE;
615 const SQL_INTERVAL_HOUR_TO_SECOND = 100 + SQL_CODE_HOUR_TO_SECOND;
616 const SQL_INTERVAL_MINUTE_TO_SECOND = 100 + SQL_CODE_MINUTE_TO_SECOND;
617 }//[Yes] #endif
618
619
620 static if ((ODBCVER >= 0x0201) && (ODBCVER < 0x0300)) {
621 const SQL_OJ_CAPABILITIES = 65003;
622 }
623
624 static if (ODBCVER >= 0x0250) {
625 const SQL_NO_ACTION = 3;
626 const SQL_SET_DEFAULT = 4;
627 }
628
629 static if (ODBCVER >= 0x0300) {
630 const SQL_ACTIVE_ENVIRONMENTS = 116;
631 const SQL_AD_ADD_CONSTRAINT_DEFERRABLE = 0x00000080L;
632 const SQL_AD_ADD_CONSTRAINT_INITIALLY_DEFERRED = 0x00000020L;
633 const SQL_AD_ADD_CONSTRAINT_INITIALLY_IMMEDIATE = 0x00000040L;
634 const SQL_AD_ADD_CONSTRAINT_NON_DEFERRABLE = 0x00000100L;
635 const SQL_AD_ADD_DOMAIN_CONSTRAINT = 0x00000002L;
636 const SQL_AD_ADD_DOMAIN_DEFAULT = 0x00000008L;
637 const SQL_AD_CONSTRAINT_NAME_DEFINITION = 0x00000001L;
638 const SQL_AD_DROP_DOMAIN_CONSTRAINT = 0x00000004L;
639 const SQL_AD_DROP_DOMAIN_DEFAULT = 0x00000010L;
640 const SQL_AF_ALL = 0x00000040L;
641 const SQL_AF_AVG = 0x00000001L;
642 const SQL_AF_COUNT = 0x00000002L;
643 const SQL_AF_DISTINCT = 0x00000020L;
644 const SQL_AF_MAX = 0x00000004L;
645 const SQL_AF_MIN = 0x00000008L;
646 const SQL_AF_SUM = 0x00000010L;
647 const SQL_AGGREGATE_FUNCTIONS = 169;
648 const SQL_ALL_CATALOGS = "%";
649 const SQL_ALL_SCHEMAS = "%";
650 const SQL_ALL_TABLE_TYPES = "%";
651 const SQL_ALTER_DOMAIN = 117;
652 const SQL_AM_CONNECTION = 1;
653 const SQL_AM_NONE = 0;
654 const SQL_AM_STATEMENT = 2;
655 const SQL_API_ODBC3_ALL_FUNCTIONS = 999;
656 const SQL_API_ODBC3_ALL_FUNCTIONS_SIZE = 250;
657 const SQL_API_SQLALLOCHANDLESTD = 73;
658 const SQL_API_SQLBULKOPERATIONS = 24;
659 const SQL_ASYNC_MODE = 10021;
660 const SQL_AT_ADD_COLUMN_COLLATION = 0x00000080L;
661 const SQL_AT_ADD_COLUMN_DEFAULT = 0x00000040L;
662 const SQL_AT_ADD_COLUMN_SINGLE = 0x00000020L;
663 const SQL_AT_ADD_TABLE_CONSTRAINT = 0x00001000L;
664 const SQL_AT_CONSTRAINT_DEFERRABLE = 0x00040000L;
665 const SQL_AT_CONSTRAINT_INITIALLY_DEFERRED = 0x00010000L;
666 const SQL_AT_CONSTRAINT_INITIALLY_IMMEDIATE = 0x00020000L;
667 const SQL_AT_CONSTRAINT_NAME_DEFINITION = 0x00008000L;
668 const SQL_AT_CONSTRAINT_NON_DEFERRABLE = 0x00080000L;
669 const SQL_AT_DROP_COLUMN_CASCADE = 0x00000400L;
670 const SQL_AT_DROP_COLUMN_DEFAULT = 0x00000200L;
671 const SQL_AT_DROP_COLUMN_RESTRICT = 0x00000800L;
672 const SQL_AT_DROP_TABLE_CONSTRAINT_CASCADE = 0x00002000L;
673 const SQL_AT_DROP_TABLE_CONSTRAINT_RESTRICT = 0x00004000L;
674 const SQL_AT_SET_COLUMN_DEFAULT = 0x00000100L;
675 const SQL_ATTR_ACCESS_MODE = SQL_ACCESS_MODE;
676 const SQL_ATTR_ASYNC_ENABLE = 4;
677 const SQL_ATTR_AUTOCOMMIT = SQL_AUTOCOMMIT;
678 const SQL_ATTR_CONCURRENCY = SQL_CONCURRENCY;
679 const SQL_ATTR_CONNECTION_POOLING = 201;
680 const SQL_ATTR_CONNECTION_TIMEOUT = 113;
681 const SQL_ATTR_CP_MATCH = 202;
682 const SQL_ATTR_CURRENT_CATALOG = SQL_CURRENT_QUALIFIER;
683 const SQL_ATTR_CURSOR_TYPE = SQL_CURSOR_TYPE;
684 const SQL_ATTR_DISCONNECT_BEHAVIOR = 114;
685 const SQL_ATTR_ENABLE_AUTO_IPD = 15;
686 const SQL_ATTR_ENLIST_IN_DTC = 1207;
687 const SQL_ATTR_ENLIST_IN_XA = 1208;
688 const SQL_ATTR_FETCH_BOOKMARK_PTR = 16;
689 const SQL_ATTR_KEYSET_SIZE = SQL_KEYSET_SIZE;
690 const SQL_ATTR_LOGIN_TIMEOUT = SQL_LOGIN_TIMEOUT;
691 const SQL_ATTR_MAX_LENGTH = SQL_MAX_LENGTH;
692 const SQL_ATTR_MAX_ROWS = SQL_MAX_ROWS;
693 const SQL_ATTR_NOSCAN = SQL_NOSCAN;
694 const SQL_ATTR_ODBC_CURSORS = SQL_ODBC_CURSORS;
695 const SQL_ATTR_ODBC_VERSION = 200;
696 const SQL_ATTR_PACKET_SIZE = SQL_PACKET_SIZE;
697 const SQL_ATTR_PARAM_BIND_OFFSET_PTR = 17;
698 const SQL_ATTR_PARAM_BIND_TYPE = 18;
699 const SQL_ATTR_PARAM_OPERATION_PTR = 19;
700 const SQL_ATTR_PARAM_STATUS_PTR = 20;
701 const SQL_ATTR_PARAMS_PROCESSED_PTR = 21;
702 const SQL_ATTR_PARAMSET_SIZE = 22;
703 const SQL_ATTR_QUERY_TIMEOUT = SQL_QUERY_TIMEOUT;
704 const SQL_ATTR_QUIET_MODE = SQL_QUIET_MODE;
705 const SQL_ATTR_RETRIEVE_DATA = SQL_RETRIEVE_DATA;
706 const SQL_ATTR_ROW_ARRAY_SIZE = 27;
707 const SQL_ATTR_ROW_BIND_OFFSET_PTR = 23;
708 const SQL_ATTR_ROW_BIND_TYPE = SQL_BIND_TYPE;
709 const SQL_ATTR_ROW_NUMBER = SQL_ROW_NUMBER;
710 const SQL_ATTR_ROW_OPERATION_PTR = 24;
711 const SQL_ATTR_ROW_STATUS_PTR = 25;
712 const SQL_ATTR_ROWS_FETCHED_PTR = 26;
713 const SQL_ATTR_SIMULATE_CURSOR = SQL_SIMULATE_CURSOR;
714 const SQL_ATTR_TRACE = SQL_OPT_TRACE;
715 const SQL_ATTR_TRACEFILE = SQL_OPT_TRACEFILE;
716 const SQL_ATTR_TRANSLATE_LIB = SQL_TRANSLATE_DLL;
717 const SQL_ATTR_TRANSLATE_OPTION = SQL_TRANSLATE_OPTION;
718 const SQL_ATTR_TXN_ISOLATION = SQL_TXN_ISOLATION;
719 const SQL_ATTR_USE_BOOKMARKS = SQL_USE_BOOKMARKS;
720 const SQL_BATCH_ROW_COUNT = 120;
721 const SQL_BATCH_SUPPORT = 121;
722 const SQL_BRC_EXPLICIT = 0x0000002;
723 const SQL_BRC_PROCEDURES = 0x0000001;
724 const SQL_BRC_ROLLED_UP = 0x0000004;
725 const SQL_BS_ROW_COUNT_EXPLICIT = 0x00000002L;
726 const SQL_BS_ROW_COUNT_PROC = 0x00000008L;
727 const SQL_BS_SELECT_EXPLICIT = 0x00000001L;
728 const SQL_BS_SELECT_PROC = 0x00000004L;
729 const SQL_C_INTERVAL_DAY = SQL_INTERVAL_DAY;
730 const SQL_C_INTERVAL_DAY_TO_HOUR = SQL_INTERVAL_DAY_TO_HOUR;
731 const SQL_C_INTERVAL_DAY_TO_MINUTE = SQL_INTERVAL_DAY_TO_MINUTE;
732 const SQL_C_INTERVAL_DAY_TO_SECOND = SQL_INTERVAL_DAY_TO_SECOND;
733 const SQL_C_INTERVAL_HOUR = SQL_INTERVAL_HOUR;
734 const SQL_C_INTERVAL_HOUR_TO_MINUTE = SQL_INTERVAL_HOUR_TO_MINUTE;
735 const SQL_C_INTERVAL_HOUR_TO_SECOND = SQL_INTERVAL_HOUR_TO_SECOND;
736 const SQL_C_INTERVAL_MINUTE = SQL_INTERVAL_MINUTE;
737 const SQL_C_INTERVAL_MINUTE_TO_SECOND = SQL_INTERVAL_MINUTE_TO_SECOND;
738 const SQL_C_INTERVAL_MONTH = SQL_INTERVAL_MONTH;
739 const SQL_C_INTERVAL_SECOND = SQL_INTERVAL_SECOND;
740 const SQL_C_INTERVAL_YEAR = SQL_INTERVAL_YEAR;
741 const SQL_C_INTERVAL_YEAR_TO_MONTH = SQL_INTERVAL_YEAR_TO_MONTH;
742 const SQL_C_NUMERIC = SQL_NUMERIC;
743 const SQL_C_SBIGINT = SQL_BIGINT+SQL_SIGNED_OFFSET;
744 const SQL_C_TYPE_DATE = SQL_TYPE_DATE;
745 const SQL_C_TYPE_TIME = SQL_TYPE_TIME;
746 const SQL_C_TYPE_TIMESTAMP = SQL_TYPE_TIMESTAMP;
747 const SQL_C_UBIGINT = SQL_BIGINT+SQL_UNSIGNED_OFFSET;
748 const SQL_C_VARBOOKMARK = SQL_C_BINARY;
749 const SQL_CA_CONSTRAINT_DEFERRABLE = 0x00000040L;
750 const SQL_CA_CONSTRAINT_INITIALLY_DEFERRED = 0x00000010L;
751 const SQL_CA_CONSTRAINT_INITIALLY_IMMEDIATE = 0x00000020L;
752 const SQL_CA_CONSTRAINT_NON_DEFERRABLE = 0x00000080L;
753 const SQL_CA_CREATE_ASSERTION = 0x00000001L;
754 const SQL_CA1_ABSOLUTE = 0x00000002L;
755 const SQL_CA1_BOOKMARK = 0x00000008L;
756 const SQL_CA1_BULK_ADD = 0x00010000L;
757 const SQL_CA1_BULK_DELETE_BY_BOOKMARK = 0x00040000L;
758 const SQL_CA1_BULK_FETCH_BY_BOOKMARK = 0x00080000L;
759 const SQL_CA1_BULK_UPDATE_BY_BOOKMARK = 0x00020000L;
760 const SQL_CA1_LOCK_EXCLUSIVE = 0x00000080L;
761 const SQL_CA1_LOCK_NO_CHANGE = 0x00000040L;
762 const SQL_CA1_LOCK_UNLOCK = 0x00000100L;
763 const SQL_CA1_NEXT = 0x00000001L;
764 const SQL_CA1_POS_DELETE = 0x00000800L;
765 const SQL_CA1_POS_POSITION = 0x00000200L;
766 const SQL_CA1_POS_REFRESH = 0x00001000L;
767 const SQL_CA1_POS_UPDATE = 0x00000400L;
768 const SQL_CA1_POSITIONED_DELETE = 0x00004000L;
769 const SQL_CA1_POSITIONED_UPDATE = 0x00002000L;
770 const SQL_CA1_RELATIVE = 0x00000004L;
771 const SQL_CA1_SELECT_FOR_UPDATE = 0x00008000L;
772 const SQL_CA2_CRC_APPROXIMATE = 0x00002000L;
773 const SQL_CA2_CRC_EXACT = 0x00001000L;
774 const SQL_CA2_LOCK_CONCURRENCY = 0x00000002L;
775
776 const SQL_CA2_MAX_ROWS_CATALOG = 0x00000800L;
777 const SQL_CA2_MAX_ROWS_DELETE = 0x00000200L;
778 const SQL_CA2_MAX_ROWS_INSERT = 0x00000100L;
779 const SQL_CA2_MAX_ROWS_SELECT = 0x00000080L;
780 const SQL_CA2_MAX_ROWS_UPDATE = 0x00000400L;
781 const SQL_CA2_MAX_ROWS_AFFECTS_ALL = SQL_CA2_MAX_ROWS_SELECT | SQL_CA2_MAX_ROWS_INSERT |
782 SQL_CA2_MAX_ROWS_DELETE | SQL_CA2_MAX_ROWS_UPDATE | SQL_CA2_MAX_ROWS_CATALOG;
783
784 const SQL_CA2_OPT_ROWVER_CONCURRENCY = 0x00000004L;
785 const SQL_CA2_OPT_VALUES_CONCURRENCY = 0x00000008L;
786 const SQL_CA2_READ_ONLY_CONCURRENCY = 0x00000001L;
787 const SQL_CA2_SENSITIVITY_ADDITIONS = 0x00000010L;
788 const SQL_CA2_SENSITIVITY_DELETIONS = 0x00000020L;
789 const SQL_CA2_SENSITIVITY_UPDATES = 0x00000040L;
790 const SQL_CA2_SIMULATE_NON_UNIQUE = 0x00004000L;
791 const SQL_CA2_SIMULATE_TRY_UNIQUE = 0x00008000L;
792 const SQL_CA2_SIMULATE_UNIQUE = 0x00010000L;
793 const SQL_CATALOG_LOCATION = SQL_QUALIFIER_LOCATION;
794 const SQL_CATALOG_NAME_SEPARATOR = SQL_QUALIFIER_NAME_SEPARATOR;
795 const SQL_CATALOG_TERM = SQL_QUALIFIER_TERM;
796 const SQL_CATALOG_USAGE = SQL_QUALIFIER_USAGE;
797 const SQL_CCOL_CREATE_COLLATION = 0x00000001L;
798 const SQL_CCS_COLLATE_CLAUSE = 0x00000002L;
799 const SQL_CCS_CREATE_CHARACTER_SET = 0x00000001L;
800 const SQL_CCS_LIMITED_COLLATION = 0x00000004L;
801 const SQL_CDO_COLLATION = 0x00000008L;
802 const SQL_CDO_CONSTRAINT = 0x00000004L;
803 const SQL_CDO_CONSTRAINT_DEFERRABLE = 0x00000080L;
804 const SQL_CDO_CONSTRAINT_INITIALLY_DEFERRED = 0x00000020L;
805 const SQL_CDO_CONSTRAINT_INITIALLY_IMMEDIATE = 0x00000040L;
806 const SQL_CDO_CONSTRAINT_NAME_DEFINITION = 0x00000010L;
807 const SQL_CDO_CONSTRAINT_NON_DEFERRABLE = 0x00000100L;
808 const SQL_CDO_CREATE_DOMAIN = 0x00000001L;
809 const SQL_CDO_DEFAULT = 0x00000002L;
810 const SQL_CL_END = SQL_QL_END;
811 const SQL_CL_START = SQL_QL_START;
812 const SQL_COL_PRED_BASIC = SQL_ALL_EXCEPT_LIKE;
813 const SQL_COL_PRED_CHAR = SQL_LIKE_ONLY;
814 const SQL_COLUMN_DRIVER_START = 1000;
815 const SQL_COLUMN_IGNORE = SQL_IGNORE;
816 const SQL_COLUMN_NUMBER_UNKNOWN = -2;
817 const SQL_CONVERT_GUID = 173;
818
819 const SQL_CONVERT_WCHAR = 122;
820 const SQL_CONVERT_INTERVAL_DAY_TIME = 123;
821 const SQL_CONVERT_INTERVAL_YEAR_MONTH = 124;
822 const SQL_CONVERT_WLONGVARCHAR = 125;
823 const SQL_CONVERT_WVARCHAR = 126;
824
825 const SQL_CREATE_ASSERTION = 127;
826 const SQL_CREATE_CHARACTER_SET = 128;
827 const SQL_CREATE_COLLATION = 129;
828 const SQL_CREATE_DOMAIN = 130;
829 const SQL_CREATE_SCHEMA = 131;
830 const SQL_CREATE_TABLE = 132;
831 const SQL_CREATE_TRANSLATION = 133;
832 const SQL_CREATE_VIEW = 134;
833
834
835 const SQL_CP_OFF = 0UL;
836 const SQL_CP_DEFAULT = SQL_CP_OFF;
837 const SQL_CP_ONE_PER_DRIVER = 1UL;
838 const SQL_CP_ONE_PER_HENV = 2UL;
839
840 const SQL_CP_STRICT_MATCH = 0UL;
841 const SQL_CP_MATCH_DEFAULT = SQL_CP_STRICT_MATCH;
842 const SQL_CP_RELAXED_MATCH = 1UL;
843
844 const SQL_CS_CREATE_SCHEMA = 0x00000001L;
845 const SQL_CS_AUTHORIZATION = 0x00000002L;
846 const SQL_CS_DEFAULT_CHARACTER_SET = 0x00000004L;
847
848 const SQL_CT_COLUMN_COLLATION = 0x00000800L;
849 const SQL_CT_COLUMN_CONSTRAINT = 0x00000200L;
850 const SQL_CT_COLUMN_DEFAULT = 0x00000400L;
851 const SQL_CT_COMMIT_DELETE = 0x00000004L;
852 const SQL_CT_COMMIT_PRESERVE = 0x00000002L;
853 const SQL_CT_CONSTRAINT_DEFERRABLE = 0x00000080L;
854 const SQL_CT_CONSTRAINT_INITIALLY_DEFERRED = 0x00000020L;
855 const SQL_CT_CONSTRAINT_INITIALLY_IMMEDIATE = 0x00000040L;
856 const SQL_CT_CONSTRAINT_NAME_DEFINITION = 0x00002000L;
857 const SQL_CT_CONSTRAINT_NON_DEFERRABLE = 0x00000100L;
858 const SQL_CT_CREATE_TABLE = 0x00000001L;
859 const SQL_CT_GLOBAL_TEMPORARY = 0x00000008L;
860 const SQL_CT_LOCAL_TEMPORARY = 0x00000010L;
861 const SQL_CT_TABLE_CONSTRAINT = 0x00001000L;
862
863 const SQL_CTR_CREATE_TRANSLATION = 0x00000001L;
864
865 const SQL_CU_DML_STATEMENTS = SQL_QU_DML_STATEMENTS;
866 const SQL_CU_INDEX_DEFINITION = SQL_QU_INDEX_DEFINITION;
867 const SQL_CU_PRIVILEGE_DEFINITION = SQL_QU_PRIVILEGE_DEFINITION;
868 const SQL_CU_PROCEDURE_INVOCATION = SQL_QU_PROCEDURE_INVOCATION;
869 const SQL_CU_TABLE_DEFINITION = SQL_QU_TABLE_DEFINITION;
870
871 const SQL_CVT_INTERVAL_YEAR_MONTH = 0x00080000L;
872 const SQL_CVT_INTERVAL_DAY_TIME = 0x00100000L;
873 const SQL_CVT_WCHAR = 0x00200000L;
874 const SQL_CVT_WLONGVARCHAR = 0x00400000L;
875 const SQL_CVT_WVARCHAR = 0x00800000L;
876 const SQL_CVT_GUID = 0x01000000L;
877
878 const SQL_DA_DROP_ASSERTION = 0x00000001L;
879 const SQL_DATETIME_LITERALS = 119;
880
881 const SQL_DB_DISCONNECT = 1UL;
882 const SQL_DB_RETURN_TO_POOL = 0UL;
883 const SQL_DB_DEFAULT = SQL_DB_RETURN_TO_POOL;
884
885 const SQL_DC_DROP_COLLATION = 0x00000001L;
886 const SQL_DCS_DROP_CHARACTER_SET = 0x00000001L;
887 const SQL_DD_CASCADE = 0x00000004L;
888 const SQL_DD_DROP_DOMAIN = 0x00000001L;
889 const SQL_DD_RESTRICT = 0x00000002L;
890 const SQL_DDL_INDEX = 170;
891 const SQL_DELETE_BY_BOOKMARK = 6;
892 const SQL_DESC_ARRAY_SIZE = 20;
893 const SQL_DESC_ARRAY_STATUS_PTR = 21;
894 const SQL_DESC_AUTO_UNIQUE_VALUE = SQL_COLUMN_AUTO_INCREMENT;
895 const SQL_DESC_BASE_COLUMN_NAME = 22;
896 const SQL_DESC_BASE_TABLE_NAME = 23;
897 const SQL_DESC_BIND_OFFSET_PTR = 24;
898 const SQL_DESC_BIND_TYPE = 25;
899 const SQL_DESC_CASE_SENSITIVE = SQL_COLUMN_CASE_SENSITIVE;
900 const SQL_DESC_CATALOG_NAME = SQL_COLUMN_QUALIFIER_NAME;
901 const SQL_DESC_CONCISE_TYPE = SQL_COLUMN_TYPE;
902 const SQL_DESC_DATETIME_INTERVAL_PRECISION = 26;
903 const SQL_DESC_DISPLAY_SIZE = SQL_COLUMN_DISPLAY_SIZE;
904 const SQL_DESC_FIXED_PREC_SCALE = SQL_COLUMN_MONEY;
905 const SQL_DESC_LABEL = SQL_COLUMN_LABEL;
906 const SQL_DESC_LITERAL_PREFIX = 27;
907 const SQL_DESC_LITERAL_SUFFIX = 28;
908 const SQL_DESC_LOCAL_TYPE_NAME = 29;
909 const SQL_DESC_MAXIMUM_SCALE = 30;
910 const SQL_DESC_MINIMUM_SCALE = 31;
911 const SQL_DESC_NUM_PREC_RADIX = 32;
912 const SQL_DESC_PARAMETER_TYPE = 33;
913 const SQL_DESC_ROWS_PROCESSED_PTR = 34;
914 const SQL_DESC_SCHEMA_NAME = SQL_COLUMN_OWNER_NAME;
915 const SQL_DESC_SEARCHABLE = SQL_COLUMN_SEARCHABLE;
916 const SQL_DESC_TABLE_NAME = SQL_COLUMN_TABLE_NAME;
917 const SQL_DESC_TYPE_NAME = SQL_COLUMN_TYPE_NAME;
918 const SQL_DESC_UNSIGNED = SQL_COLUMN_UNSIGNED;
919 const SQL_DESC_UPDATABLE = SQL_COLUMN_UPDATABLE;
920 const SQL_DI_CREATE_INDEX = 0x00000001L;
921 const SQL_DI_DROP_INDEX = 0x00000002L;
922
923 const SQL_DIAG_COLUMN_NUMBER = -1247;
924 const SQL_DIAG_ROW_NUMBER = -1248;
925 const SQL_DIAG_CURSOR_ROW_COUNT = -1249;
926
927 const SQL_DL_SQL92_DATE = 0x00000001L;
928 const SQL_DL_SQL92_INTERVAL_DAY = 0x00000020L;
929 const SQL_DL_SQL92_INTERVAL_DAY_TO_HOUR = 0x00000400L;
930 const SQL_DL_SQL92_INTERVAL_DAY_TO_MINUTE = 0x00000800L;
931 const SQL_DL_SQL92_INTERVAL_DAY_TO_SECOND = 0x00001000L;
932 const SQL_DL_SQL92_INTERVAL_HOUR = 0x00000040L;
933 const SQL_DL_SQL92_INTERVAL_HOUR_TO_MINUTE = 0x00002000L;
934 const SQL_DL_SQL92_INTERVAL_HOUR_TO_SECOND = 0x00004000L;
935 const SQL_DL_SQL92_INTERVAL_MINUTE = 0x00000080L;
936 const SQL_DL_SQL92_INTERVAL_MINUTE_TO_SECOND = 0x00008000L;
937 const SQL_DL_SQL92_INTERVAL_MONTH = 0x00000010L;
938 const SQL_DL_SQL92_INTERVAL_SECOND = 0x00000100L;
939 const SQL_DL_SQL92_INTERVAL_YEAR = 0x00000008L;
940 const SQL_DL_SQL92_INTERVAL_YEAR_TO_MONTH = 0x00000200L;
941 const SQL_DL_SQL92_TIME = 0x00000002L;
942 const SQL_DL_SQL92_TIMESTAMP = 0x00000004L;
943 const SQL_DM_VER = 171;
944 const SQL_DRIVER_HDESC = 135;
945 const SQL_DROP_ASSERTION = 136;
946 const SQL_DROP_CHARACTER_SET = 137;
947 const SQL_DROP_COLLATION = 138;
948 const SQL_DROP_DOMAIN = 139;
949 const SQL_DROP_SCHEMA = 140;
950 const SQL_DROP_TABLE = 141;
951 const SQL_DROP_TRANSLATION = 142;
952 const SQL_DROP_VIEW = 143;
953 const SQL_DS_CASCADE = 0x00000004L;
954 const SQL_DS_DROP_SCHEMA = 0x00000001L;
955 const SQL_DS_RESTRICT = 0x00000002L;
956 const SQL_DT_CASCADE = 0x00000004L;
957 const SQL_DT_DROP_TABLE = 0x00000001L;
958 const SQL_DT_RESTRICT = 0x00000002L;
959 const SQL_DTC_DONE = 0L;
960 const SQL_DTR_DROP_TRANSLATION = 0x00000001L;
961 const SQL_DV_CASCADE = 0x00000004L;
962 const SQL_DV_DROP_VIEW = 0x00000001L;
963 const SQL_DV_RESTRICT = 0x00000002L;
964 const SQL_DYNAMIC_CURSOR_ATTRIBUTES1 = 144;
965 const SQL_DYNAMIC_CURSOR_ATTRIBUTES2 = 145;
966 const SQL_EXT_API_LAST = SQL_API_SQLBINDPARAMETER;
967 const SQL_EXT_API_START = 40;
968 const SQL_FETCH_BY_BOOKMARK = 7;
969 const SQL_FETCH_FIRST_SYSTEM = 32;
970 const SQL_FETCH_FIRST_USER = 31;
971 const SQL_FN_CVT_CAST = 0x00000002L;
972 const SQL_FN_STR_BIT_LENGTH = 0x00080000L;
973 const SQL_FN_STR_CHAR_LENGTH = 0x00100000L;
974 const SQL_FN_STR_CHARACTER_LENGTH = 0x00200000L;
975 const SQL_FN_STR_OCTET_LENGTH = 0x00400000L;
976 const SQL_FN_STR_POSITION = 0x00800000L;
977 const SQL_FN_TD_CURRENT_DATE = 0x00020000L;
978 const SQL_FN_TD_CURRENT_TIME = 0x00040000L;
979 const SQL_FN_TD_CURRENT_TIMESTAMP = 0x00080000L;
980 const SQL_FN_TD_EXTRACT = 0x00100000L;
981 const SQL_FORWARD_ONLY_CURSOR_ATTRIBUTES1 = 146;
982 const SQL_FORWARD_ONLY_CURSOR_ATTRIBUTES2 = 147;
983 /* #define SQL_FUNC_EXISTS(exists, api)
984 ((*(((UWORD*) (exists)) + ((api) >> 4)) & (1 << ((api) & 15)) ) ?
985 SQL_TRUE : SQL_FALSE )
986 */
987 const SQL_GB_COLLATE = 0x0004;
988 const SQL_HANDLE_SENV = 5;
989
990 const SQL_IK_NONE = 0;
991 const SQL_IK_ASC = 1;
992 const SQL_IK_DESC = 2;
993 const SQL_IK_ALL = SQL_IK_ASC | SQL_IK_DESC;
994
995 const SQL_INDEX_KEYWORDS = 148;
996 const SQL_INFO_DRIVER_START = 1000;
997 const SQL_INFO_LAST = SQL_QUALIFIER_LOCATION;
998 const SQL_INFO_SCHEMA_VIEWS = 149;
999 const SQL_INITIALLY_DEFERRED = 5;
1000 const SQL_INITIALLY_IMMEDIATE = 6;
1001 const SQL_INSERT_STATEMENT = 172;
1002 const SQL_INTERVAL = 10;
1003 const SQL_IS_INSERT_LITERALS = 0x00000001L;
1004 const SQL_IS_INSERT_SEARCHED = 0x00000002L;
1005 const SQL_IS_INTEGER = -6;
1006 const SQL_IS_POINTER = -4;
1007 const SQL_IS_SELECT_INTO = 0x00000004L;
1008 const SQL_IS_SMALLINT = -8;
1009 const SQL_IS_UINTEGER = -5;
1010 const SQL_IS_USMALLINT = -7;
1011 const SQL_ISV_ASSERTIONS = 0x00000001L;
1012 const SQL_ISV_CHARACTER_SETS = 0x00000002L;
1013 const SQL_ISV_CHECK_CONSTRAINTS = 0x00000004L;
1014 const SQL_ISV_COLLATIONS = 0x00000008L;
1015 const SQL_ISV_COLUMN_DOMAIN_USAGE = 0x00000010L;
1016 const SQL_ISV_COLUMN_PRIVILEGES = 0x00000020L;
1017 const SQL_ISV_COLUMNS = 0x00000040L;
1018 const SQL_ISV_CONSTRAINT_COLUMN_USAGE = 0x00000080L;
1019 const SQL_ISV_CONSTRAINT_TABLE_USAGE = 0x00000100L;
1020 const SQL_ISV_DOMAIN_CONSTRAINTS = 0x00000200L;
1021 const SQL_ISV_DOMAINS = 0x00000400L;
1022 const SQL_ISV_KEY_COLUMN_USAGE = 0x00000800L;
1023 const SQL_ISV_REFERENTIAL_CONSTRAINTS = 0x00001000L;
1024 const SQL_ISV_SCHEMATA = 0x00002000L;
1025 const SQL_ISV_SQL_LANGUAGES = 0x00004000L;
1026 const SQL_ISV_TABLE_CONSTRAINTS = 0x00008000L;
1027 const SQL_ISV_TABLE_PRIVILEGES = 0x00010000L;
1028 const SQL_ISV_TABLES = 0x00020000L;
1029 const SQL_ISV_TRANSLATIONS = 0x00040000L;
1030 const SQL_ISV_USAGE_PRIVILEGES = 0x00080000L;
1031 const SQL_ISV_VIEW_COLUMN_USAGE = 0x00100000L;
1032 const SQL_ISV_VIEW_TABLE_USAGE = 0x00200000L;
1033 const SQL_ISV_VIEWS = 0x00400000L;
1034 const SQL_KEYSET_CURSOR_ATTRIBUTES1 = 150;
1035 const SQL_KEYSET_CURSOR_ATTRIBUTES2 = 151;
1036 const SQL_MAX_ASYNC_CONCURRENT_STATEMENTS = 10022;
1037 const SQL_NO_COLUMN_NUMBER = -1;
1038 const SQL_NO_ROW_NUMBER = -1;
1039 const SQL_NOT_DEFERRABLE = 7;
1040 const SQL_NUM_EXTENSIONS = SQL_EXT_API_LAST-SQL_EXT_API_START+1;
1041 const SQL_NUM_FUNCTIONS = 23;
1042 const SQL_ODBC_INTERFACE_CONFORMANCE = 152;
1043
1044 enum : ULONG {
1045 SQL_OIC_CORE = 1,
1046 SQL_OIC_LEVEL1,
1047 SQL_OIC_LEVEL2
1048 }
1049 enum : ULONG {
1050 SQL_OV_ODBC2 = 2,
1051 SQL_OV_ODBC3 = 3
1052 }
1053
1054 const ULONG
1055 SQL_PARAM_BIND_BY_COLUMN = 0,
1056 SQL_PARAM_BIND_TYPE_DEFAULT = SQL_PARAM_BIND_BY_COLUMN;
1057
1058 const SQL_PARAM_ARRAY_ROW_COUNTS = 153;
1059 const SQL_PARAM_ARRAY_SELECTS = 154;
1060 const SQL_PARAM_DIAG_UNAVAILABLE = 1;
1061 const SQL_PARAM_ERROR = 5;
1062 const SQL_PARAM_IGNORE = 1;
1063 const SQL_PARAM_PROCEED = 0;
1064 const SQL_PARAM_SUCCESS = 0;
1065 const SQL_PARAM_SUCCESS_WITH_INFO = 6;
1066 const SQL_PARAM_UNUSED = 7;
1067
1068 const SQL_PARC_BATCH = 1;
1069 const SQL_PARC_NO_BATCH = 2;
1070 const SQL_PAS_BATCH = 1;
1071 const SQL_PAS_NO_BATCH = 2;
1072 const SQL_PAS_NO_SELECT = 3;
1073
1074 const SQL_ROW_IGNORE = 1;
1075 const SQL_ROW_NUMBER_UNKNOWN = -2;
1076 const SQL_ROW_PROCEED = 0;
1077 const SQL_ROW_SUCCESS_WITH_INFO = 6;
1078
1079 const SQL_SC_FIPS127_2_TRANSITIONAL = 0x00000002L;
1080 const SQL_SC_SQL92_ENTRY = 0x00000001L;
1081 const SQL_SC_SQL92_FULL = 0x00000008L;
1082 const SQL_SC_SQL92_INTERMEDIATE = 0x00000004L;
1083
1084 const SQL_SCC_ISO92_CLI = 0x00000002L;
1085 const SQL_SCC_XOPEN_CLI_VERSION1 = 0x00000001L;
1086
1087 const SQL_SCHEMA_TERM = SQL_OWNER_TERM;
1088 const SQL_SCHEMA_USAGE = SQL_OWNER_USAGE;
1089 const SQL_SDF_CURRENT_DATE = 0x00000001L;
1090 const SQL_SDF_CURRENT_TIME = 0x00000002L;
1091 const SQL_SDF_CURRENT_TIMESTAMP = 0x00000004L;
1092 const SQL_SFKD_CASCADE = 0x00000001L;
1093 const SQL_SFKD_NO_ACTION = 0x00000002L;
1094 const SQL_SFKD_SET_DEFAULT = 0x00000004L;
1095 const SQL_SFKD_SET_NULL = 0x00000008L;
1096 const SQL_SFKU_CASCADE = 0x00000001L;
1097 const SQL_SFKU_NO_ACTION = 0x00000002L;
1098 const SQL_SFKU_SET_DEFAULT = 0x00000004L;
1099 const SQL_SFKU_SET_NULL = 0x00000008L;
1100 const SQL_SG_DELETE_TABLE = 0x00000020L;
1101 const SQL_SG_INSERT_COLUMN = 0x00000080L;
1102 const SQL_SG_INSERT_TABLE = 0x00000040L;
1103 const SQL_SG_REFERENCES_COLUMN = 0x00000200L;
1104 const SQL_SG_REFERENCES_TABLE = 0x00000100L;
1105 const SQL_SG_SELECT_TABLE = 0x00000400L;
1106 const SQL_SG_UPDATE_COLUMN = 0x00001000L;
1107 const SQL_SG_UPDATE_TABLE = 0x00000800L;
1108 const SQL_SG_USAGE_ON_CHARACTER_SET = 0x00000002L;
1109 const SQL_SG_USAGE_ON_COLLATION = 0x00000004L;
1110 const SQL_SG_USAGE_ON_DOMAIN = 0x00000001L;
1111 const SQL_SG_USAGE_ON_TRANSLATION = 0x00000008L;
1112 const SQL_SG_WITH_GRANT_OPTION = 0x00000010L;
1113 const SQL_SNVF_BIT_LENGTH = 0x00000001L;
1114 const SQL_SNVF_CHAR_LENGTH = 0x00000002L;
1115 const SQL_SNVF_CHARACTER_LENGTH = 0x00000004L;
1116 const SQL_SNVF_EXTRACT = 0x00000008L;
1117 const SQL_SNVF_OCTET_LENGTH = 0x00000010L;
1118 const SQL_SNVF_POSITION = 0x00000020L;
1119 const SQL_SP_BETWEEN = 0x00000800L;
1120 const SQL_SP_COMPARISON = 0x00001000L;
1121 const SQL_SP_EXISTS = 0x00000001L;
1122 const SQL_SP_IN = 0x00000400L;
1123 const SQL_SP_ISNOTNULL = 0x00000002L;
1124 const SQL_SP_ISNULL = 0x00000004L;
1125 const SQL_SP_LIKE = 0x00000200L;
1126 const SQL_SP_MATCH_FULL = 0x00000008L;
1127 const SQL_SP_MATCH_PARTIAL = 0x00000010L;
1128 const SQL_SP_MATCH_UNIQUE_FULL = 0x00000020L;
1129 const SQL_SP_MATCH_UNIQUE_PARTIAL = 0x00000040L;
1130 const SQL_SP_OVERLAPS = 0x00000080L;
1131 const SQL_SP_QUANTIFIED_COMPARISON = 0x00002000L;
1132 const SQL_SP_UNIQUE = 0x00000100L;
1133 const SQL_SQL_CONFORMANCE = 118;
1134 const SQL_SQL92_DATETIME_FUNCTIONS = 155;
1135 const SQL_SQL92_FOREIGN_KEY_DELETE_RULE = 156;
1136 const SQL_SQL92_FOREIGN_KEY_UPDATE_RULE = 157;
1137 const SQL_SQL92_GRANT = 158;
1138 const SQL_SQL92_NUMERIC_VALUE_FUNCTIONS = 159;
1139 const SQL_SQL92_PREDICATES = 160;
1140 const SQL_SQL92_RELATIONAL_JOIN_OPERATORS = 161;
1141 const SQL_SQL92_REVOKE = 162;
1142 const SQL_SQL92_ROW_VALUE_CONSTRUCTOR = 163;
1143 const SQL_SQL92_STRING_FUNCTIONS = 164;
1144 const SQL_SQL92_VALUE_EXPRESSIONS = 165;
1145 const SQL_SR_CASCADE = 0x00000020L;
1146 const SQL_SR_DELETE_TABLE = 0x00000080L;
1147 const SQL_SR_GRANT_OPTION_FOR = 0x00000010L;
1148 const SQL_SR_INSERT_COLUMN = 0x00000200L;
1149 const SQL_SR_INSERT_TABLE = 0x00000100L;
1150 const SQL_SR_REFERENCES_COLUMN = 0x00000800L;
1151 const SQL_SR_REFERENCES_TABLE = 0x00000400L;
1152 const SQL_SR_RESTRICT = 0x00000040L;
1153 const SQL_SR_SELECT_TABLE = 0x00001000L;
1154 const SQL_SR_UPDATE_COLUMN = 0x00004000L;
1155 const SQL_SR_UPDATE_TABLE = 0x00002000L;
1156 const SQL_SR_USAGE_ON_CHARACTER_SET = 0x00000002L;
1157 const SQL_SR_USAGE_ON_COLLATION = 0x00000004L;
1158 const SQL_SR_USAGE_ON_DOMAIN = 0x00000001L;
1159 const SQL_SR_USAGE_ON_TRANSLATION = 0x00000008L;
1160 const SQL_SRJO_CORRESPONDING_CLAUSE = 0x00000001L;
1161 const SQL_SRJO_CROSS_JOIN = 0x00000002L;
1162 const SQL_SRJO_EXCEPT_JOIN = 0x00000004L;
1163 const SQL_SRJO_FULL_OUTER_JOIN = 0x00000008L;
1164 const SQL_SRJO_INNER_JOIN = 0x00000010L;
1165 const SQL_SRJO_INTERSECT_JOIN = 0x00000020L;
1166 const SQL_SRJO_LEFT_OUTER_JOIN = 0x00000040L;
1167 const SQL_SRJO_NATURAL_JOIN = 0x00000080L;
1168 const SQL_SRJO_RIGHT_OUTER_JOIN = 0x00000100L;
1169 const SQL_SRJO_UNION_JOIN = 0x00000200L;
1170 const SQL_SRVC_DEFAULT = 0x00000004L;
1171 const SQL_SRVC_NULL = 0x00000002L;
1172 const SQL_SRVC_ROW_SUBQUERY = 0x00000008L;
1173 const SQL_SRVC_VALUE_EXPRESSION = 0x00000001L;
1174 const SQL_SSF_CONVERT = 0x00000001L;
1175 const SQL_SSF_LOWER = 0x00000002L;
1176 const SQL_SSF_SUBSTRING = 0x00000008L;
1177 const SQL_SSF_TRANSLATE = 0x00000010L;
1178 const SQL_SSF_TRIM_BOTH = 0x00000020L;
1179 const SQL_SSF_TRIM_LEADING = 0x00000040L;
1180 const SQL_SSF_TRIM_TRAILING = 0x00000080L;
1181 const SQL_SSF_UPPER = 0x00000004L;
1182 const SQL_STANDARD_CLI_CONFORMANCE = 166;
1183 const SQL_STATIC_CURSOR_ATTRIBUTES1 = 167;
1184 const SQL_STATIC_CURSOR_ATTRIBUTES2 = 168;
1185 const SQL_SU_DML_STATEMENTS = SQL_OU_DML_STATEMENTS;
1186 const SQL_SU_INDEX_DEFINITION = SQL_OU_INDEX_DEFINITION;
1187 const SQL_SU_PRIVILEGE_DEFINITION = SQL_OU_PRIVILEGE_DEFINITION;
1188 const SQL_SU_PROCEDURE_INVOCATION = SQL_OU_PROCEDURE_INVOCATION;
1189 const SQL_SU_TABLE_DEFINITION = SQL_OU_TABLE_DEFINITION;
1190 const SQL_SVE_CASE = 0x00000001L;
1191 const SQL_SVE_CAST = 0x00000002L;
1192 const SQL_SVE_COALESCE = 0x00000004L;
1193 const SQL_SVE_NULLIF = 0x00000008L;
1194 const SQL_UB_FIXED = SQL_UB_ON;
1195 const SQL_UB_VARIABLE = 2UL;
1196 const SQL_UNION_STATEMENT = SQL_UNION;
1197 const SQL_UPDATE_BY_BOOKMARK = 5;
1198 const SQL_US_UNION = SQL_U_UNION;
1199 const SQL_US_UNION_ALL = SQL_U_UNION_ALL;
1200 }//[Yes] #endif /* ODBCVER >= 0x300 */
1201 static if (ODBCVER >= 0x0350) {
1202 const SQL_DESC_ROWVER = 35;
1203 const SQL_GUID = -11;
1204 const SQL_C_GUID = SQL_GUID;
1205 //#ifdef ODBC_STD
1206 //#define SQLAllocHandle SQLAllocHandleStd
1207 //#define SQLAllocEnv(p) SQLAllocHandleStd(SQL_HANDLE_ENV, SQL_NULL_HANDLE, p)
1208 //#define SQL_YEAR SQL_CODE_YEAR
1209 //#define SQL_MONTH SQL_CODE_MONTH
1210 //#define SQL_DAY SQL_CODE_DAY
1211 //#define SQL_HOUR SQL_CODE_HOUR
1212 //#define SQL_MINUTE SQL_CODE_MINUTE
1213 //#define SQL_SECOND SQL_CODE_SECOND
1214 //#define SQL_YEAR_TO_MONTH SQL_CODE_YEAR_TO_MONTH
1215 //#define SQL_DAY_TO_HOUR SQL_CODE_DAY_TO_HOUR
1216 //#define SQL_DAY_TO_MINUTE SQL_CODE_DAY_TO_MINUTE
1217 //#define SQL_DAY_TO_SECOND SQL_CODE_DAY_TO_SECOND
1218 //#define SQL_HOUR_TO_MINUTE SQL_CODE_HOUR_TO_MINUTE
1219 //#define SQL_HOUR_TO_SECOND SQL_CODE_HOUR_TO_SECOND
1220 //#define SQL_MINUTE_TO_SECOND SQL_CODE_MINUTE_TO_SECOND
1221 //#endif /* ODBC_STD */
1222 }//#endif /* ODBCVER >= 0x0350 */
1223
1224 //static if (ODBCVER >= 0x0351) {
1225 const SQL_ATTR_ANSI_APP=115;
1226 const SQL_AA_TRUE=1L;
1227 const SQL_AA_FALSE=0L;
1228 //}//[Yes] #endif
1229
1230 const TRACE_VERSION=1000;
1231 const TRACE_ON=1;
1232
1233 const char [] SQL_ODBC_KEYWORDS =
1234 "ABSOLUTE, ACTION, ADA, ADD, ALL, ALLOCATE, ALTER, AND, ANY, ARE, AS, "
1235 ~ "ASC, ASSERTION, AT, AUTHORIZATION, AVG, "
1236 ~ "BEGIN, BETWEEN, BIT, BIT_LENGTH, BOTH, BY, CASCADE, CASCADED, CASE, CAST, CATALOG, "
1237 ~ "CHAR, CHAR_LENGTH, CHARACTER, CHARACTER_LENGTH, CHECK, CLOSE, COALESCE, "
1238 ~ "COLLATE, COLLATION, COLUMN, COMMIT, CONNECT, CONNECTION, CONSTRAINT, "
1239 ~ "CONSTRAINTS, CONTINUE, CONVERT, CORRESPONDING, COUNT, CREATE, CROSS, CURRENT, "
1240 ~ "CURRENT_DATE, CURRENT_TIME, CURRENT_TIMESTAMP, CURRENT_USER, CURSOR, "
1241 ~ "DATE, DAY, DEALLOCATE, DEC, DECIMAL, DECLARE, DEFAULT, DEFERRABLE, "
1242 ~ "DEFERRED, DELETE, DESC, DESCRIBE, DESCRIPTOR, DIAGNOSTICS, DISCONNECT, "
1243 ~ "DISTINCT, DOMAIN, DOUBLE, DROP, "
1244 ~ "ELSE, END, END-EXEC, ESCAPE, EXCEPT, EXCEPTION, EXEC, EXECUTE, "
1245 ~ "EXISTS, EXTERNAL, EXTRACT, "
1246 ~ "FALSE, FETCH, FIRST, FLOAT, FOR, FOREIGN, FORTRAN, FOUND, FROM, FULL, "
1247 ~ "GET, GLOBAL, GO, GOTO, GRANT, GROUP, HAVING, HOUR, "
1248 ~ "IDENTITY, IMMEDIATE, IN, INCLUDE, INDEX, INDICATOR, INITIALLY, INNER, "
1249 ~ "INPUT, INSENSITIVE, INSERT, INT, INTEGER, INTERSECT, INTERVAL, INTO, IS, ISOLATION, "
1250 ~ "JOIN, KEY, LANGUAGE, LAST, LEADING, LEFT, LEVEL, LIKE, LOCAL, LOWER, "
1251 ~ "MATCH, MAX, MIN, MINUTE, MODULE, MONTH, "
1252 ~ "NAMES, NATIONAL, NATURAL, NCHAR, NEXT, NO, NONE, NOT, NULL, NULLIF, NUMERIC, "
1253 ~ "OCTET_LENGTH, OF, ON, ONLY, OPEN, OPTION, OR, ORDER, OUTER, OUTPUT, OVERLAPS, "
1254 ~ "PAD, PARTIAL, PASCAL, PLI, POSITION, PRECISION, PREPARE, PRESERVE, "
1255 ~ "PRIMARY, PRIOR, PRIVILEGES, PROCEDURE, PUBLIC, "
1256 ~ "READ, REAL, REFERENCES, RELATIVE, RESTRICT, REVOKE, RIGHT, ROLLBACK, ROWS"
1257 ~ "SCHEMA, SCROLL, SECOND, SECTION, SELECT, SESSION, SESSION_USER, SET, SIZE, "
1258 ~ "SMALLINT, SOME, SPACE, SQL, SQLCA, SQLCODE, SQLERROR, SQLSTATE, SQLWARNING, "
1259 ~ "SUBSTRING, SUM, SYSTEM_USER, "
1260 ~ "TABLE, TEMPORARY, THEN, TIME, TIMESTAMP, TIMEZONE_HOUR, TIMEZONE_MINUTE, "
1261 ~ "TO, TRAILING, TRANSACTION, TRANSLATE, TRANSLATION, TRIM, TRUE, "
1262 ~ "UNION, UNIQUE, UNKNOWN, UPDATE, UPPER, USAGE, USER, USING, "
1263 ~ "VALUE, VALUES, VARCHAR, VARYING, VIEW, WHEN, WHENEVER, WHERE, WITH, WORK, WRITE, "
1264 ~ "YEAR, ZONE";
1265 extern (Windows) {
1266 SQLRETURN SQLDriverConnect(SQLHDBC, SQLHWND, SQLCHAR*, SQLSMALLINT, SQLCHAR*, SQLSMALLINT, SQLSMALLINT*, SQLUSMALLINT);
1267 SQLRETURN SQLBrowseConnect(SQLHDBC, SQLCHAR*, SQLSMALLINT, SQLCHAR*, SQLSMALLINT, SQLSMALLINT*);
1268 SQLRETURN SQLColumnPrivileges(SQLHSTMT, SQLCHAR*, SQLSMALLINT, SQLCHAR*, SQLSMALLINT, SQLCHAR*, SQLSMALLINT, SQLCHAR*, SQLSMALLINT);
1269 SQLRETURN SQLColAttributes(SQLHSTMT, SQLUSMALLINT, SQLUSMALLINT, SQLPOINTER, SQLSMALLINT, SQLSMALLINT*, SQLLEN*);
1270 SQLRETURN SQLDescribeParam(SQLHSTMT, SQLUSMALLINT, SQLSMALLINT*, SQLULEN*, SQLSMALLINT*, SQLSMALLINT*);
1271 SQLRETURN SQLExtendedFetch(SQLHSTMT, SQLUSMALLINT, SQLINTEGER, SQLUINTEGER*, SQLUSMALLINT*);
1272 SQLRETURN SQLForeignKeys(SQLHSTMT, SQLCHAR*, SQLSMALLINT, SQLCHAR*, SQLSMALLINT, SQLCHAR*, SQLSMALLINT, SQLCHAR*, SQLSMALLINT, SQLCHAR*, SQLSMALLINT, SQLCHAR*, SQLSMALLINT);
1273 SQLRETURN SQLMoreResults(SQLHSTMT);
1274 SQLRETURN SQLNativeSql(SQLHDBC, SQLCHAR*, SQLINTEGER, SQLCHAR*, SQLINTEGER, SQLINTEGER*);
1275 SQLRETURN SQLNumParams(SQLHSTMT, SQLSMALLINT*);
1276 SQLRETURN SQLParamOptions(SQLHSTMT, SQLUINTEGER, SQLUINTEGER*);
1277 SQLRETURN SQLPrimaryKeys(SQLHSTMT, SQLCHAR*, SQLSMALLINT, SQLCHAR*, SQLSMALLINT, SQLCHAR*, SQLSMALLINT);
1278 SQLRETURN SQLProcedureColumns(SQLHSTMT, SQLCHAR*, SQLSMALLINT, SQLCHAR*, SQLSMALLINT, SQLCHAR*, SQLSMALLINT, SQLCHAR*, SQLSMALLINT);
1279 SQLRETURN SQLProcedures(SQLHSTMT, SQLCHAR*, SQLSMALLINT, SQLCHAR*, SQLSMALLINT, SQLCHAR*, SQLSMALLINT);
1280 SQLRETURN SQLSetPos(SQLHSTMT, SQLUSMALLINT, SQLUSMALLINT, SQLUSMALLINT);
1281 SQLRETURN SQLTablePrivileges(SQLHSTMT, SQLCHAR*, SQLSMALLINT, SQLCHAR*, SQLSMALLINT, SQLCHAR*, SQLSMALLINT);
1282 SQLRETURN SQLDrivers(SQLHENV, SQLUSMALLINT, SQLCHAR*, SQLSMALLINT, SQLSMALLINT*, SQLCHAR*, SQLSMALLINT, SQLSMALLINT*);
1283 SQLRETURN SQLBindParameter(SQLHSTMT, SQLUSMALLINT, SQLSMALLINT, SQLSMALLINT, SQLSMALLINT, SQLULEN, SQLSMALLINT, SQLPOINTER, SQLLEN, SQLLEN*);
1284 SQLRETURN SQLSetScrollOptions(SQLHSTMT, SQLUSMALLINT, SQLLEN, SQLUSMALLINT);/* deprecated */
1285 DWORD ODBCGetTryWaitValue();
1286 BOOL ODBCSetTryWaitValue(DWORD);
1287 RETCODE TraceOpenLogFile(LPWSTR, LPWSTR, DWORD);
1288 RETCODE TraceCloseLogFile();
1289 VOID TraceReturn(RETCODE, RETCODE);
1290 DWORD TraceVersion();
1291 //static if (ODBCVER >= 0x0300) {
1292 SQLRETURN SQLBulkOperations(SQLHSTMT, SQLSMALLINT);
1293 SQLRETURN SQLAllocHandleStd( SQLSMALLINT, SQLHANDLE, SQLHANDLE*);
1294 //}
1295 }