source: Daodan/MSYS2/mingw32/i686-w64-mingw32/include/sql.h@ 1170

Last change on this file since 1170 was 1166, checked in by rossy, 3 years ago

Daodan: Replace MinGW build env with an up-to-date MSYS2 env
File size: 20.8 KB
Line 
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
16extern "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
Note: See TracBrowser for help on using the repository browser.