sqlext.h 66.7 KB
Newer Older
Alexandre Julliard's avatar
Alexandre Julliard committed
1 2
/*
 * MS SQL Extension definitions
3 4 5 6 7 8 9 10 11 12 13 14 15 16 17
 *
 * Copyright (C) 1999 Xiang Li
 *
 * This library is free software; you can redistribute it and/or
 * modify it under the terms of the GNU Lesser General Public
 * License as published by the Free Software Foundation; either
 * version 2.1 of the License, or (at your option) any later version.
 *
 * This library is distributed in the hope that it will be useful,
 * but WITHOUT ANY WARRANTY; without even the implied warranty of
 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the GNU
 * Lesser General Public License for more details.
 *
 * You should have received a copy of the GNU Lesser General Public
 * License along with this library; if not, write to the Free Software
18
 * Foundation, Inc., 51 Franklin St, Fifth Floor, Boston, MA 02110-1301, USA
Alexandre Julliard's avatar
Alexandre Julliard committed
19
 */
20

Alexandre Julliard's avatar
Alexandre Julliard committed
21 22 23
#ifndef __SQLEXT_H
#define __SQLEXT_H

24
#include <sql.h>
Alexandre Julliard's avatar
Alexandre Julliard committed
25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55

#ifdef __cplusplus
extern "C" {
#endif

#define SQL_SPEC_MAJOR     3
#define SQL_SPEC_MINOR	   51
#define SQL_SPEC_STRING   "03.51"

#define SQL_SQLSTATE_SIZE	5
#define SQL_MAX_DSN_LENGTH	32

#define SQL_MAX_OPTION_STRING_LENGTH    256

#if (ODBCVER < 0x0300)
#define SQL_NO_DATA_FOUND	100
#else
#define SQL_NO_DATA_FOUND	SQL_NO_DATA
#endif

#if (ODBCVER >= 0x0300)
#define	SQL_HANDLE_SENV		5
#endif

#if (ODBCVER >= 0x0300)
#define SQL_ATTR_ODBC_VERSION				200
#define SQL_ATTR_CONNECTION_POOLING			201
#define SQL_ATTR_CP_MATCH					202
#endif

#if (ODBCVER >= 0x0300)
56 57 58
#define SQL_CP_OFF                      __MSABI_LONG(0U)
#define SQL_CP_ONE_PER_DRIVER           __MSABI_LONG(1U)
#define SQL_CP_ONE_PER_HENV             __MSABI_LONG(2U)
Alexandre Julliard's avatar
Alexandre Julliard committed
59 60
#define SQL_CP_DEFAULT						SQL_CP_OFF

61 62
#define SQL_CP_STRICT_MATCH             __MSABI_LONG(0U)
#define SQL_CP_RELAXED_MATCH            __MSABI_LONG(1U)
63
#define SQL_CP_MATCH_DEFAULT				SQL_CP_STRICT_MATCH
Alexandre Julliard's avatar
Alexandre Julliard committed
64

65 66
#define SQL_OV_ODBC2                    __MSABI_LONG(2U)
#define SQL_OV_ODBC3                    __MSABI_LONG(3U)
Alexandre Julliard's avatar
Alexandre Julliard committed
67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115
#endif

#define SQL_ACCESS_MODE                 101
#define SQL_AUTOCOMMIT                  102
#define SQL_LOGIN_TIMEOUT               103
#define SQL_OPT_TRACE                   104
#define SQL_OPT_TRACEFILE               105
#define SQL_TRANSLATE_DLL               106
#define SQL_TRANSLATE_OPTION            107
#define SQL_TXN_ISOLATION               108
#define SQL_CURRENT_QUALIFIER           109
#define SQL_ODBC_CURSORS                110
#define SQL_QUIET_MODE                  111
#define SQL_PACKET_SIZE                 112

#if (ODBCVER >= 0x0300)
#define SQL_ATTR_ACCESS_MODE		SQL_ACCESS_MODE
#define SQL_ATTR_AUTOCOMMIT			SQL_AUTOCOMMIT
#define SQL_ATTR_CONNECTION_TIMEOUT	113
#define SQL_ATTR_CURRENT_CATALOG	SQL_CURRENT_QUALIFIER
#define SQL_ATTR_DISCONNECT_BEHAVIOR	114
#define SQL_ATTR_ENLIST_IN_DTC		1207
#define SQL_ATTR_ENLIST_IN_XA		1208
#define SQL_ATTR_LOGIN_TIMEOUT		SQL_LOGIN_TIMEOUT
#define SQL_ATTR_ODBC_CURSORS		SQL_ODBC_CURSORS
#define SQL_ATTR_PACKET_SIZE		SQL_PACKET_SIZE
#define SQL_ATTR_QUIET_MODE			SQL_QUIET_MODE
#define SQL_ATTR_TRACE				SQL_OPT_TRACE
#define SQL_ATTR_TRACEFILE			SQL_OPT_TRACEFILE
#define SQL_ATTR_TRANSLATE_LIB		SQL_TRANSLATE_DLL
#define SQL_ATTR_TRANSLATE_OPTION	SQL_TRANSLATE_OPTION
#define SQL_ATTR_TXN_ISOLATION		SQL_TXN_ISOLATION
#endif

#define SQL_ATTR_CONNECTION_DEAD	1209

#if (ODBCVER >= 0x0351)
#define SQL_ATTR_ANSI_APP			115
#endif

#if (ODBCVER < 0x0300)
#define SQL_CONNECT_OPT_DRVR_START      1000
#endif

#if (ODBCVER < 0x0300)
#define SQL_CONN_OPT_MAX                SQL_PACKET_SIZE
#define SQL_CONN_OPT_MIN                SQL_ACCESS_MODE
#endif

116 117
#define SQL_MODE_READ_WRITE             __MSABI_LONG(0U)
#define SQL_MODE_READ_ONLY              __MSABI_LONG(1U)
Alexandre Julliard's avatar
Alexandre Julliard committed
118 119
#define SQL_MODE_DEFAULT                SQL_MODE_READ_WRITE

120 121
#define SQL_AUTOCOMMIT_OFF              __MSABI_LONG(0U)
#define SQL_AUTOCOMMIT_ON               __MSABI_LONG(1U)
Alexandre Julliard's avatar
Alexandre Julliard committed
122 123
#define SQL_AUTOCOMMIT_DEFAULT          SQL_AUTOCOMMIT_ON

124
#define SQL_LOGIN_TIMEOUT_DEFAULT       __MSABI_LONG(15U)
Alexandre Julliard's avatar
Alexandre Julliard committed
125

126 127
#define SQL_OPT_TRACE_OFF               __MSABI_LONG(0U)
#define SQL_OPT_TRACE_ON                __MSABI_LONG(1U)
Alexandre Julliard's avatar
Alexandre Julliard committed
128 129 130
#define SQL_OPT_TRACE_DEFAULT           SQL_OPT_TRACE_OFF
#define SQL_OPT_TRACE_FILE_DEFAULT      "\\SQL.LOG"

131 132 133
#define SQL_CUR_USE_IF_NEEDED           __MSABI_LONG(0U)
#define SQL_CUR_USE_ODBC                __MSABI_LONG(1U)
#define SQL_CUR_USE_DRIVER              __MSABI_LONG(2U)
Alexandre Julliard's avatar
Alexandre Julliard committed
134 135 136
#define SQL_CUR_DEFAULT                 SQL_CUR_USE_DRIVER

#if (ODBCVER >= 0x0300)
137 138
#define SQL_DB_RETURN_TO_POOL           __MSABI_LONG(0U)
#define SQL_DB_DISCONNECT               __MSABI_LONG(1U)
Alexandre Julliard's avatar
Alexandre Julliard committed
139 140
#define SQL_DB_DEFAULT					SQL_DB_RETURN_TO_POOL

141
#define SQL_DTC_DONE                    __MSABI_LONG(0)
142
#endif
Alexandre Julliard's avatar
Alexandre Julliard committed
143

144 145
#define SQL_CD_TRUE                     __MSABI_LONG(1)
#define SQL_CD_FALSE                    __MSABI_LONG(0)
Alexandre Julliard's avatar
Alexandre Julliard committed
146 147

#if (ODBCVER >= 0x0351)
148 149
#define SQL_AA_TRUE                     __MSABI_LONG(1)
#define SQL_AA_FALSE                    __MSABI_LONG(0)
Alexandre Julliard's avatar
Alexandre Julliard committed
150 151 152 153 154 155 156 157 158 159 160 161 162 163 164 165 166 167 168 169 170 171 172 173 174 175 176 177 178 179 180 181 182 183 184 185 186 187 188 189
#endif

#define SQL_QUERY_TIMEOUT		0
#define SQL_MAX_ROWS			1
#define SQL_NOSCAN			2
#define SQL_MAX_LENGTH			3
#define SQL_ASYNC_ENABLE		4
#define SQL_BIND_TYPE			5
#define SQL_CURSOR_TYPE			6
#define SQL_CONCURRENCY			7
#define SQL_KEYSET_SIZE			8
#define SQL_ROWSET_SIZE			9
#define SQL_SIMULATE_CURSOR		10
#define SQL_RETRIEVE_DATA		11
#define SQL_USE_BOOKMARKS		12
#define SQL_GET_BOOKMARK		13
#define SQL_ROW_NUMBER			14

#if (ODBCVER >= 0x0300)
#define SQL_ATTR_ASYNC_ENABLE				4
#define SQL_ATTR_CONCURRENCY				SQL_CONCURRENCY
#define SQL_ATTR_CURSOR_TYPE				SQL_CURSOR_TYPE
#define	SQL_ATTR_ENABLE_AUTO_IPD			15
#define SQL_ATTR_FETCH_BOOKMARK_PTR			16
#define SQL_ATTR_KEYSET_SIZE				SQL_KEYSET_SIZE
#define SQL_ATTR_MAX_LENGTH				SQL_MAX_LENGTH
#define SQL_ATTR_MAX_ROWS				SQL_MAX_ROWS
#define SQL_ATTR_NOSCAN					SQL_NOSCAN
#define SQL_ATTR_PARAM_BIND_OFFSET_PTR			17
#define	SQL_ATTR_PARAM_BIND_TYPE			18
#define SQL_ATTR_PARAM_OPERATION_PTR			19
#define SQL_ATTR_PARAM_STATUS_PTR			20
#define	SQL_ATTR_PARAMS_PROCESSED_PTR			21
#define SQL_ATTR_RETRIEVE_DATA				SQL_RETRIEVE_DATA
#define SQL_ATTR_ROW_BIND_OFFSET_PTR			23
#define	SQL_ATTR_ROW_BIND_TYPE				SQL_BIND_TYPE
#define SQL_ATTR_ROW_NUMBER				SQL_ROW_NUMBER
#define SQL_ATTR_ROW_OPERATION_PTR			24
#define	SQL_ATTR_ROW_STATUS_PTR				25
#define	SQL_ATTR_ROWS_FETCHED_PTR			26
190
#define SQL_ATTR_ROW_ARRAY_SIZE				27
Alexandre Julliard's avatar
Alexandre Julliard committed
191
#define SQL_ATTR_SIMULATE_CURSOR			SQL_SIMULATE_CURSOR
192
#define SQL_ATTR_USE_BOOKMARKS				SQL_USE_BOOKMARKS
Alexandre Julliard's avatar
Alexandre Julliard committed
193 194 195 196 197 198 199 200 201 202 203 204 205 206 207 208 209 210 211 212 213 214

#endif

#if (ODBCVER < 0x0300)
#define SQL_STMT_OPT_MAX                SQL_ROW_NUMBER
#define SQL_STMT_OPT_MIN	SQL_QUERY_TIMEOUT
#endif

#if (ODBCVER >= 0x0300)
#define	SQL_COL_PRED_CHAR		SQL_LIKE_ONLY
#define	SQL_COL_PRED_BASIC		SQL_ALL_EXCEPT_LIKE
#endif

#if (ODBCVER >= 0x0300)
#define SQL_IS_POINTER							(-4)
#define SQL_IS_UINTEGER							(-5)
#define SQL_IS_INTEGER							(-6)
#define SQL_IS_USMALLINT						(-7)
#define SQL_IS_SMALLINT							(-8)
#endif

#if (ODBCVER >= 0x0300)
215
#define SQL_PARAM_BIND_BY_COLUMN        __MSABI_LONG(0U)
Alexandre Julliard's avatar
Alexandre Julliard committed
216 217 218
#define SQL_PARAM_BIND_TYPE_DEFAULT			SQL_PARAM_BIND_BY_COLUMN
#endif

219
#define SQL_QUERY_TIMEOUT_DEFAULT       __MSABI_LONG(0U)
Alexandre Julliard's avatar
Alexandre Julliard committed
220

221
#define SQL_MAX_ROWS_DEFAULT            __MSABI_LONG(0U)
Alexandre Julliard's avatar
Alexandre Julliard committed
222

223 224
#define SQL_NOSCAN_OFF                  __MSABI_LONG(0U)
#define SQL_NOSCAN_ON                   __MSABI_LONG(1U)
Alexandre Julliard's avatar
Alexandre Julliard committed
225 226
#define SQL_NOSCAN_DEFAULT              SQL_NOSCAN_OFF

227
#define SQL_MAX_LENGTH_DEFAULT          __MSABI_LONG(0U)
Alexandre Julliard's avatar
Alexandre Julliard committed
228

229 230
#define SQL_ASYNC_ENABLE_OFF            __MSABI_LONG(0U)
#define SQL_ASYNC_ENABLE_ON             __MSABI_LONG(1U)
Alexandre Julliard's avatar
Alexandre Julliard committed
231 232
#define SQL_ASYNC_ENABLE_DEFAULT        SQL_ASYNC_ENABLE_OFF

233
#define SQL_BIND_BY_COLUMN              __MSABI_LONG(0U)
Alexandre Julliard's avatar
Alexandre Julliard committed
234 235 236 237 238 239 240 241
#define SQL_BIND_TYPE_DEFAULT           SQL_BIND_BY_COLUMN

#define SQL_CONCUR_READ_ONLY            1
#define SQL_CONCUR_LOCK                 2
#define SQL_CONCUR_ROWVER               3
#define SQL_CONCUR_VALUES               4
#define SQL_CONCUR_DEFAULT              SQL_CONCUR_READ_ONLY

242 243 244 245
#define SQL_CURSOR_FORWARD_ONLY         __MSABI_LONG(0U)
#define SQL_CURSOR_KEYSET_DRIVEN        __MSABI_LONG(1U)
#define SQL_CURSOR_DYNAMIC              __MSABI_LONG(2U)
#define SQL_CURSOR_STATIC               __MSABI_LONG(3U)
Alexandre Julliard's avatar
Alexandre Julliard committed
246 247
#define SQL_CURSOR_TYPE_DEFAULT         SQL_CURSOR_FORWARD_ONLY

248
#define SQL_ROWSET_SIZE_DEFAULT         __MSABI_LONG(1U)
Alexandre Julliard's avatar
Alexandre Julliard committed
249

250
#define SQL_KEYSET_SIZE_DEFAULT         __MSABI_LONG(0U)
Alexandre Julliard's avatar
Alexandre Julliard committed
251

252 253 254
#define SQL_SC_NON_UNIQUE               __MSABI_LONG(0U)
#define SQL_SC_TRY_UNIQUE               __MSABI_LONG(1U)
#define SQL_SC_UNIQUE                   __MSABI_LONG(2U)
Alexandre Julliard's avatar
Alexandre Julliard committed
255

256 257
#define SQL_RD_OFF                      __MSABI_LONG(0U)
#define SQL_RD_ON                       __MSABI_LONG(1U)
Alexandre Julliard's avatar
Alexandre Julliard committed
258 259
#define SQL_RD_DEFAULT                  SQL_RD_ON

260 261
#define SQL_UB_OFF                      __MSABI_LONG(0U)
#define SQL_UB_ON                       __MSABI_LONG(1U)
Alexandre Julliard's avatar
Alexandre Julliard committed
262 263 264 265
#define SQL_UB_DEFAULT                  SQL_UB_OFF

#if (ODBCVER >= 0x0300)
#define SQL_UB_FIXED					SQL_UB_ON
266
#define SQL_UB_VARIABLE                 __MSABI_LONG(2U)
Alexandre Julliard's avatar
Alexandre Julliard committed
267 268 269 270 271 272 273 274 275 276 277 278 279 280 281 282 283 284 285 286 287 288 289 290 291 292 293 294 295 296 297 298 299 300 301 302 303 304 305
#endif

#if (ODBCVER >= 0x0300)
#define SQL_DESC_ARRAY_SIZE					20
#define SQL_DESC_ARRAY_STATUS_PTR				21
#define SQL_DESC_AUTO_UNIQUE_VALUE				SQL_COLUMN_AUTO_INCREMENT
#define SQL_DESC_BASE_COLUMN_NAME				22
#define SQL_DESC_BASE_TABLE_NAME				23
#define SQL_DESC_BIND_OFFSET_PTR				24
#define SQL_DESC_BIND_TYPE					25
#define SQL_DESC_CASE_SENSITIVE					SQL_COLUMN_CASE_SENSITIVE
#define SQL_DESC_CATALOG_NAME					SQL_COLUMN_QUALIFIER_NAME
#define SQL_DESC_CONCISE_TYPE					SQL_COLUMN_TYPE
#define SQL_DESC_DATETIME_INTERVAL_PRECISION			26
#define SQL_DESC_DISPLAY_SIZE					SQL_COLUMN_DISPLAY_SIZE
#define SQL_DESC_FIXED_PREC_SCALE				SQL_COLUMN_MONEY
#define SQL_DESC_LABEL						SQL_COLUMN_LABEL
#define SQL_DESC_LITERAL_PREFIX					27
#define SQL_DESC_LITERAL_SUFFIX					28
#define SQL_DESC_LOCAL_TYPE_NAME				29
#define	SQL_DESC_MAXIMUM_SCALE					30
#define SQL_DESC_MINIMUM_SCALE					31
#define SQL_DESC_NUM_PREC_RADIX					32
#define SQL_DESC_PARAMETER_TYPE					33
#define SQL_DESC_ROWS_PROCESSED_PTR				34
#if (ODBCVER >= 0x0350)
#define SQL_DESC_ROWVER						35
#endif
#define SQL_DESC_SCHEMA_NAME					SQL_COLUMN_OWNER_NAME
#define SQL_DESC_SEARCHABLE					SQL_COLUMN_SEARCHABLE
#define SQL_DESC_TYPE_NAME					SQL_COLUMN_TYPE_NAME
#define SQL_DESC_TABLE_NAME					SQL_COLUMN_TABLE_NAME
#define SQL_DESC_UNSIGNED					SQL_COLUMN_UNSIGNED
#define SQL_DESC_UPDATABLE					SQL_COLUMN_UPDATABLE
#endif

#if (ODBCVER >= 0x0300)
#define SQL_DIAG_CURSOR_ROW_COUNT			(-1249)
#define SQL_DIAG_ROW_NUMBER				(-1248)
306
#define SQL_DIAG_COLUMN_NUMBER				(-1247)
Alexandre Julliard's avatar
Alexandre Julliard committed
307 308 309 310 311
#endif

#define SQL_DATE                                9
#if (ODBCVER >= 0x0300)
#define SQL_INTERVAL				10
312
#endif
Alexandre Julliard's avatar
Alexandre Julliard committed
313 314 315 316 317 318 319 320 321 322 323
#define SQL_TIME                                10
#define SQL_TIMESTAMP                           11
#define SQL_LONGVARCHAR                         (-1)
#define SQL_BINARY                              (-2)
#define SQL_VARBINARY                           (-3)
#define SQL_LONGVARBINARY                       (-4)
#define SQL_BIGINT                              (-5)
#define SQL_TINYINT                             (-6)
#define SQL_BIT                                 (-7)
#if (ODBCVER >= 0x0350)
#define SQL_GUID				(-11)
324
#endif
Alexandre Julliard's avatar
Alexandre Julliard committed
325 326 327 328 329 330 331 332 333 334 335 336 337 338 339 340 341 342 343 344 345 346 347 348 349 350 351 352 353 354 355 356 357 358 359 360 361 362 363 364 365 366 367 368 369 370 371 372 373 374 375 376 377 378 379 380 381 382 383 384 385 386 387 388 389 390 391 392 393 394 395 396 397 398 399 400 401 402 403 404 405 406 407 408 409 410 411 412 413 414 415 416 417 418 419 420 421 422 423 424 425 426 427 428 429 430 431 432 433 434 435 436

#if (ODBCVER >= 0x0300)
#define SQL_CODE_YEAR				1
#define SQL_CODE_MONTH				2
#define SQL_CODE_DAY				3
#define SQL_CODE_HOUR				4
#define SQL_CODE_MINUTE				5
#define SQL_CODE_SECOND				6
#define SQL_CODE_YEAR_TO_MONTH			7
#define SQL_CODE_DAY_TO_HOUR			8
#define SQL_CODE_DAY_TO_MINUTE			9
#define SQL_CODE_DAY_TO_SECOND			10
#define SQL_CODE_HOUR_TO_MINUTE			11
#define SQL_CODE_HOUR_TO_SECOND			12
#define SQL_CODE_MINUTE_TO_SECOND		13

#define SQL_INTERVAL_YEAR			(100 + SQL_CODE_YEAR)
#define SQL_INTERVAL_MONTH			(100 + SQL_CODE_MONTH)
#define SQL_INTERVAL_DAY			(100 + SQL_CODE_DAY)
#define SQL_INTERVAL_HOUR			(100 + SQL_CODE_HOUR)
#define SQL_INTERVAL_MINUTE			(100 + SQL_CODE_MINUTE)
#define SQL_INTERVAL_SECOND                	(100 + SQL_CODE_SECOND)
#define SQL_INTERVAL_YEAR_TO_MONTH		(100 + SQL_CODE_YEAR_TO_MONTH)
#define SQL_INTERVAL_DAY_TO_HOUR		(100 + SQL_CODE_DAY_TO_HOUR)
#define SQL_INTERVAL_DAY_TO_MINUTE		(100 + SQL_CODE_DAY_TO_MINUTE)
#define SQL_INTERVAL_DAY_TO_SECOND		(100 + SQL_CODE_DAY_TO_SECOND)
#define SQL_INTERVAL_HOUR_TO_MINUTE		(100 + SQL_CODE_HOUR_TO_MINUTE)
#define SQL_INTERVAL_HOUR_TO_SECOND		(100 + SQL_CODE_HOUR_TO_SECOND)
#define SQL_INTERVAL_MINUTE_TO_SECOND		(100 + SQL_CODE_MINUTE_TO_SECOND)

#else
#define SQL_INTERVAL_YEAR                       (-80)
#define SQL_INTERVAL_MONTH                      (-81)
#define SQL_INTERVAL_YEAR_TO_MONTH              (-82)
#define SQL_INTERVAL_DAY                        (-83)
#define SQL_INTERVAL_HOUR                       (-84)
#define SQL_INTERVAL_MINUTE                     (-85)
#define SQL_INTERVAL_SECOND                     (-86)
#define SQL_INTERVAL_DAY_TO_HOUR                (-87)
#define SQL_INTERVAL_DAY_TO_MINUTE              (-88)
#define SQL_INTERVAL_DAY_TO_SECOND              (-89)
#define SQL_INTERVAL_HOUR_TO_MINUTE             (-90)
#define SQL_INTERVAL_HOUR_TO_SECOND             (-91)
#define SQL_INTERVAL_MINUTE_TO_SECOND           (-92)
#endif


#if (ODBCVER <= 0x0300)
#define SQL_UNICODE                             (-95)
#define SQL_UNICODE_VARCHAR                     (-96)
#define SQL_UNICODE_LONGVARCHAR                 (-97)
#define SQL_UNICODE_CHAR                        SQL_UNICODE
#else

#define	SQL_UNICODE			SQL_WCHAR
#define	SQL_UNICODE_VARCHAR		SQL_WVARCHAR
#define SQL_UNICODE_LONGVARCHAR	SQL_WLONGVARCHAR
#define SQL_UNICODE_CHAR		SQL_WCHAR
#endif

#if (ODBCVER < 0x0300)
#define SQL_TYPE_DRIVER_START                   SQL_INTERVAL_YEAR
#define SQL_TYPE_DRIVER_END                     SQL_UNICODE_LONGVARCHAR
#endif

#define SQL_C_CHAR    SQL_CHAR
#define SQL_C_LONG    SQL_INTEGER
#define SQL_C_SHORT   SQL_SMALLINT
#define SQL_C_FLOAT   SQL_REAL
#define SQL_C_DOUBLE  SQL_DOUBLE
#if (ODBCVER >= 0x0300)
#define	SQL_C_NUMERIC		SQL_NUMERIC
#endif
#define SQL_C_DEFAULT 99

#define SQL_SIGNED_OFFSET       (-20)
#define SQL_UNSIGNED_OFFSET     (-22)

#define SQL_C_DATE       SQL_DATE
#define SQL_C_TIME       SQL_TIME
#define SQL_C_TIMESTAMP  SQL_TIMESTAMP
#if (ODBCVER >= 0x0300)
#define SQL_C_TYPE_DATE				SQL_TYPE_DATE
#define SQL_C_TYPE_TIME				SQL_TYPE_TIME
#define SQL_C_TYPE_TIMESTAMP			SQL_TYPE_TIMESTAMP
#define SQL_C_INTERVAL_YEAR			SQL_INTERVAL_YEAR
#define SQL_C_INTERVAL_MONTH			SQL_INTERVAL_MONTH
#define SQL_C_INTERVAL_DAY			SQL_INTERVAL_DAY
#define SQL_C_INTERVAL_HOUR			SQL_INTERVAL_HOUR
#define SQL_C_INTERVAL_MINUTE			SQL_INTERVAL_MINUTE
#define SQL_C_INTERVAL_SECOND			SQL_INTERVAL_SECOND
#define SQL_C_INTERVAL_YEAR_TO_MONTH		SQL_INTERVAL_YEAR_TO_MONTH
#define SQL_C_INTERVAL_DAY_TO_HOUR		SQL_INTERVAL_DAY_TO_HOUR
#define SQL_C_INTERVAL_DAY_TO_MINUTE		SQL_INTERVAL_DAY_TO_MINUTE
#define SQL_C_INTERVAL_DAY_TO_SECOND		SQL_INTERVAL_DAY_TO_SECOND
#define SQL_C_INTERVAL_HOUR_TO_MINUTE		SQL_INTERVAL_HOUR_TO_MINUTE
#define SQL_C_INTERVAL_HOUR_TO_SECOND		SQL_INTERVAL_HOUR_TO_SECOND
#define SQL_C_INTERVAL_MINUTE_TO_SECOND		SQL_INTERVAL_MINUTE_TO_SECOND
#endif
#define SQL_C_BINARY     SQL_BINARY
#define SQL_C_BIT        SQL_BIT
#if (ODBCVER >= 0x0300)
#define SQL_C_SBIGINT	(SQL_BIGINT+SQL_SIGNED_OFFSET)
#define SQL_C_UBIGINT	(SQL_BIGINT+SQL_UNSIGNED_OFFSET)
#endif
#define SQL_C_TINYINT    SQL_TINYINT
#define SQL_C_SLONG      (SQL_C_LONG+SQL_SIGNED_OFFSET)
#define SQL_C_SSHORT     (SQL_C_SHORT+SQL_SIGNED_OFFSET)
#define SQL_C_STINYINT   (SQL_TINYINT+SQL_SIGNED_OFFSET)
#define SQL_C_ULONG      (SQL_C_LONG+SQL_UNSIGNED_OFFSET)
#define SQL_C_USHORT     (SQL_C_SHORT+SQL_UNSIGNED_OFFSET)
#define SQL_C_UTINYINT   (SQL_TINYINT+SQL_UNSIGNED_OFFSET)
437
#define SQL_C_BOOKMARK   SQL_C_ULONG
Alexandre Julliard's avatar
Alexandre Julliard committed
438 439 440 441 442 443 444 445 446 447 448 449 450 451 452 453 454 455 456 457 458 459 460 461 462 463 464 465 466 467 468 469 470 471

#if (ODBCVER >= 0x0350)
#define SQL_C_GUID	SQL_GUID
#endif

#define SQL_TYPE_NULL                   0
#if (ODBCVER < 0x0300)
#define SQL_TYPE_MIN                    SQL_BIT
#define SQL_TYPE_MAX                    SQL_VARCHAR
#endif

#if (ODBCVER >= 0x0300)
#define SQL_C_VARBOOKMARK		SQL_C_BINARY
#endif

#if (ODBCVER >= 0x0300)
#define SQL_NO_ROW_NUMBER					(-1)
#define SQL_NO_COLUMN_NUMBER					(-1)
#define SQL_ROW_NUMBER_UNKNOWN					(-2)
#define SQL_COLUMN_NUMBER_UNKNOWN				(-2)
#endif

#define SQL_DEFAULT_PARAM            (-5)
#define SQL_IGNORE                   (-6)
#if (ODBCVER >= 0x0300)
#define SQL_COLUMN_IGNORE		SQL_IGNORE
#endif
#define SQL_LEN_DATA_AT_EXEC_OFFSET  (-100)
#define SQL_LEN_DATA_AT_EXEC(length) (-(length)+SQL_LEN_DATA_AT_EXEC_OFFSET)

#define SQL_LEN_BINARY_ATTR_OFFSET	 (-100)
#define SQL_LEN_BINARY_ATTR(length)	 (-(length)+SQL_LEN_BINARY_ATTR_OFFSET)

#define SQL_PARAM_TYPE_DEFAULT           SQL_PARAM_INPUT_OUTPUT
472
#define SQL_SETPARAM_VALUE_MAX           (__MSABI_LONG(-1))
Alexandre Julliard's avatar
Alexandre Julliard committed
473 474 475 476 477 478 479 480 481 482 483 484 485 486 487 488 489 490 491 492 493 494 495 496 497 498 499 500 501 502 503 504 505 506 507 508 509 510 511 512 513 514 515 516 517 518 519 520 521 522 523 524 525 526 527 528 529 530 531 532 533 534 535 536 537 538 539 540 541 542 543 544 545 546 547 548 549 550 551 552 553 554 555 556

#define SQL_COLUMN_COUNT                0
#define SQL_COLUMN_NAME                 1
#define SQL_COLUMN_TYPE                 2
#define SQL_COLUMN_LENGTH               3
#define SQL_COLUMN_PRECISION            4
#define SQL_COLUMN_SCALE                5
#define SQL_COLUMN_DISPLAY_SIZE         6
#define SQL_COLUMN_NULLABLE             7
#define SQL_COLUMN_UNSIGNED             8
#define SQL_COLUMN_MONEY                9
#define SQL_COLUMN_UPDATABLE            10
#define SQL_COLUMN_AUTO_INCREMENT       11
#define SQL_COLUMN_CASE_SENSITIVE       12
#define SQL_COLUMN_SEARCHABLE           13
#define SQL_COLUMN_TYPE_NAME            14
#define SQL_COLUMN_TABLE_NAME           15
#define SQL_COLUMN_OWNER_NAME           16
#define SQL_COLUMN_QUALIFIER_NAME       17
#define SQL_COLUMN_LABEL                18
#define SQL_COLATT_OPT_MAX              SQL_COLUMN_LABEL
#if (ODBCVER < 0x0300)
#define SQL_COLUMN_DRIVER_START         1000
#endif

#define SQL_COLATT_OPT_MIN              SQL_COLUMN_COUNT

#define SQL_ATTR_READONLY               0
#define SQL_ATTR_WRITE                  1
#define SQL_ATTR_READWRITE_UNKNOWN      2

#define SQL_UNSEARCHABLE                0
#define SQL_LIKE_ONLY                   1
#define SQL_ALL_EXCEPT_LIKE             2
#define SQL_SEARCHABLE                  3
#define SQL_PRED_SEARCHABLE				SQL_SEARCHABLE


#define SQL_NO_TOTAL                    (-4)

#if (ODBCVER >= 0x0300)
#define SQL_API_SQLALLOCHANDLESTD	73
#define SQL_API_SQLBULKOPERATIONS	24
#endif
#define SQL_API_SQLBINDPARAMETER    72
#define SQL_API_SQLBROWSECONNECT    55
#define SQL_API_SQLCOLATTRIBUTES    6
#define SQL_API_SQLCOLUMNPRIVILEGES 56
#define SQL_API_SQLDESCRIBEPARAM    58
#define	SQL_API_SQLDRIVERCONNECT	41
#define SQL_API_SQLDRIVERS          71
#define SQL_API_SQLEXTENDEDFETCH    59
#define SQL_API_SQLFOREIGNKEYS      60
#define SQL_API_SQLMORERESULTS      61
#define SQL_API_SQLNATIVESQL        62
#define SQL_API_SQLNUMPARAMS        63
#define SQL_API_SQLPARAMOPTIONS     64
#define SQL_API_SQLPRIMARYKEYS      65
#define SQL_API_SQLPROCEDURECOLUMNS 66
#define SQL_API_SQLPROCEDURES       67
#define SQL_API_SQLSETPOS           68
#define SQL_API_SQLSETSCROLLOPTIONS 69
#define SQL_API_SQLTABLEPRIVILEGES  70

#if (ODBCVER < 0x0300)
#define SQL_EXT_API_LAST            SQL_API_SQLBINDPARAMETER
#define SQL_NUM_FUNCTIONS           23
#define SQL_EXT_API_START           40
#define SQL_NUM_EXTENSIONS (SQL_EXT_API_LAST-SQL_EXT_API_START+1)
#endif

#define SQL_API_ALL_FUNCTIONS       0

#define SQL_API_LOADBYORDINAL       199

#if (ODBCVER >= 0x0300)
#define SQL_API_ODBC3_ALL_FUNCTIONS		999
#define	SQL_API_ODBC3_ALL_FUNCTIONS_SIZE	250


#define SQL_FUNC_EXISTS(pfExists, uwAPI) ((*(((UWORD*) (pfExists)) + ((uwAPI) >> 4)) & (1 << ((uwAPI) & 0x000F)) ) ? SQL_TRUE : SQL_FALSE )

#endif

557
#define SQL_INFO_FIRST                       0
Alexandre Julliard's avatar
Alexandre Julliard committed
558 559 560 561 562 563 564 565 566 567 568 569 570 571 572 573 574 575 576 577 578 579 580 581 582 583 584 585 586 587 588 589 590 591 592 593 594 595 596 597 598 599 600 601 602 603 604 605 606 607 608 609 610 611 612 613 614 615 616 617 618 619 620 621 622 623 624 625 626 627 628 629 630 631 632 633 634 635 636 637 638 639 640 641 642 643 644 645 646 647 648 649 650 651 652 653 654 655 656 657 658 659 660 661 662 663 664 665 666 667 668 669 670 671 672 673 674 675 676 677 678 679 680 681 682 683 684
#define SQL_ACTIVE_CONNECTIONS               0
#define SQL_ACTIVE_STATEMENTS                1
#define SQL_DRIVER_HDBC                      3
#define SQL_DRIVER_HENV                      4
#define SQL_DRIVER_HSTMT                     5
#define SQL_DRIVER_NAME                      6
#define SQL_DRIVER_VER                       7
#define SQL_ODBC_API_CONFORMANCE             9
#define SQL_ODBC_VER                        10
#define SQL_ROW_UPDATES                     11
#define SQL_ODBC_SAG_CLI_CONFORMANCE        12
#define SQL_ODBC_SQL_CONFORMANCE            15
#define SQL_PROCEDURES                      21
#define SQL_CONCAT_NULL_BEHAVIOR            22
#define SQL_CURSOR_ROLLBACK_BEHAVIOR        24
#define SQL_EXPRESSIONS_IN_ORDERBY          27
#define SQL_MAX_OWNER_NAME_LEN              32
#define SQL_MAX_PROCEDURE_NAME_LEN          33
#define SQL_MAX_QUALIFIER_NAME_LEN          34
#define SQL_MULT_RESULT_SETS                36
#define SQL_MULTIPLE_ACTIVE_TXN             37
#define SQL_OUTER_JOINS                     38
#define SQL_OWNER_TERM                      39
#define SQL_PROCEDURE_TERM                  40
#define SQL_QUALIFIER_NAME_SEPARATOR        41
#define SQL_QUALIFIER_TERM                  42
#define SQL_SCROLL_OPTIONS                  44
#define SQL_TABLE_TERM                      45
#define SQL_CONVERT_FUNCTIONS               48
#define SQL_NUMERIC_FUNCTIONS               49
#define SQL_STRING_FUNCTIONS                50
#define SQL_SYSTEM_FUNCTIONS                51
#define SQL_TIMEDATE_FUNCTIONS              52
#define SQL_CONVERT_BIGINT                  53
#define SQL_CONVERT_BINARY                  54
#define SQL_CONVERT_BIT                     55
#define SQL_CONVERT_CHAR                    56
#define SQL_CONVERT_DATE                    57
#define SQL_CONVERT_DECIMAL                 58
#define SQL_CONVERT_DOUBLE                  59
#define SQL_CONVERT_FLOAT                   60
#define SQL_CONVERT_INTEGER                 61
#define SQL_CONVERT_LONGVARCHAR             62
#define SQL_CONVERT_NUMERIC                 63
#define SQL_CONVERT_REAL                    64
#define SQL_CONVERT_SMALLINT                65
#define SQL_CONVERT_TIME                    66
#define SQL_CONVERT_TIMESTAMP               67
#define SQL_CONVERT_TINYINT                 68
#define SQL_CONVERT_VARBINARY               69
#define SQL_CONVERT_VARCHAR                 70
#define SQL_CONVERT_LONGVARBINARY           71
#define SQL_ODBC_SQL_OPT_IEF                73
#define SQL_CORRELATION_NAME                74
#define SQL_NON_NULLABLE_COLUMNS            75
#define SQL_DRIVER_HLIB                     76
#define SQL_DRIVER_ODBC_VER                 77
#define SQL_LOCK_TYPES                      78
#define SQL_POS_OPERATIONS                  79
#define SQL_POSITIONED_STATEMENTS           80
#define SQL_BOOKMARK_PERSISTENCE            82
#define SQL_STATIC_SENSITIVITY              83
#define SQL_FILE_USAGE                      84
#define SQL_COLUMN_ALIAS                    87
#define SQL_GROUP_BY                        88
#define SQL_KEYWORDS                        89
#define SQL_OWNER_USAGE                     91
#define SQL_QUALIFIER_USAGE                 92
#define SQL_QUOTED_IDENTIFIER_CASE          93
#define SQL_SUBQUERIES                      95
#define SQL_UNION                           96
#define SQL_MAX_ROW_SIZE_INCLUDES_LONG      103
#define SQL_MAX_CHAR_LITERAL_LEN            108
#define SQL_TIMEDATE_ADD_INTERVALS          109
#define SQL_TIMEDATE_DIFF_INTERVALS         110
#define SQL_NEED_LONG_DATA_LEN              111
#define SQL_MAX_BINARY_LITERAL_LEN          112
#define SQL_LIKE_ESCAPE_CLAUSE              113
#define SQL_QUALIFIER_LOCATION              114

#if (ODBCVER >= 0x0201 && ODBCVER < 0x0300)
#define SQL_OJ_CAPABILITIES         65003
#endif

#if (ODBCVER < 0x0300)
#define SQL_INFO_LAST							SQL_QUALIFIER_LOCATION
#define SQL_INFO_DRIVER_START						1000
#endif

#if (ODBCVER >= 0x0300)
#define SQL_ACTIVE_ENVIRONMENTS						116
#define	SQL_ALTER_DOMAIN						117

#define	SQL_SQL_CONFORMANCE						118
#define SQL_DATETIME_LITERALS						119

#define	SQL_ASYNC_MODE							10021
#define SQL_BATCH_ROW_COUNT						120
#define SQL_BATCH_SUPPORT						121
#define SQL_CATALOG_LOCATION						SQL_QUALIFIER_LOCATION
#define SQL_CATALOG_NAME_SEPARATOR					SQL_QUALIFIER_NAME_SEPARATOR
#define SQL_CATALOG_TERM						SQL_QUALIFIER_TERM
#define SQL_CATALOG_USAGE						SQL_QUALIFIER_USAGE
#define	SQL_CONVERT_WCHAR						122
#define SQL_CONVERT_INTERVAL_DAY_TIME					123
#define SQL_CONVERT_INTERVAL_YEAR_MONTH					124
#define	SQL_CONVERT_WLONGVARCHAR					125
#define	SQL_CONVERT_WVARCHAR						126
#define	SQL_CREATE_ASSERTION						127
#define	SQL_CREATE_CHARACTER_SET					128
#define	SQL_CREATE_COLLATION						129
#define	SQL_CREATE_DOMAIN						130
#define	SQL_CREATE_SCHEMA						131
#define	SQL_CREATE_TABLE						132
#define	SQL_CREATE_TRANSLATION						133
#define	SQL_CREATE_VIEW							134
#define SQL_DRIVER_HDESC						135
#define	SQL_DROP_ASSERTION						136
#define	SQL_DROP_CHARACTER_SET						137
#define	SQL_DROP_COLLATION						138
#define	SQL_DROP_DOMAIN							139
#define	SQL_DROP_SCHEMA							140
#define	SQL_DROP_TABLE							141
#define	SQL_DROP_TRANSLATION						142
#define	SQL_DROP_VIEW							143
#define SQL_DYNAMIC_CURSOR_ATTRIBUTES1			144
#define SQL_DYNAMIC_CURSOR_ATTRIBUTES2			145
685
#define SQL_FORWARD_ONLY_CURSOR_ATTRIBUTES1		146
Alexandre Julliard's avatar
Alexandre Julliard committed
686 687 688 689 690 691 692 693 694 695 696 697
#define SQL_FORWARD_ONLY_CURSOR_ATTRIBUTES2		147
#define SQL_INDEX_KEYWORDS				148
#define SQL_INFO_SCHEMA_VIEWS				149
#define SQL_KEYSET_CURSOR_ATTRIBUTES1			150
#define SQL_KEYSET_CURSOR_ATTRIBUTES2			151
#define	SQL_MAX_ASYNC_CONCURRENT_STATEMENTS		10022
#define SQL_ODBC_INTERFACE_CONFORMANCE			152
#define SQL_PARAM_ARRAY_ROW_COUNTS     			153
#define SQL_PARAM_ARRAY_SELECTS     			154
#define SQL_SCHEMA_TERM					SQL_OWNER_TERM
#define SQL_SCHEMA_USAGE				SQL_OWNER_USAGE
#define SQL_SQL92_DATETIME_FUNCTIONS			155
698 699
#define SQL_SQL92_FOREIGN_KEY_DELETE_RULE		156
#define SQL_SQL92_FOREIGN_KEY_UPDATE_RULE		157
Alexandre Julliard's avatar
Alexandre Julliard committed
700 701 702 703 704 705 706 707 708
#define SQL_SQL92_GRANT					158
#define SQL_SQL92_NUMERIC_VALUE_FUNCTIONS		159
#define SQL_SQL92_PREDICATES				160
#define SQL_SQL92_RELATIONAL_JOIN_OPERATORS		161
#define SQL_SQL92_REVOKE				162
#define SQL_SQL92_ROW_VALUE_CONSTRUCTOR			163
#define SQL_SQL92_STRING_FUNCTIONS			164
#define SQL_SQL92_VALUE_EXPRESSIONS			165
#define SQL_STANDARD_CLI_CONFORMANCE			166
709
#define SQL_STATIC_CURSOR_ATTRIBUTES1			167
Alexandre Julliard's avatar
Alexandre Julliard committed
710 711 712 713 714 715 716 717 718 719 720 721 722
#define SQL_STATIC_CURSOR_ATTRIBUTES2			168

#define SQL_AGGREGATE_FUNCTIONS				169
#define SQL_DDL_INDEX					170
#define SQL_DM_VER					171
#define SQL_INSERT_STATEMENT				172
#define SQL_UNION_STATEMENT				SQL_UNION
#endif

#define	SQL_DTC_TRANSITION_COST				1750

#if (ODBCVER >= 0x0300)

723 724 725 726 727 728 729 730 731 732 733 734 735 736 737 738 739 740 741 742 743 744 745 746 747 748 749 750 751 752 753 754 755 756 757 758
#define SQL_AT_ADD_COLUMN_SINGLE                        __MSABI_LONG(0x00000020)
#define SQL_AT_ADD_COLUMN_DEFAULT                       __MSABI_LONG(0x00000040)
#define SQL_AT_ADD_COLUMN_COLLATION                     __MSABI_LONG(0x00000080)
#define SQL_AT_SET_COLUMN_DEFAULT                       __MSABI_LONG(0x00000100)
#define SQL_AT_DROP_COLUMN_DEFAULT                      __MSABI_LONG(0x00000200)
#define SQL_AT_DROP_COLUMN_CASCADE                      __MSABI_LONG(0x00000400)
#define SQL_AT_DROP_COLUMN_RESTRICT                     __MSABI_LONG(0x00000800)
#define SQL_AT_ADD_TABLE_CONSTRAINT                     __MSABI_LONG(0x00001000)
#define SQL_AT_DROP_TABLE_CONSTRAINT_CASCADE            __MSABI_LONG(0x00002000)
#define SQL_AT_DROP_TABLE_CONSTRAINT_RESTRICT           __MSABI_LONG(0x00004000)
#define SQL_AT_CONSTRAINT_NAME_DEFINITION               __MSABI_LONG(0x00008000)
#define SQL_AT_CONSTRAINT_INITIALLY_DEFERRED            __MSABI_LONG(0x00010000)
#define SQL_AT_CONSTRAINT_INITIALLY_IMMEDIATE           __MSABI_LONG(0x00020000)
#define SQL_AT_CONSTRAINT_DEFERRABLE                    __MSABI_LONG(0x00040000)
#define SQL_AT_CONSTRAINT_NON_DEFERRABLE                __MSABI_LONG(0x00080000)
#endif

#define SQL_CVT_CHAR                    __MSABI_LONG(0x00000001)
#define SQL_CVT_NUMERIC                 __MSABI_LONG(0x00000002)
#define SQL_CVT_DECIMAL                 __MSABI_LONG(0x00000004)
#define SQL_CVT_INTEGER                 __MSABI_LONG(0x00000008)
#define SQL_CVT_SMALLINT                __MSABI_LONG(0x00000010)
#define SQL_CVT_FLOAT                   __MSABI_LONG(0x00000020)
#define SQL_CVT_REAL                    __MSABI_LONG(0x00000040)
#define SQL_CVT_DOUBLE                  __MSABI_LONG(0x00000080)
#define SQL_CVT_VARCHAR                 __MSABI_LONG(0x00000100)
#define SQL_CVT_LONGVARCHAR             __MSABI_LONG(0x00000200)
#define SQL_CVT_BINARY                  __MSABI_LONG(0x00000400)
#define SQL_CVT_VARBINARY               __MSABI_LONG(0x00000800)
#define SQL_CVT_BIT                     __MSABI_LONG(0x00001000)
#define SQL_CVT_TINYINT                 __MSABI_LONG(0x00002000)
#define SQL_CVT_BIGINT                  __MSABI_LONG(0x00004000)
#define SQL_CVT_DATE                    __MSABI_LONG(0x00008000)
#define SQL_CVT_TIME                    __MSABI_LONG(0x00010000)
#define SQL_CVT_TIMESTAMP               __MSABI_LONG(0x00020000)
#define SQL_CVT_LONGVARBINARY           __MSABI_LONG(0x00040000)
Alexandre Julliard's avatar
Alexandre Julliard committed
759
#if (ODBCVER >= 0x0300)
760 761 762 763 764
#define SQL_CVT_INTERVAL_YEAR_MONTH     __MSABI_LONG(0x00080000)
#define SQL_CVT_INTERVAL_DAY_TIME       __MSABI_LONG(0x00100000)
#define SQL_CVT_WCHAR                   __MSABI_LONG(0x00200000)
#define SQL_CVT_WLONGVARCHAR            __MSABI_LONG(0x00400000)
#define SQL_CVT_WVARCHAR                __MSABI_LONG(0x00800000)
Alexandre Julliard's avatar
Alexandre Julliard committed
765 766 767 768

#endif


769
#define SQL_FN_CVT_CONVERT              __MSABI_LONG(0x00000001)
Alexandre Julliard's avatar
Alexandre Julliard committed
770
#if (ODBCVER >= 0x0300)
771 772 773 774 775 776 777 778 779 780 781 782 783 784 785 786 787 788 789 790 791 792
#define SQL_FN_CVT_CAST                 __MSABI_LONG(0x00000002)
#endif

#define SQL_FN_STR_CONCAT               __MSABI_LONG(0x00000001)
#define SQL_FN_STR_INSERT               __MSABI_LONG(0x00000002)
#define SQL_FN_STR_LEFT                 __MSABI_LONG(0x00000004)
#define SQL_FN_STR_LTRIM                __MSABI_LONG(0x00000008)
#define SQL_FN_STR_LENGTH               __MSABI_LONG(0x00000010)
#define SQL_FN_STR_LOCATE               __MSABI_LONG(0x00000020)
#define SQL_FN_STR_LCASE                __MSABI_LONG(0x00000040)
#define SQL_FN_STR_REPEAT               __MSABI_LONG(0x00000080)
#define SQL_FN_STR_REPLACE              __MSABI_LONG(0x00000100)
#define SQL_FN_STR_RIGHT                __MSABI_LONG(0x00000200)
#define SQL_FN_STR_RTRIM                __MSABI_LONG(0x00000400)
#define SQL_FN_STR_SUBSTRING            __MSABI_LONG(0x00000800)
#define SQL_FN_STR_UCASE                __MSABI_LONG(0x00001000)
#define SQL_FN_STR_ASCII                __MSABI_LONG(0x00002000)
#define SQL_FN_STR_CHAR                 __MSABI_LONG(0x00004000)
#define SQL_FN_STR_DIFFERENCE           __MSABI_LONG(0x00008000)
#define SQL_FN_STR_LOCATE_2             __MSABI_LONG(0x00010000)
#define SQL_FN_STR_SOUNDEX              __MSABI_LONG(0x00020000)
#define SQL_FN_STR_SPACE                __MSABI_LONG(0x00040000)
Alexandre Julliard's avatar
Alexandre Julliard committed
793
#if (ODBCVER >= 0x0300)
794 795 796 797 798
#define SQL_FN_STR_BIT_LENGTH           __MSABI_LONG(0x00080000)
#define SQL_FN_STR_CHAR_LENGTH          __MSABI_LONG(0x00100000)
#define SQL_FN_STR_CHARACTER_LENGTH     __MSABI_LONG(0x00200000)
#define SQL_FN_STR_OCTET_LENGTH         __MSABI_LONG(0x00400000)
#define SQL_FN_STR_POSITION             __MSABI_LONG(0x00800000)
Alexandre Julliard's avatar
Alexandre Julliard committed
799 800 801
#endif

#if (ODBCVER >= 0x0300)
802 803 804 805 806 807 808 809 810 811 812 813 814 815 816 817 818 819 820 821 822 823 824 825 826 827 828 829 830 831 832 833 834 835
#define SQL_SSF_CONVERT                 __MSABI_LONG(0x00000001)
#define SQL_SSF_LOWER                   __MSABI_LONG(0x00000002)
#define SQL_SSF_UPPER                   __MSABI_LONG(0x00000004)
#define SQL_SSF_SUBSTRING               __MSABI_LONG(0x00000008)
#define SQL_SSF_TRANSLATE               __MSABI_LONG(0x00000010)
#define SQL_SSF_TRIM_BOTH               __MSABI_LONG(0x00000020)
#define SQL_SSF_TRIM_LEADING            __MSABI_LONG(0x00000040)
#define SQL_SSF_TRIM_TRAILING           __MSABI_LONG(0x00000080)
#endif

#define SQL_FN_NUM_ABS                  __MSABI_LONG(0x00000001)
#define SQL_FN_NUM_ACOS                 __MSABI_LONG(0x00000002)
#define SQL_FN_NUM_ASIN                 __MSABI_LONG(0x00000004)
#define SQL_FN_NUM_ATAN                 __MSABI_LONG(0x00000008)
#define SQL_FN_NUM_ATAN2                __MSABI_LONG(0x00000010)
#define SQL_FN_NUM_CEILING              __MSABI_LONG(0x00000020)
#define SQL_FN_NUM_COS                  __MSABI_LONG(0x00000040)
#define SQL_FN_NUM_COT                  __MSABI_LONG(0x00000080)
#define SQL_FN_NUM_EXP                  __MSABI_LONG(0x00000100)
#define SQL_FN_NUM_FLOOR                __MSABI_LONG(0x00000200)
#define SQL_FN_NUM_LOG                  __MSABI_LONG(0x00000400)
#define SQL_FN_NUM_MOD                  __MSABI_LONG(0x00000800)
#define SQL_FN_NUM_SIGN                 __MSABI_LONG(0x00001000)
#define SQL_FN_NUM_SIN                  __MSABI_LONG(0x00002000)
#define SQL_FN_NUM_SQRT                 __MSABI_LONG(0x00004000)
#define SQL_FN_NUM_TAN                  __MSABI_LONG(0x00008000)
#define SQL_FN_NUM_PI                   __MSABI_LONG(0x00010000)
#define SQL_FN_NUM_RAND                 __MSABI_LONG(0x00020000)
#define SQL_FN_NUM_DEGREES              __MSABI_LONG(0x00040000)
#define SQL_FN_NUM_LOG10                __MSABI_LONG(0x00080000)
#define SQL_FN_NUM_POWER                __MSABI_LONG(0x00100000)
#define SQL_FN_NUM_RADIANS              __MSABI_LONG(0x00200000)
#define SQL_FN_NUM_ROUND                __MSABI_LONG(0x00400000)
#define SQL_FN_NUM_TRUNCATE             __MSABI_LONG(0x00800000)
Alexandre Julliard's avatar
Alexandre Julliard committed
836 837

#if (ODBCVER >= 0x0300)
838 839 840 841 842 843 844 845 846 847 848 849 850 851 852 853 854 855 856 857 858 859 860 861 862
#define SQL_SNVF_BIT_LENGTH             __MSABI_LONG(0x00000001)
#define SQL_SNVF_CHAR_LENGTH            __MSABI_LONG(0x00000002)
#define SQL_SNVF_CHARACTER_LENGTH       __MSABI_LONG(0x00000004)
#define SQL_SNVF_EXTRACT                __MSABI_LONG(0x00000008)
#define SQL_SNVF_OCTET_LENGTH           __MSABI_LONG(0x00000010)
#define SQL_SNVF_POSITION               __MSABI_LONG(0x00000020)
#endif

#define SQL_FN_TD_NOW                   __MSABI_LONG(0x00000001)
#define SQL_FN_TD_CURDATE               __MSABI_LONG(0x00000002)
#define SQL_FN_TD_DAYOFMONTH            __MSABI_LONG(0x00000004)
#define SQL_FN_TD_DAYOFWEEK             __MSABI_LONG(0x00000008)
#define SQL_FN_TD_DAYOFYEAR             __MSABI_LONG(0x00000010)
#define SQL_FN_TD_MONTH                 __MSABI_LONG(0x00000020)
#define SQL_FN_TD_QUARTER               __MSABI_LONG(0x00000040)
#define SQL_FN_TD_WEEK                  __MSABI_LONG(0x00000080)
#define SQL_FN_TD_YEAR                  __MSABI_LONG(0x00000100)
#define SQL_FN_TD_CURTIME               __MSABI_LONG(0x00000200)
#define SQL_FN_TD_HOUR                  __MSABI_LONG(0x00000400)
#define SQL_FN_TD_MINUTE                __MSABI_LONG(0x00000800)
#define SQL_FN_TD_SECOND                __MSABI_LONG(0x00001000)
#define SQL_FN_TD_TIMESTAMPADD          __MSABI_LONG(0x00002000)
#define SQL_FN_TD_TIMESTAMPDIFF         __MSABI_LONG(0x00004000)
#define SQL_FN_TD_DAYNAME               __MSABI_LONG(0x00008000)
#define SQL_FN_TD_MONTHNAME             __MSABI_LONG(0x00010000)
Alexandre Julliard's avatar
Alexandre Julliard committed
863
#if (ODBCVER >= 0x0300)
864 865 866 867
#define SQL_FN_TD_CURRENT_DATE          __MSABI_LONG(0x00020000)
#define SQL_FN_TD_CURRENT_TIME          __MSABI_LONG(0x00040000)
#define SQL_FN_TD_CURRENT_TIMESTAMP     __MSABI_LONG(0x00080000)
#define SQL_FN_TD_EXTRACT               __MSABI_LONG(0x00100000)
Alexandre Julliard's avatar
Alexandre Julliard committed
868 869 870
#endif

#if (ODBCVER >= 0x0300)
871 872 873
#define SQL_SDF_CURRENT_DATE            __MSABI_LONG(0x00000001)
#define SQL_SDF_CURRENT_TIME            __MSABI_LONG(0x00000002)
#define SQL_SDF_CURRENT_TIMESTAMP       __MSABI_LONG(0x00000004)
874
#endif
Alexandre Julliard's avatar
Alexandre Julliard committed
875

876 877 878
#define SQL_FN_SYS_USERNAME             __MSABI_LONG(0x00000001)
#define SQL_FN_SYS_DBNAME               __MSABI_LONG(0x00000002)
#define SQL_FN_SYS_IFNULL               __MSABI_LONG(0x00000004)
Alexandre Julliard's avatar
Alexandre Julliard committed
879

880 881 882 883 884 885 886 887 888
#define SQL_FN_TSI_FRAC_SECOND          __MSABI_LONG(0x00000001)
#define SQL_FN_TSI_SECOND               __MSABI_LONG(0x00000002)
#define SQL_FN_TSI_MINUTE               __MSABI_LONG(0x00000004)
#define SQL_FN_TSI_HOUR                 __MSABI_LONG(0x00000008)
#define SQL_FN_TSI_DAY                  __MSABI_LONG(0x00000010)
#define SQL_FN_TSI_WEEK                 __MSABI_LONG(0x00000020)
#define SQL_FN_TSI_MONTH                __MSABI_LONG(0x00000040)
#define SQL_FN_TSI_QUARTER              __MSABI_LONG(0x00000080)
#define SQL_FN_TSI_YEAR                 __MSABI_LONG(0x00000100)
Alexandre Julliard's avatar
Alexandre Julliard committed
889 890

#if (ODBCVER >= 0x0300)
891 892 893 894
#define SQL_CA1_NEXT                    __MSABI_LONG(0x00000001)
#define SQL_CA1_ABSOLUTE                __MSABI_LONG(0x00000002)
#define SQL_CA1_RELATIVE                __MSABI_LONG(0x00000004)
#define SQL_CA1_BOOKMARK                __MSABI_LONG(0x00000008)
Alexandre Julliard's avatar
Alexandre Julliard committed
895

896 897 898
#define SQL_CA1_LOCK_NO_CHANGE          __MSABI_LONG(0x00000040)
#define SQL_CA1_LOCK_EXCLUSIVE          __MSABI_LONG(0x00000080)
#define SQL_CA1_LOCK_UNLOCK             __MSABI_LONG(0x00000100)
Alexandre Julliard's avatar
Alexandre Julliard committed
899

900 901 902 903
#define SQL_CA1_POS_POSITION            __MSABI_LONG(0x00000200)
#define SQL_CA1_POS_UPDATE              __MSABI_LONG(0x00000400)
#define SQL_CA1_POS_DELETE              __MSABI_LONG(0x00000800)
#define SQL_CA1_POS_REFRESH             __MSABI_LONG(0x00001000)
Alexandre Julliard's avatar
Alexandre Julliard committed
904

905 906 907
#define SQL_CA1_POSITIONED_UPDATE       __MSABI_LONG(0x00002000)
#define SQL_CA1_POSITIONED_DELETE       __MSABI_LONG(0x00004000)
#define SQL_CA1_SELECT_FOR_UPDATE       __MSABI_LONG(0x00008000)
Alexandre Julliard's avatar
Alexandre Julliard committed
908

909 910 911 912
#define SQL_CA1_BULK_ADD                __MSABI_LONG(0x00010000)
#define SQL_CA1_BULK_UPDATE_BY_BOOKMARK __MSABI_LONG(0x00020000)
#define SQL_CA1_BULK_DELETE_BY_BOOKMARK __MSABI_LONG(0x00040000)
#define SQL_CA1_BULK_FETCH_BY_BOOKMARK  __MSABI_LONG(0x00080000)
Alexandre Julliard's avatar
Alexandre Julliard committed
913 914 915
#endif

#if (ODBCVER >= 0x0300)
916 917 918 919 920 921 922 923 924 925 926 927 928 929
#define SQL_CA2_READ_ONLY_CONCURRENCY   __MSABI_LONG(0x00000001)
#define SQL_CA2_LOCK_CONCURRENCY        __MSABI_LONG(0x00000002)
#define SQL_CA2_OPT_ROWVER_CONCURRENCY  __MSABI_LONG(0x00000004)
#define SQL_CA2_OPT_VALUES_CONCURRENCY  __MSABI_LONG(0x00000008)

#define SQL_CA2_SENSITIVITY_ADDITIONS   __MSABI_LONG(0x00000010)
#define SQL_CA2_SENSITIVITY_DELETIONS   __MSABI_LONG(0x00000020)
#define SQL_CA2_SENSITIVITY_UPDATES     __MSABI_LONG(0x00000040)

#define SQL_CA2_MAX_ROWS_SELECT         __MSABI_LONG(0x00000080)
#define SQL_CA2_MAX_ROWS_INSERT         __MSABI_LONG(0x00000100)
#define SQL_CA2_MAX_ROWS_DELETE         __MSABI_LONG(0x00000200)
#define SQL_CA2_MAX_ROWS_UPDATE         __MSABI_LONG(0x00000400)
#define SQL_CA2_MAX_ROWS_CATALOG        __MSABI_LONG(0x00000800)
Alexandre Julliard's avatar
Alexandre Julliard committed
930 931
#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)

932 933
#define SQL_CA2_CRC_EXACT               __MSABI_LONG(0x00001000)
#define SQL_CA2_CRC_APPROXIMATE         __MSABI_LONG(0x00002000)
Alexandre Julliard's avatar
Alexandre Julliard committed
934

935 936 937
#define SQL_CA2_SIMULATE_NON_UNIQUE     __MSABI_LONG(0x00004000)
#define SQL_CA2_SIMULATE_TRY_UNIQUE     __MSABI_LONG(0x00008000)
#define SQL_CA2_SIMULATE_UNIQUE         __MSABI_LONG(0x00010000)
Alexandre Julliard's avatar
Alexandre Julliard committed
938 939 940 941 942 943 944 945 946 947 948 949 950 951 952 953
#endif

#define SQL_OAC_NONE                        0x0000
#define SQL_OAC_LEVEL1                      0x0001
#define SQL_OAC_LEVEL2                      0x0002

#define SQL_OSCC_NOT_COMPLIANT              0x0000
#define SQL_OSCC_COMPLIANT                  0x0001

#define SQL_OSC_MINIMUM                     0x0000
#define SQL_OSC_CORE                        0x0001
#define SQL_OSC_EXTENDED                    0x0002

#define SQL_CB_NULL                         0x0000
#define SQL_CB_NON_NULL                     0x0001

954 955 956 957 958
#define SQL_SO_FORWARD_ONLY             __MSABI_LONG(0x00000001)
#define SQL_SO_KEYSET_DRIVEN            __MSABI_LONG(0x00000002)
#define SQL_SO_DYNAMIC                  __MSABI_LONG(0x00000004)
#define SQL_SO_MIXED                    __MSABI_LONG(0x00000008)
#define SQL_SO_STATIC                   __MSABI_LONG(0x00000010)
Alexandre Julliard's avatar
Alexandre Julliard committed
959

960
#define SQL_FD_FETCH_BOOKMARK           __MSABI_LONG(0x00000080)
Alexandre Julliard's avatar
Alexandre Julliard committed
961 962 963 964 965 966 967 968 969 970 971 972 973 974 975 976

#define SQL_CN_NONE                         0x0000
#define SQL_CN_DIFFERENT                    0x0001
#define SQL_CN_ANY                          0x0002

#define SQL_NNC_NULL                        0x0000
#define SQL_NNC_NON_NULL                    0x0001

#define SQL_NC_START                        0x0002
#define SQL_NC_END                          0x0004

#define SQL_FILE_NOT_SUPPORTED              0x0000
#define SQL_FILE_TABLE                      0x0001
#define SQL_FILE_QUALIFIER                  0x0002
#define SQL_FILE_CATALOG		SQL_FILE_QUALIFIER

977 978
#define SQL_GD_BLOCK                    __MSABI_LONG(0x00000004)
#define SQL_GD_BOUND                    __MSABI_LONG(0x00000008)
Alexandre Julliard's avatar
Alexandre Julliard committed
979

980 981 982
#define SQL_PS_POSITIONED_DELETE        __MSABI_LONG(0x00000001)
#define SQL_PS_POSITIONED_UPDATE        __MSABI_LONG(0x00000002)
#define SQL_PS_SELECT_FOR_UPDATE        __MSABI_LONG(0x00000004)
Alexandre Julliard's avatar
Alexandre Julliard committed
983 984 985 986 987 988 989 990 991 992

#define SQL_GB_NOT_SUPPORTED                0x0000
#define SQL_GB_GROUP_BY_EQUALS_SELECT       0x0001
#define SQL_GB_GROUP_BY_CONTAINS_SELECT     0x0002
#define SQL_GB_NO_RELATION                  0x0003
#if (ODBCVER >= 0x0300)
#define	SQL_GB_COLLATE			0x0004

#endif

993 994 995 996 997
#define SQL_OU_DML_STATEMENTS           __MSABI_LONG(0x00000001)
#define SQL_OU_PROCEDURE_INVOCATION     __MSABI_LONG(0x00000002)
#define SQL_OU_TABLE_DEFINITION         __MSABI_LONG(0x00000004)
#define SQL_OU_INDEX_DEFINITION         __MSABI_LONG(0x00000008)
#define SQL_OU_PRIVILEGE_DEFINITION     __MSABI_LONG(0x00000010)
Alexandre Julliard's avatar
Alexandre Julliard committed
998 999 1000 1001 1002 1003 1004 1005 1006

#if (ODBCVER >= 0x0300)
#define SQL_SU_DML_STATEMENTS			SQL_OU_DML_STATEMENTS
#define SQL_SU_PROCEDURE_INVOCATION		SQL_OU_PROCEDURE_INVOCATION
#define SQL_SU_TABLE_DEFINITION			SQL_OU_TABLE_DEFINITION
#define SQL_SU_INDEX_DEFINITION			SQL_OU_INDEX_DEFINITION
#define SQL_SU_PRIVILEGE_DEFINITION		SQL_OU_PRIVILEGE_DEFINITION
#endif

1007 1008 1009 1010 1011
#define SQL_QU_DML_STATEMENTS           __MSABI_LONG(0x00000001)
#define SQL_QU_PROCEDURE_INVOCATION     __MSABI_LONG(0x00000002)
#define SQL_QU_TABLE_DEFINITION         __MSABI_LONG(0x00000004)
#define SQL_QU_INDEX_DEFINITION         __MSABI_LONG(0x00000008)
#define SQL_QU_PRIVILEGE_DEFINITION     __MSABI_LONG(0x00000010)
Alexandre Julliard's avatar
Alexandre Julliard committed
1012 1013 1014 1015 1016 1017 1018 1019 1020

#if (ODBCVER >= 0x0300)
#define SQL_CU_DML_STATEMENTS			SQL_QU_DML_STATEMENTS
#define SQL_CU_PROCEDURE_INVOCATION		SQL_QU_PROCEDURE_INVOCATION
#define SQL_CU_TABLE_DEFINITION			SQL_QU_TABLE_DEFINITION
#define SQL_CU_INDEX_DEFINITION			SQL_QU_INDEX_DEFINITION
#define SQL_CU_PRIVILEGE_DEFINITION		SQL_QU_PRIVILEGE_DEFINITION
#endif

1021 1022 1023 1024 1025
#define SQL_SQ_COMPARISON               __MSABI_LONG(0x00000001)
#define SQL_SQ_EXISTS                   __MSABI_LONG(0x00000002)
#define SQL_SQ_IN                       __MSABI_LONG(0x00000004)
#define SQL_SQ_QUANTIFIED               __MSABI_LONG(0x00000008)
#define SQL_SQ_CORRELATED_SUBQUERIES    __MSABI_LONG(0x00000010)
Alexandre Julliard's avatar
Alexandre Julliard committed
1026

1027 1028
#define SQL_U_UNION                     __MSABI_LONG(0x00000001)
#define SQL_U_UNION_ALL                 __MSABI_LONG(0x00000002)
Alexandre Julliard's avatar
Alexandre Julliard committed
1029

1030 1031 1032 1033 1034 1035 1036
#define SQL_BP_CLOSE                    __MSABI_LONG(0x00000001)
#define SQL_BP_DELETE                   __MSABI_LONG(0x00000002)
#define SQL_BP_DROP                     __MSABI_LONG(0x00000004)
#define SQL_BP_TRANSACTION              __MSABI_LONG(0x00000008)
#define SQL_BP_UPDATE                   __MSABI_LONG(0x00000010)
#define SQL_BP_OTHER_HSTMT              __MSABI_LONG(0x00000020)
#define SQL_BP_SCROLL                   __MSABI_LONG(0x00000040)
Alexandre Julliard's avatar
Alexandre Julliard committed
1037

1038 1039 1040
#define SQL_SS_ADDITIONS                __MSABI_LONG(0x00000001)
#define SQL_SS_DELETIONS                __MSABI_LONG(0x00000002)
#define SQL_SS_UPDATES                  __MSABI_LONG(0x00000004)
Alexandre Julliard's avatar
Alexandre Julliard committed
1041

1042 1043 1044 1045
#define SQL_CV_CREATE_VIEW              __MSABI_LONG(0x00000001)
#define SQL_CV_CHECK_OPTION             __MSABI_LONG(0x00000002)
#define SQL_CV_CASCADED                 __MSABI_LONG(0x00000004)
#define SQL_CV_LOCAL                    __MSABI_LONG(0x00000008)
Alexandre Julliard's avatar
Alexandre Julliard committed
1046

1047 1048 1049
#define SQL_LCK_NO_CHANGE               __MSABI_LONG(0x00000001)
#define SQL_LCK_EXCLUSIVE               __MSABI_LONG(0x00000002)
#define SQL_LCK_UNLOCK                  __MSABI_LONG(0x00000004)
Alexandre Julliard's avatar
Alexandre Julliard committed
1050

1051 1052 1053 1054 1055
#define SQL_POS_POSITION                __MSABI_LONG(0x00000001)
#define SQL_POS_REFRESH                 __MSABI_LONG(0x00000002)
#define SQL_POS_UPDATE                  __MSABI_LONG(0x00000004)
#define SQL_POS_DELETE                  __MSABI_LONG(0x00000008)
#define SQL_POS_ADD                     __MSABI_LONG(0x00000010)
Alexandre Julliard's avatar
Alexandre Julliard committed
1056 1057 1058 1059 1060

#define SQL_QL_START                        0x0001
#define SQL_QL_END                          0x0002

#if (ODBCVER >= 0x0300)
1061 1062 1063 1064 1065 1066 1067 1068 1069 1070 1071 1072 1073 1074 1075 1076 1077 1078 1079 1080 1081 1082 1083 1084 1085 1086 1087 1088 1089
#define SQL_AF_AVG                      __MSABI_LONG(0x00000001)
#define SQL_AF_COUNT                    __MSABI_LONG(0x00000002)
#define SQL_AF_MAX                      __MSABI_LONG(0x00000004)
#define SQL_AF_MIN                      __MSABI_LONG(0x00000008)
#define SQL_AF_SUM                      __MSABI_LONG(0x00000010)
#define SQL_AF_DISTINCT                 __MSABI_LONG(0x00000020)
#define SQL_AF_ALL                      __MSABI_LONG(0x00000040)

#define SQL_SC_SQL92_ENTRY              __MSABI_LONG(0x00000001)
#define SQL_SC_FIPS127_2_TRANSITIONAL   __MSABI_LONG(0x00000002)
#define SQL_SC_SQL92_INTERMEDIATE       __MSABI_LONG(0x00000004)
#define SQL_SC_SQL92_FULL               __MSABI_LONG(0x00000008)

#define SQL_DL_SQL92_DATE               __MSABI_LONG(0x00000001)
#define SQL_DL_SQL92_TIME               __MSABI_LONG(0x00000002)
#define SQL_DL_SQL92_TIMESTAMP          __MSABI_LONG(0x00000004)
#define SQL_DL_SQL92_INTERVAL_YEAR      __MSABI_LONG(0x00000008)
#define SQL_DL_SQL92_INTERVAL_MONTH     __MSABI_LONG(0x00000010)
#define SQL_DL_SQL92_INTERVAL_DAY       __MSABI_LONG(0x00000020)
#define SQL_DL_SQL92_INTERVAL_HOUR      __MSABI_LONG(0x00000040)
#define SQL_DL_SQL92_INTERVAL_MINUTE    __MSABI_LONG(0x00000080)
#define SQL_DL_SQL92_INTERVAL_SECOND    __MSABI_LONG(0x00000100)
#define SQL_DL_SQL92_INTERVAL_YEAR_TO_MONTH     __MSABI_LONG(0x00000200)
#define SQL_DL_SQL92_INTERVAL_DAY_TO_HOUR       __MSABI_LONG(0x00000400)
#define SQL_DL_SQL92_INTERVAL_DAY_TO_MINUTE     __MSABI_LONG(0x00000800)
#define SQL_DL_SQL92_INTERVAL_DAY_TO_SECOND     __MSABI_LONG(0x00001000)
#define SQL_DL_SQL92_INTERVAL_HOUR_TO_MINUTE    __MSABI_LONG(0x00002000)
#define SQL_DL_SQL92_INTERVAL_HOUR_TO_SECOND    __MSABI_LONG(0x00004000)
#define SQL_DL_SQL92_INTERVAL_MINUTE_TO_SECOND  __MSABI_LONG(0x00008000)
Alexandre Julliard's avatar
Alexandre Julliard committed
1090 1091 1092 1093 1094 1095 1096 1097

#define SQL_CL_START						SQL_QL_START
#define SQL_CL_END							SQL_QL_END

#define SQL_BRC_PROCEDURES			0x0000001
#define	SQL_BRC_EXPLICIT			0x0000002
#define	SQL_BRC_ROLLED_UP			0x0000004

1098 1099 1100 1101
#define SQL_BS_SELECT_EXPLICIT          __MSABI_LONG(0x00000001)
#define SQL_BS_ROW_COUNT_EXPLICIT       __MSABI_LONG(0x00000002)
#define SQL_BS_SELECT_PROC              __MSABI_LONG(0x00000004)
#define SQL_BS_ROW_COUNT_PROC           __MSABI_LONG(0x00000008)
Alexandre Julliard's avatar
Alexandre Julliard committed
1102 1103 1104 1105 1106

#define SQL_PARC_BATCH		1
#define SQL_PARC_NO_BATCH	2

#define SQL_PAS_BATCH				1
1107
#define SQL_PAS_NO_BATCH			2
Alexandre Julliard's avatar
Alexandre Julliard committed
1108 1109
#define SQL_PAS_NO_SELECT			3

1110 1111 1112
#define SQL_IK_NONE                     __MSABI_LONG(0x00000000)
#define SQL_IK_ASC                      __MSABI_LONG(0x00000001)
#define SQL_IK_DESC                     __MSABI_LONG(0x00000002)
Alexandre Julliard's avatar
Alexandre Julliard committed
1113 1114
#define SQL_IK_ALL							(SQL_IK_ASC | SQL_IK_DESC)

1115 1116 1117 1118 1119 1120 1121 1122 1123 1124 1125 1126 1127 1128 1129 1130 1131 1132 1133 1134 1135 1136 1137
#define SQL_ISV_ASSERTIONS              __MSABI_LONG(0x00000001)
#define SQL_ISV_CHARACTER_SETS          __MSABI_LONG(0x00000002)
#define SQL_ISV_CHECK_CONSTRAINTS       __MSABI_LONG(0x00000004)
#define SQL_ISV_COLLATIONS              __MSABI_LONG(0x00000008)
#define SQL_ISV_COLUMN_DOMAIN_USAGE     __MSABI_LONG(0x00000010)
#define SQL_ISV_COLUMN_PRIVILEGES       __MSABI_LONG(0x00000020)
#define SQL_ISV_COLUMNS                 __MSABI_LONG(0x00000040)
#define SQL_ISV_CONSTRAINT_COLUMN_USAGE __MSABI_LONG(0x00000080)
#define SQL_ISV_CONSTRAINT_TABLE_USAGE  __MSABI_LONG(0x00000100)
#define SQL_ISV_DOMAIN_CONSTRAINTS      __MSABI_LONG(0x00000200)
#define SQL_ISV_DOMAINS                 __MSABI_LONG(0x00000400)
#define SQL_ISV_KEY_COLUMN_USAGE        __MSABI_LONG(0x00000800)
#define SQL_ISV_REFERENTIAL_CONSTRAINTS __MSABI_LONG(0x00001000)
#define SQL_ISV_SCHEMATA                __MSABI_LONG(0x00002000)
#define SQL_ISV_SQL_LANGUAGES           __MSABI_LONG(0x00004000)
#define SQL_ISV_TABLE_CONSTRAINTS       __MSABI_LONG(0x00008000)
#define SQL_ISV_TABLE_PRIVILEGES        __MSABI_LONG(0x00010000)
#define SQL_ISV_TABLES                  __MSABI_LONG(0x00020000)
#define SQL_ISV_TRANSLATIONS            __MSABI_LONG(0x00040000)
#define SQL_ISV_USAGE_PRIVILEGES        __MSABI_LONG(0x00080000)
#define SQL_ISV_VIEW_COLUMN_USAGE       __MSABI_LONG(0x00100000)
#define SQL_ISV_VIEW_TABLE_USAGE        __MSABI_LONG(0x00200000)
#define SQL_ISV_VIEWS                   __MSABI_LONG(0x00400000)
Alexandre Julliard's avatar
Alexandre Julliard committed
1138 1139 1140 1141 1142

#define	SQL_AM_NONE			0
#define	SQL_AM_CONNECTION	1
#define	SQL_AM_STATEMENT	2

1143 1144 1145 1146 1147 1148 1149 1150 1151 1152 1153 1154 1155 1156 1157 1158 1159 1160 1161 1162 1163 1164 1165 1166 1167 1168 1169 1170 1171 1172 1173 1174 1175 1176 1177 1178 1179 1180 1181 1182 1183 1184 1185 1186 1187 1188 1189 1190 1191 1192 1193 1194 1195 1196 1197 1198 1199 1200 1201 1202 1203 1204 1205 1206 1207 1208 1209 1210 1211 1212 1213 1214 1215 1216 1217 1218 1219 1220 1221 1222 1223 1224 1225 1226 1227 1228 1229 1230 1231 1232 1233 1234 1235 1236 1237 1238 1239 1240 1241 1242 1243 1244 1245 1246 1247 1248 1249 1250 1251 1252 1253 1254 1255 1256 1257 1258 1259 1260 1261 1262 1263 1264 1265 1266 1267 1268 1269 1270 1271 1272 1273 1274 1275 1276 1277 1278 1279 1280 1281 1282 1283 1284 1285 1286 1287 1288 1289 1290 1291 1292 1293 1294 1295 1296 1297 1298 1299 1300 1301 1302 1303 1304 1305 1306 1307 1308
#define SQL_AD_CONSTRAINT_NAME_DEFINITION               __MSABI_LONG(0x00000001)
#define SQL_AD_ADD_DOMAIN_CONSTRAINT                    __MSABI_LONG(0x00000002)
#define SQL_AD_DROP_DOMAIN_CONSTRAINT                   __MSABI_LONG(0x00000004)
#define SQL_AD_ADD_DOMAIN_DEFAULT                       __MSABI_LONG(0x00000008)
#define SQL_AD_DROP_DOMAIN_DEFAULT                      __MSABI_LONG(0x00000010)
#define SQL_AD_ADD_CONSTRAINT_INITIALLY_DEFERRED        __MSABI_LONG(0x00000020)
#define SQL_AD_ADD_CONSTRAINT_INITIALLY_IMMEDIATE       __MSABI_LONG(0x00000040)
#define SQL_AD_ADD_CONSTRAINT_DEFERRABLE                __MSABI_LONG(0x00000080)
#define SQL_AD_ADD_CONSTRAINT_NON_DEFERRABLE            __MSABI_LONG(0x00000100)

#define SQL_CS_CREATE_SCHEMA            __MSABI_LONG(0x00000001)
#define SQL_CS_AUTHORIZATION            __MSABI_LONG(0x00000002)
#define SQL_CS_DEFAULT_CHARACTER_SET    __MSABI_LONG(0x00000004)

#define SQL_CTR_CREATE_TRANSLATION      __MSABI_LONG(0x00000001)

#define SQL_CA_CREATE_ASSERTION                 __MSABI_LONG(0x00000001)
#define SQL_CA_CONSTRAINT_INITIALLY_DEFERRED    __MSABI_LONG(0x00000010)
#define SQL_CA_CONSTRAINT_INITIALLY_IMMEDIATE   __MSABI_LONG(0x00000020)
#define SQL_CA_CONSTRAINT_DEFERRABLE            __MSABI_LONG(0x00000040)
#define SQL_CA_CONSTRAINT_NON_DEFERRABLE        __MSABI_LONG(0x00000080)

#define SQL_CCS_CREATE_CHARACTER_SET    __MSABI_LONG(0x00000001)
#define SQL_CCS_COLLATE_CLAUSE          __MSABI_LONG(0x00000002)
#define SQL_CCS_LIMITED_COLLATION       __MSABI_LONG(0x00000004)

#define SQL_CCOL_CREATE_COLLATION       __MSABI_LONG(0x00000001)

#define SQL_CDO_CREATE_DOMAIN                   __MSABI_LONG(0x00000001)
#define SQL_CDO_DEFAULT                         __MSABI_LONG(0x00000002)
#define SQL_CDO_CONSTRAINT                      __MSABI_LONG(0x00000004)
#define SQL_CDO_COLLATION                       __MSABI_LONG(0x00000008)
#define SQL_CDO_CONSTRAINT_NAME_DEFINITION      __MSABI_LONG(0x00000010)
#define SQL_CDO_CONSTRAINT_INITIALLY_DEFERRED   __MSABI_LONG(0x00000020)
#define SQL_CDO_CONSTRAINT_INITIALLY_IMMEDIATE  __MSABI_LONG(0x00000040)
#define SQL_CDO_CONSTRAINT_DEFERRABLE           __MSABI_LONG(0x00000080)
#define SQL_CDO_CONSTRAINT_NON_DEFERRABLE       __MSABI_LONG(0x00000100)

#define SQL_CT_CREATE_TABLE                     __MSABI_LONG(0x00000001)
#define SQL_CT_COMMIT_PRESERVE                  __MSABI_LONG(0x00000002)
#define SQL_CT_COMMIT_DELETE                    __MSABI_LONG(0x00000004)
#define SQL_CT_GLOBAL_TEMPORARY                 __MSABI_LONG(0x00000008)
#define SQL_CT_LOCAL_TEMPORARY                  __MSABI_LONG(0x00000010)
#define SQL_CT_CONSTRAINT_INITIALLY_DEFERRED    __MSABI_LONG(0x00000020)
#define SQL_CT_CONSTRAINT_INITIALLY_IMMEDIATE   __MSABI_LONG(0x00000040)
#define SQL_CT_CONSTRAINT_DEFERRABLE            __MSABI_LONG(0x00000080)
#define SQL_CT_CONSTRAINT_NON_DEFERRABLE        __MSABI_LONG(0x00000100)
#define SQL_CT_COLUMN_CONSTRAINT                __MSABI_LONG(0x00000200)
#define SQL_CT_COLUMN_DEFAULT                   __MSABI_LONG(0x00000400)
#define SQL_CT_COLUMN_COLLATION                 __MSABI_LONG(0x00000800)
#define SQL_CT_TABLE_CONSTRAINT                 __MSABI_LONG(0x00001000)
#define SQL_CT_CONSTRAINT_NAME_DEFINITION       __MSABI_LONG(0x00002000)

#define SQL_DI_CREATE_INDEX             __MSABI_LONG(0x00000001)
#define SQL_DI_DROP_INDEX               __MSABI_LONG(0x00000002)

#define SQL_DC_DROP_COLLATION           __MSABI_LONG(0x00000001)

#define SQL_DD_DROP_DOMAIN              __MSABI_LONG(0x00000001)
#define SQL_DD_RESTRICT                 __MSABI_LONG(0x00000002)
#define SQL_DD_CASCADE                  __MSABI_LONG(0x00000004)

#define SQL_DS_DROP_SCHEMA              __MSABI_LONG(0x00000001)
#define SQL_DS_RESTRICT                 __MSABI_LONG(0x00000002)
#define SQL_DS_CASCADE                  __MSABI_LONG(0x00000004)

#define SQL_DCS_DROP_CHARACTER_SET      __MSABI_LONG(0x00000001)

#define SQL_DA_DROP_ASSERTION           __MSABI_LONG(0x00000001)

#define SQL_DT_DROP_TABLE               __MSABI_LONG(0x00000001)
#define SQL_DT_RESTRICT                 __MSABI_LONG(0x00000002)
#define SQL_DT_CASCADE                  __MSABI_LONG(0x00000004)

#define SQL_DTR_DROP_TRANSLATION        __MSABI_LONG(0x00000001)

#define SQL_DV_DROP_VIEW                __MSABI_LONG(0x00000001)
#define SQL_DV_RESTRICT                 __MSABI_LONG(0x00000002)
#define SQL_DV_CASCADE                  __MSABI_LONG(0x00000004)

#define SQL_IS_INSERT_LITERALS          __MSABI_LONG(0x00000001)
#define SQL_IS_INSERT_SEARCHED          __MSABI_LONG(0x00000002)
#define SQL_IS_SELECT_INTO              __MSABI_LONG(0x00000004)

#define SQL_OIC_CORE                    __MSABI_LONG(1U)
#define SQL_OIC_LEVEL1                  __MSABI_LONG(2U)
#define SQL_OIC_LEVEL2                  __MSABI_LONG(3U)

#define SQL_SFKD_CASCADE                __MSABI_LONG(0x00000001)
#define SQL_SFKD_NO_ACTION              __MSABI_LONG(0x00000002)
#define SQL_SFKD_SET_DEFAULT            __MSABI_LONG(0x00000004)
#define SQL_SFKD_SET_NULL               __MSABI_LONG(0x00000008)

#define SQL_SFKU_CASCADE                __MSABI_LONG(0x00000001)
#define SQL_SFKU_NO_ACTION              __MSABI_LONG(0x00000002)
#define SQL_SFKU_SET_DEFAULT            __MSABI_LONG(0x00000004)
#define SQL_SFKU_SET_NULL               __MSABI_LONG(0x00000008)

#define SQL_SG_USAGE_ON_DOMAIN          __MSABI_LONG(0x00000001)
#define SQL_SG_USAGE_ON_CHARACTER_SET   __MSABI_LONG(0x00000002)
#define SQL_SG_USAGE_ON_COLLATION       __MSABI_LONG(0x00000004)
#define SQL_SG_USAGE_ON_TRANSLATION     __MSABI_LONG(0x00000008)
#define SQL_SG_WITH_GRANT_OPTION        __MSABI_LONG(0x00000010)
#define SQL_SG_DELETE_TABLE             __MSABI_LONG(0x00000020)
#define SQL_SG_INSERT_TABLE             __MSABI_LONG(0x00000040)
#define SQL_SG_INSERT_COLUMN            __MSABI_LONG(0x00000080)
#define SQL_SG_REFERENCES_TABLE         __MSABI_LONG(0x00000100)
#define SQL_SG_REFERENCES_COLUMN        __MSABI_LONG(0x00000200)
#define SQL_SG_SELECT_TABLE             __MSABI_LONG(0x00000400)
#define SQL_SG_UPDATE_TABLE             __MSABI_LONG(0x00000800)
#define SQL_SG_UPDATE_COLUMN            __MSABI_LONG(0x00001000)

#define SQL_SP_EXISTS                   __MSABI_LONG(0x00000001)
#define SQL_SP_ISNOTNULL                __MSABI_LONG(0x00000002)
#define SQL_SP_ISNULL                   __MSABI_LONG(0x00000004)
#define SQL_SP_MATCH_FULL               __MSABI_LONG(0x00000008)
#define SQL_SP_MATCH_PARTIAL            __MSABI_LONG(0x00000010)
#define SQL_SP_MATCH_UNIQUE_FULL        __MSABI_LONG(0x00000020)
#define SQL_SP_MATCH_UNIQUE_PARTIAL     __MSABI_LONG(0x00000040)
#define SQL_SP_OVERLAPS                 __MSABI_LONG(0x00000080)
#define SQL_SP_UNIQUE                   __MSABI_LONG(0x00000100)
#define SQL_SP_LIKE                     __MSABI_LONG(0x00000200)
#define SQL_SP_IN                       __MSABI_LONG(0x00000400)
#define SQL_SP_BETWEEN                  __MSABI_LONG(0x00000800)
#define SQL_SP_COMPARISON               __MSABI_LONG(0x00001000)
#define SQL_SP_QUANTIFIED_COMPARISON    __MSABI_LONG(0x00002000)

#define SQL_SRJO_CORRESPONDING_CLAUSE   __MSABI_LONG(0x00000001)
#define SQL_SRJO_CROSS_JOIN             __MSABI_LONG(0x00000002)
#define SQL_SRJO_EXCEPT_JOIN            __MSABI_LONG(0x00000004)
#define SQL_SRJO_FULL_OUTER_JOIN        __MSABI_LONG(0x00000008)
#define SQL_SRJO_INNER_JOIN             __MSABI_LONG(0x00000010)
#define SQL_SRJO_INTERSECT_JOIN         __MSABI_LONG(0x00000020)
#define SQL_SRJO_LEFT_OUTER_JOIN        __MSABI_LONG(0x00000040)
#define SQL_SRJO_NATURAL_JOIN           __MSABI_LONG(0x00000080)
#define SQL_SRJO_RIGHT_OUTER_JOIN       __MSABI_LONG(0x00000100)
#define SQL_SRJO_UNION_JOIN             __MSABI_LONG(0x00000200)

#define SQL_SR_USAGE_ON_DOMAIN          __MSABI_LONG(0x00000001)
#define SQL_SR_USAGE_ON_CHARACTER_SET   __MSABI_LONG(0x00000002)
#define SQL_SR_USAGE_ON_COLLATION       __MSABI_LONG(0x00000004)
#define SQL_SR_USAGE_ON_TRANSLATION     __MSABI_LONG(0x00000008)
#define SQL_SR_GRANT_OPTION_FOR         __MSABI_LONG(0x00000010)
#define SQL_SR_CASCADE                  __MSABI_LONG(0x00000020)
#define SQL_SR_RESTRICT                 __MSABI_LONG(0x00000040)
#define SQL_SR_DELETE_TABLE             __MSABI_LONG(0x00000080)
#define SQL_SR_INSERT_TABLE             __MSABI_LONG(0x00000100)
#define SQL_SR_INSERT_COLUMN            __MSABI_LONG(0x00000200)
#define SQL_SR_REFERENCES_TABLE         __MSABI_LONG(0x00000400)
#define SQL_SR_REFERENCES_COLUMN        __MSABI_LONG(0x00000800)
#define SQL_SR_SELECT_TABLE             __MSABI_LONG(0x00001000)
#define SQL_SR_UPDATE_TABLE             __MSABI_LONG(0x00002000)
#define SQL_SR_UPDATE_COLUMN            __MSABI_LONG(0x00004000)

#define SQL_SRVC_VALUE_EXPRESSION       __MSABI_LONG(0x00000001)
#define SQL_SRVC_NULL                   __MSABI_LONG(0x00000002)
#define SQL_SRVC_DEFAULT                __MSABI_LONG(0x00000004)
#define SQL_SRVC_ROW_SUBQUERY           __MSABI_LONG(0x00000008)

#define SQL_SVE_CASE                    __MSABI_LONG(0x00000001)
#define SQL_SVE_CAST                    __MSABI_LONG(0x00000002)
#define SQL_SVE_COALESCE                __MSABI_LONG(0x00000004)
#define SQL_SVE_NULLIF                  __MSABI_LONG(0x00000008)

#define SQL_SCC_XOPEN_CLI_VERSION1      __MSABI_LONG(0x00000001)
#define SQL_SCC_ISO92_CLI               __MSABI_LONG(0x00000002)
Alexandre Julliard's avatar
Alexandre Julliard committed
1309 1310 1311 1312 1313 1314

#define SQL_US_UNION							SQL_U_UNION
#define SQL_US_UNION_ALL						SQL_U_UNION_ALL

#endif

1315 1316
#define SQL_DTC_ENLIST_EXPENSIVE        __MSABI_LONG(0x00000001)
#define SQL_DTC_UNENLIST_EXPENSIVE      __MSABI_LONG(0x00000002)
Alexandre Julliard's avatar
Alexandre Julliard committed
1317 1318 1319 1320

#if (ODBCVER >= 0x0300)
#define SQL_FETCH_FIRST_USER				31
#define SQL_FETCH_FIRST_SYSTEM				32
1321
#endif
Alexandre Julliard's avatar
Alexandre Julliard committed
1322 1323 1324 1325 1326 1327 1328 1329 1330 1331 1332 1333 1334 1335 1336 1337 1338 1339 1340 1341 1342 1343 1344 1345 1346 1347 1348 1349 1350 1351 1352 1353 1354 1355 1356 1357 1358 1359 1360 1361 1362 1363 1364 1365 1366 1367 1368 1369 1370 1371 1372 1373 1374 1375 1376 1377 1378 1379 1380 1381 1382 1383 1384 1385 1386 1387 1388 1389 1390 1391 1392 1393 1394 1395 1396 1397 1398 1399 1400 1401 1402 1403 1404 1405 1406 1407 1408 1409 1410 1411 1412 1413 1414 1415 1416 1417 1418 1419 1420 1421 1422 1423 1424 1425 1426 1427 1428 1429 1430 1431 1432 1433 1434 1435 1436 1437 1438 1439 1440 1441 1442 1443 1444 1445 1446 1447 1448 1449 1450 1451 1452 1453 1454 1455 1456 1457

#define SQL_ENTIRE_ROWSET            0

#define SQL_POSITION                 0
#define SQL_REFRESH                  1
#define SQL_UPDATE                   2
#define SQL_DELETE                   3

#define SQL_ADD                      4
#define	SQL_SETPOS_MAX_OPTION_VALUE			SQL_ADD
#if (ODBCVER >= 0x0300)
#define SQL_UPDATE_BY_BOOKMARK		 5
#define SQL_DELETE_BY_BOOKMARK		 6
#define	SQL_FETCH_BY_BOOKMARK		 7

#endif

#define SQL_LOCK_NO_CHANGE           0
#define SQL_LOCK_EXCLUSIVE           1
#define SQL_LOCK_UNLOCK              2

#define	SQL_SETPOS_MAX_LOCK_VALUE		SQL_LOCK_UNLOCK

#define SQL_POSITION_TO(hstmt,irow) SQLSetPos(hstmt,irow,SQL_POSITION,SQL_LOCK_NO_CHANGE)
#define SQL_LOCK_RECORD(hstmt,irow,fLock) SQLSetPos(hstmt,irow,SQL_POSITION,fLock)
#define SQL_REFRESH_RECORD(hstmt,irow,fLock) SQLSetPos(hstmt,irow,SQL_REFRESH,fLock)
#define SQL_UPDATE_RECORD(hstmt,irow) SQLSetPos(hstmt,irow,SQL_UPDATE,SQL_LOCK_NO_CHANGE)
#define SQL_DELETE_RECORD(hstmt,irow) SQLSetPos(hstmt,irow,SQL_DELETE,SQL_LOCK_NO_CHANGE)
#define SQL_ADD_RECORD(hstmt,irow) SQLSetPos(hstmt,irow,SQL_ADD,SQL_LOCK_NO_CHANGE)

#define SQL_BEST_ROWID                  1
#define SQL_ROWVER                      2

#define SQL_PC_NOT_PSEUDO               1

#define SQL_QUICK                       0
#define SQL_ENSURE                      1

#define SQL_TABLE_STAT                  0

#if (ODBCVER >= 0x0300)
#define SQL_ALL_CATALOGS				"%"
#define SQL_ALL_SCHEMAS					"%"
#define SQL_ALL_TABLE_TYPES				"%"
#endif  /* ODBCVER >= 0x0300 */

#define SQL_DRIVER_NOPROMPT             0
#define SQL_DRIVER_COMPLETE             1
#define SQL_DRIVER_PROMPT               2
#define SQL_DRIVER_COMPLETE_REQUIRED    3

SQLRETURN WINAPI  SQLDriverConnect(
    SQLHDBC            hdbc,
    SQLHWND            hwnd,
    SQLCHAR 		  *szConnStrIn,
    SQLSMALLINT        cbConnStrIn,
    SQLCHAR           *szConnStrOut,
    SQLSMALLINT        cbConnStrOutMax,
    SQLSMALLINT 	  *pcbConnStrOut,
    SQLUSMALLINT       fDriverCompletion);

#define SQL_FETCH_BOOKMARK               8

#define SQL_ROW_SUCCESS                  0
#define SQL_ROW_DELETED                  1
#define SQL_ROW_UPDATED                  2
#define SQL_ROW_NOROW                    3
#define SQL_ROW_ADDED                    4
#define SQL_ROW_ERROR                    5
#if (ODBCVER >= 0x0300)
#define SQL_ROW_SUCCESS_WITH_INFO		 6
#define SQL_ROW_PROCEED					 0
#define SQL_ROW_IGNORE					 1
#endif

#if (ODBCVER >= 0x0300)
#define SQL_PARAM_SUCCESS				0
#define SQL_PARAM_SUCCESS_WITH_INFO		6
#define SQL_PARAM_ERROR					5
#define SQL_PARAM_UNUSED				7
#define SQL_PARAM_DIAG_UNAVAILABLE		1

#define SQL_PARAM_PROCEED				0
#define SQL_PARAM_IGNORE				1
#endif

#define SQL_CASCADE                      0
#define SQL_RESTRICT                     1
#define SQL_SET_NULL                     2
#if (ODBCVER >= 0x0250)
#define SQL_NO_ACTION			 3
#define SQL_SET_DEFAULT			 4
#endif

#if (ODBCVER >= 0x0300)

#define SQL_INITIALLY_DEFERRED			5
#define SQL_INITIALLY_IMMEDIATE			6
#define SQL_NOT_DEFERRABLE			7

#endif

#define SQL_PARAM_TYPE_UNKNOWN           0
#define SQL_PARAM_INPUT                  1
#define SQL_PARAM_INPUT_OUTPUT           2
#define SQL_RESULT_COL                   3
#define SQL_PARAM_OUTPUT                 4
#define SQL_RETURN_VALUE                 5

#define SQL_PT_UNKNOWN                   0
#define SQL_PT_PROCEDURE                 1
#define SQL_PT_FUNCTION                  2

#define SQL_ODBC_KEYWORDS "ABSOLUTE,ACTION,ADA,ADD,ALL,ALLOCATE,ALTER,AND,ANY,ARE,AS,"

SQLRETURN WINAPI  SQLBrowseConnect(
    SQLHDBC            hdbc,
    SQLCHAR 		  *szConnStrIn,
    SQLSMALLINT        cbConnStrIn,
    SQLCHAR 		  *szConnStrOut,
    SQLSMALLINT        cbConnStrOutMax,
    SQLSMALLINT       *pcbConnStrOut);

#if (ODBCVER >= 0x0300)
SQLRETURN WINAPI	SQLBulkOperations(
	SQLHSTMT			StatementHandle,
	SQLSMALLINT			Operation);
#endif

SQLRETURN WINAPI  SQLColAttributes(
    SQLHSTMT           hstmt,
    SQLUSMALLINT       icol,
    SQLUSMALLINT       fDescType,
    SQLPOINTER         rgbDesc,
    SQLSMALLINT        cbDescMax,
    SQLSMALLINT 	  *pcbDesc,
1458
    SQLLEN		  *pfDesc);
Alexandre Julliard's avatar
Alexandre Julliard committed
1459 1460 1461 1462 1463 1464 1465 1466 1467 1468 1469 1470 1471 1472 1473 1474

SQLRETURN WINAPI  SQLColumnPrivileges(
    SQLHSTMT           hstmt,
    SQLCHAR 		  *szCatalogName,
    SQLSMALLINT        cbCatalogName,
    SQLCHAR 		  *szSchemaName,
    SQLSMALLINT        cbSchemaName,
    SQLCHAR 		  *szTableName,
    SQLSMALLINT        cbTableName,
    SQLCHAR 		  *szColumnName,
    SQLSMALLINT        cbColumnName);

SQLRETURN WINAPI  SQLDescribeParam(
    SQLHSTMT           hstmt,
    SQLUSMALLINT       ipar,
    SQLSMALLINT 	  *pfSqlType,
1475
    SQLULEN		  *pcbParamDef,
Alexandre Julliard's avatar
Alexandre Julliard committed
1476 1477 1478 1479 1480 1481
    SQLSMALLINT 	  *pibScale,
    SQLSMALLINT 	  *pfNullable);

SQLRETURN WINAPI  SQLExtendedFetch(
    SQLHSTMT           hstmt,
    SQLUSMALLINT       fFetchType,
1482 1483
    SQLLEN	       irow,
    SQLULEN		  *pcrow,
Alexandre Julliard's avatar
Alexandre Julliard committed
1484 1485 1486 1487 1488 1489 1490 1491 1492 1493 1494 1495 1496 1497 1498 1499 1500 1501 1502 1503 1504 1505 1506 1507 1508 1509 1510 1511 1512 1513 1514 1515 1516 1517
    SQLUSMALLINT 	  *rgfRowStatus);

SQLRETURN WINAPI  SQLForeignKeys(
    SQLHSTMT           hstmt,
    SQLCHAR 		  *szPkCatalogName,
    SQLSMALLINT        cbPkCatalogName,
    SQLCHAR 		  *szPkSchemaName,
    SQLSMALLINT        cbPkSchemaName,
    SQLCHAR 		  *szPkTableName,
    SQLSMALLINT        cbPkTableName,
    SQLCHAR 		  *szFkCatalogName,
    SQLSMALLINT        cbFkCatalogName,
    SQLCHAR 		  *szFkSchemaName,
    SQLSMALLINT        cbFkSchemaName,
    SQLCHAR 		  *szFkTableName,
    SQLSMALLINT        cbFkTableName);

SQLRETURN WINAPI  SQLMoreResults(
    SQLHSTMT           hstmt);

SQLRETURN WINAPI  SQLNativeSql(
    SQLHDBC            hdbc,
    SQLCHAR 		  *szSqlStrIn,
    SQLINTEGER         cbSqlStrIn,
    SQLCHAR 		  *szSqlStr,
    SQLINTEGER         cbSqlStrMax,
    SQLINTEGER 		  *pcbSqlStr);

SQLRETURN WINAPI  SQLNumParams(
    SQLHSTMT           hstmt,
    SQLSMALLINT 	  *pcpar);

SQLRETURN WINAPI  SQLParamOptions(
    SQLHSTMT           hstmt,
1518 1519
    SQLULEN	       crow,
    SQLULEN		  *pirow);
Alexandre Julliard's avatar
Alexandre Julliard committed
1520 1521 1522 1523 1524 1525 1526 1527 1528 1529 1530 1531 1532 1533 1534 1535 1536 1537 1538 1539 1540 1541 1542 1543 1544 1545 1546 1547 1548 1549 1550 1551

SQLRETURN WINAPI  SQLPrimaryKeys(
    SQLHSTMT           hstmt,
    SQLCHAR 		  *szCatalogName,
    SQLSMALLINT        cbCatalogName,
    SQLCHAR 		  *szSchemaName,
    SQLSMALLINT        cbSchemaName,
    SQLCHAR 		  *szTableName,
    SQLSMALLINT        cbTableName);

SQLRETURN WINAPI  SQLProcedureColumns(
    SQLHSTMT           hstmt,
    SQLCHAR 		  *szCatalogName,
    SQLSMALLINT        cbCatalogName,
    SQLCHAR 		  *szSchemaName,
    SQLSMALLINT        cbSchemaName,
    SQLCHAR 		  *szProcName,
    SQLSMALLINT        cbProcName,
    SQLCHAR 		  *szColumnName,
    SQLSMALLINT        cbColumnName);

SQLRETURN WINAPI  SQLProcedures(
    SQLHSTMT           hstmt,
    SQLCHAR 		  *szCatalogName,
    SQLSMALLINT        cbCatalogName,
    SQLCHAR 		  *szSchemaName,
    SQLSMALLINT        cbSchemaName,
    SQLCHAR 		  *szProcName,
    SQLSMALLINT        cbProcName);

SQLRETURN WINAPI  SQLSetPos(
    SQLHSTMT           hstmt,
1552
    SQLSETPOSIROW      irow,
Alexandre Julliard's avatar
Alexandre Julliard committed
1553 1554 1555 1556 1557 1558 1559 1560 1561 1562 1563 1564 1565 1566 1567 1568 1569 1570 1571 1572 1573 1574 1575 1576 1577 1578 1579 1580
    SQLUSMALLINT       fOption,
    SQLUSMALLINT       fLock);

SQLRETURN WINAPI  SQLTablePrivileges(
    SQLHSTMT           hstmt,
    SQLCHAR 		  *szCatalogName,
    SQLSMALLINT        cbCatalogName,
    SQLCHAR 		  *szSchemaName,
    SQLSMALLINT        cbSchemaName,
    SQLCHAR 		  *szTableName,
    SQLSMALLINT        cbTableName);

SQLRETURN WINAPI  SQLDrivers(
    SQLHENV            henv,
    SQLUSMALLINT       fDirection,
    SQLCHAR 		  *szDriverDesc,
    SQLSMALLINT        cbDriverDescMax,
    SQLSMALLINT 	  *pcbDriverDesc,
    SQLCHAR 		  *szDriverAttributes,
    SQLSMALLINT        cbDrvrAttrMax,
    SQLSMALLINT 	  *pcbDrvrAttr);

SQLRETURN WINAPI  SQLBindParameter(
    SQLHSTMT           hstmt,
    SQLUSMALLINT       ipar,
    SQLSMALLINT        fParamType,
    SQLSMALLINT        fCType,
    SQLSMALLINT        fSqlType,
1581
    SQLULEN	       cbColDef,
Alexandre Julliard's avatar
Alexandre Julliard committed
1582 1583
    SQLSMALLINT        ibScale,
    SQLPOINTER         rgbValue,
1584 1585
    SQLLEN	       cbValueMax,
    SQLLEN		  *pcbValue);
Alexandre Julliard's avatar
Alexandre Julliard committed
1586 1587 1588 1589 1590 1591 1592 1593 1594 1595

#ifdef ODBC_STD
#define SQLAllocHandle  SQLAllocHandleStd
#define SQLAllocEnv(phenv)  SQLAllocHandleStd(SQL_HANDLE_ENV, SQL_NULL_HANDLE, phenv)

#define SQL_YEAR						SQL_CODE_YEAR
#define SQL_MONTH						SQL_CODE_MONTH
#define SQL_DAY							SQL_CODE_DAY
#define SQL_HOUR						SQL_CODE_HOUR
#define SQL_MINUTE						SQL_CODE_MINUTE
1596
#define SQL_SECOND						SQL_CODE_SECOND
Alexandre Julliard's avatar
Alexandre Julliard committed
1597 1598 1599 1600
#define SQL_YEAR_TO_MONTH				SQL_CODE_YEAR_TO_MONTH
#define SQL_DAY_TO_HOUR					SQL_CODE_DAY_TO_HOUR
#define SQL_DAY_TO_MINUTE				SQL_CODE_DAY_TO_MINUTE
#define SQL_DAY_TO_SECOND				SQL_CODE_DAY_TO_SECOND
1601
#define SQL_HOUR_TO_MINUTE				SQL_CODE_HOUR_TO_MINUTE
Alexandre Julliard's avatar
Alexandre Julliard committed
1602 1603 1604 1605 1606 1607 1608 1609 1610 1611 1612 1613 1614 1615 1616 1617 1618 1619 1620 1621 1622 1623
#define SQL_HOUR_TO_SECOND				SQL_CODE_HOUR_TO_SECOND
#define SQL_MINUTE_TO_SECOND			SQL_CODE_MINUTE_TO_SECOND
#endif

#if (ODBCVER >= 0x0300)
SQLRETURN WINAPI  SQLAllocHandleStd(
	SQLSMALLINT		fHandleType,
	SQLHANDLE		hInput,
	SQLHANDLE	   *phOutput);
#endif

#define SQL_DATABASE_NAME               16
#define SQL_FD_FETCH_PREV               SQL_FD_FETCH_PRIOR
#define SQL_FETCH_PREV                  SQL_FETCH_PRIOR
#define SQL_CONCUR_TIMESTAMP            SQL_CONCUR_ROWVER
#define SQL_SCCO_OPT_TIMESTAMP          SQL_SCCO_OPT_ROWVER
#define SQL_CC_DELETE                   SQL_CB_DELETE
#define SQL_CR_DELETE                   SQL_CB_DELETE
#define SQL_CC_CLOSE                    SQL_CB_CLOSE
#define SQL_CR_CLOSE                    SQL_CB_CLOSE
#define SQL_CC_PRESERVE                 SQL_CB_PRESERVE
#define SQL_CR_PRESERVE                 SQL_CB_PRESERVE
1624 1625 1626 1627
#define SQL_SCROLL_FORWARD_ONLY         __MSABI_LONG(0)
#define SQL_SCROLL_KEYSET_DRIVEN        (__MSABI_LONG(-1))
#define SQL_SCROLL_DYNAMIC              (__MSABI_LONG(-2))
#define SQL_SCROLL_STATIC               (__MSABI_LONG(-3))
Alexandre Julliard's avatar
Alexandre Julliard committed
1628 1629 1630 1631

SQLRETURN WINAPI  SQLSetScrollOptions(
    SQLHSTMT           hstmt,
    SQLUSMALLINT       fConcurrency,
1632
    SQLLEN	       crowKeyset,
Alexandre Julliard's avatar
Alexandre Julliard committed
1633 1634 1635 1636 1637
    SQLUSMALLINT       crowRowset);

#define		TRACE_VERSION	1000

RETCODE	 TraceOpenLogFile(LPWSTR,LPWSTR,DWORD);
1638
RETCODE	 TraceCloseLogFile(void);
Alexandre Julliard's avatar
Alexandre Julliard committed
1639
VOID	 TraceReturn(RETCODE,RETCODE);
1640
DWORD	 TraceVersion(void);
Alexandre Julliard's avatar
Alexandre Julliard committed
1641

1642 1643
/*#define TRACE_ON                      __MSABI_LONG(0x00000001)*/
#define TRACE_VS_EVENT_ON               __MSABI_LONG(0x00000002)
Alexandre Julliard's avatar
Alexandre Julliard committed
1644

1645
RETCODE	TraceVSControl(DWORD);
Alexandre Julliard's avatar
Alexandre Julliard committed
1646

1647 1648 1649 1650
#define ODBC_VS_FLAG_UNICODE_ARG        __MSABI_LONG(0x00000001)
#define ODBC_VS_FLAG_UNICODE_COR        __MSABI_LONG(0x00000002)
#define ODBC_VS_FLAG_RETCODE            __MSABI_LONG(0x00000004)
#define ODBC_VS_FLAG_STOP               __MSABI_LONG(0x00000008)
Alexandre Julliard's avatar
Alexandre Julliard committed
1651 1652 1653 1654 1655

typedef struct tagODBC_VS_ARGS {
	const GUID	*pguidEvent;
	DWORD	dwFlags;
	union {
1656
		WCHAR	*wszArg;
Alexandre Julliard's avatar
Alexandre Julliard committed
1657
		CHAR	*szArg;
1658
	} DUMMYUNIONNAME1;
Alexandre Julliard's avatar
Alexandre Julliard committed
1659 1660 1661
	union {
		WCHAR	*wszCorrelation;
		CHAR	*szCorrelation;
1662
	} DUMMYUNIONNAME2;
Alexandre Julliard's avatar
Alexandre Julliard committed
1663 1664 1665 1666 1667 1668 1669 1670 1671 1672 1673
	RETCODE	RetCode;
} ODBC_VS_ARGS, *PODBC_VS_ARGS;

VOID	FireVSDebugEvent(PODBC_VS_ARGS);


#ifdef __cplusplus
}
#endif

#endif