sqlext.h

能够连接各种数据库的API

/*
 *  SQLGetInfo - SQL_CORRELATION_NAME
 */
#define SQL_CN_NONE 				0x0000
#define SQL_CN_DIFFERENT			0x0001
#define SQL_CN_ANY				0x0002


/*
 *  SQLGetInfo - SQL_CREATE_ASSERTION
 */
#if (ODBCVER >= 0x0300)
#define SQL_CA_CREATE_ASSERTION			0x00000001L
#define SQL_CA_CONSTRAINT_INITIALLY_DEFERRED	0x00000010L
#define SQL_CA_CONSTRAINT_INITIALLY_IMMEDIATE	0x00000020L
#define SQL_CA_CONSTRAINT_DEFERRABLE		0x00000040L
#define SQL_CA_CONSTRAINT_NON_DEFERRABLE	0x00000080L
#endif	/* ODBCVER >= 0x0300 */


/*
 *  SQLGetInfo - SQL_CREATE_CHARACTER_SET
 */
#if (ODBCVER >= 0x0300)
#define SQL_CCS_CREATE_CHARACTER_SET		0x00000001L
#define SQL_CCS_COLLATE_CLAUSE			0x00000002L
#define SQL_CCS_LIMITED_COLLATION		0x00000004L
#endif	/* ODBCVER >= 0x0300 */


/*
 *  SQLGetInfo - SQL_CREATE_COLLATION
 */
#if (ODBCVER >= 0x0300)
#define SQL_CCOL_CREATE_COLLATION		0x00000001L
#endif	/* ODBCVER >= 0x0300 */


/*
 *  SQLGetInfo - SQL_CREATE_DOMAIN
 */
#if (ODBCVER >= 0x0300)
#define SQL_CDO_CREATE_DOMAIN			0x00000001L
#define SQL_CDO_DEFAULT				0x00000002L
#define SQL_CDO_CONSTRAINT			0x00000004L
#define SQL_CDO_COLLATION			0x00000008L
#define SQL_CDO_CONSTRAINT_NAME_DEFINITION	0x00000010L
#define SQL_CDO_CONSTRAINT_INITIALLY_DEFERRED	0x00000020L
#define SQL_CDO_CONSTRAINT_INITIALLY_IMMEDIATE	0x00000040L
#define SQL_CDO_CONSTRAINT_DEFERRABLE		0x00000080L
#define SQL_CDO_CONSTRAINT_NON_DEFERRABLE	0x00000100L
#endif	/* ODBCVER >= 0x0300 */


/*
 *  SQLGetInfo - SQL_CREATE_SCHEMA
 */
#if (ODBCVER >= 0x0300)
#define SQL_CS_CREATE_SCHEMA			0x00000001L
#define SQL_CS_AUTHORIZATION			0x00000002L
#define SQL_CS_DEFAULT_CHARACTER_SET		0x00000004L
#endif	/* ODBCVER >= 0x0300 */


/*
 *  SQLGetInfo - SQL_CREATE_TABLE
 */
#if (ODBCVER >= 0x0300)
#define SQL_CT_CREATE_TABLE			0x00000001L
#define SQL_CT_COMMIT_PRESERVE			0x00000002L
#define SQL_CT_COMMIT_DELETE			0x00000004L
#define SQL_CT_GLOBAL_TEMPORARY			0x00000008L
#define SQL_CT_LOCAL_TEMPORARY			0x00000010L
#define SQL_CT_CONSTRAINT_INITIALLY_DEFERRED	0x00000020L
#define SQL_CT_CONSTRAINT_INITIALLY_IMMEDIATE	0x00000040L
#define SQL_CT_CONSTRAINT_DEFERRABLE		0x00000080L
#define SQL_CT_CONSTRAINT_NON_DEFERRABLE	0x00000100L
#define SQL_CT_COLUMN_CONSTRAINT		0x00000200L
#define SQL_CT_COLUMN_DEFAULT			0x00000400L
#define SQL_CT_COLUMN_COLLATION			0x00000800L
#define SQL_CT_TABLE_CONSTRAINT			0x00001000L
#define SQL_CT_CONSTRAINT_NAME_DEFINITION	0x00002000L
#endif	/* ODBCVER >= 0x0300 */


/*
 *  SQLGetInfo - SQL_CREATE_TRANSLATION
 */
