sqlext.h

来自「MinGW+MSYS开发必用的api参考」· C头文件 代码 · 共 1,219 行 · 第 1/4 页

#define SQL_LCK_UNLOCK 4
#define SQL_LEN_BINARY_ATTR(length) (-(length)+SQL_LEN_BINARY_ATTR_OFFSET)
#define SQL_LEN_BINARY_ATTR_OFFSET (-100)
#define SQL_LEN_DATA_AT_EXEC(length) (-(length)+SQL_LEN_DATA_AT_EXEC_OFFSET)
#define SQL_LEN_DATA_AT_EXEC_OFFSET (-100)
#define SQL_LIKE_ESCAPE_CLAUSE 113
#define SQL_LIKE_ONLY 1
#define SQL_LOCK_EXCLUSIVE 1
#define SQL_LOCK_NO_CHANGE 0
#define SQL_LOCK_TYPES 78
#define SQL_LOCK_UNLOCK 2
#define SQL_LOGIN_TIMEOUT 103
#define SQL_LOGIN_TIMEOUT_DEFAULT 15UL
#define SQL_LONGVARBINARY (-4)
#define SQL_LONGVARCHAR (-1)
#define SQL_MAX_BINARY_LITERAL_LEN 112
#define SQL_MAX_CHAR_LITERAL_LEN 108
#define SQL_MAX_DSN_LENGTH 32
#define SQL_MAX_LENGTH 3
#define SQL_MAX_LENGTH_DEFAULT 0UL
#define SQL_MAX_OPTION_STRING_LENGTH 256
#define SQL_MAX_OWNER_NAME_LEN 32
#define SQL_MAX_PROCEDURE_NAME_LEN 33
#define SQL_MAX_QUALIFIER_NAME_LEN 34
#define SQL_MAX_ROW_SIZE_INCLUDES_LONG 103
#define SQL_MAX_ROWS 1
#define SQL_MAX_ROWS_DEFAULT 0UL
#define SQL_MODE_DEFAULT SQL_MODE_READ_WRITE
#define SQL_MODE_READ_ONLY 1UL
#define SQL_MODE_READ_WRITE 0UL
#define SQL_MULT_RESULT_SETS 36
#define SQL_MULTIPLE_ACTIVE_TXN 37
#define SQL_NC_END 0x0004
#define SQL_NC_START 0x0002
#define SQL_NEED_LONG_DATA_LEN 111
#define SQL_NNC_NON_NULL 0x0001
#define SQL_NNC_NULL 0x0000
#define SQL_NO_TOTAL (-4)
#define SQL_NON_NULLABLE_COLUMNS 75
#define SQL_NOSCAN 2
#define SQL_NOSCAN_DEFAULT SQL_NOSCAN_OFF
#define SQL_NOSCAN_OFF 0UL
#define SQL_NOSCAN_ON 1UL
#define SQL_NUMERIC_FUNCTIONS 49
#define SQL_OAC_LEVEL1 0x0001
#define SQL_OAC_LEVEL2 0x0002
#define SQL_OAC_NONE 0x0000
#define SQL_ODBC_API_CONFORMANCE 9
#define SQL_ODBC_CURSORS 110
#define SQL_ODBC_SAG_CLI_CONFORMANCE 12
#define SQL_ODBC_SQL_CONFORMANCE 15
#define SQL_ODBC_SQL_OPT_IEF 73
#define SQL_ODBC_VER 10
#define SQL_OPT_TRACE 104
#define SQL_OPT_TRACE_DEFAULT SQL_OPT_TRACE_OFF
#define SQL_OPT_TRACE_FILE_DEFAULT "\\SQL.LOG"
#define SQL_OPT_TRACE_OFF 0UL
#define SQL_OPT_TRACE_ON 1UL
#define SQL_OPT_TRACEFILE 105
#define SQL_OSC_CORE 1
#define SQL_OSC_EXTENDED 2
#define SQL_OSC_MINIMUM 0
#define SQL_OSCC_COMPLIANT 1
#define SQL_OSCC_NOT_COMPLIANT 0
#define SQL_OU_DML_STATEMENTS 1
#define SQL_OU_INDEX_DEFINITION 8
#define SQL_OU_PRIVILEGE_DEFINITION 16
#define SQL_OU_PROCEDURE_INVOCATION 2
#define SQL_OU_TABLE_DEFINITION 4
#define SQL_OUTER_JOINS 38
#define SQL_OWNER_TERM 39
#define SQL_OWNER_USAGE 91
#define SQL_PACKET_SIZE 112
#define SQL_PARAM_INPUT 1
#define SQL_PARAM_INPUT_OUTPUT 2
#define SQL_PARAM_OUTPUT 4
#define SQL_PARAM_TYPE_DEFAULT SQL_PARAM_INPUT_OUTPUT
#define SQL_PARAM_TYPE_UNKNOWN 0
#define SQL_PC_NOT_PSEUDO 1
#define SQL_POS_ADD 16
#define SQL_POS_DELETE 8
#define SQL_POS_OPERATIONS 79
#define SQL_POS_POSITION 1
#define SQL_POS_REFRESH 2
#define SQL_POS_UPDATE 4
#define SQL_POSITION 0
#define SQL_POSITIONED_STATEMENTS 80
#define SQL_PRED_SEARCHABLE SQL_SEARCHABLE
#define SQL_PROCEDURE_TERM 40
#define SQL_PROCEDURES 21
#define SQL_PS_POSITIONED_DELETE 1
#define SQL_PS_POSITIONED_UPDATE 2
#define SQL_PS_SELECT_FOR_UPDATE 4
#define SQL_PT_FUNCTION 2
#define SQL_PT_PROCEDURE 1
#define SQL_PT_UNKNOWN 0
#define SQL_QL_END 0x0002
#define SQL_QL_START 0x0001
#define SQL_QU_DML_STATEMENTS 1
#define SQL_QU_INDEX_DEFINITION 8
#define SQL_QU_PRIVILEGE_DEFINITION 16
#define SQL_QU_PROCEDURE_INVOCATION 2
#define SQL_QU_TABLE_DEFINITION 4
#define SQL_QUALIFIER_LOCATION 114
#define SQL_QUALIFIER_NAME_SEPARATOR 41
#define SQL_QUALIFIER_TERM 42
#define SQL_QUALIFIER_USAGE 92
#define SQL_QUERY_TIMEOUT 0
#define SQL_QUERY_TIMEOUT_DEFAULT 0UL
#define SQL_QUICK 0
#define SQL_QUIET_MODE 111
#define SQL_QUOTED_IDENTIFIER_CASE 93
#define SQL_RD_DEFAULT SQL_RD_ON
#define SQL_RD_OFF 0UL
#define SQL_RD_ON 1UL
#define SQL_REFRESH 1
#define SQL_RESTRICT 1
#define SQL_RESULT_COL 3
#define SQL_RETRIEVE_DATA 11
#define SQL_RETURN_VALUE 5
#define SQL_ROW_ADDED 4
#define SQL_ROW_DELETED 1
#define SQL_ROW_ERROR 5
#define SQL_ROW_NOROW 3
#define SQL_ROW_NUMBER 14
#define SQL_ROW_SUCCESS 0
#define SQL_ROW_UPDATED 2
#define SQL_ROW_UPDATES 11
#define SQL_ROWSET_SIZE 9
#define SQL_ROWSET_SIZE_DEFAULT 1UL
#define SQL_ROWVER 2
#define SQL_SC_NON_UNIQUE 0UL
#define SQL_SC_TRY_UNIQUE 1UL
#define SQL_SC_UNIQUE 2UL
#define SQL_SCCO_OPT_TIMESTAMP SQL_SCCO_OPT_ROWVER /* deprecated */ 
#define SQL_SCROLL_DYNAMIC (-2L) /* deprecated */   
#define SQL_SCROLL_FORWARD_ONLY 0L /* deprecated */   
#define SQL_SCROLL_KEYSET_DRIVEN (-1L) /* deprecated */   
#define SQL_SCROLL_OPTIONS 44
#define SQL_SCROLL_STATIC (-3L) /* deprecated */   
#define SQL_SEARCHABLE 3
#define SQL_SET_NULL 2
#define SQL_SETPARAM_VALUE_MAX (-1L)
#define SQL_SETPOS_MAX_LOCK_VALUE SQL_LOCK_UNLOCK
#define SQL_SETPOS_MAX_OPTION_VALUE SQL_ADD
#define SQL_SIGNED_OFFSET (-20)
#define SQL_SIMULATE_CURSOR 10
#define SQL_SO_DYNAMIC 4
#define SQL_SO_FORWARD_ONLY 1
#define SQL_SO_KEYSET_DRIVEN 2
#define SQL_SO_MIXED 8
#define SQL_SO_STATIC 16
#define SQL_SQ_COMPARISON 1
#define SQL_SQ_CORRELATED_SUBQUERIES 16
#define SQL_SQ_EXISTS 2
#define SQL_SQ_IN 4
#define SQL_SQ_QUANTIFIED 8
#define SQL_SQLSTATE_SIZE 5
#define SQL_SS_ADDITIONS 1
#define SQL_SS_DELETIONS 2
#define SQL_SS_UPDATES 4
#define SQL_STATIC_SENSITIVITY 83
#define SQL_STRING_FUNCTIONS 50
#define SQL_SUBQUERIES 95
#define SQL_SYSTEM_FUNCTIONS 51
#define SQL_TABLE_STAT 0
#define SQL_TABLE_TERM 45
#define SQL_TIME 10
#define SQL_TIMEDATE_ADD_INTERVALS 109
#define SQL_TIMEDATE_DIFF_INTERVALS 110
#define SQL_TIMEDATE_FUNCTIONS 52
#define SQL_TIMESTAMP 11
#define SQL_TINYINT (-6)
#define SQL_TRANSLATE_DLL 106
#define SQL_TRANSLATE_OPTION 107
#define SQL_TXN_ISOLATION 108
#define SQL_TXN_VERSIONING 16
#define SQL_TYPE_NULL 0
#define SQL_U_UNION 1
#define SQL_U_UNION_ALL 2
#define SQL_UB_DEFAULT SQL_UB_OFF
#define SQL_UB_OFF 0UL
#define SQL_UB_ON 01UL
#define SQL_UNION 96
#define SQL_UNSEARCHABLE 0
#define SQL_UNSIGNED_OFFSET (-22)
#define SQL_UPDATE 2 
#define SQL_USE_BOOKMARKS 12
#define SQL_VARBINARY (-3)
#define SQL_POSITION_TO(s,r) SQLSetPos(s,r,SQL_POSITION,SQL_LOCK_NO_CHANGE)
#define SQL_LOCK_RECORD(s,r,l) SQLSetPos(s,r,SQL_POSITION,l)
#define SQL_REFRESH_RECORD(s,r,l) SQLSetPos(s,r,SQL_REFRESH,l)
#define SQL_UPDATE_RECORD(s,r) SQLSetPos(s,r,SQL_UPDATE,SQL_LOCK_NO_CHANGE)
#define SQL_DELETE_RECORD(s,r) SQLSetPos(s,r,SQL_DELETE,SQL_LOCK_NO_CHANGE)
#define SQL_ADD_RECORD(s,r) SQLSetPos(s,r,SQL_ADD,SQL_LOCK_NO_CHANGE)

