8 * The iODBC driver manager.
10 * Copyright (C) 1995 by Ke Jin <kejin@empress.com>
12 * This library is free software; you can redistribute it and/or
13 * modify it under the terms of the GNU Library General Public
14 * License as published by the Free Software Foundation; either
15 * version 2 of the License, or (at your option) any later version.
17 * This library is distributed in the hope that it will be useful,
18 * but WITHOUT ANY WARRANTY; without even the implied warranty of
19 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU
20 * Library General Public License for more details.
22 * You should have received a copy of the GNU Library General Public
23 * License along with this library; if not, write to the Free
24 * Software Foundation, Inc., 675 Mass Ave, Cambridge, MA 02139, USA.
31 #define SQL_API __stdcall
36 #define SQL_API EXPORT CALLBACK
42 typedef void *SQLHWND
;
44 typedef unsigned char UCHAR
;
45 typedef long int SDWORD
;
46 typedef short int SWORD
;
47 typedef unsigned long int UDWORD
;
48 typedef unsigned short int UWORD
;
50 typedef void FAR
*PTR
;
51 typedef void FAR
*HENV
;
52 typedef void FAR
*HDBC
;
53 typedef void FAR
*HSTMT
;
55 typedef signed short RETCODE
;
56 #define SQLRETURN RETCODE
59 #define ODBCVER 0x0250
61 #define SQL_MAX_MESSAGE_LENGTH 512
62 #define SQL_MAX_DSN_LENGTH 32
65 * Function return codes
67 #define SQL_INVALID_HANDLE (-2)
68 #define SQL_ERROR (-1)
70 #define SQL_SUCCESS_WITH_INFO 1
71 #define SQL_NO_DATA_FOUND 100
74 * Standard SQL datatypes, using ANSI type numbering
80 #define SQL_SMALLINT 5
84 #define SQL_VARCHAR 12
86 #define SQL_TYPE_MIN SQL_CHAR
87 #define SQL_TYPE_NULL 0
88 #define SQL_TYPE_MAX SQL_VARCHAR
91 * C datatype to SQL datatype mapping
93 #define SQL_C_CHAR SQL_CHAR
94 #define SQL_C_LONG SQL_INTEGER
95 #define SQL_C_SHORT SQL_SMALLINT
96 #define SQL_C_FLOAT SQL_REAL
97 #define SQL_C_DOUBLE SQL_DOUBLE
98 #define SQL_C_DEFAULT 99
101 * NULL status constants.
103 #define SQL_NO_NULLS 0
104 #define SQL_NULLABLE 1
105 #define SQL_NULLABLE_UNKNOWN 2
108 * Special length values
110 #define SQL_NULL_DATA (-1)
111 #define SQL_DATA_AT_EXEC (-2)
120 #define SQL_RESET_PARAMS 3
126 #define SQL_ROLLBACK 1
131 #define SQL_COLUMN_COUNT 0
132 #define SQL_COLUMN_NAME 1
133 #define SQL_COLUMN_TYPE 2
134 #define SQL_COLUMN_LENGTH 3
135 #define SQL_COLUMN_PRECISION 4
136 #define SQL_COLUMN_SCALE 5
137 #define SQL_COLUMN_DISPLAY_SIZE 6
138 #define SQL_COLUMN_NULLABLE 7
139 #define SQL_COLUMN_UNSIGNED 8
140 #define SQL_COLUMN_MONEY 9
141 #define SQL_COLUMN_UPDATABLE 10
142 #define SQL_COLUMN_AUTO_INCREMENT 11
143 #define SQL_COLUMN_CASE_SENSITIVE 12
144 #define SQL_COLUMN_SEARCHABLE 13
145 #define SQL_COLUMN_TYPE_NAME 14
146 #define SQL_COLUMN_TABLE_NAME 15
147 #define SQL_COLUMN_OWNER_NAME 16
148 #define SQL_COLUMN_QUALIFIER_NAME 17
149 #define SQL_COLUMN_LABEL 18
151 #define SQL_COLATT_OPT_MAX SQL_COLUMN_LABEL
152 #define SQL_COLATT_OPT_MIN SQL_COLUMN_COUNT
153 #define SQL_COLUMN_DRIVER_START 1000
156 * SQLColAttributes : SQL_COLUMN_UPDATABLE
158 #define SQL_ATTR_READONLY 0
159 #define SQL_ATTR_WRITE 1
160 #define SQL_ATTR_READWRITE_UNKNOWN 2
163 * SQLColAttributes : SQL_COLUMN_SEARCHABLE
165 #define SQL_UNSEARCHABLE 0
166 #define SQL_LIKE_ONLY 1
167 #define SQL_ALL_EXCEPT_LIKE 2
168 #define SQL_SEARCHABLE 3
173 #define SQL_NULL_HENV 0
174 #define SQL_NULL_HDBC 0
175 #define SQL_NULL_HSTMT 0
179 * Function Prototypes
186 RETCODE SQL_API
SQLAllocConnect (HENV henv
, HDBC FAR
* phdbc
);
187 RETCODE SQL_API
SQLAllocEnv (HENV FAR
* phenv
);
188 RETCODE SQL_API
SQLAllocStmt (HDBC hdbc
, HSTMT FAR
* phstmt
);
189 RETCODE SQL_API
SQLBindCol (HSTMT hstmt
, UWORD icol
, SWORD fCType
,
190 PTR rgbValue
, SDWORD cbValueMax
, SDWORD FAR
* pcbValue
);
191 RETCODE SQL_API
SQLCancel (HSTMT hstmt
);
192 RETCODE SQL_API
SQLColAttributes (HSTMT hstmt
, UWORD icol
, UWORD fDescType
,
193 PTR rgbDesc
, SWORD cbDescMax
, SWORD FAR
* pcbDesc
, SDWORD FAR
* pfDesc
);
194 RETCODE SQL_API
SQLConnect (HDBC hdbc
, UCHAR FAR
* szDSN
, SWORD cbDSN
,
195 UCHAR FAR
* szUID
, SWORD cbUID
, UCHAR FAR
* szAuthStr
, SWORD cbAuthStr
);
196 RETCODE SQL_API
SQLDescribeCol (HSTMT hstmt
, UWORD icol
,
197 UCHAR FAR
* szColName
, SWORD cbColNameMax
, SWORD FAR
* pcbColName
,
198 SWORD FAR
* pfSqlType
, UDWORD FAR
* pcbColDef
, SWORD FAR
* pibScale
,
199 SWORD FAR
* pfNullable
);
200 RETCODE SQL_API
SQLDisconnect (HDBC hdbc
);
201 RETCODE SQL_API
SQLError (HENV henv
, HDBC hdbc
, HSTMT hstmt
,
202 UCHAR FAR
* szSqlState
, SDWORD FAR
* pfNativeError
, UCHAR FAR
* szErrorMsg
,
203 SWORD cbErrorMsgMax
, SWORD FAR
* pcbErrorMsg
);
204 RETCODE SQL_API
SQLExecDirect (HSTMT hstmt
, UCHAR FAR
* szSqlStr
,
206 RETCODE SQL_API
SQLExecute (HSTMT hstmt
);
207 RETCODE SQL_API
SQLFetch (HSTMT hstmt
);
208 RETCODE SQL_API
SQLFreeConnect (HDBC hdbc
);
209 RETCODE SQL_API
SQLFreeEnv (HENV henv
);
210 RETCODE SQL_API
SQLFreeStmt (HSTMT hstmt
, UWORD fOption
);
211 RETCODE SQL_API
SQLGetCursorName (HSTMT hstmt
, UCHAR FAR
* szCursor
,
212 SWORD cbCursorMax
, SWORD FAR
* pcbCursor
);
213 RETCODE SQL_API
SQLNumResultCols (HSTMT hstmt
, SWORD FAR
* pccol
);
214 RETCODE SQL_API
SQLPrepare (HSTMT hstmt
, UCHAR FAR
* szSqlStr
,
216 RETCODE SQL_API
SQLRowCount (HSTMT hstmt
, SDWORD FAR
* pcrow
);
217 RETCODE SQL_API
SQLSetCursorName (HSTMT hstmt
, UCHAR FAR
* szCursor
,
219 RETCODE SQL_API
SQLTransact (HENV henv
, HDBC hdbc
, UWORD fType
);
222 * Depreciated ODBC 1.0 function - Use SQLBindParameter
224 RETCODE SQL_API
SQLSetParam (HSTMT hstmt
, UWORD ipar
, SWORD fCType
,
225 SWORD fSqlType
, UDWORD cbColDef
, SWORD ibScale
, PTR rgbValue
,
226 SDWORD FAR
* pcbValue
);