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