#if (ODBCVER < 0x0300)
#define SQL_CONNECT_OPT_DRVR_START 1000
#define SQL_CONN_OPT_MAX SQL_PACKET_SIZE
#define SQL_CONN_OPT_MIN SQL_ACCESS_MODE
#define SQL_STMT_OPT_MAX SQL_ROW_NUMBER
#define SQL_STMT_OPT_MIN SQL_QUERY_TIMEOUT
#define SQL_TYPE_DRIVER_START SQL_INTERVAL_YEAR
#define SQL_TYPE_DRIVER_END SQL_UNICODE_LONGVARCHAR
#define SQL_TYPE_MIN SQL_BIT
#define SQL_TYPE_MAX SQL_VARCHAR
#endif

#if (ODBCVER < 0x0300)
#define SQL_NO_DATA_FOUND 100
#define SQL_INTERVAL_YEAR (-80)
#define SQL_INTERVAL_MONTH (-81)
#define SQL_INTERVAL_YEAR_TO_MONTH (-82)
#define SQL_INTERVAL_DAY (-83)
#define SQL_INTERVAL_HOUR (-84)
#define SQL_INTERVAL_MINUTE (-85)
#define SQL_INTERVAL_SECOND (-86)
#define SQL_INTERVAL_DAY_TO_HOUR (-87)
#define SQL_INTERVAL_DAY_TO_MINUTE (-88)
#define SQL_INTERVAL_DAY_TO_SECOND (-89)
#define SQL_INTERVAL_HOUR_TO_MINUTE (-90)
#define SQL_INTERVAL_HOUR_TO_SECOND (-91)
#define SQL_INTERVAL_MINUTE_TO_SECOND (-92)
#else  
#define SQL_NO_DATA_FOUND SQL_NO_DATA
#define SQL_CODE_YEAR 1
#define SQL_CODE_MONTH 2
#define SQL_CODE_DAY 3
#define SQL_CODE_HOUR 4
#define SQL_CODE_MINUTE 5
#define SQL_CODE_SECOND 6
#define SQL_CODE_YEAR_TO_MONTH 7
#define SQL_CODE_DAY_TO_HOUR 8
#define SQL_CODE_DAY_TO_MINUTE 9
#define SQL_CODE_DAY_TO_SECOND 10
#define SQL_CODE_HOUR_TO_MINUTE 11
#define SQL_CODE_HOUR_TO_SECOND 12
#define SQL_CODE_MINUTE_TO_SECOND 13
#define SQL_INTERVAL_YEAR (100 + SQL_CODE_YEAR)
#define SQL_INTERVAL_MONTH (100 + SQL_CODE_MONTH)
#define SQL_INTERVAL_DAY (100 + SQL_CODE_DAY)
#define SQL_INTERVAL_HOUR (100 + SQL_CODE_HOUR)
#define SQL_INTERVAL_MINUTE (100 + SQL_CODE_MINUTE)
#define SQL_INTERVAL_SECOND (100 + SQL_CODE_SECOND)
#define SQL_INTERVAL_YEAR_TO_MONTH (100 + SQL_CODE_YEAR_TO_MONTH)  
#define SQL_INTERVAL_DAY_TO_HOUR (100 + SQL_CODE_DAY_TO_HOUR)
#define SQL_INTERVAL_DAY_TO_MINUTE (100 + SQL_CODE_DAY_TO_MINUTE)
#define SQL_INTERVAL_DAY_TO_SECOND (100 + SQL_CODE_DAY_TO_SECOND)
#define SQL_INTERVAL_HOUR_TO_MINUTE (100 + SQL_CODE_HOUR_TO_MINUTE)
#define SQL_INTERVAL_HOUR_TO_SECOND (100 + SQL_CODE_HOUR_TO_SECOND)
#define SQL_INTERVAL_MINUTE_TO_SECOND (100 + SQL_CODE_MINUTE_TO_SECOND)
#endif