#if (ODBCVER >= 0x0300)
#define SQL_CTR_CREATE_TRANSLATION		0x00000001L
#endif	/* ODBCVER >= 0x0300 */


/*
 *  SQLGetInfo - SQL_DATETIME_LITERALS
 */
#if (ODBCVER >= 0x0300)
#define SQL_DL_SQL92_DATE			0x00000001L
#define SQL_DL_SQL92_TIME			0x00000002L
#define SQL_DL_SQL92_TIMESTAMP			0x00000004L
#define SQL_DL_SQL92_INTERVAL_YEAR		0x00000008L
#define SQL_DL_SQL92_INTERVAL_MONTH		0x00000010L
#define SQL_DL_SQL92_INTERVAL_DAY		0x00000020L
#define SQL_DL_SQL92_INTERVAL_HOUR		0x00000040L
#define SQL_DL_SQL92_INTERVAL_MINUTE		0x00000080L
#define SQL_DL_SQL92_INTERVAL_SECOND		0x00000100L
#define SQL_DL_SQL92_INTERVAL_YEAR_TO_MONTH	0x00000200L
#define SQL_DL_SQL92_INTERVAL_DAY_TO_HOUR	0x00000400L
#define SQL_DL_SQL92_INTERVAL_DAY_TO_MINUTE	0x00000800L
#define SQL_DL_SQL92_INTERVAL_DAY_TO_SECOND	0x00001000L
#define SQL_DL_SQL92_INTERVAL_HOUR_TO_MINUTE	0x00002000L
#define SQL_DL_SQL92_INTERVAL_HOUR_TO_SECOND	0x00004000L
#define SQL_DL_SQL92_INTERVAL_MINUTE_TO_SECOND	0x00008000L
#endif	/* ODBCVER >= 0x0300 */


/*
 *  SQLGetInfo - SQL_DDL_INDEX
 */
#if (ODBCVER >= 0x0300)
#define SQL_DI_CREATE_INDEX			0x00000001L
#define SQL_DI_DROP_INDEX			0x00000002L
#endif	/* ODBCVER >= 0x0300 */


/*
 *  SQLGetInfo - SQL_DROP_ASSERTION
 */
#if (ODBCVER >= 0x0300)
#define SQL_DA_DROP_ASSERTION			0x00000001L
#endif	/* ODBCVER >= 0x0300 */


/*
 *  SQLGetInfo - SQL_DROP_CHARACTER_SET
 */
#if (ODBCVER >= 0x0300)
#define SQL_DCS_DROP_CHARACTER_SET		0x00000001L
#endif	/* ODBCVER >= 0x0300 */


/*
 *  SQLGetInfo - SQL_DROP_COLLATION
 */
#if (ODBCVER >= 0x0300)
#define SQL_DC_DROP_COLLATION			0x00000001L
#endif	/* ODBCVER >= 0x0300 */


/*
 *  SQLGetInfo - SQL_DROP_DOMAIN
 */
#if (ODBCVER >= 0x0300)
#define SQL_DD_DROP_DOMAIN			0x00000001L
#define SQL_DD_RESTRICT				0x00000002L
#define SQL_DD_CASCADE				0x00000004L
#endif	/* ODBCVER >= 0x0300 */


/*
 *  SQLGetInfo - SQL_DROP_SCHEMA
 */
#if (ODBCVER >= 0x0300)
#define SQL_DS_DROP_SCHEMA			0x00000001L
#define SQL_DS_RESTRICT				0x00000002L
#define SQL_DS_CASCADE				0x00000004L
#endif	/* ODBCVER >= 0x0300 */


/*
 *  SQLGetInfo - SQL_DROP_TABLE
 */
#if (ODBCVER >= 0x0300)
#define SQL_DT_DROP_TABLE			0x00000001L
#define SQL_DT_RESTRICT				0x00000002L
#define SQL_DT_CASCADE				0x00000004L
#endif	/* ODBCVER >= 0x0300 */


/*
 *  SQLGetInfo - SQL_DROP_TRANSLATION
 */
#if (ODBCVER >= 0x0300)
#define SQL_DTR_DROP_TRANSLATION		0x00000001L
#endif	/* ODBCVER >= 0x0300 */


/*
 *  SQLGetInfo - SQL_DROP_VIEW
 */
