sqlext.h

SQLAPI C/C++ 连接Oracle 数据库！

#define SQL_OPT_TRACE_FILE_DEFAULTW		L"\\SQL.LOG"
#else
#define SQL_OPT_TRACE_FILE_DEFAULT		"/tmp/odbc.log"
#define SQL_OPT_TRACE_FILE_DEFAULTW		L"/tmp/odbc.log"
#endif


/*
 *  SQLGetConnectAttr - SQL_ATTR_ANSI_APP
 */
#if (ODBCVER >= 0x0351)
#define SQL_AA_TRUE				1L /* ANSI app */
#define SQL_AA_FALSE				0L /* Unicode app */
#endif


/*
 *  SQLGetConnectAttr - SQL_ATTR_CONNECTION_DEAD
 */
#define SQL_CD_TRUE				1L /* closed/dead */
#define SQL_CD_FALSE				0L /* open/available */


/*
 *  SQLGetConnectAttr - SQL_ATTR_DISCONNECT_BEHAVIOR
 */
#if (ODBCVER >= 0x0300)
#define SQL_DB_RETURN_TO_POOL			0UL
#define SQL_DB_DISCONNECT			1UL
#define SQL_DB_DEFAULT				SQL_DB_RETURN_TO_POOL
#endif	/* ODBCVER >= 0x0300 */


/*
 *  SQLGetConnectAttr - SQL_ATTR_ENLIST_IN_DTC
 */
#if (ODBCVER >= 0x0300)
#define SQL_DTC_DONE				0L
#endif	/* ODBCVER >= 0x0300 */


/*
 *   SQLGetConnectAttr - Unicode drivers
 */
#if (ODBCVER >= 0x0351)
#define SQL_ATTR_ANSI_APP			115
#endif


/*
 *  SQLGetData
 */
#define SQL_NO_TOTAL				(-4)


/*
 *  SQLGetDescField - extended descriptor field
 */
#if (ODBCVER >= 0x0300)
#define SQL_DESC_ARRAY_SIZE			20
#define SQL_DESC_ARRAY_STATUS_PTR		21
#define SQL_DESC_AUTO_UNIQUE_VALUE		SQL_COLUMN_AUTO_INCREMENT
#define SQL_DESC_BASE_COLUMN_NAME		22
#define SQL_DESC_BASE_TABLE_NAME		23
#define SQL_DESC_BIND_OFFSET_PTR		24
#define SQL_DESC_BIND_TYPE			25
#define SQL_DESC_CASE_SENSITIVE			SQL_COLUMN_CASE_SENSITIVE
#define SQL_DESC_CATALOG_NAME			SQL_COLUMN_QUALIFIER_NAME
#define SQL_DESC_CONCISE_TYPE			SQL_COLUMN_TYPE
#define SQL_DESC_DATETIME_INTERVAL_PRECISION	26
#define SQL_DESC_DISPLAY_SIZE			SQL_COLUMN_DISPLAY_SIZE
#define SQL_DESC_FIXED_PREC_SCALE		SQL_COLUMN_MONEY
#define SQL_DESC_LABEL				SQL_COLUMN_LABEL
#define SQL_DESC_LITERAL_PREFIX			27
#define SQL_DESC_LITERAL_SUFFIX			28
#define SQL_DESC_LOCAL_TYPE_NAME		29
#define SQL_DESC_MAXIMUM_SCALE			30
#define SQL_DESC_MINIMUM_SCALE			31
#define SQL_DESC_NUM_PREC_RADIX			32
#define SQL_DESC_PARAMETER_TYPE			33
#define SQL_DESC_ROWS_PROCESSED_PTR		34
#if (ODBCVER >= 0x0350)
#define SQL_DESC_ROWVER				35
#endif	/* ODBCVER >= 0x0350 */
#define SQL_DESC_SCHEMA_NAME			SQL_COLUMN_OWNER_NAME
#define SQL_DESC_SEARCHABLE			SQL_COLUMN_SEARCHABLE
#define SQL_DESC_TYPE_NAME			SQL_COLUMN_TYPE_NAME
#define SQL_DESC_TABLE_NAME			SQL_COLUMN_TABLE_NAME
#define SQL_DESC_UNSIGNED			SQL_COLUMN_UNSIGNED
#define SQL_DESC_UPDATABLE			SQL_COLUMN_UPDATABLE
#endif	/* ODBCVER >= 0x0300 */


/*
 *  SQLGetDiagField - defines for diagnostics fields
 */
