isqlext.h

浙江大学的悟空嵌入式系统模拟器

 *  SQL_CONVERT_FUNCTIONS
 */
#define SQL_FN_CVT_CONVERT		0x00000001L

/*
 *  SQL_STRING_FUNCTIONS
 */
#define SQL_FN_STR_CONCAT		0x00000001L
#define SQL_FN_STR_INSERT		0x00000002L
#define SQL_FN_STR_LEFT 		0x00000004L
#define SQL_FN_STR_LTRIM		0x00000008L
#define SQL_FN_STR_LENGTH		0x00000010L
#define SQL_FN_STR_LOCATE		0x00000020L
#define SQL_FN_STR_LCASE		0x00000040L
#define SQL_FN_STR_REPEAT		0x00000080L
#define SQL_FN_STR_REPLACE		0x00000100L
#define SQL_FN_STR_RIGHT		0x00000200L
#define SQL_FN_STR_RTRIM		0x00000400L
#define SQL_FN_STR_SUBSTRING		0x00000800L
#define SQL_FN_STR_UCASE		0x00001000L
#define SQL_FN_STR_ASCII		0x00002000L
#define SQL_FN_STR_CHAR 		0x00004000L
#define SQL_FN_STR_DIFFERENCE		0x00008000L
#define SQL_FN_STR_LOCATE_2 		0x00010000L
#define SQL_FN_STR_SOUNDEX		0x00020000L
#define SQL_FN_STR_SPACE		0x00040000L

/*
 *  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

/*
 *  SQL_TIMEDATE_FUNCTIONS
 */
#define SQL_FN_TD_NOW			0x00000001L
#define SQL_FN_TD_CURDATE		0x00000002L
#define SQL_FN_TD_DAYOFMONTH		0x00000004L
#define SQL_FN_TD_DAYOFWEEK 		0x00000008L
#define SQL_FN_TD_DAYOFYEAR 		0x00000010L
#define SQL_FN_TD_MONTH 		0x00000020L
#define SQL_FN_TD_QUARTER		0x00000040L
#define SQL_FN_TD_WEEK			0x00000080L
#define SQL_FN_TD_YEAR			0x00000100L
#define SQL_FN_TD_CURTIME		0x00000200L
#define SQL_FN_TD_HOUR			0x00000400L
#define SQL_FN_TD_MINUTE		0x00000800L
#define SQL_FN_TD_SECOND		0x00001000L
#define SQL_FN_TD_TIMESTAMPADD		0x00002000L
#define SQL_FN_TD_TIMESTAMPDIFF 	0x00004000L
#define SQL_FN_TD_DAYNAME		0x00008000L
#define SQL_FN_TD_MONTHNAME 		0x00010000L

/*
 *  SQL_SYSTEM_FUNCTIONS
 */
#define SQL_FN_SYS_USERNAME 		0x00000001L
#define SQL_FN_SYS_DBNAME		0x00000002L
#define SQL_FN_SYS_IFNULL		0x00000004L

/*
 *  SQL_TIMEDATE_ADD_INTERVALS
 *  SQL_TIMEDATE_DIFF_INTERVALS
 */
#define SQL_FN_TSI_FRAC_SECOND		0x00000001L
#define SQL_FN_TSI_SECOND		0x00000002L
#define SQL_FN_TSI_MINUTE		0x00000004L
#define SQL_FN_TSI_HOUR 		0x00000008L
#define SQL_FN_TSI_DAY			0x00000010L
#define SQL_FN_TSI_WEEK 		0x00000020L
#define SQL_FN_TSI_MONTH		0x00000040L
#define SQL_FN_TSI_QUARTER		0x00000080L
#define SQL_FN_TSI_YEAR 		0x00000100L

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

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

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

/*
 *  SQL_CONCAT_NULL_BEHAVIOR
 */
#define SQL_CB_NULL 			0x0000
#define SQL_CB_NON_NULL		 	0x0001

/*
 *  SQL_CURSOR_COMMIT_BEHAVIOR
 *  SQL_CURSOR_ROLLBACK_BEHAVIOR
 */