#if (ODBCVER >= 0x0300)
#define SQL_DV_DROP_VIEW			0x00000001L
#define SQL_DV_RESTRICT				0x00000002L
#define SQL_DV_CASCADE				0x00000004L
#endif	/* ODBCVER >= 0x0300 */


/*
 *  SQLGetInfo - SQL_DTC_TRANSITION_COST
 */
#define SQL_DTC_ENLIST_EXPENSIVE		0x00000001L
#define SQL_DTC_UNENLIST_EXPENSIVE		0x00000002L


/*
 *  SQLGetInfo - SQL_DYNAMIC_CURSOR_ATTRIBUTES1
 *  SQLGetInfo - SQL_FORWARD_ONLY_CURSOR_ATTRIBUTES1
 *  SQLGetInfo - SQL_KEYSET_CURSOR_ATTRIBUTES1
 *  SQLGetInfo - SQL_STATIC_CURSOR_ATTRIBUTES1
 */
#if (ODBCVER >= 0x0300)
/*
 *  SQLFetchScroll - FetchOrientation
 */
#define SQL_CA1_NEXT				0x00000001L
#define SQL_CA1_ABSOLUTE			0x00000002L
#define SQL_CA1_RELATIVE			0x00000004L
#define SQL_CA1_BOOKMARK			0x00000008L


/*
 *  SQLSetPos - LockType
 */
#define SQL_CA1_LOCK_NO_CHANGE			0x00000040L
#define SQL_CA1_LOCK_EXCLUSIVE			0x00000080L
#define SQL_CA1_LOCK_UNLOCK			0x00000100L


/*
 *  SQLSetPos Operations
 */
#define SQL_CA1_POS_POSITION			0x00000200L
#define SQL_CA1_POS_UPDATE			0x00000400L
#define SQL_CA1_POS_DELETE			0x00000800L
#define SQL_CA1_POS_REFRESH			0x00001000L


/*
 *  positioned updates and deletes
 */
#define SQL_CA1_POSITIONED_UPDATE		0x00002000L
#define SQL_CA1_POSITIONED_DELETE		0x00004000L
#define SQL_CA1_SELECT_FOR_UPDATE		0x00008000L


/*
 *  SQLBulkOperations operations
 */
#define SQL_CA1_BULK_ADD			0x00010000L
#define SQL_CA1_BULK_UPDATE_BY_BOOKMARK		0x00020000L
#define SQL_CA1_BULK_DELETE_BY_BOOKMARK		0x00040000L
#define SQL_CA1_BULK_FETCH_BY_BOOKMARK		0x00080000L

#endif	/* ODBCVER >= 0x0300 */


/*
 *  SQLGetInfo - SQL_DYNAMIC_CURSOR_ATTRIBUTES2
 *  SQLGetInfo - SQL_FORWARD_ONLY_CURSOR_ATTRIBUTES2
 *  SQLGetInfo - SQL_KEYSET_CURSOR_ATTRIBUTES2
 *  SQLGetInfo - SQL_STATIC_CURSOR_ATTRIBUTES2
 */
#if (ODBCVER >= 0x0300)
/*
 *  SQL_ATTR_SCROLL_CONCURRENCY
 */
#define SQL_CA2_READ_ONLY_CONCURRENCY		0x00000001L
#define SQL_CA2_LOCK_CONCURRENCY		0x00000002L
#define SQL_CA2_OPT_ROWVER_CONCURRENCY		0x00000004L
#define SQL_CA2_OPT_VALUES_CONCURRENCY		0x00000008L


/*
 *  sensitivity of the cursor to its own inserts, deletes, and updates
 */
#define SQL_CA2_SENSITIVITY_ADDITIONS		0x00000010L
#define SQL_CA2_SENSITIVITY_DELETIONS		0x00000020L
#define SQL_CA2_SENSITIVITY_UPDATES		0x00000040L

/*
 *  SQL_ATTR_MAX_ROWS
 */
#define SQL_CA2_MAX_ROWS_SELECT			0x00000080L
#define SQL_CA2_MAX_ROWS_INSERT			0x00000100L
#define SQL_CA2_MAX_ROWS_DELETE			0x00000200L
#define SQL_CA2_MAX_ROWS_UPDATE			0x00000400L
#define SQL_CA2_MAX_ROWS_CATALOG		0x00000800L
#define SQL_CA2_MAX_ROWS_AFFECTS_ALL		(SQL_CA2_MAX_ROWS_SELECT | \
						 SQL_CA2_MAX_ROWS_INSERT | \
						 SQL_CA2_MAX_ROWS_DELETE | \
						 SQL_CA2_MAX_ROWS_UPDATE | \
						 SQL_CA2_MAX_ROWS_CATALOG)

