| /* | |
| * ODBC definitions | |
| * | |
| * 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 | |
| * Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA | |
| */ | |
| #ifndef __SQL_H | |
| #define __SQL_H | |
| #ifndef ODBCVER | |
| #define ODBCVER 0x0351 | |
| #endif | |
| #include <sqltypes.h> | |
| #ifdef __cplusplus | |
| extern "C" { | |
| #endif | |
| #define SQL_NULL_DATA (-1) | |
| #define SQL_DATA_AT_EXEC (-2) | |
| #define SQL_SUCCESS 0 | |
| #define SQL_SUCCESS_WITH_INFO 1 | |
| #if (ODBCVER >= 0x0300) | |
| #define SQL_NO_DATA 100 | |
| #endif | |
| #define SQL_ERROR (-1) | |
| #define SQL_INVALID_HANDLE (-2) | |
| #define SQL_STILL_EXECUTING 2 | |
| #define SQL_NEED_DATA 99 | |
| #define SQL_SUCCEEDED(rc) (((rc)&(~1))==0) | |
| #define SQL_NTS (-3) | |
| #define SQL_NTSL (-3L) | |
| #define SQL_MAX_MESSAGE_LENGTH 512 | |
| #if (ODBCVER >= 0x0300) | |
| #define SQL_DATE_LEN 10 | |
| #define SQL_TIME_LEN 8 | |
| #define SQL_TIMESTAMP_LEN 19 | |
| #endif | |
| #if (ODBCVER >= 0x0300) | |
| #define SQL_HANDLE_ENV 1 | |
| #define SQL_HANDLE_DBC 2 | |
| #define SQL_HANDLE_STMT 3 | |
| #define SQL_HANDLE_DESC 4 | |
| #endif | |
| #if (ODBCVER >= 0x0300) | |
| #define SQL_ATTR_OUTPUT_NTS 10001 | |
| #endif | |
| #if (ODBCVER >= 0x0300) | |
| #define SQL_ATTR_AUTO_IPD 10001 | |
| #define SQL_ATTR_METADATA_ID 10014 | |
| #endif | |
| #if (ODBCVER >= 0x0300) | |
| #define SQL_ATTR_APP_ROW_DESC 10010 | |
| #define SQL_ATTR_APP_PARAM_DESC 10011 | |
| #define SQL_ATTR_IMP_ROW_DESC 10012 | |
| #define SQL_ATTR_IMP_PARAM_DESC 10013 | |
| #define SQL_ATTR_CURSOR_SCROLLABLE (-1) | |
| #define SQL_ATTR_CURSOR_SENSITIVITY (-2) | |
| #endif | |
| #if (ODBCVER >= 0x0300) | |
| #define SQL_NONSCROLLABLE 0 | |
| #define SQL_SCROLLABLE 1 | |
| #endif | |
| #if (ODBCVER >= 0x0300) | |
| #define SQL_DESC_COUNT 1001 | |
| #define SQL_DESC_TYPE 1002 | |
| #define SQL_DESC_LENGTH 1003 | |
| #define SQL_DESC_OCTET_LENGTH_PTR 1004 | |
| #define SQL_DESC_PRECISION 1005 | |
| #define SQL_DESC_SCALE 1006 | |
| #define SQL_DESC_DATETIME_INTERVAL_CODE 1007 | |
| #define SQL_DESC_NULLABLE 1008 | |
| #define SQL_DESC_INDICATOR_PTR 1009 | |
| #define SQL_DESC_DATA_PTR 1010 | |
| #define SQL_DESC_NAME 1011 | |
| #define SQL_DESC_UNNAMED 1012 | |
| #define SQL_DESC_OCTET_LENGTH 1013 | |
| #define SQL_DESC_ALLOC_TYPE 1099 | |
| #endif | |
| #if (ODBCVER >= 0x0300) | |
| #define SQL_DIAG_RETURNCODE 1 | |
| #define SQL_DIAG_NUMBER 2 | |
| #define SQL_DIAG_ROW_COUNT 3 | |
| #define SQL_DIAG_SQLSTATE 4 | |
| #define SQL_DIAG_NATIVE 5 | |
| #define SQL_DIAG_MESSAGE_TEXT 6 | |
| #define SQL_DIAG_DYNAMIC_FUNCTION 7 | |
| #define SQL_DIAG_CLASS_ORIGIN 8 | |
| #define SQL_DIAG_SUBCLASS_ORIGIN 9 | |
| #define SQL_DIAG_CONNECTION_NAME 10 | |
| #define SQL_DIAG_SERVER_NAME 11 | |
| #define SQL_DIAG_DYNAMIC_FUNCTION_CODE 12 | |
| #endif | |
| #if (ODBCVER >= 0x0300) | |
| #define SQL_DIAG_ALTER_DOMAIN 3 | |
| #define SQL_DIAG_ALTER_TABLE 4 | |
| #define SQL_DIAG_CALL 7 | |
| #define SQL_DIAG_CREATE_ASSERTION 6 | |
| #define SQL_DIAG_CREATE_CHARACTER_SET 8 | |
| #define SQL_DIAG_CREATE_COLLATION 10 | |
| #define SQL_DIAG_CREATE_DOMAIN 23 | |
| #define SQL_DIAG_CREATE_INDEX (-1) | |
| #define SQL_DIAG_CREATE_SCHEMA 64 | |
| #define SQL_DIAG_CREATE_TABLE 77 | |
| #define SQL_DIAG_CREATE_TRANSLATION 79 | |
| #define SQL_DIAG_CREATE_VIEW 84 | |
| #define SQL_DIAG_DELETE_WHERE 19 | |
| #define SQL_DIAG_DROP_ASSERTION 24 | |
| #define SQL_DIAG_DROP_CHARACTER_SET 25 | |
| #define SQL_DIAG_DROP_COLLATION 26 | |
| #define SQL_DIAG_DROP_DOMAIN 27 | |
| #define SQL_DIAG_DROP_INDEX (-2) | |
| #define SQL_DIAG_DROP_SCHEMA 31 | |
| #define SQL_DIAG_DROP_TABLE 32 | |
| #define SQL_DIAG_DROP_TRANSLATION 33 | |
| #define SQL_DIAG_DROP_VIEW 36 | |
| #define SQL_DIAG_DYNAMIC_DELETE_CURSOR 38 | |
| #define SQL_DIAG_DYNAMIC_UPDATE_CURSOR 81 | |
| #define SQL_DIAG_GRANT 48 | |
| #define SQL_DIAG_INSERT 50 | |
| #define SQL_DIAG_REVOKE 59 | |
| #define SQL_DIAG_SELECT_CURSOR 85 | |
| #define SQL_DIAG_UNKNOWN_STATEMENT 0 | |
| #define SQL_DIAG_UPDATE_WHERE 82 | |
| #endif | |
| #define SQL_UNKNOWN_TYPE 0 | |
| #define SQL_CHAR 1 | |
| #define SQL_NUMERIC 2 | |
| #define SQL_DECIMAL 3 | |
| #define SQL_INTEGER 4 | |
| #define SQL_SMALLINT 5 | |
| #define SQL_FLOAT 6 | |
| #define SQL_REAL 7 | |
| #define SQL_DOUBLE 8 | |
| #if (ODBCVER >= 0x0300) | |
| #define SQL_DATETIME 9 | |
| #endif | |
| #define SQL_VARCHAR 12 | |
| #if (ODBCVER >= 0x0300) | |
| #define SQL_TYPE_DATE 91 | |
| #define SQL_TYPE_TIME 92 | |
| #define SQL_TYPE_TIMESTAMP 93 | |
| #endif | |
| #if (ODBCVER >= 0x0300) | |
| #define SQL_UNSPECIFIED 0 | |
| #define SQL_INSENSITIVE 1 | |
| #define SQL_SENSITIVE 2 | |
| #endif | |
| #define SQL_ALL_TYPES 0 | |
| #if (ODBCVER >= 0x0300) | |
| #define SQL_DEFAULT 99 | |
| #endif | |
| #if (ODBCVER >= 0x0300) | |
| #define SQL_ARD_TYPE (-99) | |
| #endif | |
| #if (ODBCVER >= 0x0300) | |
| #define SQL_CODE_DATE 1 | |
| #define SQL_CODE_TIME 2 | |
| #define SQL_CODE_TIMESTAMP 3 | |
| #endif | |
| #if (ODBCVER >= 0x0300) | |
| #define SQL_FALSE 0 | |
| #define SQL_TRUE 1 | |
| #endif | |
| #define SQL_NO_NULLS 0 | |
| #define SQL_NULLABLE 1 | |
| #define SQL_NULLABLE_UNKNOWN 2 | |
| #if (ODBCVER >= 0x0300) | |
| #define SQL_PRED_NONE 0 | |
| #define SQL_PRED_CHAR 1 | |
| #define SQL_PRED_BASIC 2 | |
| #endif | |
| #if (ODBCVER >= 0x0300) | |
| #define SQL_NAMED 0 | |
| #define SQL_UNNAMED 1 | |
| #endif | |
| #if (ODBCVER >= 0x0300) | |
| #define SQL_DESC_ALLOC_AUTO 1 | |
| #define SQL_DESC_ALLOC_USER 2 | |
| #endif | |
| #define SQL_CLOSE 0 | |
| #define SQL_DROP 1 | |
| #define SQL_UNBIND 2 | |
| #define SQL_RESET_PARAMS 3 | |
| #define SQL_FETCH_NEXT 1 | |
| #define SQL_FETCH_FIRST 2 | |
| #define SQL_FETCH_LAST 3 | |
| #define SQL_FETCH_PRIOR 4 | |
| #define SQL_FETCH_ABSOLUTE 5 | |
| #define SQL_FETCH_RELATIVE 6 | |
| #define SQL_COMMIT 0 | |
| #define SQL_ROLLBACK 1 | |
| #define SQL_NULL_HENV 0 | |
| #define SQL_NULL_HDBC 0 | |
| #define SQL_NULL_HSTMT 0 | |
| #if (ODBCVER >= 0x0300) | |
| #define SQL_NULL_HDESC 0 | |
| #endif | |
| #if (ODBCVER >= 0x0300) | |
| #define SQL_NULL_HANDLE 0L | |
| #endif | |
| #define SQL_SCOPE_CURROW 0 | |
| #define SQL_SCOPE_TRANSACTION 1 | |
| #define SQL_SCOPE_SESSION 2 | |
| #define SQL_PC_UNKNOWN 0 | |
| #if (ODBCVER >= 0x0300) | |
| #define SQL_PC_NON_PSEUDO 1 | |
| #endif | |
| #define SQL_PC_PSEUDO 2 | |
| #if (ODBCVER >= 0x0300) | |
| #define SQL_ROW_IDENTIFIER 1 | |
| #endif | |
| #define SQL_INDEX_UNIQUE 0 | |
| #define SQL_INDEX_ALL 1 | |
| #define SQL_INDEX_CLUSTERED 1 | |
| #define SQL_INDEX_HASHED 2 | |
| #define SQL_INDEX_OTHER 3 | |
| #define SQL_API_SQLALLOCCONNECT 1 | |
| #define SQL_API_SQLALLOCENV 2 | |
| #if (ODBCVER >= 0x0300) | |
| #define SQL_API_SQLALLOCHANDLE 1001 | |
| #endif | |
| #define SQL_API_SQLALLOCSTMT 3 | |
| #define SQL_API_SQLBINDCOL 4 | |
| #if (ODBCVER >= 0x0300) | |
| #define SQL_API_SQLBINDPARAM 1002 | |
| #endif | |
| #define SQL_API_SQLCANCEL 5 | |
| #if (ODBCVER >= 0x0300) | |
| #define SQL_API_SQLCLOSECURSOR 1003 | |
| #define SQL_API_SQLCOLATTRIBUTE 6 | |
| #endif | |
| #define SQL_API_SQLCOLUMNS 40 | |
| #define SQL_API_SQLCONNECT 7 | |
| #if (ODBCVER >= 0x0300) | |
| #define SQL_API_SQLCOPYDESC 1004 | |
| #endif | |
| #define SQL_API_SQLDATASOURCES 57 | |
| #define SQL_API_SQLDESCRIBECOL 8 | |
| #define SQL_API_SQLDISCONNECT 9 | |
| #if (ODBCVER >= 0x0300) | |
| #define SQL_API_SQLENDTRAN 1005 | |
| #endif | |
| #define SQL_API_SQLERROR 10 | |
| #define SQL_API_SQLEXECDIRECT 11 | |
| #define SQL_API_SQLEXECUTE 12 | |
| #define SQL_API_SQLFETCH 13 | |
| #if (ODBCVER >= 0x0300) | |
| #define SQL_API_SQLFETCHSCROLL 1021 | |
| #endif | |
| #define SQL_API_SQLFREECONNECT 14 | |
| #define SQL_API_SQLFREEENV 15 | |
| #if (ODBCVER >= 0x0300) | |
| #define SQL_API_SQLFREEHANDLE 1006 | |
| #endif | |
| #define SQL_API_SQLFREESTMT 16 | |
| #if (ODBCVER >= 0x0300) | |
| #define SQL_API_SQLGETCONNECTATTR 1007 | |
| #endif | |
| #define SQL_API_SQLGETCONNECTOPTION 42 | |
| #define SQL_API_SQLGETCURSORNAME 17 | |
| #define SQL_API_SQLGETDATA 43 | |
| #if (ODBCVER >= 0x0300) | |
| #define SQL_API_SQLGETDESCFIELD 1008 | |
| #define SQL_API_SQLGETDESCREC 1009 | |
| #define SQL_API_SQLGETDIAGFIELD 1010 | |
| #define SQL_API_SQLGETDIAGREC 1011 | |
| #define SQL_API_SQLGETENVATTR 1012 | |
| #endif | |
| #define SQL_API_SQLGETFUNCTIONS 44 | |
| #define SQL_API_SQLGETINFO 45 | |
| #if (ODBCVER >= 0x0300) | |
| #define SQL_API_SQLGETSTMTATTR 1014 | |
| #endif | |
| #define SQL_API_SQLGETSTMTOPTION 46 | |
| #define SQL_API_SQLGETTYPEINFO 47 | |
| #define SQL_API_SQLNUMRESULTCOLS 18 | |
| #define SQL_API_SQLPARAMDATA 48 | |
| #define SQL_API_SQLPREPARE 19 | |
| #define SQL_API_SQLPUTDATA 49 | |
| #define SQL_API_SQLROWCOUNT 20 | |
| #if (ODBCVER >= 0x0300) | |
| #define SQL_API_SQLSETCONNECTATTR 1016 | |
| #endif | |
| #define SQL_API_SQLSETCONNECTOPTION 50 | |
| #define SQL_API_SQLSETCURSORNAME 21 | |
| #if (ODBCVER >= 0x0300) | |
| #define SQL_API_SQLSETDESCFIELD 1017 | |
| #define SQL_API_SQLSETDESCREC 1018 | |
| #define SQL_API_SQLSETENVATTR 1019 | |
| #endif | |
| #define SQL_API_SQLSETPARAM 22 | |
| #if (ODBCVER >= 0x0300) | |
| #define SQL_API_SQLSETSTMTATTR 1020 | |
| #endif | |
| #define SQL_API_SQLSETSTMTOPTION 51 | |
| #define SQL_API_SQLSPECIALCOLUMNS 52 | |
| #define SQL_API_SQLSTATISTICS 53 | |
| #define SQL_API_SQLTABLES 54 | |
| #define SQL_API_SQLTRANSACT 23 | |
| #if (ODBCVER >= 0x0300) | |
| #define SQL_MAX_DRIVER_CONNECTIONS 0 | |
| #define SQL_MAXIMUM_DRIVER_CONNECTIONS SQL_MAX_DRIVER_CONNECTIONS | |
| #define SQL_MAX_CONCURRENT_ACTIVITIES 1 | |
| #define SQL_MAXIMUM_CONCURRENT_ACTIVITIES SQL_MAX_CONCURRENT_ACTIVITIES | |
| #endif | |
| #define SQL_DATA_SOURCE_NAME 2 | |
| #define SQL_FETCH_DIRECTION 8 | |
| #define SQL_SERVER_NAME 13 | |
| #define SQL_SEARCH_PATTERN_ESCAPE 14 | |
| #define SQL_DBMS_NAME 17 | |
| #define SQL_DBMS_VER 18 | |
| #define SQL_ACCESSIBLE_TABLES 19 | |
| #define SQL_ACCESSIBLE_PROCEDURES 20 | |
| #define SQL_CURSOR_COMMIT_BEHAVIOR 23 | |
| #define SQL_DATA_SOURCE_READ_ONLY 25 | |
| #define SQL_DEFAULT_TXN_ISOLATION 26 | |
| #define SQL_IDENTIFIER_CASE 28 | |
| #define SQL_IDENTIFIER_QUOTE_CHAR 29 | |
| #define SQL_MAX_COLUMN_NAME_LEN 30 | |
| #define SQL_MAXIMUM_COLUMN_NAME_LENGTH SQL_MAX_COLUMN_NAME_LEN | |
| #define SQL_MAX_CURSOR_NAME_LEN 31 | |
| #define SQL_MAXIMUM_CURSOR_NAME_LENGTH SQL_MAX_CURSOR_NAME_LEN | |
| #define SQL_MAX_SCHEMA_NAME_LEN 32 | |
| #define SQL_MAXIMUM_SCHEMA_NAME_LENGTH SQL_MAX_SCHEMA_NAME_LEN | |
| #define SQL_MAX_CATALOG_NAME_LEN 34 | |
| #define SQL_MAXIMUM_CATALOG_NAME_LENGTH SQL_MAX_CATALOG_NAME_LEN | |
| #define SQL_MAX_TABLE_NAME_LEN 35 | |
| #define SQL_SCROLL_CONCURRENCY 43 | |
| #define SQL_TXN_CAPABLE 46 | |
| #define SQL_TRANSACTION_CAPABLE SQL_TXN_CAPABLE | |
| #define SQL_USER_NAME 47 | |
| #define SQL_TXN_ISOLATION_OPTION 72 | |
| #define SQL_TRANSACTION_ISOLATION_OPTION SQL_TXN_ISOLATION_OPTION | |
| #define SQL_INTEGRITY 73 | |
| #define SQL_GETDATA_EXTENSIONS 81 | |
| #define SQL_NULL_COLLATION 85 | |
| #define SQL_ALTER_TABLE 86 | |
| #define SQL_ORDER_BY_COLUMNS_IN_SELECT 90 | |
| #define SQL_SPECIAL_CHARACTERS 94 | |
| #define SQL_MAX_COLUMNS_IN_GROUP_BY 97 | |
| #define SQL_MAXIMUM_COLUMNS_IN_GROUP_BY SQL_MAX_COLUMNS_IN_GROUP_BY | |
| #define SQL_MAX_COLUMNS_IN_INDEX 98 | |
| #define SQL_MAXIMUM_COLUMNS_IN_INDEX SQL_MAX_COLUMNS_IN_INDEX | |
| #define SQL_MAX_COLUMNS_IN_ORDER_BY 99 | |
| #define SQL_MAXIMUM_COLUMNS_IN_ORDER_BY SQL_MAX_COLUMNS_IN_ORDER_BY | |
| #define SQL_MAX_COLUMNS_IN_SELECT 100 | |
| #define SQL_MAXIMUM_COLUMNS_IN_SELECT SQL_MAX_COLUMNS_IN_SELECT | |
| #define SQL_MAX_COLUMNS_IN_TABLE 101 | |
| #define SQL_MAX_INDEX_SIZE 102 | |
| #define SQL_MAXIMUM_INDEX_SIZE SQL_MAX_INDEX_SIZE | |
| #define SQL_MAX_ROW_SIZE 104 | |
| #define SQL_MAXIMUM_ROW_SIZE SQL_MAX_ROW_SIZE | |
| #define SQL_MAX_STATEMENT_LEN 105 | |
| #define SQL_MAXIMUM_STATEMENT_LENGTH SQL_MAX_STATEMENT_LEN | |
| #define SQL_MAX_TABLES_IN_SELECT 106 | |
| #define SQL_MAXIMUM_TABLES_IN_SELECT SQL_MAX_TABLES_IN_SELECT | |
| #define SQL_MAX_USER_NAME_LEN 107 | |
| #define SQL_MAXIMUM_USER_NAME_LENGTH SQL_MAX_USER_NAME_LEN | |
| #if (ODBCVER >= 0x0300) | |
| #define SQL_OJ_CAPABILITIES 115 | |
| #define SQL_OUTER_JOIN_CAPABILITIES SQL_OJ_CAPABILITIES | |
| #endif | |
| #if (ODBCVER >= 0x0300) | |
| #define SQL_XOPEN_CLI_YEAR 10000 | |
| #define SQL_CURSOR_SENSITIVITY 10001 | |
| #define SQL_DESCRIBE_PARAMETER 10002 | |
| #define SQL_CATALOG_NAME 10003 | |
| #define SQL_COLLATION_SEQ 10004 | |
| #define SQL_MAX_IDENTIFIER_LEN 10005 | |
| #define SQL_MAXIMUM_IDENTIFIER_LENGTH SQL_MAX_IDENTIFIER_LEN | |
| #endif | |
| #if (ODBCVER >= 0x0200) | |
| #define SQL_AT_ADD_COLUMN 0x00000001L | |
| #define SQL_AT_DROP_COLUMN 0x00000002L | |
| #endif | |
| #if (ODBCVER >= 0x0300) | |
| #define SQL_AT_ADD_CONSTRAINT 0x00000008L | |
| #endif /* ODBCVER >= 0x0300 */ | |
| #if (ODBCVER >= 0x0300) | |
| #define SQL_AM_NONE 0 | |
| #define SQL_AM_CONNECTION 1 | |
| #define SQL_AM_STATEMENT 2 | |
| #endif | |
| #define SQL_CB_DELETE 0 | |
| #define SQL_CB_CLOSE 1 | |
| #define SQL_CB_PRESERVE 2 | |
| #define SQL_FD_FETCH_NEXT 0x00000001L | |
| #define SQL_FD_FETCH_FIRST 0x00000002L | |
| #define SQL_FD_FETCH_LAST 0x00000004L | |
| #define SQL_FD_FETCH_PRIOR 0x00000008L | |
| #define SQL_FD_FETCH_ABSOLUTE 0x00000010L | |
| #define SQL_FD_FETCH_RELATIVE 0x00000020L | |
| #define SQL_GD_ANY_COLUMN 0x00000001L | |
| #define SQL_GD_ANY_ORDER 0x00000002L | |
| #define SQL_IC_UPPER 1 | |
| #define SQL_IC_LOWER 2 | |
| #define SQL_IC_SENSITIVE 3 | |
| #define SQL_IC_MIXED 4 | |
| #if (ODBCVER >= 0x0201) | |
| #define SQL_OJ_LEFT 0x00000001L | |
| #define SQL_OJ_RIGHT 0x00000002L | |
| #define SQL_OJ_FULL 0x00000004L | |
| #define SQL_OJ_NESTED 0x00000008L | |
| #define SQL_OJ_NOT_ORDERED 0x00000010L | |
| #define SQL_OJ_INNER 0x00000020L | |
| #define SQL_OJ_ALL_COMPARISON_OPS 0x00000040L | |
| #endif | |
| #define SQL_SCCO_READ_ONLY 0x00000001L | |
| #define SQL_SCCO_LOCK 0x00000002L | |
| #define SQL_SCCO_OPT_ROWVER 0x00000004L | |
| #define SQL_SCCO_OPT_VALUES 0x00000008L | |
| #define SQL_TC_NONE 0 | |
| #define SQL_TC_DML 1 | |
| #define SQL_TC_ALL 2 | |
| #define SQL_TC_DDL_COMMIT 3 | |
| #define SQL_TC_DDL_IGNORE 4 | |
| #define SQL_TXN_READ_UNCOMMITTED 0x00000001L | |
| #define SQL_TRANSACTION_READ_UNCOMMITTED SQL_TXN_READ_UNCOMMITTED | |
| #define SQL_TXN_READ_COMMITTED 0x00000002L | |
| #define SQL_TRANSACTION_READ_COMMITTED SQL_TXN_READ_COMMITTED | |
| #define SQL_TXN_REPEATABLE_READ 0x00000004L | |
| #define SQL_TRANSACTION_REPEATABLE_READ SQL_TXN_REPEATABLE_READ | |
| #define SQL_TXN_SERIALIZABLE 0x00000008L | |
| #define SQL_TRANSACTION_SERIALIZABLE SQL_TXN_SERIALIZABLE | |
| #define SQL_NC_HIGH 0 | |
| #define SQL_NC_LOW 1 | |
| SQLRETURN WINAPI SQLAllocConnect(SQLHENV EnvironmentHandle, | |
| SQLHDBC *ConnectionHandle); | |
| SQLRETURN WINAPI SQLAllocEnv(SQLHENV *EnvironmentHandle); | |
| #if (ODBCVER >= 0x0300) | |
| SQLRETURN WINAPI SQLAllocHandle(SQLSMALLINT HandleType, | |
| SQLHANDLE InputHandle, SQLHANDLE *OutputHandle); | |
| #endif | |
| SQLRETURN WINAPI SQLAllocStmt(SQLHDBC ConnectionHandle, | |
| SQLHSTMT *StatementHandle); | |
| SQLRETURN WINAPI SQLBindCol(SQLHSTMT StatementHandle, | |
| SQLUSMALLINT ColumnNumber, SQLSMALLINT TargetType, | |
| SQLPOINTER TargetValue, SQLINTEGER BufferLength, | |
| SQLINTEGER *StrLen_or_Ind); | |
| #if (ODBCVER >= 0x0300) | |
| SQLRETURN WINAPI SQLBindParam(SQLHSTMT StatementHandle, | |
| SQLUSMALLINT ParameterNumber, SQLSMALLINT ValueType, | |
| SQLSMALLINT ParameterType, SQLUINTEGER LengthPrecision, | |
| SQLSMALLINT ParameterScale, SQLPOINTER ParameterValue, | |
| SQLINTEGER *StrLen_or_Ind); | |
| #endif | |
| SQLRETURN WINAPI SQLCancel(SQLHSTMT StatementHandle); | |
| #if (ODBCVER >= 0x0300) | |
| SQLRETURN WINAPI SQLCloseCursor(SQLHSTMT StatementHandle); | |
| SQLRETURN WINAPI SQLColAttribute (SQLHSTMT StatementHandle, | |
| SQLUSMALLINT ColumnNumber, SQLUSMALLINT FieldIdentifier, | |
| SQLPOINTER CharacterAttribute, SQLSMALLINT BufferLength, | |
| SQLSMALLINT *StringLength, SQLPOINTER NumericAttribute); | |
| #endif | |
| SQLRETURN WINAPI SQLColumns(SQLHSTMT StatementHandle, | |
| SQLCHAR *CatalogName, SQLSMALLINT NameLength1, | |
| SQLCHAR *SchemaName, SQLSMALLINT NameLength2, | |
| SQLCHAR *TableName, SQLSMALLINT NameLength3, | |
| SQLCHAR *ColumnName, SQLSMALLINT NameLength4); | |
| SQLRETURN WINAPI SQLConnect(SQLHDBC ConnectionHandle, | |
| SQLCHAR *ServerName, SQLSMALLINT NameLength1, | |
| SQLCHAR *UserName, SQLSMALLINT NameLength2, | |
| SQLCHAR *Authentication, SQLSMALLINT NameLength3); | |
| #if (ODBCVER >= 0x0300) | |
| SQLRETURN WINAPI SQLCopyDesc(SQLHDESC SourceDescHandle, | |
| SQLHDESC TargetDescHandle); | |
| #endif | |
| SQLRETURN WINAPI SQLDataSources(SQLHENV EnvironmentHandle, | |
| SQLUSMALLINT Direction, SQLCHAR *ServerName, | |
| SQLSMALLINT BufferLength1, SQLSMALLINT *NameLength1, | |
| SQLCHAR *Description, SQLSMALLINT BufferLength2, | |
| SQLSMALLINT *NameLength2); | |
| SQLRETURN WINAPI SQLDescribeCol(SQLHSTMT StatementHandle, | |
| SQLUSMALLINT ColumnNumber, SQLCHAR *ColumnName, | |
| SQLSMALLINT BufferLength, SQLSMALLINT *NameLength, | |
| SQLSMALLINT *DataType, SQLUINTEGER *ColumnSize, | |
| SQLSMALLINT *DecimalDigits, SQLSMALLINT *Nullable); | |
| SQLRETURN WINAPI SQLDisconnect(SQLHDBC ConnectionHandle); | |
| #if (ODBCVER >= 0x0300) | |
| SQLRETURN WINAPI SQLEndTran(SQLSMALLINT HandleType, SQLHANDLE Handle, | |
| SQLSMALLINT CompletionType); | |
| #endif | |
| SQLRETURN WINAPI SQLError(SQLHENV EnvironmentHandle, | |
| SQLHDBC ConnectionHandle, SQLHSTMT StatementHandle, | |
| SQLCHAR *Sqlstate, SQLINTEGER *NativeError, | |
| SQLCHAR *MessageText, SQLSMALLINT BufferLength, | |
| SQLSMALLINT *TextLength); | |
| SQLRETURN WINAPI SQLExecDirect(SQLHSTMT StatementHandle, | |
| SQLCHAR *StatementText, SQLINTEGER TextLength); | |
| SQLRETURN WINAPI SQLExecute(SQLHSTMT StatementHandle); | |
| SQLRETURN WINAPI SQLFetch(SQLHSTMT StatementHandle); | |
| #if (ODBCVER >= 0x0300) | |
| SQLRETURN WINAPI SQLFetchScroll(SQLHSTMT StatementHandle, | |
| SQLSMALLINT FetchOrientation, SQLINTEGER FetchOffset); | |
| #endif | |
| SQLRETURN WINAPI SQLFreeConnect(SQLHDBC ConnectionHandle); | |
| SQLRETURN WINAPI SQLFreeEnv(SQLHENV EnvironmentHandle); | |
| #if (ODBCVER >= 0x0300) | |
| SQLRETURN WINAPI SQLFreeHandle(SQLSMALLINT HandleType, SQLHANDLE Handle); | |
| #endif | |
| SQLRETURN WINAPI SQLFreeStmt(SQLHSTMT StatementHandle, | |
| SQLUSMALLINT Option); | |
| #if (ODBCVER >= 0x0300) | |
| SQLRETURN WINAPI SQLGetConnectAttr(SQLHDBC ConnectionHandle, | |
| SQLINTEGER Attribute, SQLPOINTER Value, | |
| SQLINTEGER BufferLength, SQLINTEGER *StringLength); | |
| #endif | |
| SQLRETURN WINAPI SQLGetConnectOption(SQLHDBC ConnectionHandle, | |
| SQLUSMALLINT Option, SQLPOINTER Value); | |
| SQLRETURN WINAPI SQLGetCursorName(SQLHSTMT StatementHandle, | |
| SQLCHAR *CursorName, SQLSMALLINT BufferLength, | |
| SQLSMALLINT *NameLength); | |
| SQLRETURN WINAPI SQLGetData(SQLHSTMT StatementHandle, | |
| SQLUSMALLINT ColumnNumber, SQLSMALLINT TargetType, | |
| SQLPOINTER TargetValue, SQLINTEGER BufferLength, | |
| SQLINTEGER *StrLen_or_Ind); | |
| #if (ODBCVER >= 0x0300) | |
| SQLRETURN WINAPI SQLGetDescField(SQLHDESC DescriptorHandle, | |
| SQLSMALLINT RecNumber, SQLSMALLINT FieldIdentifier, | |
| SQLPOINTER Value, SQLINTEGER BufferLength, | |
| SQLINTEGER *StringLength); | |
| SQLRETURN WINAPI SQLGetDescRec(SQLHDESC DescriptorHandle, | |
| SQLSMALLINT RecNumber, SQLCHAR *Name, | |
| SQLSMALLINT BufferLength, SQLSMALLINT *StringLength, | |
| SQLSMALLINT *Type, SQLSMALLINT *SubType, | |
| SQLINTEGER *Length, SQLSMALLINT *Precision, | |
| SQLSMALLINT *Scale, SQLSMALLINT *Nullable); | |
| SQLRETURN WINAPI SQLGetDiagField(SQLSMALLINT HandleType, SQLHANDLE Handle, | |
| SQLSMALLINT RecNumber, SQLSMALLINT DiagIdentifier, | |
| SQLPOINTER DiagInfo, SQLSMALLINT BufferLength, | |
| SQLSMALLINT *StringLength); | |
| SQLRETURN WINAPI SQLGetDiagRec(SQLSMALLINT HandleType, SQLHANDLE Handle, | |
| SQLSMALLINT RecNumber, SQLCHAR *Sqlstate, | |
| SQLINTEGER *NativeError, SQLCHAR *MessageText, | |
| SQLSMALLINT BufferLength, SQLSMALLINT *TextLength); | |
| SQLRETURN WINAPI SQLGetEnvAttr(SQLHENV EnvironmentHandle, | |
| SQLINTEGER Attribute, SQLPOINTER Value, | |
| SQLINTEGER BufferLength, SQLINTEGER *StringLength); | |
| #endif | |
| SQLRETURN WINAPI SQLGetFunctions(SQLHDBC ConnectionHandle, | |
| SQLUSMALLINT FunctionId, SQLUSMALLINT *Supported); | |
| SQLRETURN WINAPI SQLGetInfo(SQLHDBC ConnectionHandle, | |
| SQLUSMALLINT InfoType, SQLPOINTER InfoValue, | |
| SQLSMALLINT BufferLength, SQLSMALLINT *StringLength); | |
| #if (ODBCVER >= 0x0300) | |
| SQLRETURN WINAPI SQLGetStmtAttr(SQLHSTMT StatementHandle, | |
| SQLINTEGER Attribute, SQLPOINTER Value, | |
| SQLINTEGER BufferLength, SQLINTEGER *StringLength); | |
| #endif | |
| SQLRETURN WINAPI SQLGetStmtOption(SQLHSTMT StatementHandle, | |
| SQLUSMALLINT Option, SQLPOINTER Value); | |
| SQLRETURN WINAPI SQLGetTypeInfo(SQLHSTMT StatementHandle, | |
| SQLSMALLINT DataType); | |
| SQLRETURN WINAPI SQLNumResultCols(SQLHSTMT StatementHandle, | |
| SQLSMALLINT *ColumnCount); | |
| SQLRETURN WINAPI SQLParamData(SQLHSTMT StatementHandle, | |
| SQLPOINTER *Value); | |
| SQLRETURN WINAPI SQLPrepare(SQLHSTMT StatementHandle, | |
| SQLCHAR *StatementText, SQLINTEGER TextLength); | |
| SQLRETURN WINAPI SQLPutData(SQLHSTMT StatementHandle, | |
| SQLPOINTER Data, SQLINTEGER StrLen_or_Ind); | |
| SQLRETURN WINAPI SQLRowCount(SQLHSTMT StatementHandle, | |
| SQLINTEGER *RowCount); | |
| #if (ODBCVER >= 0x0300) | |
| SQLRETURN WINAPI SQLSetConnectAttr(SQLHDBC ConnectionHandle, | |
| SQLINTEGER Attribute, SQLPOINTER Value, | |
| SQLINTEGER StringLength); | |
| #endif | |
| SQLRETURN WINAPI SQLSetConnectOption(SQLHDBC ConnectionHandle, | |
| SQLUSMALLINT Option, SQLUINTEGER Value); | |
| SQLRETURN WINAPI SQLSetCursorName(SQLHSTMT StatementHandle, | |
| SQLCHAR *CursorName, SQLSMALLINT NameLength); | |
| #if (ODBCVER >= 0x0300) | |
| SQLRETURN WINAPI SQLSetDescField(SQLHDESC DescriptorHandle, | |
| SQLSMALLINT RecNumber, SQLSMALLINT FieldIdentifier, | |
| SQLPOINTER Value, SQLINTEGER BufferLength); | |
| SQLRETURN WINAPI SQLSetDescRec(SQLHDESC DescriptorHandle, | |
| SQLSMALLINT RecNumber, SQLSMALLINT Type, | |
| SQLSMALLINT SubType, SQLINTEGER Length, | |
| SQLSMALLINT Precision, SQLSMALLINT Scale, | |
| SQLPOINTER Data, SQLINTEGER *StringLength, | |
| SQLINTEGER *Indicator); | |
| SQLRETURN WINAPI SQLSetEnvAttr(SQLHENV EnvironmentHandle, | |
| SQLINTEGER Attribute, SQLPOINTER Value, | |
| SQLINTEGER StringLength); | |
| #endif | |
| SQLRETURN WINAPI SQLSetParam(SQLHSTMT StatementHandle, | |
| SQLUSMALLINT ParameterNumber, SQLSMALLINT ValueType, | |
| SQLSMALLINT ParameterType, SQLUINTEGER LengthPrecision, | |
| SQLSMALLINT ParameterScale, SQLPOINTER ParameterValue, | |
| SQLINTEGER *StrLen_or_Ind); | |
| #if (ODBCVER >= 0x0300) | |
| SQLRETURN WINAPI SQLSetStmtAttr(SQLHSTMT StatementHandle, | |
| SQLINTEGER Attribute, SQLPOINTER Value, | |
| SQLINTEGER StringLength); | |
| #endif | |
| SQLRETURN WINAPI SQLSetStmtOption(SQLHSTMT StatementHandle, | |
| SQLUSMALLINT Option, SQLUINTEGER Value); | |
| SQLRETURN WINAPI SQLSpecialColumns(SQLHSTMT StatementHandle, | |
| SQLUSMALLINT IdentifierType, SQLCHAR *CatalogName, | |
| SQLSMALLINT NameLength1, SQLCHAR *SchemaName, | |
| SQLSMALLINT NameLength2, SQLCHAR *TableName, | |
| SQLSMALLINT NameLength3, SQLUSMALLINT Scope, | |
| SQLUSMALLINT Nullable); | |
| SQLRETURN WINAPI SQLStatistics(SQLHSTMT StatementHandle, | |
| SQLCHAR *CatalogName, SQLSMALLINT NameLength1, | |
| SQLCHAR *SchemaName, SQLSMALLINT NameLength2, | |
| SQLCHAR *TableName, SQLSMALLINT NameLength3, | |
| SQLUSMALLINT Unique, SQLUSMALLINT Reserved); | |
| SQLRETURN WINAPI SQLTables(SQLHSTMT StatementHandle, | |
| SQLCHAR *CatalogName, SQLSMALLINT NameLength1, | |
| SQLCHAR *SchemaName, SQLSMALLINT NameLength2, | |
| SQLCHAR *TableName, SQLSMALLINT NameLength3, | |
| SQLCHAR *TableType, SQLSMALLINT NameLength4); | |
| SQLRETURN WINAPI SQLTransact(SQLHENV EnvironmentHandle, | |
| SQLHDBC ConnectionHandle, SQLUSMALLINT CompletionType); | |
| #ifdef __cplusplus | |
| } | |
| #endif | |
| #endif |