#define SQL_CB_DELETE			0x0000
#define SQL_CB_CLOSE			0x0001
#define SQL_CB_PRESERVE			0x0002

/*
 *  SQL_IDENTIFIER_CASE
 */
#define SQL_IC_UPPER			0x0001
#define SQL_IC_LOWER			0x0002
#define SQL_IC_SENSITIVE		0x0003
#define SQL_IC_MIXED			0x0004

/*
 *  SQL_TXN_CAPABLE
 */
#define SQL_TC_NONE 			0x0000
#define SQL_TC_DML			0x0001
#define SQL_TC_ALL			0x0002
#define SQL_TC_DDL_COMMIT		0x0003
#define SQL_TC_DDL_IGNORE		0x0004

/*
 *  SQL_SCROLL_OPTIONS
 */
#define SQL_SO_FORWARD_ONLY 		0x00000001L
#define SQL_SO_KEYSET_DRIVEN		0x00000002L
#define SQL_SO_DYNAMIC			0x00000004L
#define SQL_SO_MIXED			0x00000008L
#define SQL_SO_STATIC			0x00000010L

/*
 * SQL_SCROLL_CONCURRENCY
 */
#define SQL_SCCO_READ_ONLY		0x00000001L
#define SQL_SCCO_LOCK			0x00000002L
#define SQL_SCCO_OPT_ROWVER 		0x00000004L
#define SQL_SCCO_OPT_VALUES 		0x00000008L

/*
 *  SQL_FETCH_DIRECTION
 */
#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_FD_FETCH_RESUME 		0x00000040L
#define SQL_FD_FETCH_BOOKMARK		0x00000080L

/*
 *  SQL_TXN_ISOLATION_OPTION
 */
#define SQL_TXN_READ_UNCOMMITTED	0x00000001L
#define SQL_TXN_READ_COMMITTED		0x00000002L
#define SQL_TXN_REPEATABLE_READ 	0x00000004L
#define SQL_TXN_SERIALIZABLE		0x00000008L
#define SQL_TXN_VERSIONING		0x00000010L

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

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

/*
 *  SQL_NULL_COLLATION
 */
#define SQL_NC_HIGH 			0x0000
#define SQL_NC_LOW			0x0001
#define SQL_NC_START			0x0002
#define SQL_NC_END			0x0004

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

/*
 *  SQL_GETDATA_EXTENSIONS
 */
#define SQL_GD_ANY_COLUMN		0x00000001L
#define SQL_GD_ANY_ORDER		0x00000002L
#define SQL_GD_BLOCK			0x00000004L
#define SQL_GD_BOUND			0x00000008L

/*
 * SQL_ALTER_TABLE
 */
#define SQL_AT_ADD_COLUMN		0x00000001L
#define SQL_AT_DROP_COLUMN		0x00000002L

/*
 *  SQL_POSITIONED_STATEMENTS
 */
#define SQL_PS_POSITIONED_DELETE	0x00000001L
#define SQL_PS_POSITIONED_UPDATE	0x00000002L
#define SQL_PS_SELECT_FOR_UPDATE	0x00000004L

/*
 *  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

/*
 *  SQL_OWNER_USAGE
 */
#define SQL_OU_DML_STATEMENTS		0x00000001L
#define SQL_OU_PROCEDURE_INVOCATION	0x00000002L
#define SQL_OU_TABLE_DEFINITION 	0x00000004L
#define SQL_OU_INDEX_DEFINITION 	0x00000008L
#define SQL_OU_PRIVILEGE_DEFINITION	0x00000010L

/*
 * SQL_QUALIFIER_USAGE
 */
#define SQL_QU_DML_STATEMENTS		0x00000001L
#define SQL_QU_PROCEDURE_INVOCATION 	0x00000002L
#define SQL_QU_TABLE_DEFINITION 	0x00000004L
#define SQL_QU_INDEX_DEFINITION 	0x00000008L
#define SQL_QU_PRIVILEGE_DEFINITION 	0x00000010L