/*
 *  SQL_DIAG_CURSOR_ROW_COUNT
 */
#define SQL_CA2_CRC_EXACT			0x00001000L
#define SQL_CA2_CRC_APPROXIMATE			0x00002000L


/*
 *  the kinds of positioned statements that can be simulated
 */
#define SQL_CA2_SIMULATE_NON_UNIQUE		0x00004000L
#define SQL_CA2_SIMULATE_TRY_UNIQUE		0x00008000L
#define SQL_CA2_SIMULATE_UNIQUE			0x00010000L
#endif	/* ODBCVER >= 0x0300 */


/*
 *  SQLGetInfo - SQL_FETCH_DIRECTION
 */
#if (ODBCVER < 0x0300)
#define SQL_FD_FETCH_RESUME 			0x00000040L
#endif	/* ODBCVER < 0x0300 */
#define SQL_FD_FETCH_BOOKMARK			0x00000080L


/*
 *  SQLGetInfo - SQL_FILE_USAGE
 */
#define SQL_FILE_NOT_SUPPORTED			0x0000
#define SQL_FILE_TABLE				0x0001
#define SQL_FILE_QUALIFIER			0x0002
#define SQL_FILE_CATALOG			SQL_FILE_QUALIFIER


/*
 *  SQLGetInfo - SQL_GETDATA_EXTENSIONS
 */
#define SQL_GD_BLOCK				0x00000004L
#define SQL_GD_BOUND				0x00000008L


/*
 *  SQLGetInfo - SQL_GROUP_BY
 */
#define SQL_GB_NOT_SUPPORTED			0x0000
#define SQL_GB_GROUP_BY_EQUALS_SELECT		0x0001
#define SQL_GB_GROUP_BY_CONTAINS_SELECT		0x0002
#define SQL_GB_NO_RELATION			0x0003
#if (ODBCVER >= 0x0300)
#define SQL_GB_COLLATE				0x0004
#endif	/* ODBCVER >= 0x0300 */


/*
 *  SQLGetInfo - SQL_INDEX_KEYWORDS
 */
#if (ODBCVER >= 0x0300)
#define SQL_IK_NONE				0x00000000L
#define SQL_IK_ASC				0x00000001L
#define SQL_IK_DESC				0x00000002L
#define SQL_IK_ALL				(SQL_IK_ASC | SQL_IK_DESC)
#endif	/* ODBCVER >= 0x0300 */


/*
 *  SQLGetInfo - SQL_INFO_SCHEMA_VIEWS
 */
#if (ODBCVER >= 0x0300)
#define SQL_ISV_ASSERTIONS			0x00000001L
#define SQL_ISV_CHARACTER_SETS			0x00000002L
#define SQL_ISV_CHECK_CONSTRAINTS		0x00000004L
#define SQL_ISV_COLLATIONS			0x00000008L
#define SQL_ISV_COLUMN_DOMAIN_USAGE		0x00000010L
#define SQL_ISV_COLUMN_PRIVILEGES		0x00000020L
#define SQL_ISV_COLUMNS				0x00000040L
#define SQL_ISV_CONSTRAINT_COLUMN_USAGE		0x00000080L
#define SQL_ISV_CONSTRAINT_TABLE_USAGE		0x00000100L
#define SQL_ISV_DOMAIN_CONSTRAINTS		0x00000200L
#define SQL_ISV_DOMAINS				0x00000400L
#define SQL_ISV_KEY_COLUMN_USAGE		0x00000800L
#define SQL_ISV_REFERENTIAL_CONSTRAINTS		0x00001000L
#define SQL_ISV_SCHEMATA			0x00002000L
#define SQL_ISV_SQL_LANGUAGES			0x00004000L
#define SQL_ISV_TABLE_CONSTRAINTS		0x00008000L
#define SQL_ISV_TABLE_PRIVILEGES		0x00010000L
#define SQL_ISV_TABLES				0x00020000L
#define SQL_ISV_TRANSLATIONS			0x00040000L
#define SQL_ISV_USAGE_PRIVILEGES		0x00080000L
#define SQL_ISV_VIEW_COLUMN_USAGE		0x00100000L
#define SQL_ISV_VIEW_TABLE_USAGE		0x00200000L
#define SQL_ISV_VIEWS				0x00400000L
#endif	/* ODBCVER >= 0x0300 */