#if (ODBCVER >= 0x0300)
#define SQL_DIAG_CURSOR_ROW_COUNT		(-1249)
#define SQL_DIAG_ROW_NUMBER			(-1248)
#define SQL_DIAG_COLUMN_NUMBER			(-1247)
#endif	/* ODBCVER >= 0x0300 */


/*
 *  SQLGetDiagField  - SQL_DIAG_ROW_NUMBER and SQL_DIAG_COLUMN_NUMBER
 */
#if (ODBCVER >= 0x0300)
#define SQL_NO_ROW_NUMBER			(-1)
#define SQL_NO_COLUMN_NUMBER			(-1)
#define SQL_ROW_NUMBER_UNKNOWN			(-2)
#define SQL_COLUMN_NUMBER_UNKNOWN		(-2)
#endif


#if (ODBCVER >= 0x0300)
/*
 *  SQLGetEnvAttr - Attributes
 */
#define SQL_ATTR_ODBC_VERSION			200
#define SQL_ATTR_CONNECTION_POOLING		201
#define SQL_ATTR_CP_MATCH			202


/*
 * SQLGetEnvAttr - SQL_ATTR_ODBC_VERSION
 */
#define SQL_OV_ODBC2				2UL
#define SQL_OV_ODBC3				3UL


/*
 *  SQLGetEnvAttr - SQL_ATTR_CONNECTION_POOLING
 */
#define SQL_CP_OFF				0UL
#define SQL_CP_ONE_PER_DRIVER			1UL
#define SQL_CP_ONE_PER_HENV			2UL
#define SQL_CP_DEFAULT				SQL_CP_OFF


/*
 * SQLGetEnvAttr - SQL_ATTR_CP_MATCH
 */
#define SQL_CP_STRICT_MATCH			0UL
#define SQL_CP_RELAXED_MATCH			1UL
#define SQL_CP_MATCH_DEFAULT			SQL_CP_STRICT_MATCH
#endif	/* ODBCVER >= 0x0300 */


/*
 *  SQLGetFunctions - extensions to the X/Open specification
 */
#if (ODBCVER >= 0x0300)
#define SQL_API_SQLALLOCHANDLESTD		73
#define SQL_API_SQLBULKOPERATIONS		24
#endif	/* ODBCVER >= 0x0300 */
#define SQL_API_SQLBINDPARAMETER		72
#define SQL_API_SQLBROWSECONNECT		55
#define SQL_API_SQLCOLATTRIBUTES		6
#define SQL_API_SQLCOLUMNPRIVILEGES		56
#define SQL_API_SQLDESCRIBEPARAM		58
#define SQL_API_SQLDRIVERCONNECT		41
#define SQL_API_SQLDRIVERS			71
#define SQL_API_SQLEXTENDEDFETCH		59
#define SQL_API_SQLFOREIGNKEYS			60
#define SQL_API_SQLMORERESULTS			61
#define SQL_API_SQLNATIVESQL			62
#define SQL_API_SQLNUMPARAMS			63
#define SQL_API_SQLPARAMOPTIONS			64
#define SQL_API_SQLPRIMARYKEYS			65
#define SQL_API_SQLPROCEDURECOLUMNS		66
#define SQL_API_SQLPROCEDURES			67
#define SQL_API_SQLSETPOS			68
#define SQL_API_SQLSETSCROLLOPTIONS		69
#define SQL_API_SQLTABLEPRIVILEGES		70


/*
 *  These are not useful anymore as the X/Open specification defines
 *  functions in the 10000 range
 */
#if (ODBCVER < 0x0300)
#define SQL_EXT_API_LAST			SQL_API_SQLBINDPARAMETER
#define SQL_NUM_FUNCTIONS			23
#define SQL_EXT_API_START			40
#define SQL_NUM_EXTENSIONS		(SQL_EXT_API_LAST-SQL_EXT_API_START+1)
#endif	/* ODBCVER < 0x0300 */


/*
 *  SQLGetFunctions - ODBC version 2.x and earlier
 */
#define SQL_API_ALL_FUNCTIONS			0


/*
 *  Loading by ordinal is not supported for 3.0 and above drivers
 */
#define SQL_API_LOADBYORDINAL			199


/*
 *  SQLGetFunctions - SQL_API_ODBC3_ALL_FUNCTIONS
 */
#if (ODBCVER >= 0x0300)
#define SQL_API_ODBC3_ALL_FUNCTIONS		999
#define SQL_API_ODBC3_ALL_FUNCTIONS_SIZE	250