#if (ODBCVER <= 0x0300)
#define SQL_UNICODE (-95)
#define SQL_UNICODE_VARCHAR (-96)
#define SQL_UNICODE_LONGVARCHAR (-97)
#define SQL_UNICODE_CHAR SQL_UNICODE
#else
#define SQL_UNICODE SQL_WCHAR
#define SQL_UNICODE_VARCHAR SQL_WVARCHAR
#define SQL_UNICODE_LONGVARCHAR SQL_WLONGVARCHAR
#define SQL_UNICODE_CHAR SQL_WCHAR
#endif

#if (ODBCVER >= 0x0201) && (ODBCVER < 0x0300) 
#define SQL_OJ_CAPABILITIES 65003  
#endif /* ODBCVER < 0x0300 */

#if (ODBCVER >= 0x0250)
#define SQL_NO_ACTION 3
#define SQL_SET_DEFAULT 4
#endif /* ODBCVER >= 0x0250 */

#if (ODBCVER >= 0x0300)
#define SQL_ACTIVE_ENVIRONMENTS 116
#define SQL_AD_ADD_CONSTRAINT_DEFERRABLE 0x00000080L
#define SQL_AD_ADD_CONSTRAINT_INITIALLY_DEFERRED 0x00000020L
#define SQL_AD_ADD_CONSTRAINT_INITIALLY_IMMEDIATE 0x00000040L
#define SQL_AD_ADD_CONSTRAINT_NON_DEFERRABLE 0x00000100L
#define SQL_AD_ADD_DOMAIN_CONSTRAINT 0x00000002L
#define SQL_AD_ADD_DOMAIN_DEFAULT 0x00000008L
#define SQL_AD_CONSTRAINT_NAME_DEFINITION 0x00000001L
#define SQL_AD_DROP_DOMAIN_CONSTRAINT 0x00000004L
#define SQL_AD_DROP_DOMAIN_DEFAULT 0x00000010L
#define SQL_AF_ALL 0x00000040L
#define SQL_AF_AVG 0x00000001L
#define SQL_AF_COUNT 0x00000002L
#define SQL_AF_DISTINCT 0x00000020L
#define SQL_AF_MAX 0x00000004L
#define SQL_AF_MIN 0x00000008L
#define SQL_AF_SUM 0x00000010L
#define SQL_AGGREGATE_FUNCTIONS 169
#define SQL_ALL_CATALOGS "%"
#define SQL_ALL_SCHEMAS "%"
#define SQL_ALL_TABLE_TYPES "%"
#define SQL_ALTER_DOMAIN 117
#define SQL_AM_CONNECTION 1
#define SQL_AM_NONE 0
#define SQL_AM_STATEMENT 2
#define SQL_API_ODBC3_ALL_FUNCTIONS 999
#define SQL_API_ODBC3_ALL_FUNCTIONS_SIZE 250
#define SQL_API_SQLALLOCHANDLESTD 73
#define SQL_API_SQLBULKOPERATIONS 24
#define SQL_ASYNC_MODE 10021