/*
 *  SQL_SUBQUERIES
 */
#define SQL_SQ_COMPARISON		0x00000001L
#define SQL_SQ_EXISTS			0x00000002L
#define SQL_SQ_IN			0x00000004L
#define SQL_SQ_QUANTIFIED		0x00000008L
#define SQL_SQ_CORRELATED_SUBQUERIES	0x00000010L

/*
 *  SQL_UNION
 */
#define SQL_U_UNION			0x00000001L
#define SQL_U_UNION_ALL			0x00000002L

/*
 *  SQL_BOOKMARK_PERSISTENCE
 */
#define SQL_BP_CLOSE			0x00000001L
#define SQL_BP_DELETE			0x00000002L
#define SQL_BP_DROP 			0x00000004L
#define SQL_BP_TRANSACTION		0x00000008L
#define SQL_BP_UPDATE			0x00000010L
#define SQL_BP_OTHER_HSTMT		0x00000020L
#define SQL_BP_SCROLL			0x00000040L

/*
 * SQL_STATIC_SENSITIVITY
 */
#define SQL_SS_ADDITIONS		0x00000001L
#define SQL_SS_DELETIONS		0x00000002L
#define SQL_SS_UPDATES			0x00000004L

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

/*
 *  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

/*
 *  SQL_QUALIFIER_LOCATION
 */
#define SQL_QL_START			0x0001L
#define SQL_QL_END			0x0002L

/*
 *  SQL_OJ_CAPABILITIES
 */
#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

/*
 *  SQLGetStmtOption/SQLSetStmtOption
 */
#define SQL_QUERY_TIMEOUT		0
#define SQL_MAX_ROWS			1
#define SQL_NOSCAN			2
#define SQL_MAX_LENGTH			3
#define SQL_ASYNC_ENABLE		4
#define SQL_BIND_TYPE			5
#define SQL_CURSOR_TYPE 		6
#define SQL_CONCURRENCY 		7
#define SQL_KEYSET_SIZE 		8
#define SQL_ROWSET_SIZE 		9
#define SQL_SIMULATE_CURSOR 		10
#define SQL_RETRIEVE_DATA		11
#define SQL_USE_BOOKMARKS		12
#define SQL_GET_BOOKMARK		13
#define SQL_ROW_NUMBER			14

#define SQL_STMT_OPT_MIN		SQL_QUERY_TIMEOUT
#define SQL_STMT_OPT_MAX		SQL_ROW_NUMBER


/*
 * SQL_QUERY_TIMEOUT
 */
#define SQL_QUERY_TIMEOUT_DEFAULT	0UL

/*
 *  SQL_MAX_ROWS
 */
#define SQL_MAX_ROWS_DEFAULT		0UL

/*
 *  SQL_NOSCAN
 */
#define SQL_NOSCAN_OFF			0UL	/* 1.0 FALSE */
#define SQL_NOSCAN_ON			1UL	/* 1.0 TRUE */
#define SQL_NOSCAN_DEFAULT		SQL_NOSCAN_OFF

/*
 *  SQL_MAX_LENGTH
 */
#define SQL_MAX_LENGTH_DEFAULT		0UL

/*
 *  SQL_ASYNC_ENABLE
 */
#define SQL_ASYNC_ENABLE_OFF		0UL
#define SQL_ASYNC_ENABLE_ON		1UL
#define SQL_ASYNC_ENABLE_DEFAULT	SQL_ASYNC_ENABLE_OFF

/*
 *  SQL_BIND_TYPE
 */
#define SQL_BIND_BY_COLUMN		0UL
#define SQL_BIND_TYPE_DEFAULT		SQL_BIND_BY_COLUMN

/*
 *  SQL_CONCURRENCY
 */
#define SQL_CONCUR_READ_ONLY		1
#define SQL_CONCUR_LOCK 		2
#define SQL_CONCUR_ROWVER		3
#define SQL_CONCUR_VALUES		4
#define SQL_CONCUR_DEFAULT		SQL_CONCUR_READ_ONLY