Attachment 21028 Details for Bug 34007 – /usr/include/sql.h

/usr/include/sql.h

sql.h (text/plain), 27.76 KB, created by Andrei Ivanov on 2003-11-21 04:59:43 UTC

(hide)

Description:

Filename:

MIME Type:

Creator: Andrei Ivanov

Created: 2003-11-21 04:59:43 UTC

Size: 27.76 KB

patch

obsolete

>/**************************************************
> * sql.h
> *
> * These should be consistent with the MS version.
> *
> **************************************************/
>#ifndef __SQL_H
>#define __SQL_H
>
>/****************************
> * default to 3.51 declare something else before here and you get a whole new ball of wax
> ***************************/
>#ifndef ODBCVER
>#define ODBCVER 0x0351
>#endif
>
>#include "sqltypes.h"
>
>#ifdef __cplusplus
>extern "C" {
>#endif
>
>/****************************
> * some ret values
> ***************************/
>#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)
>
>/****************************
> * use these to indicate string termination to some function
> ***************************/
>#define SQL_NTS                   (-3)
>#define SQL_NTSL                  (-3L)
>
>/* maximum message length */
>#define SQL_MAX_MESSAGE_LENGTH   512
>
>/* date/time length constants */
>#if (ODBCVER >= 0x0300)
>#define SQL_DATE_LEN           10
>#define SQL_TIME_LEN            8  /* add P+1 if precision is nonzero */
>#define SQL_TIMESTAMP_LEN      19  /* add P+1 if precision is nonzero */
>#endif
>
>/* handle type identifiers */
>#if (ODBCVER >= 0x0300)
>#define SQL_HANDLE_ENV             1
>#define SQL_HANDLE_DBC             2
>#define SQL_HANDLE_STMT            3
>#define SQL_HANDLE_DESC            4
>#endif
>
>/* environment attribute */
>#if (ODBCVER >= 0x0300)
>#define SQL_ATTR_OUTPUT_NTS    10001
>#endif
>
>/* connection attributes */
>#if (ODBCVER >= 0x0300)
>#define SQL_ATTR_AUTO_IPD      10001
>#define SQL_ATTR_METADATA_ID   10014
>#endif  /* ODBCVER >= 0x0300 */
>
>/* statement attributes */
>#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
>
>/* SQL_ATTR_CURSOR_SCROLLABLE values */
>#if (ODBCVER >= 0x0300)
>#define SQL_NONSCROLLABLE			0
>#define SQL_SCROLLABLE				1
>#endif  /* ODBCVER >= 0x0300 */
>
>/* identifiers of fields in the SQL descriptor */
>#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
>
>/* identifiers of fields in the diagnostics area */
>#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
>
>/* dynamic function codes */
>#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  /* ODBCVER >= 0x0300 */
>
>/* SQL data type codes */
>#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
>
>/* One-parameter shortcuts for date/time data types */
>#if (ODBCVER >= 0x0300)
>#define SQL_TYPE_DATE      91
>#define SQL_TYPE_TIME      92
>#define SQL_TYPE_TIMESTAMP 93
>#endif
>
>/* Statement attribute values for cursor sensitivity */
>#if (ODBCVER >= 0x0300)
>#define SQL_UNSPECIFIED     0
>#define SQL_INSENSITIVE     1
>#define SQL_SENSITIVE       2
>#endif
>
>/* GetTypeInfo() request for all data types */
>#define SQL_ALL_TYPES       0
>
>/* Default conversion code for SQLBindCol(), SQLBindParam() and SQLGetData() */
>#if (ODBCVER >= 0x0300)
>#define SQL_DEFAULT        99
>#endif
>
>/* SQLGetData() code indicating that the application row descriptor
> * specifies the data type
> */
>#if (ODBCVER >= 0x0300)
>#define SQL_ARD_TYPE      (-99)
>#endif
>
>/* SQL date/time type subcodes */
>#if (ODBCVER >= 0x0300)
>#define SQL_CODE_DATE       1
>#define SQL_CODE_TIME       2
>#define SQL_CODE_TIMESTAMP  3
>#endif
>
>/* CLI option values */
>#if (ODBCVER >= 0x0300)
>#define SQL_FALSE           0
>#define SQL_TRUE            1
>#endif
>
>/* values of NULLABLE field in descriptor */
>#define SQL_NO_NULLS        0
>#define SQL_NULLABLE        1
>
>/* Value returned by SQLGetTypeInfo() to denote that it is
> * not known whether or not a data type supports null values.
> */
>#define SQL_NULLABLE_UNKNOWN  2
>
>/* Values returned by SQLGetTypeInfo() to show WHERE clause
> * supported
> */
>#if (ODBCVER >= 0x0300)
>#define SQL_PRED_NONE     0
>#define SQL_PRED_CHAR     1
>#define SQL_PRED_BASIC    2
>#endif
>
>/* values of UNNAMED field in descriptor */
>#if (ODBCVER >= 0x0300)
>#define SQL_NAMED           0
>#define SQL_UNNAMED         1
>#endif
>
>/* values of ALLOC_TYPE field in descriptor */
>#if (ODBCVER >= 0x0300)
>#define SQL_DESC_ALLOC_AUTO 1
>#define SQL_DESC_ALLOC_USER 2
>#endif
>
>/* FreeStmt() options */
>#define SQL_CLOSE           0
>#define SQL_DROP            1
>#define SQL_UNBIND          2
>#define SQL_RESET_PARAMS    3
>
>/* Codes used for FetchOrientation in SQLFetchScroll(),
>   and in SQLDataSources()
>*/
>#define SQL_FETCH_NEXT      1
>#define SQL_FETCH_FIRST     2
>
>/* Other codes used for FetchOrientation in SQLFetchScroll() */
>#define SQL_FETCH_LAST      3
>#define SQL_FETCH_PRIOR     4
>#define SQL_FETCH_ABSOLUTE  5
>#define SQL_FETCH_RELATIVE  6
>
>/* SQLEndTran() options */
>#define SQL_COMMIT          0
>#define SQL_ROLLBACK        1
>
>/* null handles returned by SQLAllocHandle() */
>#define SQL_NULL_HENV       0
>#define SQL_NULL_HDBC       0
>#define SQL_NULL_HSTMT      0
>#if (ODBCVER >= 0x0300)
>#define SQL_NULL_HDESC      0
>#endif
>
>/* null handle used in place of parent handle when allocating HENV */
>#if (ODBCVER >= 0x0300)
>#define SQL_NULL_HANDLE     0L
>#endif
>
>/* Values that may appear in the result set of SQLSpecialColumns() */
>#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
>
>/* Reserved value for the IdentifierType argument of SQLSpecialColumns() */
>#if (ODBCVER >= 0x0300)
>#define SQL_ROW_IDENTIFIER  1
>#endif
>
>/* Reserved values for UNIQUE argument of SQLStatistics() */
>#define SQL_INDEX_UNIQUE    0
>#define SQL_INDEX_ALL       1
>
>/* Values that may appear in the result set of SQLStatistics() */
>#define SQL_INDEX_CLUSTERED 1
>#define SQL_INDEX_HASHED    2
>#define SQL_INDEX_OTHER     3
>
>/* SQLGetFunctions() values to identify ODBC APIs */
>#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
>
>/* Information requested by SQLGetInfo() */
>#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 /* ODBCVER >= 0x0300 */
>
>#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 /* ODBCVER >= 0x0300 */
>
>/* SQL_ALTER_TABLE bitmasks */
>#if (ODBCVER >= 0x0200)
>#define SQL_AT_ADD_COLUMN                   	0x00000001L
>#define SQL_AT_DROP_COLUMN                  	0x00000002L
>#endif /* ODBCVER >= 0x0200 */
>
>#if (ODBCVER >= 0x0300)
>#define SQL_AT_ADD_CONSTRAINT               	0x00000008L
>
>/* The following bitmasks are ODBC extensions and defined in sqlext.h
>*#define	SQL_AT_COLUMN_SINGLE					0x00000020L	
>*#define	SQL_AT_ADD_COLUMN_DEFAULT				0x00000040L
>*#define	SQL_AT_ADD_COLUMN_COLLATION				0x00000080L
>*#define	SQL_AT_SET_COLUMN_DEFAULT				0x00000100L
>*#define	SQL_AT_DROP_COLUMN_DEFAULT				0x00000200L
>*#define	SQL_AT_DROP_COLUMN_CASCADE				0x00000400L
>*#define	SQL_AT_DROP_COLUMN_RESTRICT				0x00000800L
>*#define SQL_AT_ADD_TABLE_CONSTRAINT				0x00001000L		
>*#define SQL_AT_DROP_TABLE_CONSTRAINT_CASCADE		0x00002000L		
>*#define SQL_AT_DROP_TABLE_CONSTRAINT_RESTRICT		0x00004000L		
>*#define SQL_AT_CONSTRAINT_NAME_DEFINITION			0x00008000L
>*#define SQL_AT_CONSTRAINT_INITIALLY_DEFERRED		0x00010000L
>*#define SQL_AT_CONSTRAINT_INITIALLY_IMMEDIATE		0x00020000L
>*#define SQL_AT_CONSTRAINT_DEFERRABLE				0x00040000L
>*#define SQL_AT_CONSTRAINT_NON_DEFERRABLE			0x00080000L
>*/
>#endif  /* ODBCVER >= 0x0300 */
>
>
>/* SQL_ASYNC_MODE values */
>#if (ODBCVER >= 0x0300)
>#define SQL_AM_NONE                         0
>#define SQL_AM_CONNECTION                   1
>#define SQL_AM_STATEMENT                    2
>#endif
>
>/* SQL_CURSOR_COMMIT_BEHAVIOR values */
>#define SQL_CB_DELETE                       0
>#define SQL_CB_CLOSE                        1
>#define SQL_CB_PRESERVE                     2
>
>/* SQL_FETCH_DIRECTION bitmasks */
>#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
>
>/* SQL_GETDATA_EXTENSIONS bitmasks */
>#define SQL_GD_ANY_COLUMN                   0x00000001L
>#define SQL_GD_ANY_ORDER                    0x00000002L
>
>/* SQL_IDENTIFIER_CASE values */
>#define SQL_IC_UPPER                        1
>#define SQL_IC_LOWER                        2
>#define SQL_IC_SENSITIVE                    3
>#define SQL_IC_MIXED                        4
>
>/* SQL_OJ_CAPABILITIES bitmasks */
>/* NB: this means 'outer join', not what  you may be thinking */
>
>
>#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
>
>/* SQL_SCROLL_CONCURRENCY bitmasks */
>#define SQL_SCCO_READ_ONLY                  0x00000001L
>#define SQL_SCCO_LOCK                       0x00000002L
>#define SQL_SCCO_OPT_ROWVER                 0x00000004L
>#define SQL_SCCO_OPT_VALUES                 0x00000008L
>
>/* SQL_TXN_CAPABLE values */
>#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
>
>/* SQL_TXN_ISOLATION_OPTION bitmasks */
>#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
>
>/* SQL_NULL_COLLATION values */
>#define SQL_NC_HIGH                         0
>#define SQL_NC_LOW                          1
>
>SQLRETURN   SQLAllocConnect(SQLHENV EnvironmentHandle,
>           SQLHDBC *ConnectionHandle);
>
>SQLRETURN   SQLAllocEnv(SQLHENV *EnvironmentHandle);
>
>#if (ODBCVER >= 0x0300)
>SQLRETURN   SQLAllocHandle(SQLSMALLINT HandleType,
>           SQLHANDLE InputHandle, SQLHANDLE *OutputHandle);
>#endif
>
>SQLRETURN   SQLAllocStmt(SQLHDBC ConnectionHandle,
>           SQLHSTMT *StatementHandle);
>
>SQLRETURN   SQLBindCol(SQLHSTMT StatementHandle,
>		   SQLUSMALLINT ColumnNumber, SQLSMALLINT TargetType,
>		   SQLPOINTER TargetValue, SQLLEN BufferLength,
>	   	   SQLLEN *StrLen_or_Ind);
>
>#if (ODBCVER >= 0x0300)
>SQLRETURN   SQLBindParam(SQLHSTMT StatementHandle,
>           SQLUSMALLINT ParameterNumber, SQLSMALLINT ValueType,
>           SQLSMALLINT ParameterType, SQLULEN LengthPrecision,
>           SQLSMALLINT ParameterScale, SQLPOINTER ParameterValue,
>           SQLLEN *StrLen_or_Ind);
>#endif
>
>SQLRETURN   SQLCancel(SQLHSTMT StatementHandle);
>
>#if (ODBCVER >= 0x0300)
>SQLRETURN   SQLCloseCursor(SQLHSTMT StatementHandle);
>
>SQLRETURN   SQLColAttribute (SQLHSTMT StatementHandle,
>           SQLUSMALLINT ColumnNumber, SQLUSMALLINT FieldIdentifier,
>           SQLPOINTER CharacterAttribute, SQLSMALLINT BufferLength,
>           SQLSMALLINT *StringLength, SQLPOINTER NumericAttribute);
>#endif
>
>
>SQLRETURN   SQLColumns(SQLHSTMT StatementHandle,
>           SQLCHAR *CatalogName, SQLSMALLINT NameLength1,
>           SQLCHAR *SchemaName, SQLSMALLINT NameLength2,
>           SQLCHAR *TableName, SQLSMALLINT NameLength3,
>           SQLCHAR *ColumnName, SQLSMALLINT NameLength4);
>
>
>SQLRETURN   SQLConnect(SQLHDBC ConnectionHandle,
>           SQLCHAR *ServerName, SQLSMALLINT NameLength1,
>           SQLCHAR *UserName, SQLSMALLINT NameLength2,
>           SQLCHAR *Authentication, SQLSMALLINT NameLength3);
>
>#if (ODBCVER >= 0x0300)
>SQLRETURN   SQLCopyDesc(SQLHDESC SourceDescHandle,
>           SQLHDESC TargetDescHandle);
>#endif
>
>SQLRETURN   SQLDataSources(SQLHENV EnvironmentHandle,
>           SQLUSMALLINT Direction, SQLCHAR *ServerName,
>           SQLSMALLINT BufferLength1, SQLSMALLINT *NameLength1,
>           SQLCHAR *Description, SQLSMALLINT BufferLength2,
>           SQLSMALLINT *NameLength2);
>
>SQLRETURN   SQLDescribeCol(SQLHSTMT StatementHandle,
>           SQLUSMALLINT ColumnNumber, SQLCHAR *ColumnName,
>           SQLSMALLINT BufferLength, SQLSMALLINT *NameLength,
>           SQLSMALLINT *DataType, SQLULEN *ColumnSize,
>           SQLSMALLINT *DecimalDigits, SQLSMALLINT *Nullable);
>
>SQLRETURN   SQLDisconnect(SQLHDBC ConnectionHandle);
>
>#if (ODBCVER >= 0x0300)
>SQLRETURN   SQLEndTran(SQLSMALLINT HandleType, SQLHANDLE Handle,
>           SQLSMALLINT CompletionType);
>#endif
>
>SQLRETURN   SQLError(SQLHENV EnvironmentHandle,
>           SQLHDBC ConnectionHandle, SQLHSTMT StatementHandle,
>           SQLCHAR *Sqlstate, SQLINTEGER *NativeError,
>           SQLCHAR *MessageText, SQLSMALLINT BufferLength,
>           SQLSMALLINT *TextLength);
>
>SQLRETURN   SQLExecDirect(SQLHSTMT StatementHandle,
>           SQLCHAR *StatementText, SQLINTEGER TextLength);
>
>SQLRETURN   SQLExecute(SQLHSTMT StatementHandle);
>
>SQLRETURN   SQLFetch(SQLHSTMT StatementHandle);
>
>#if (ODBCVER >= 0x0300)
>SQLRETURN   SQLFetchScroll(SQLHSTMT StatementHandle,
>           SQLSMALLINT FetchOrientation, SQLROWOFFSET FetchOffset);
>#endif
>
>SQLRETURN   SQLFreeConnect(SQLHDBC ConnectionHandle);
>
>SQLRETURN   SQLFreeEnv(SQLHENV EnvironmentHandle);
>
>#if (ODBCVER >= 0x0300)
>SQLRETURN   SQLFreeHandle(SQLSMALLINT HandleType, SQLHANDLE Handle);
>#endif
>
>SQLRETURN   SQLFreeStmt(SQLHSTMT StatementHandle,
>           SQLUSMALLINT Option);
>
>#if (ODBCVER >= 0x0300)
>SQLRETURN   SQLGetConnectAttr(SQLHDBC ConnectionHandle,
>           SQLINTEGER Attribute, SQLPOINTER Value,
>           SQLINTEGER BufferLength, SQLINTEGER *StringLength);
>#endif
>
>SQLRETURN   SQLGetConnectOption(SQLHDBC ConnectionHandle,
>           SQLUSMALLINT Option, SQLPOINTER Value);
>
>SQLRETURN   SQLGetCursorName(SQLHSTMT StatementHandle,
>           SQLCHAR *CursorName, SQLSMALLINT BufferLength,
>           SQLSMALLINT *NameLength);
>
>SQLRETURN   SQLGetData(SQLHSTMT StatementHandle,
>           SQLUSMALLINT ColumnNumber, SQLSMALLINT TargetType,
>           SQLPOINTER TargetValue, SQLLEN BufferLength,
>           SQLLEN *StrLen_or_Ind);
>
>#if (ODBCVER >= 0x0300)
>SQLRETURN   SQLGetDescField(SQLHDESC DescriptorHandle,
>           SQLSMALLINT RecNumber, SQLSMALLINT FieldIdentifier,
>           SQLPOINTER Value, SQLINTEGER BufferLength,
>           SQLINTEGER *StringLength);
>
>SQLRETURN   SQLGetDescRec(SQLHDESC DescriptorHandle,
>           SQLSMALLINT RecNumber, SQLCHAR *Name,
>           SQLSMALLINT BufferLength, SQLSMALLINT *StringLength,
>           SQLSMALLINT *Type, SQLSMALLINT *SubType,
>           SQLLEN *Length, SQLSMALLINT *Precision,
>           SQLSMALLINT *Scale, SQLSMALLINT *Nullable);
>
>SQLRETURN   SQLGetDiagField(SQLSMALLINT HandleType, SQLHANDLE Handle,
>           SQLSMALLINT RecNumber, SQLSMALLINT DiagIdentifier,
>           SQLPOINTER DiagInfo, SQLSMALLINT BufferLength,
>           SQLSMALLINT *StringLength);
>
>SQLRETURN   SQLGetDiagRec(SQLSMALLINT HandleType, SQLHANDLE Handle,
>           SQLSMALLINT RecNumber, SQLCHAR *Sqlstate,
>           SQLINTEGER *NativeError, SQLCHAR *MessageText,
>           SQLSMALLINT BufferLength, SQLSMALLINT *TextLength);
>
>SQLRETURN   SQLGetEnvAttr(SQLHENV EnvironmentHandle,
>           SQLINTEGER Attribute, SQLPOINTER Value,
>           SQLINTEGER BufferLength, SQLINTEGER *StringLength);
>#endif  /* ODBCVER >= 0x0300 */
>
>SQLRETURN   SQLGetFunctions(SQLHDBC ConnectionHandle,
>           SQLUSMALLINT FunctionId, SQLUSMALLINT *Supported);
>
>SQLRETURN   SQLGetInfo(SQLHDBC ConnectionHandle,
>           SQLUSMALLINT InfoType, SQLPOINTER InfoValue,
>           SQLSMALLINT BufferLength, SQLSMALLINT *StringLength);
>
>#if (ODBCVER >= 0x0300)
>SQLRETURN   SQLGetStmtAttr(SQLHSTMT StatementHandle,
>           SQLINTEGER Attribute, SQLPOINTER Value,
>           SQLINTEGER BufferLength, SQLINTEGER *StringLength);
>#endif  /* ODBCVER >= 0x0300 */
>
>SQLRETURN   SQLGetStmtOption(SQLHSTMT StatementHandle,
>           SQLUSMALLINT Option, SQLPOINTER Value);
>
>SQLRETURN   SQLGetTypeInfo(SQLHSTMT StatementHandle,
>           SQLSMALLINT DataType);
>
>SQLRETURN   SQLNumResultCols(SQLHSTMT StatementHandle,
>           SQLSMALLINT *ColumnCount);
>
>SQLRETURN   SQLParamData(SQLHSTMT StatementHandle,
>           SQLPOINTER *Value);
>
>SQLRETURN   SQLPrepare(SQLHSTMT StatementHandle,
>           SQLCHAR *StatementText, SQLINTEGER TextLength);
>
>SQLRETURN   SQLPutData(SQLHSTMT StatementHandle,
>           SQLPOINTER Data, SQLLEN StrLen_or_Ind);
>
>SQLRETURN   SQLRowCount(SQLHSTMT StatementHandle,
>	   SQLLEN *RowCount);
>
>#if (ODBCVER >= 0x0300)
>SQLRETURN   SQLSetConnectAttr(SQLHDBC ConnectionHandle,
>           SQLINTEGER Attribute, SQLPOINTER Value,
>           SQLINTEGER StringLength);
>#endif /* ODBCVER >= 0x0300 */
>
>SQLRETURN   SQLSetConnectOption(SQLHDBC ConnectionHandle,
>           SQLUSMALLINT Option, SQLULEN Value);
>
>SQLRETURN   SQLSetCursorName(SQLHSTMT StatementHandle,
>           SQLCHAR *CursorName, SQLSMALLINT NameLength);
>
>#if (ODBCVER >= 0x0300)
>SQLRETURN   SQLSetDescField(SQLHDESC DescriptorHandle,
>           SQLSMALLINT RecNumber, SQLSMALLINT FieldIdentifier,
>           SQLPOINTER Value, SQLINTEGER BufferLength);
>
>SQLRETURN   SQLSetDescRec(SQLHDESC DescriptorHandle,
>           SQLSMALLINT RecNumber, SQLSMALLINT Type,
>           SQLSMALLINT SubType, SQLLEN Length,
>           SQLSMALLINT Precision, SQLSMALLINT Scale,
>           SQLPOINTER Data, SQLLEN *StringLength,
>           SQLLEN *Indicator);
>
>SQLRETURN   SQLSetEnvAttr(SQLHENV EnvironmentHandle,
>           SQLINTEGER Attribute, SQLPOINTER Value,
>           SQLINTEGER StringLength);
>#endif /* ODBCVER >= 0x0300 */
>
>SQLRETURN   SQLSetParam(SQLHSTMT StatementHandle,
>           SQLUSMALLINT ParameterNumber, SQLSMALLINT ValueType,
>           SQLSMALLINT ParameterType, SQLULEN LengthPrecision,
>           SQLSMALLINT ParameterScale, SQLPOINTER ParameterValue,
>           SQLLEN *StrLen_or_Ind);
>
>#if (ODBCVER >= 0x0300)
>SQLRETURN   SQLSetStmtAttr(SQLHSTMT StatementHandle,
>           SQLINTEGER Attribute, SQLPOINTER Value,
>           SQLINTEGER StringLength);
>#endif
>
>SQLRETURN   SQLSetStmtOption(SQLHSTMT StatementHandle,
>           SQLUSMALLINT Option, SQLROWCOUNT Value);
>
>SQLRETURN   SQLSpecialColumns(SQLHSTMT StatementHandle,
>           SQLUSMALLINT IdentifierType, SQLCHAR *CatalogName,
>           SQLSMALLINT NameLength1, SQLCHAR *SchemaName,
>           SQLSMALLINT NameLength2, SQLCHAR *TableName,
>           SQLSMALLINT NameLength3, SQLUSMALLINT Scope,
>           SQLUSMALLINT Nullable);
>
>SQLRETURN   SQLStatistics(SQLHSTMT StatementHandle,
>           SQLCHAR *CatalogName, SQLSMALLINT NameLength1,
>           SQLCHAR *SchemaName, SQLSMALLINT NameLength2,
>           SQLCHAR *TableName, SQLSMALLINT NameLength3,
>           SQLUSMALLINT Unique, SQLUSMALLINT Reserved);
>
>SQLRETURN   SQLTables(SQLHSTMT StatementHandle,
>           SQLCHAR *CatalogName, SQLSMALLINT NameLength1,
>           SQLCHAR *SchemaName, SQLSMALLINT NameLength2,
>           SQLCHAR *TableName, SQLSMALLINT NameLength3,
>           SQLCHAR *TableType, SQLSMALLINT NameLength4);
>
>SQLRETURN   SQLTransact(SQLHENV EnvironmentHandle,
>           SQLHDBC ConnectionHandle, SQLUSMALLINT CompletionType);
>
>#ifdef __cplusplus
>}
>#endif
>#endif

Actions: View

Attachments on bug 34007: 21028