/*
 *  SQLGetInfo - SQL_INSERT_STATEMENT
 */
#if (ODBCVER >= 0x0300)
#define SQL_IS_INSERT_LITERALS			0x00000001L
#define SQL_IS_INSERT_SEARCHED			0x00000002L
#define SQL_IS_SELECT_INTO			0x00000004L
#endif	/* ODBCVER >= 0x0300 */


/*
 *  SQLGetInfo - SQL_LOCK_TYPES
 */
#define SQL_LCK_NO_CHANGE			0x00000001L
#define SQL_LCK_EXCLUSIVE			0x00000002L
#define SQL_LCK_UNLOCK				0x00000004L


/*
 *  SQLGetInfo - SQL_POS_OPERATIONS
 */
#define SQL_POS_POSITION			0x00000001L
#define SQL_POS_REFRESH 			0x00000002L
#define SQL_POS_UPDATE				0x00000004L
#define SQL_POS_DELETE				0x00000008L
#define SQL_POS_ADD				0x00000010L


/*
 *  SQLGetInfo - SQL_NON_NULLABLE_COLUMNS
 */
#define SQL_NNC_NULL				0x0000
#define SQL_NNC_NON_NULL			0x0001


/*
 *  SQLGetInfo - SQL_NULL_COLLATION
 */
#define SQL_NC_START				0x0002
#define SQL_NC_END				0x0004


/*
 *  SQLGetInfo - SQL_NUMERIC_FUNCTIONS
 */
#define SQL_FN_NUM_ABS				0x00000001L
#define SQL_FN_NUM_ACOS 			0x00000002L
#define SQL_FN_NUM_ASIN 			0x00000004L
#define SQL_FN_NUM_ATAN 			0x00000008L
#define SQL_FN_NUM_ATAN2			0x00000010L
#define SQL_FN_NUM_CEILING			0x00000020L
#define SQL_FN_NUM_COS				0x00000040L
#define SQL_FN_NUM_COT				0x00000080L
#define SQL_FN_NUM_EXP				0x00000100L
#define SQL_FN_NUM_FLOOR			0x00000200L
#define SQL_FN_NUM_LOG				0x00000400L
#define SQL_FN_NUM_MOD				0x00000800L
#define SQL_FN_NUM_SIGN			 	0x00001000L
#define SQL_FN_NUM_SIN				0x00002000L
#define SQL_FN_NUM_SQRT			 	0x00004000L
#define SQL_FN_NUM_TAN				0x00008000L
#define SQL_FN_NUM_PI				0x00010000L
#define SQL_FN_NUM_RAND			 	0x00020000L
#define SQL_FN_NUM_DEGREES			0x00040000L
#define SQL_FN_NUM_LOG10			0x00080000L
#define SQL_FN_NUM_POWER			0x00100000L
#define SQL_FN_NUM_RADIANS			0x00200000L
#define SQL_FN_NUM_ROUND			0x00400000L
#define SQL_FN_NUM_TRUNCATE 			0x00800000L


/*
 *  SQLGetInfo - SQL_ODBC_API_CONFORMANCE
 */
#define SQL_OAC_NONE				0x0000
#define SQL_OAC_LEVEL1				0x0001
#define SQL_OAC_LEVEL2				0x0002


/*
 *  SQLGetInfo - SQL_ODBC_INTERFACE_CONFORMANCE
 */
#if (ODBCVER >= 0x0300)
#define SQL_OIC_CORE				1UL
#define SQL_OIC_LEVEL1				2UL
#define SQL_OIC_LEVEL2				3UL
#endif	/* ODBCVER >= 0x0300 */


/*
 *  SQLGetInfo - SQL_ODBC_SAG_CLI_CONFORMANCE
 */
#define SQL_OSCC_NOT_COMPLIANT			0x0000
#define SQL_OSCC_COMPLIANT			0x0001


/*
 *  SQLGetInfo - SQL_ODBC_SQL_CONFORMANCE
 */
#define SQL_OSC_MINIMUM 			0x0000
#define SQL_OSC_CORE				0x0001
#define SQL_OSC_EXTENDED			0x0002