isqlext.h

来自「A*算法 A*算法 A*算法 A*算法A*算法A*算法」· C头文件 代码 · 共 1,179 行 · 第 1/3 页

 *  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