#define SQL_FUNC_EXISTS(pfExists, uwAPI) \
    ((*(((UWORD*) (pfExists)) + ((uwAPI) >> 4)) & (1 << ((uwAPI) & 0x000F))) \
    ? SQL_TRUE : SQL_FALSE)
#endif	/* ODBCVER >= 0x0300 */


/*
 *  SQLGetInfo - ODBC 2.x extensions to the X/Open standard
 */
#define SQL_INFO_FIRST				0
#define SQL_ACTIVE_CONNECTIONS			0 /* MAX_DRIVER_CONNECTIONS */
#define SQL_ACTIVE_STATEMENTS			1 /* MAX_CONCURRENT_ACTIVITIES */
#define SQL_DRIVER_HDBC				3
#define SQL_DRIVER_HENV				4
#define SQL_DRIVER_HSTMT			5
#define SQL_DRIVER_NAME				6
#define SQL_DRIVER_VER				7
#define SQL_ODBC_API_CONFORMANCE		9
#define SQL_ODBC_VER				10
#define SQL_ROW_UPDATES				11
#define SQL_ODBC_SAG_CLI_CONFORMANCE		12
#define SQL_ODBC_SQL_CONFORMANCE		15
#define SQL_PROCEDURES				21
#define SQL_CONCAT_NULL_BEHAVIOR		22
#define SQL_CURSOR_ROLLBACK_BEHAVIOR		24
#define SQL_EXPRESSIONS_IN_ORDERBY		27
#define SQL_MAX_OWNER_NAME_LEN			32 /* MAX_SCHEMA_NAME_LEN */
#define SQL_MAX_PROCEDURE_NAME_LEN		33
#define SQL_MAX_QUALIFIER_NAME_LEN		34 /* MAX_CATALOG_NAME_LEN */
#define SQL_MULT_RESULT_SETS			36
#define SQL_MULTIPLE_ACTIVE_TXN			37
#define SQL_OUTER_JOINS				38
#define SQL_OWNER_TERM				39
#define SQL_PROCEDURE_TERM			40
#define SQL_QUALIFIER_NAME_SEPARATOR		41
#define SQL_QUALIFIER_TERM			42
#define SQL_SCROLL_OPTIONS			44
#define SQL_TABLE_TERM				45
#define SQL_CONVERT_FUNCTIONS			48
#define SQL_NUMERIC_FUNCTIONS			49
#define SQL_STRING_FUNCTIONS			50
#define SQL_SYSTEM_FUNCTIONS			51
#define SQL_TIMEDATE_FUNCTIONS			52
#define SQL_CONVERT_BIGINT			53
#define SQL_CONVERT_BINARY			54
#define SQL_CONVERT_BIT				55
#define SQL_CONVERT_CHAR			56
#define SQL_CONVERT_DATE			57
#define SQL_CONVERT_DECIMAL			58
#define SQL_CONVERT_DOUBLE			59
#define SQL_CONVERT_FLOAT			60
#define SQL_CONVERT_INTEGER			61
#define SQL_CONVERT_LONGVARCHAR			62
#define SQL_CONVERT_NUMERIC			63
#define SQL_CONVERT_REAL			64
#define SQL_CONVERT_SMALLINT			65
#define SQL_CONVERT_TIME			66
#define SQL_CONVERT_TIMESTAMP			67
#define SQL_CONVERT_TINYINT			68
#define SQL_CONVERT_VARBINARY			69
#define SQL_CONVERT_VARCHAR			70
#define SQL_CONVERT_LONGVARBINARY		71
#define SQL_ODBC_SQL_OPT_IEF			73 /* SQL_INTEGRITY */
#define SQL_CORRELATION_NAME			74
#define SQL_NON_NULLABLE_COLUMNS		75
#define SQL_DRIVER_HLIB				76
#define SQL_DRIVER_ODBC_VER			77
#define SQL_LOCK_TYPES				78
#define SQL_POS_OPERATIONS			79
#define SQL_POSITIONED_STATEMENTS		80
#define SQL_BOOKMARK_PERSISTENCE		82
#define SQL_STATIC_SENSITIVITY			83
#define SQL_FILE_USAGE				84
#define SQL_COLUMN_ALIAS			87
#define SQL_GROUP_BY				88
#define SQL_KEYWORDS				89
#define SQL_OWNER_USAGE				91
#define SQL_QUALIFIER_USAGE			92
#define SQL_QUOTED_IDENTIFIER_CASE		93
#define SQL_SUBQUERIES				95
#define SQL_UNION				96
#define SQL_MAX_ROW_SIZE_INCLUDES_LONG		103
#define SQL_MAX_CHAR_LITERAL_LEN		108
#define SQL_TIMEDATE_ADD_INTERVALS		109
#define SQL_TIMEDATE_DIFF_INTERVALS		110
#define SQL_NEED_LONG_DATA_LEN			111
#define SQL_MAX_BINARY_LITERAL_LEN		112
#define SQL_LIKE_ESCAPE_CLAUSE			113
#define SQL_QUALIFIER_LOCATION			114

#if (ODBCVER >= 0x0201 && ODBCVER < 0x0300)
#define SQL_OJ_CAPABILITIES         65003  /* Temp value until ODBC 3.0 */
#endif	/* ODBCVER >= 0x0201 && ODBCVER < 0x0300 */


/*
 *  These values are not useful anymore as X/Open defines values in the
 *  10000 range
 */
#if (ODBCVER < 0x0300)
#define SQL_INFO_LAST				SQL_QUALIFIER_LOCATION
#define SQL_INFO_DRIVER_START			1000
#endif	/* ODBCVER < 0x0300 */


/*
 *  SQLGetInfo - ODBC 3.x extensions to the X/Open standard
 */
#if (ODBCVER >= 0x0300)
#define SQL_ACTIVE_ENVIRONMENTS			116
#define SQL_ALTER_DOMAIN			117

#define SQL_SQL_CONFORMANCE			118
#define SQL_DATETIME_LITERALS			119

#define SQL_ASYNC_MODE				10021	/* new X/Open spec */
#define SQL_BATCH_ROW_COUNT			120
#define SQL_BATCH_SUPPORT			121
#define SQL_CATALOG_LOCATION			SQL_QUALIFIER_LOCATION
#define SQL_CATALOG_NAME_SEPARATOR		SQL_QUALIFIER_NAME_SEPARATOR
#define SQL_CATALOG_TERM			SQL_QUALIFIER_TERM
#define SQL_CATALOG_USAGE			SQL_QUALIFIER_USAGE
#define SQL_CONVERT_WCHAR			122
#define SQL_CONVERT_INTERVAL_DAY_TIME		123
#define SQL_CONVERT_INTERVAL_YEAR_MONTH		124
#define SQL_CONVERT_WLONGVARCHAR		125
#define SQL_CONVERT_WVARCHAR			126
#define SQL_CREATE_ASSERTION			127
#define SQL_CREATE_CHARACTER_SET		128
#define SQL_CREATE_COLLATION			129
#define SQL_CREATE_DOMAIN			130
#define SQL_CREATE_SCHEMA			131
#define SQL_CREATE_TABLE			132
#define SQL_CREATE_TRANSLATION			133
#define SQL_CREATE_VIEW				134
#define SQL_DRIVER_HDESC			135
#define SQL_DROP_ASSERTION			136
#define SQL_DROP_CHARACTER_SET			137
#define SQL_DROP_COLLATION			138
#define SQL_DROP_DOMAIN				139
#define SQL_DROP_SCHEMA				140
#define SQL_DROP_TABLE				141
#define SQL_DROP_TRANSLATION			142
#define SQL_DROP_VIEW				143
#define SQL_DYNAMIC_CURSOR_ATTRIBUTES1		144
#define SQL_DYNAMIC_CURSOR_ATTRIBUTES2		145
#define SQL_FORWARD_ONLY_CURSOR_ATTRIBUTES1	146
#define SQL_FORWARD_ONLY_CURSOR_ATTRIBUTES2	147
#define SQL_INDEX_KEYWORDS			148
#define SQL_INFO_SCHEMA_VIEWS			149
#define SQL_KEYSET_CURSOR_ATTRIBUTES1		150
#define SQL_KEYSET_CURSOR_ATTRIBUTES2		151
#define SQL_MAX_ASYNC_CONCURRENT_STATEMENTS	10022	/* new X/Open spec */
#define SQL_ODBC_INTERFACE_CONFORMANCE		152
#define SQL_PARAM_ARRAY_ROW_COUNTS		153
#define SQL_PARAM_ARRAY_SELECTS			154
#define SQL_SCHEMA_TERM				SQL_OWNER_TERM
#define SQL_SCHEMA_USAGE			SQL_OWNER_USAGE
#define SQL_SQL92_DATETIME_FUNCTIONS		155
#define SQL_SQL92_FOREIGN_KEY_DELETE_RULE	156
#define SQL_SQL92_FOREIGN_KEY_UPDATE_RULE	157
#define SQL_SQL92_GRANT				158
#define SQL_SQL92_NUMERIC_VALUE_FUNCTIONS	159
#define SQL_SQL92_PREDICATES			160
#define SQL_SQL92_RELATIONAL_JOIN_OPERATORS	161
#define SQL_SQL92_REVOKE			162
#define SQL_SQL92_ROW_VALUE_CONSTRUCTOR		163
#define SQL_SQL92_STRING_FUNCTIONS		164
#define SQL_SQL92_VALUE_EXPRESSIONS		165
#define SQL_STANDARD_CLI_CONFORMANCE		166
#define SQL_STATIC_CURSOR_ATTRIBUTES1		167
#define SQL_STATIC_CURSOR_ATTRIBUTES2		168

#define SQL_AGGREGATE_FUNCTIONS			169
#define SQL_DDL_INDEX				170
#define SQL_DM_VER				171
#define SQL_INSERT_STATEMENT			172
#define SQL_UNION_STATEMENT			SQL_UNION

#endif	/* ODBCVER >= 0x0300 */

#define SQL_DTC_TRANSITION_COST			1750


/*
 *  SQLGetInfo - SQL_AGGREGATE_FUNCTIONS
 */
#if (ODBCVER >= 0x0300)
#define SQL_AF_AVG				0x00000001L
#define SQL_AF_COUNT				0x00000002L
#define SQL_AF_MAX				0x00000004L
#define SQL_AF_MIN				0x00000008L
#define SQL_AF_SUM				0x00000010L
#define SQL_AF_DISTINCT				0x00000020L
#define SQL_AF_ALL				0x00000040L
#endif	/* ODBCVER >= 0x0300 */

/*
 *  SQLGetInfo - SQL_ALTER_DOMAIN
 */
#if (ODBCVER >= 0x0300)
#define SQL_AD_CONSTRAINT_NAME_DEFINITION	0x00000001L
#define SQL_AD_ADD_DOMAIN_CONSTRAINT		0x00000002L
#define SQL_AD_DROP_DOMAIN_CONSTRAINT		0x00000004L
#define SQL_AD_ADD_DOMAIN_DEFAULT		0x00000008L
#define SQL_AD_DROP_DOMAIN_DEFAULT		0x00000010L
#define SQL_AD_ADD_CONSTRAINT_INITIALLY_DEFERRED	0x00000020L
#define SQL_AD_ADD_CONSTRAINT_INITIALLY_IMMEDIATE	0x00000040L
#define SQL_AD_ADD_CONSTRAINT_DEFERRABLE	0x00000080L
#define SQL_AD_ADD_CONSTRAINT_NON_DEFERRABLE	0x00000100L
#endif	/* ODBCVER >= 0x0300 */


/*
 *  SQLGetInfo - SQL_ALTER_TABLE
 */
#if (ODBCVER >= 0x0300)
/*
	* The following 5 bitmasks are defined in sql.h
 *
 * #define SQL_AT_ADD_COLUMN			0x00000001L
 * #define SQL_AT_DROP_COLUMN			0x00000002L
 * #define SQL_AT_ADD_CONSTRAINT		0x00000008L
 */
#define SQL_AT_ADD_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 */


/*
 *  SQLGetInfo - SQL_ASYNC_MODE
 */
#if (ODBCVER >= 0x0300)
#define SQL_AM_NONE				0
#define SQL_AM_CONNECTION			1
#define SQL_AM_STATEMENT			2
#endif	/* ODBCVER >= 0x0300 */


/*
 *  SQLGetInfo - SQL_BATCH_ROW_COUNT
 */
#if (ODBCVER >= 0x0300)
#define SQL_BRC_PROCEDURES			0x0000001
#define SQL_BRC_EXPLICIT			0x0000002
#define SQL_BRC_ROLLED_UP			0x0000004
#endif	/* ODBCVER >= 0x0300 */


/*
 *  SQLGetInfo - SQL_BATCH_SUPPORT
 */
#if (ODBCVER >= 0x0300)
#define SQL_BS_SELECT_EXPLICIT			0x00000001L
#define SQL_BS_ROW_COUNT_EXPLICIT		0x00000002L
#define SQL_BS_SELECT_PROC			0x00000004L