'' '' '' sqlext -- header translated with help of SWIG FB wrapper '' '' NOTICE: This file is part of the FreeBASIC Compiler package and can't '' be included in other distributions without authorization. '' '' #ifndef __sqlext_bi__ #define __sqlext_bi__ #include once "win/sql.bi" #define SQL_SPEC_MAJOR 3 #define SQL_SPEC_MINOR 51 #define SQL_SPEC_STRING "03.51" #define SQL_ACCESS_MODE 101 #define SQL_ACTIVE_CONNECTIONS 0 #define SQL_ACTIVE_STATEMENTS 1 #define SQL_ADD 4 #define SQL_ALL_EXCEPT_LIKE 2 #define SQL_API_ALL_FUNCTIONS 0 #define SQL_API_LOADBYORDINAL 199 #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 #define SQL_ASYNC_ENABLE 4 #define SQL_ASYNC_ENABLE_OFF 0UL #define SQL_ASYNC_ENABLE_ON 1UL #define SQL_ASYNC_ENABLE_DEFAULT SQL_ASYNC_ENABLE_OFF #define SQL_ATTR_CONNECTION_DEAD 1209 #define SQL_ATTR_READONLY 0 #define SQL_ATTR_READWRITE_UNKNOWN 2 #define SQL_ATTR_WRITE 1 #define SQL_AUTOCOMMIT 102 #define SQL_AUTOCOMMIT_DEFAULT SQL_AUTOCOMMIT_ON #define SQL_AUTOCOMMIT_OFF 0UL #define SQL_AUTOCOMMIT_ON 1UL #define SQL_BEST_ROWID 1 #define SQL_BIGINT (-5) #define SQL_BINARY (-2) #define SQL_BIND_BY_COLUMN 0UL #define SQL_BIND_TYPE 5 #define SQL_BIND_TYPE_DEFAULT SQL_BIND_BY_COLUMN #define SQL_BIT (-7) #define SQL_BOOKMARK_PERSISTENCE 82 #define SQL_BP_CLOSE 1 #define SQL_BP_DELETE 2 #define SQL_BP_DROP 4 #define SQL_BP_OTHER_HSTMT 32 #define SQL_BP_SCROLL 64 #define SQL_BP_TRANSACTION 8 #define SQL_BP_UPDATE 16 #define SQL_C_BINARY SQL_BINARY #define SQL_C_BIT SQL_BIT #define SQL_C_BOOKMARK SQL_C_ULONG #define SQL_C_CHAR SQL_CHAR #define SQL_C_DATE SQL_DATE #define SQL_C_DEFAULT 99 #define SQL_C_DOUBLE SQL_DOUBLE #define SQL_C_FLOAT SQL_REAL #define SQL_C_LONG SQL_INTEGER #define SQL_C_SHORT SQL_SMALLINT #define SQL_C_SLONG (SQL_C_LONG+SQL_SIGNED_OFFSET) #define SQL_C_SSHORT (SQL_C_SHORT+SQL_SIGNED_OFFSET) #define SQL_C_STINYINT (SQL_TINYINT+SQL_SIGNED_OFFSET) #define SQL_C_TIME SQL_TIME #define SQL_C_TIMESTAMP SQL_TIMESTAMP #define SQL_C_TINYINT SQL_TINYINT #define SQL_C_ULONG (SQL_C_LONG+SQL_UNSIGNED_OFFSET) #define SQL_C_USHORT (SQL_C_SHORT+SQL_UNSIGNED_OFFSET) #define SQL_C_UTINYINT (SQL_TINYINT+SQL_UNSIGNED_OFFSET) #define SQL_CASCADE 0 #define SQL_CB_NON_NULL 1 #define SQL_CB_NULL 0 #define SQL_CC_CLOSE 1 #define SQL_CC_DELETE 0 #define SQL_CC_PRESERVE 2 #define SQL_CD_FALSE 0L #define SQL_CD_TRUE 1L #define SQL_CN_ANY 2 #define SQL_CN_DIFFERENT 1 #define SQL_CN_NONE 0 #define SQL_COLATT_OPT_MAX SQL_COLUMN_LABEL #define SQL_COLATT_OPT_MIN SQL_COLUMN_COUNT #define SQL_COLUMN_ALIAS 87 #define SQL_COLUMN_AUTO_INCREMENT 11 #define SQL_COLUMN_CASE_SENSITIVE 12 #define SQL_COLUMN_COUNT 0 #define SQL_COLUMN_DISPLAY_SIZE 6 #define SQL_COLUMN_LABEL 18 #define SQL_COLUMN_LENGTH 3 #define SQL_COLUMN_MONEY 9 #define SQL_COLUMN_NAME 1 #define SQL_COLUMN_NULLABLE 7 #define SQL_COLUMN_OWNER_NAME 16 #define SQL_COLUMN_PRECISION 4 #define SQL_COLUMN_QUALIFIER_NAME 17 #define SQL_COLUMN_SCALE 5 #define SQL_COLUMN_SEARCHABLE 13 #define SQL_COLUMN_TABLE_NAME 15 #define SQL_COLUMN_TYPE 2 #define SQL_COLUMN_TYPE_NAME 14 #define SQL_COLUMN_UNSIGNED 8 #define SQL_COLUMN_UPDATABLE 10 #define SQL_CONCAT_NULL_BEHAVIOR 22 #define SQL_CONCUR_DEFAULT SQL_CONCUR_READ_ONLY #define SQL_CONCUR_LOCK 2 #define SQL_CONCUR_READ_ONLY 1 #define SQL_CONCUR_ROWVER 3 #define SQL_CONCUR_TIMESTAMP 3 #define SQL_CONCUR_VALUES 4 #define SQL_CONCURRENCY 7 #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_FUNCTIONS 48 #define SQL_CONVERT_INTEGER 61 #define SQL_CONVERT_LONGVARBINARY 71 #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_CORRELATION_NAME 74 #define SQL_CR_CLOSE 1 #define SQL_CR_DELETE 0 #define SQL_CR_PRESERVE 2 #define SQL_CUR_DEFAULT SQL_CUR_USE_DRIVER #define SQL_CUR_USE_DRIVER 2UL #define SQL_CUR_USE_IF_NEEDED 0UL #define SQL_CUR_USE_ODBC 1UL #define SQL_CURRENT_QUALIFIER 109 #define SQL_CURSOR_DYNAMIC 2UL #define SQL_CURSOR_FORWARD_ONLY 0UL #define SQL_CURSOR_KEYSET_DRIVEN 1UL #define SQL_CURSOR_ROLLBACK_BEHAVIOR 24 #define SQL_CURSOR_STATIC 3UL #define SQL_CURSOR_TYPE 6 #define SQL_CURSOR_TYPE_DEFAULT 0UL #define SQL_CV_CASCADED &h00000004L #define SQL_CV_CHECK_OPTION &h00000002L #define SQL_CV_CREATE_VIEW &h00000001L #define SQL_CV_LOCAL &h00000008L #define SQL_CVT_BIGINT &h00004000L #define SQL_CVT_BINARY &h00000400L #define SQL_CVT_BIT &h00001000L #define SQL_CVT_CHAR &h00000001L #define SQL_CVT_DATE &h00008000L #define SQL_CVT_DECIMAL &h00000004L #define SQL_CVT_DOUBLE &h00000080L #define SQL_CVT_FLOAT &h00000020L #define SQL_CVT_INTEGER &h00000008L #define SQL_CVT_LONGVARBINARY &h00040000L #define SQL_CVT_LONGVARCHAR &h00000200L #define SQL_CVT_NUMERIC &h00000002L #define SQL_CVT_REAL &h00000040L #define SQL_CVT_SMALLINT &h00000010L #define SQL_CVT_TIME &h00010000L #define SQL_CVT_TIMESTAMP &h00020000L #define SQL_CVT_TINYINT &h00002000L #define SQL_CVT_VARBINARY &h00000800L #define SQL_CVT_VARCHAR &h00000100L #define SQL_DATABASE_NAME 16 #define SQL_DATE 9 #define SQL_DEFAULT_PARAM (-5) #define SQL_DELETE 3 #define SQL_DRIVER_COMPLETE 1 #define SQL_DRIVER_COMPLETE_REQUIRED 3 #define SQL_DRIVER_HDBC 3 #define SQL_DRIVER_HENV 4 #define SQL_DRIVER_HLIB 76 #define SQL_DRIVER_HSTMT 5 #define SQL_DRIVER_NAME 6 #define SQL_DRIVER_NOPROMPT 0 #define SQL_DRIVER_ODBC_VER 77 #define SQL_DRIVER_PROMPT 2 #define SQL_DRIVER_VER 7 #define SQL_DTC_ENLIST_EXPENSIVE 1 #define SQL_DTC_TRANSITION_COST 1750 #define SQL_DTC_UNENLIST_EXPENSIVE 2 #define SQL_ENSURE 1 #define SQL_ENTIRE_ROWSET 0 #define SQL_EXPRESSIONS_IN_ORDERBY 27 #define SQL_FD_FETCH_BOOKMARK 128 #define SQL_FD_FETCH_PREV 8 #define SQL_FD_FETCH_RESUME 64 #define SQL_FETCH_BOOKMARK 8 #define SQL_FETCH_PREV 4 #define SQL_FETCH_RESUME 7 #define SQL_FILE_CATALOG SQL_FILE_QUALIFIER #define SQL_FILE_NOT_SUPPORTED &h0000 #define SQL_FILE_QUALIFIER &h0002 #define SQL_FILE_TABLE &h0001 #define SQL_FILE_USAGE 84 #define SQL_FN_CVT_CONVERT &h00000001L #define SQL_FN_NUM_ABS &h00000001L #define SQL_FN_NUM_ACOS &h00000002L #define SQL_FN_NUM_ASIN &h00000004L #define SQL_FN_NUM_ATAN &h00000008L #define SQL_FN_NUM_ATAN2 &h00000010L #define SQL_FN_NUM_CEILING &h00000020L #define SQL_FN_NUM_COS &h00000040L #define SQL_FN_NUM_COT &h00000080L #define SQL_FN_NUM_DEGREES &h00040000L #define SQL_FN_NUM_EXP &h00000100L #define SQL_FN_NUM_FLOOR &h00000200L #define SQL_FN_NUM_LOG &h00000400L #define SQL_FN_NUM_LOG10 &h00080000L #define SQL_FN_NUM_MOD &h00000800L #define SQL_FN_NUM_PI &h00010000L #define SQL_FN_NUM_POWER &h00100000L #define SQL_FN_NUM_RADIANS &h00200000L #define SQL_FN_NUM_RAND &h00020000L #define SQL_FN_NUM_ROUND &h00400000L #define SQL_FN_NUM_SIGN &h00001000L #define SQL_FN_NUM_SIN &h00002000L #define SQL_FN_NUM_SQRT &h00004000L #define SQL_FN_NUM_TAN &h00008000L #define SQL_FN_NUM_TRUNCATE &h00800000L #define SQL_FN_STR_ASCII &h00002000L #define SQL_FN_STR_CHAR &h00004000L #define SQL_FN_STR_CONCAT &h00000001L #define SQL_FN_STR_DIFFERENCE &h00008000L #define SQL_FN_STR_INSERT &h00000002L #define SQL_FN_STR_LCASE &h00000040L #define SQL_FN_STR_LEFT &h00000004L #define SQL_FN_STR_LENGTH &h00000010L #define SQL_FN_STR_LOCATE &h00000020L #define SQL_FN_STR_LOCATE_2 &h00010000L #define SQL_FN_STR_LTRIM &h00000008L #define SQL_FN_STR_REPEAT &h00000080L #define SQL_FN_STR_REPLACE &h00000100L #define SQL_FN_STR_RIGHT &h00000200L #define SQL_FN_STR_RTRIM &h00000400L #define SQL_FN_STR_SOUNDEX &h00020000L #define SQL_FN_STR_SPACE &h00040000L #define SQL_FN_STR_SUBSTRING &h00000800L #define SQL_FN_STR_UCASE &h00001000L #define SQL_FN_SYS_DBNAME &h00000002L #define SQL_FN_SYS_IFNULL &h00000004L #define SQL_FN_SYS_USERNAME &h00000001L #define SQL_FN_TD_CURDATE &h00000002L #define SQL_FN_TD_CURTIME &h00000200L #define SQL_FN_TD_DAYNAME &h00008000L #define SQL_FN_TD_DAYOFMONTH &h00000004L #define SQL_FN_TD_DAYOFWEEK &h00000008L #define SQL_FN_TD_DAYOFYEAR &h00000010L #define SQL_FN_TD_HOUR &h00000400L #define SQL_FN_TD_MINUTE &h00000800L #define SQL_FN_TD_MONTH &h00000020L #define SQL_FN_TD_MONTHNAME &h00010000L #define SQL_FN_TD_NOW &h00000001L #define SQL_FN_TD_QUARTER &h00000040L #define SQL_FN_TD_SECOND &h00001000L #define SQL_FN_TD_TIMESTAMPADD &h00002000L #define SQL_FN_TD_TIMESTAMPDIFF &h00004000L #define SQL_FN_TD_WEEK &h00000080L #define SQL_FN_TD_YEAR &h00000100L #define SQL_FN_TSI_DAY &h00000010L #define SQL_FN_TSI_FRAC_SECOND &h00000001L #define SQL_FN_TSI_HOUR &h00000008L #define SQL_FN_TSI_MINUTE &h00000004L #define SQL_FN_TSI_MONTH &h00000040L #define SQL_FN_TSI_QUARTER &h00000080L #define SQL_FN_TSI_SECOND &h00000002L #define SQL_FN_TSI_WEEK &h00000020L #define SQL_FN_TSI_YEAR &h00000100L #define SQL_GB_GROUP_BY_CONTAINS_SELECT 2 #define SQL_GB_GROUP_BY_EQUALS_SELECT 1 #define SQL_GB_NO_RELATION 3 #define SQL_GB_NOT_SUPPORTED 0 #define SQL_GD_BLOCK 4 #define SQL_GD_BOUND 8 #define SQL_GET_BOOKMARK 13 #define SQL_GROUP_BY 88 #define SQL_IGNORE (-6) #define SQL_INFO_FIRST 0 #define SQL_KEYSET_SIZE 8 #define SQL_KEYSET_SIZE_DEFAULT 0UL #define SQL_KEYWORDS 89 #define SQL_LCK_EXCLUSIVE 2 #define SQL_LCK_NO_CHANGE 1 #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 &h0004 #define SQL_NC_START &h0002 #define SQL_NEED_LONG_DATA_LEN 111 #define SQL_NNC_NON_NULL &h0001 #define SQL_NNC_NULL &h0000 #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 &h0001 #define SQL_OAC_LEVEL2 &h0002 #define SQL_OAC_NONE &h0000 #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 2 #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_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 &h0002 #define SQL_QL_START &h0001 #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_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 4 #define SQL_SCROLL_DYNAMIC (-2L) #define SQL_SCROLL_FORWARD_ONLY 0L #define SQL_SCROLL_KEYSET_DRIVEN (-1L) #define SQL_SCROLL_OPTIONS 44 #define SQL_SCROLL_STATIC (-3L) #define SQL_SEARCHABLE 3 #define SQL_SET_NULL 2 #define SQL_SETPARAM_VALUE_MAX (-1L) #define SQL_SETPOS_MAX_LOCK_VALUE 2 #define SQL_SETPOS_MAX_OPTION_VALUE 4 #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_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) #define SQL_NO_DATA_FOUND 100 #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+6) #define SQL_INTERVAL_MONTH (100+7) #define SQL_INTERVAL_DAY (100+8) #define SQL_INTERVAL_HOUR (100+9) #define SQL_INTERVAL_MINUTE (100+10) #define SQL_INTERVAL_SECOND (100+11) #define SQL_INTERVAL_YEAR_TO_MONTH (100+12) #define SQL_INTERVAL_DAY_TO_HOUR (100+13) #define SQL_INTERVAL_DAY_TO_MINUTE (100+9) #define SQL_INTERVAL_DAY_TO_SECOND (100+10) #define SQL_INTERVAL_HOUR_TO_MINUTE (100+11) #define SQL_INTERVAL_HOUR_TO_SECOND (100+12) #define SQL_INTERVAL_MINUTE_TO_SECOND (100+13) #define SQL_NO_ACTION 3 #define SQL_SET_DEFAULT 4 #define SQL_ACTIVE_ENVIRONMENTS 116 #define SQL_AD_ADD_CONSTRAINT_DEFERRABLE &h00000080L #define SQL_AD_ADD_CONSTRAINT_INITIALLY_DEFERRED &h00000020L #define SQL_AD_ADD_CONSTRAINT_INITIALLY_IMMEDIATE &h00000040L #define SQL_AD_ADD_CONSTRAINT_NON_DEFERRABLE &h00000100L #define SQL_AD_ADD_DOMAIN_CONSTRAINT &h00000002L #define SQL_AD_ADD_DOMAIN_DEFAULT &h00000008L #define SQL_AD_CONSTRAINT_NAME_DEFINITION &h00000001L #define SQL_AD_DROP_DOMAIN_CONSTRAINT &h00000004L #define SQL_AD_DROP_DOMAIN_DEFAULT &h00000010L #define SQL_AF_ALL &h00000040L #define SQL_AF_AVG &h00000001L #define SQL_AF_COUNT &h00000002L #define SQL_AF_DISTINCT &h00000020L #define SQL_AF_MAX &h00000004L #define SQL_AF_MIN &h00000008L #define SQL_AF_SUM &h00000010L #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 #define SQL_AT_ADD_COLUMN_COLLATION &h00000080L #define SQL_AT_ADD_COLUMN_DEFAULT &h00000040L #define SQL_AT_ADD_COLUMN_SINGLE &h00000020L #define SQL_AT_ADD_TABLE_CONSTRAINT &h00001000L #define SQL_AT_CONSTRAINT_DEFERRABLE &h00040000L #define SQL_AT_CONSTRAINT_INITIALLY_DEFERRED &h00010000L #define SQL_AT_CONSTRAINT_INITIALLY_IMMEDIATE &h00020000L #define SQL_AT_CONSTRAINT_NAME_DEFINITION &h00008000L #define SQL_AT_CONSTRAINT_NON_DEFERRABLE &h00080000L #define SQL_AT_DROP_COLUMN_CASCADE &h00000400L #define SQL_AT_DROP_COLUMN_DEFAULT &h00000200L #define SQL_AT_DROP_COLUMN_RESTRICT &h00000800L #define SQL_AT_DROP_TABLE_CONSTRAINT_CASCADE &h00002000L #define SQL_AT_DROP_TABLE_CONSTRAINT_RESTRICT &h00004000L #define SQL_AT_SET_COLUMN_DEFAULT &h00000100L #define SQL_ATTR_ACCESS_MODE 101 #define SQL_ATTR_ASYNC_ENABLE 4 #define SQL_ATTR_AUTOCOMMIT 102 #define SQL_ATTR_CONCURRENCY 7 #define SQL_ATTR_CONNECTION_POOLING 201 #define SQL_ATTR_CONNECTION_TIMEOUT 113 #define SQL_ATTR_CP_MATCH 202 #define SQL_ATTR_CURRENT_CATALOG 109 #define SQL_ATTR_CURSOR_TYPE 6 #define SQL_ATTR_DISCONNECT_BEHAVIOR 114 #define SQL_ATTR_ENABLE_AUTO_IPD 15 #define SQL_ATTR_ENLIST_IN_DTC 1207 #define SQL_ATTR_ENLIST_IN_XA 1208 #define SQL_ATTR_FETCH_BOOKMARK_PTR 16 #define SQL_ATTR_KEYSET_SIZE 8 #define SQL_ATTR_LOGIN_TIMEOUT 103 #define SQL_ATTR_MAX_LENGTH 3 #define SQL_ATTR_MAX_ROWS 1 #define SQL_ATTR_NOSCAN 2 #define SQL_ATTR_ODBC_CURSORS 110 #define SQL_ATTR_ODBC_VERSION 200 #define SQL_ATTR_PACKET_SIZE 112 #define SQL_ATTR_PARAM_BIND_OFFSET_PTR 17 #define SQL_ATTR_PARAM_BIND_TYPE 18 #define SQL_ATTR_PARAM_OPERATION_PTR 19 #define SQL_ATTR_PARAM_STATUS_PTR 20 #define SQL_ATTR_PARAMS_PROCESSED_PTR 21 #define SQL_ATTR_PARAMSET_SIZE 22 #define SQL_ATTR_QUERY_TIMEOUT 0 #define SQL_ATTR_QUIET_MODE 111 #define SQL_ATTR_RETRIEVE_DATA 11 #define SQL_ATTR_ROW_ARRAY_SIZE 27 #define SQL_ATTR_ROW_BIND_OFFSET_PTR 23 #define SQL_ATTR_ROW_BIND_TYPE 5 #define SQL_ATTR_ROW_NUMBER 14 #define SQL_ATTR_ROW_OPERATION_PTR 24 #define SQL_ATTR_ROW_STATUS_PTR 25 #define SQL_ATTR_ROWS_FETCHED_PTR 26 #define SQL_ATTR_SIMULATE_CURSOR 10 #define SQL_ATTR_TRACE 104 #define SQL_ATTR_TRACEFILE 105 #define SQL_ATTR_TRANSLATE_LIB 106 #define SQL_ATTR_TRANSLATE_OPTION 107 #define SQL_ATTR_TXN_ISOLATION 108 #define SQL_ATTR_USE_BOOKMARKS 12 #define SQL_BATCH_ROW_COUNT 120 #define SQL_BATCH_SUPPORT 121 #define SQL_BRC_EXPLICIT &h0000002 #define SQL_BRC_PROCEDURES &h0000001 #define SQL_BRC_ROLLED_UP &h0000004 #define SQL_BS_ROW_COUNT_EXPLICIT &h00000002L #define SQL_BS_ROW_COUNT_PROC &h00000008L #define SQL_BS_SELECT_EXPLICIT &h00000001L #define SQL_BS_SELECT_PROC &h00000004L #define SQL_C_INTERVAL_DAY (100+8) #define SQL_C_INTERVAL_DAY_TO_HOUR (100+13) #define SQL_C_INTERVAL_DAY_TO_MINUTE (100+9) #define SQL_C_INTERVAL_DAY_TO_SECOND (100+10) #define SQL_C_INTERVAL_HOUR (100+9) #define SQL_C_INTERVAL_HOUR_TO_MINUTE (100+11) #define SQL_C_INTERVAL_HOUR_TO_SECOND (100+12) #define SQL_C_INTERVAL_MINUTE (100+10) #define SQL_C_INTERVAL_MINUTE_TO_SECOND (100+13) #define SQL_C_INTERVAL_MONTH (100+7) #define SQL_C_INTERVAL_SECOND (100+11) #define SQL_C_INTERVAL_YEAR (100+6) #define SQL_C_INTERVAL_YEAR_TO_MONTH (100+12) #define SQL_C_NUMERIC 2 #define SQL_C_SBIGINT ((-5) +(-20)) #define SQL_C_TYPE_DATE 91 #define SQL_C_TYPE_TIME 92 #define SQL_C_TYPE_TIMESTAMP 93 #define SQL_C_UBIGINT ((-5) +(-22)) #define SQL_C_VARBOOKMARK (-2) #define SQL_CA_CONSTRAINT_DEFERRABLE &h00000040L #define SQL_CA_CONSTRAINT_INITIALLY_DEFERRED &h00000010L #define SQL_CA_CONSTRAINT_INITIALLY_IMMEDIATE &h00000020L #define SQL_CA_CONSTRAINT_NON_DEFERRABLE &h00000080L #define SQL_CA_CREATE_ASSERTION &h00000001L #define SQL_CA1_ABSOLUTE &h00000002L #define SQL_CA1_BOOKMARK &h00000008L #define SQL_CA1_BULK_ADD &h00010000L #define SQL_CA1_BULK_DELETE_BY_BOOKMARK &h00040000L #define SQL_CA1_BULK_FETCH_BY_BOOKMARK &h00080000L #define SQL_CA1_BULK_UPDATE_BY_BOOKMARK &h00020000L #define SQL_CA1_LOCK_EXCLUSIVE &h00000080L #define SQL_CA1_LOCK_NO_CHANGE &h00000040L #define SQL_CA1_LOCK_UNLOCK &h00000100L #define SQL_CA1_NEXT &h00000001L #define SQL_CA1_POS_DELETE &h00000800L #define SQL_CA1_POS_POSITION &h00000200L #define SQL_CA1_POS_REFRESH &h00001000L #define SQL_CA1_POS_UPDATE &h00000400L #define SQL_CA1_POSITIONED_DELETE &h00004000L #define SQL_CA1_POSITIONED_UPDATE &h00002000L #define SQL_CA1_RELATIVE &h00000004L #define SQL_CA1_SELECT_FOR_UPDATE &h00008000L #define SQL_CA2_CRC_APPROXIMATE &h00002000L #define SQL_CA2_CRC_EXACT &h00001000L #define SQL_CA2_LOCK_CONCURRENCY &h00000002L #define SQL_CA2_MAX_ROWS_CATALOG &h00000800L #define SQL_CA2_MAX_ROWS_DELETE &h00000200L #define SQL_CA2_MAX_ROWS_INSERT &h00000100L #define SQL_CA2_MAX_ROWS_SELECT &h00000080L #define SQL_CA2_MAX_ROWS_UPDATE &h00000400L #define SQL_CA2_OPT_ROWVER_CONCURRENCY &h00000004L #define SQL_CA2_OPT_VALUES_CONCURRENCY &h00000008L #define SQL_CA2_READ_ONLY_CONCURRENCY &h00000001L #define SQL_CA2_SENSITIVITY_ADDITIONS &h00000010L #define SQL_CA2_SENSITIVITY_DELETIONS &h00000020L #define SQL_CA2_SENSITIVITY_UPDATES &h00000040L #define SQL_CA2_SIMULATE_NON_UNIQUE &h00004000L #define SQL_CA2_SIMULATE_TRY_UNIQUE &h00008000L #define SQL_CA2_SIMULATE_UNIQUE &h00010000L #define SQL_CATALOG_LOCATION 114 #define SQL_CATALOG_NAME_SEPARATOR 41 #define SQL_CATALOG_TERM 42 #define SQL_CATALOG_USAGE 92 #define SQL_CCOL_CREATE_COLLATION &h00000001L #define SQL_CCS_COLLATE_CLAUSE &h00000002L #define SQL_CCS_CREATE_CHARACTER_SET &h00000001L #define SQL_CCS_LIMITED_COLLATION &h00000004L #define SQL_CDO_COLLATION &h00000008L #define SQL_CDO_CONSTRAINT &h00000004L #define SQL_CDO_CONSTRAINT_DEFERRABLE &h00000080L #define SQL_CDO_CONSTRAINT_INITIALLY_DEFERRED &h00000020L #define SQL_CDO_CONSTRAINT_INITIALLY_IMMEDIATE &h00000040L #define SQL_CDO_CONSTRAINT_NAME_DEFINITION &h00000010L #define SQL_CDO_CONSTRAINT_NON_DEFERRABLE &h00000100L #define SQL_CDO_CREATE_DOMAIN &h00000001L #define SQL_CDO_DEFAULT &h00000002L #define SQL_CL_END &h0002 #define SQL_CL_START &h0001 #define SQL_COL_PRED_BASIC 2 #define SQL_COL_PRED_CHAR 1 #define SQL_COLUMN_DRIVER_START 1000 #define SQL_COLUMN_IGNORE (-6) #define SQL_COLUMN_NUMBER_UNKNOWN (-2) #define SQL_CONVERT_GUID 173 #define SQL_CONVERT_INTERVAL_DAY_TIME 123 #define SQL_CONVERT_INTERVAL_YEAR_MONTH 124 #define SQL_CONVERT_WCHAR 122 #define SQL_CONVERT_WLONGVARCHAR 125 #define SQL_CONVERT_WVARCHAR 126 #define SQL_CP_OFF 0UL #define SQL_CP_ONE_PER_DRIVER 1UL #define SQL_CP_ONE_PER_HENV 2UL #define SQL_CP_RELAXED_MATCH 1UL #define SQL_CP_STRICT_MATCH 0UL #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_CS_AUTHORIZATION &h00000002L #define SQL_CS_CREATE_SCHEMA &h00000001L #define SQL_CS_DEFAULT_CHARACTER_SET &h00000004L #define SQL_CT_COLUMN_COLLATION &h00000800L #define SQL_CT_COLUMN_CONSTRAINT &h00000200L #define SQL_CT_COLUMN_DEFAULT &h00000400L #define SQL_CT_COMMIT_DELETE &h00000004L #define SQL_CT_COMMIT_PRESERVE &h00000002L #define SQL_CT_CONSTRAINT_DEFERRABLE &h00000080L #define SQL_CT_CONSTRAINT_INITIALLY_DEFERRED &h00000020L #define SQL_CT_CONSTRAINT_INITIALLY_IMMEDIATE &h00000040L #define SQL_CT_CONSTRAINT_NAME_DEFINITION &h00002000L #define SQL_CT_CONSTRAINT_NON_DEFERRABLE &h00000100L #define SQL_CT_CREATE_TABLE &h00000001L #define SQL_CT_GLOBAL_TEMPORARY &h00000008L #define SQL_CT_LOCAL_TEMPORARY &h00000010L #define SQL_CT_TABLE_CONSTRAINT &h00001000L #define SQL_CTR_CREATE_TRANSLATION &h00000001L #define SQL_CU_DML_STATEMENTS 1 #define SQL_CU_INDEX_DEFINITION 8 #define SQL_CU_PRIVILEGE_DEFINITION 16 #define SQL_CU_PROCEDURE_INVOCATION 2 #define SQL_CU_TABLE_DEFINITION 4 #define SQL_CVT_GUID &h1000000L #define SQL_CVT_INTERVAL_DAY_TIME &h00100000L #define SQL_CVT_INTERVAL_YEAR_MONTH &h00080000L #define SQL_CVT_WCHAR &h00200000L #define SQL_CVT_WLONGVARCHAR &h00400000L #define SQL_CVT_WVARCHAR &h00800000L #define SQL_DA_DROP_ASSERTION &h00000001L #define SQL_DATETIME_LITERALS 119 #define SQL_DB_DISCONNECT 1UL #define SQL_DB_RETURN_TO_POOL 0UL #define SQL_DC_DROP_COLLATION &h00000001L #define SQL_DCS_DROP_CHARACTER_SET &h00000001L #define SQL_DD_CASCADE &h00000004L #define SQL_DD_DROP_DOMAIN &h00000001L #define SQL_DD_RESTRICT &h00000002L #define SQL_DDL_INDEX 170 #define SQL_DELETE_BY_BOOKMARK 6 #define SQL_DESC_ARRAY_SIZE 20 #define SQL_DESC_ARRAY_STATUS_PTR 21 #define SQL_DESC_AUTO_UNIQUE_VALUE 11 #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 12 #define SQL_DESC_CATALOG_NAME 17 #define SQL_DESC_CONCISE_TYPE 2 #define SQL_DESC_DATETIME_INTERVAL_PRECISION 26 #define SQL_DESC_DISPLAY_SIZE 6 #define SQL_DESC_FIXED_PREC_SCALE 9 #define SQL_DESC_LABEL 18 #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 #define SQL_DESC_SCHEMA_NAME 16 #define SQL_DESC_SEARCHABLE 13 #define SQL_DESC_TABLE_NAME 15 #define SQL_DESC_TYPE_NAME 14 #define SQL_DESC_UNSIGNED 8 #define SQL_DESC_UPDATABLE 10 #define SQL_DI_CREATE_INDEX &h00000001L #define SQL_DI_DROP_INDEX &h00000002L #define SQL_DIAG_COLUMN_NUMBER (-1247) #define SQL_DIAG_CURSOR_ROW_COUNT (-1249) #define SQL_DIAG_ROW_NUMBER (-1248) #define SQL_DL_SQL92_DATE &h00000001L #define SQL_DL_SQL92_INTERVAL_DAY &h00000020L #define SQL_DL_SQL92_INTERVAL_DAY_TO_HOUR &h00000400L #define SQL_DL_SQL92_INTERVAL_DAY_TO_MINUTE &h00000800L #define SQL_DL_SQL92_INTERVAL_DAY_TO_SECOND &h00001000L #define SQL_DL_SQL92_INTERVAL_HOUR &h00000040L #define SQL_DL_SQL92_INTERVAL_HOUR_TO_MINUTE &h00002000L #define SQL_DL_SQL92_INTERVAL_HOUR_TO_SECOND &h00004000L #define SQL_DL_SQL92_INTERVAL_MINUTE &h00000080L #define SQL_DL_SQL92_INTERVAL_MINUTE_TO_SECOND &h00008000L #define SQL_DL_SQL92_INTERVAL_MONTH &h00000010L #define SQL_DL_SQL92_INTERVAL_SECOND &h00000100L #define SQL_DL_SQL92_INTERVAL_YEAR &h00000008L #define SQL_DL_SQL92_INTERVAL_YEAR_TO_MONTH &h00000200L #define SQL_DL_SQL92_TIME &h00000002L #define SQL_DL_SQL92_TIMESTAMP &h00000004L #define SQL_DM_VER 171 #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_DS_CASCADE &h00000004L #define SQL_DS_DROP_SCHEMA &h00000001L #define SQL_DS_RESTRICT &h00000002L #define SQL_DT_CASCADE &h00000004L #define SQL_DT_DROP_TABLE &h00000001L #define SQL_DT_RESTRICT &h00000002L #define SQL_DTC_DONE 0L #define SQL_DTR_DROP_TRANSLATION &h00000001L #define SQL_DV_CASCADE &h00000004L #define SQL_DV_DROP_VIEW &h00000001L #define SQL_DV_RESTRICT &h00000002L #define SQL_DYNAMIC_CURSOR_ATTRIBUTES1 144 #define SQL_DYNAMIC_CURSOR_ATTRIBUTES2 145 #define SQL_EXT_API_LAST 72 #define SQL_EXT_API_START 40 #define SQL_FETCH_BY_BOOKMARK 7 #define SQL_FETCH_FIRST_SYSTEM 32 #define SQL_FETCH_FIRST_USER 31 #define SQL_FN_CVT_CAST &h00000002L #define SQL_FN_STR_BIT_LENGTH &h00080000L #define SQL_FN_STR_CHAR_LENGTH &h00100000L #define SQL_FN_STR_CHARACTER_LENGTH &h00200000L #define SQL_FN_STR_OCTET_LENGTH &h00400000L #define SQL_FN_STR_POSITION &h00800000L #define SQL_FN_TD_CURRENT_DATE &h00020000L #define SQL_FN_TD_CURRENT_TIME &h00040000L #define SQL_FN_TD_CURRENT_TIMESTAMP &h00080000L #define SQL_FN_TD_EXTRACT &h00100000L #define SQL_FORWARD_ONLY_CURSOR_ATTRIBUTES1 146 #define SQL_FORWARD_ONLY_CURSOR_ATTRIBUTES2 147 #define SQL_FUNC_EXISTS(exists, api) iif( *(cptr(UWORD ptr, exists) + (((api) shr 4) and (1 shr ((api) and 15))), SQL_TRUE, SQL_FALSE ) #define SQL_GB_COLLATE &h0004 #define SQL_HANDLE_SENV 5 #define SQL_IK_ASC 1 #define SQL_IK_DESC 2 #define SQL_IK_NONE 0 #define SQL_INDEX_KEYWORDS 148 #define SQL_INFO_DRIVER_START 1000 #define SQL_INFO_LAST 114 #define SQL_INFO_SCHEMA_VIEWS 149 #define SQL_INITIALLY_DEFERRED 5 #define SQL_INITIALLY_IMMEDIATE 6 #define SQL_INSERT_STATEMENT 172 #define SQL_INTERVAL 10 #define SQL_IS_INSERT_LITERALS &h00000001L #define SQL_IS_INSERT_SEARCHED &h00000002L #define SQL_IS_INTEGER (-6) #define SQL_IS_POINTER (-4) #define SQL_IS_SELECT_INTO &h00000004L #define SQL_IS_SMALLINT (-8) #define SQL_IS_UINTEGER (-5) #define SQL_IS_USMALLINT (-7) #define SQL_ISV_ASSERTIONS &h00000001L #define SQL_ISV_CHARACTER_SETS &h00000002L #define SQL_ISV_CHECK_CONSTRAINTS &h00000004L #define SQL_ISV_COLLATIONS &h00000008L #define SQL_ISV_COLUMN_DOMAIN_USAGE &h00000010L #define SQL_ISV_COLUMN_PRIVILEGES &h00000020L #define SQL_ISV_COLUMNS &h00000040L #define SQL_ISV_CONSTRAINT_COLUMN_USAGE &h00000080L #define SQL_ISV_CONSTRAINT_TABLE_USAGE &h00000100L #define SQL_ISV_DOMAIN_CONSTRAINTS &h00000200L #define SQL_ISV_DOMAINS &h00000400L #define SQL_ISV_KEY_COLUMN_USAGE &h00000800L #define SQL_ISV_REFERENTIAL_CONSTRAINTS &h00001000L #define SQL_ISV_SCHEMATA &h00002000L #define SQL_ISV_SQL_LANGUAGES &h00004000L #define SQL_ISV_TABLE_CONSTRAINTS &h00008000L #define SQL_ISV_TABLE_PRIVILEGES &h00010000L #define SQL_ISV_TABLES &h00020000L #define SQL_ISV_TRANSLATIONS &h00040000L #define SQL_ISV_USAGE_PRIVILEGES &h00080000L #define SQL_ISV_VIEW_COLUMN_USAGE &h00100000L #define SQL_ISV_VIEW_TABLE_USAGE &h00200000L #define SQL_ISV_VIEWS &h00400000L #define SQL_KEYSET_CURSOR_ATTRIBUTES1 150 #define SQL_KEYSET_CURSOR_ATTRIBUTES2 151 #define SQL_MAX_ASYNC_CONCURRENT_STATEMENTS 10022 #define SQL_NO_COLUMN_NUMBER (-1) #define SQL_NO_ROW_NUMBER (-1) #define SQL_NOT_DEFERRABLE 7 #define SQL_NUM_EXTENSIONS (72-40+1) #define SQL_NUM_FUNCTIONS 23 #define SQL_ODBC_INTERFACE_CONFORMANCE 152 #define SQL_OIC_CORE 1UL #define SQL_OIC_LEVEL1 2UL #define SQL_OIC_LEVEL2 3UL #define SQL_OV_ODBC2 2UL #define SQL_OV_ODBC3 3UL #define SQL_PARAM_ARRAY_ROW_COUNTS 153 #define SQL_PARAM_ARRAY_SELECTS 154 #define SQL_PARAM_BIND_BY_COLUMN 0UL #define SQL_PARAM_BIND_TYPE_DEFAULT 0UL #define SQL_PARAM_DIAG_UNAVAILABLE 1 #define SQL_PARAM_ERROR 5 #define SQL_PARAM_IGNORE 1 #define SQL_PARAM_PROCEED 0 #define SQL_PARAM_SUCCESS 0 #define SQL_PARAM_SUCCESS_WITH_INFO 6 #define SQL_PARAM_UNUSED 7 #define SQL_PARC_BATCH 1 #define SQL_PARC_NO_BATCH 2 #define SQL_PAS_BATCH 1 #define SQL_PAS_NO_BATCH 2 #define SQL_PAS_NO_SELECT 3 #define SQL_ROW_IGNORE 1 #define SQL_ROW_NUMBER_UNKNOWN (-2) #define SQL_ROW_PROCEED 0 #define SQL_ROW_SUCCESS_WITH_INFO 6 #define SQL_SC_FIPS127_2_TRANSITIONAL &h00000002L #define SQL_SC_SQL92_ENTRY &h00000001L #define SQL_SC_SQL92_FULL &h00000008L #define SQL_SC_SQL92_INTERMEDIATE &h00000004L #define SQL_SCC_ISO92_CLI &h00000002L #define SQL_SCC_XOPEN_CLI_VERSION1 &h00000001L #define SQL_SCHEMA_TERM 39 #define SQL_SCHEMA_USAGE 91 #define SQL_SDF_CURRENT_DATE &h00000001L #define SQL_SDF_CURRENT_TIME &h00000002L #define SQL_SDF_CURRENT_TIMESTAMP &h00000004L #define SQL_SFKD_CASCADE &h00000001L #define SQL_SFKD_NO_ACTION &h00000002L #define SQL_SFKD_SET_DEFAULT &h00000004L #define SQL_SFKD_SET_NULL &h00000008L #define SQL_SFKU_CASCADE &h00000001L #define SQL_SFKU_NO_ACTION &h00000002L #define SQL_SFKU_SET_DEFAULT &h00000004L #define SQL_SFKU_SET_NULL &h00000008L #define SQL_SG_DELETE_TABLE &h00000020L #define SQL_SG_INSERT_COLUMN &h00000080L #define SQL_SG_INSERT_TABLE &h00000040L #define SQL_SG_REFERENCES_COLUMN &h00000200L #define SQL_SG_REFERENCES_TABLE &h00000100L #define SQL_SG_SELECT_TABLE &h00000400L #define SQL_SG_UPDATE_COLUMN &h00001000L #define SQL_SG_UPDATE_TABLE &h00000800L #define SQL_SG_USAGE_ON_CHARACTER_SET &h00000002L #define SQL_SG_USAGE_ON_COLLATION &h00000004L #define SQL_SG_USAGE_ON_DOMAIN &h00000001L #define SQL_SG_USAGE_ON_TRANSLATION &h00000008L #define SQL_SG_WITH_GRANT_OPTION &h00000010L #define SQL_SNVF_BIT_LENGTH &h00000001L #define SQL_SNVF_CHAR_LENGTH &h00000002L #define SQL_SNVF_CHARACTER_LENGTH &h00000004L #define SQL_SNVF_EXTRACT &h00000008L #define SQL_SNVF_OCTET_LENGTH &h00000010L #define SQL_SNVF_POSITION &h00000020L #define SQL_SP_BETWEEN &h00000800L #define SQL_SP_COMPARISON &h00001000L #define SQL_SP_EXISTS &h00000001L #define SQL_SP_IN &h00000400L #define SQL_SP_ISNOTNULL &h00000002L #define SQL_SP_ISNULL &h00000004L #define SQL_SP_LIKE &h00000200L #define SQL_SP_MATCH_FULL &h00000008L #define SQL_SP_MATCH_PARTIAL &h00000010L #define SQL_SP_MATCH_UNIQUE_FULL &h00000020L #define SQL_SP_MATCH_UNIQUE_PARTIAL &h00000040L #define SQL_SP_OVERLAPS &h00000080L #define SQL_SP_QUANTIFIED_COMPARISON &h00002000L #define SQL_SP_UNIQUE &h00000100L #define SQL_SQL_CONFORMANCE 118 #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_SR_CASCADE &h00000020L #define SQL_SR_DELETE_TABLE &h00000080L #define SQL_SR_GRANT_OPTION_FOR &h00000010L #define SQL_SR_INSERT_COLUMN &h00000200L #define SQL_SR_INSERT_TABLE &h00000100L #define SQL_SR_REFERENCES_COLUMN &h00000800L #define SQL_SR_REFERENCES_TABLE &h00000400L #define SQL_SR_RESTRICT &h00000040L #define SQL_SR_SELECT_TABLE &h00001000L #define SQL_SR_UPDATE_COLUMN &h00004000L #define SQL_SR_UPDATE_TABLE &h00002000L #define SQL_SR_USAGE_ON_CHARACTER_SET &h00000002L #define SQL_SR_USAGE_ON_COLLATION &h00000004L #define SQL_SR_USAGE_ON_DOMAIN &h00000001L #define SQL_SR_USAGE_ON_TRANSLATION &h00000008L #define SQL_SRJO_CORRESPONDING_CLAUSE &h00000001L #define SQL_SRJO_CROSS_JOIN &h00000002L #define SQL_SRJO_EXCEPT_JOIN &h00000004L #define SQL_SRJO_FULL_OUTER_JOIN &h00000008L #define SQL_SRJO_INNER_JOIN &h00000010L #define SQL_SRJO_INTERSECT_JOIN &h00000020L #define SQL_SRJO_LEFT_OUTER_JOIN &h00000040L #define SQL_SRJO_NATURAL_JOIN &h00000080L #define SQL_SRJO_RIGHT_OUTER_JOIN &h00000100L #define SQL_SRJO_UNION_JOIN &h00000200L #define SQL_SRVC_DEFAULT &h00000004L #define SQL_SRVC_NULL &h00000002L #define SQL_SRVC_ROW_SUBQUERY &h00000008L #define SQL_SRVC_VALUE_EXPRESSION &h00000001L #define SQL_SSF_CONVERT &h00000001L #define SQL_SSF_LOWER &h00000002L #define SQL_SSF_SUBSTRING &h00000008L #define SQL_SSF_TRANSLATE &h00000010L #define SQL_SSF_TRIM_BOTH &h00000020L #define SQL_SSF_TRIM_LEADING &h00000040L #define SQL_SSF_TRIM_TRAILING &h00000080L #define SQL_SSF_UPPER &h00000004L #define SQL_STANDARD_CLI_CONFORMANCE 166 #define SQL_STATIC_CURSOR_ATTRIBUTES1 167 #define SQL_STATIC_CURSOR_ATTRIBUTES2 168 #define SQL_SU_DML_STATEMENTS 1 #define SQL_SU_INDEX_DEFINITION 8 #define SQL_SU_PRIVILEGE_DEFINITION 16 #define SQL_SU_PROCEDURE_INVOCATION 2 #define SQL_SU_TABLE_DEFINITION 4 #define SQL_SVE_CASE &h00000001L #define SQL_SVE_CAST &h00000002L #define SQL_SVE_COALESCE &h00000004L #define SQL_SVE_NULLIF &h00000008L #define SQL_UB_FIXED 01UL #define SQL_UB_VARIABLE 2UL #define SQL_UNION_STATEMENT 96 #define SQL_UPDATE_BY_BOOKMARK 5 #define SQL_US_UNION 1 #define SQL_US_UNION_ALL 2 #define SQL_DESC_ROWVER 35 #define SQL_GUID (-11) #define SQL_C_GUID (-11) #define SQL_ATTR_ANSI_APP 115 #define SQL_AA_TRUE 1L #define SQL_AA_FALSE 0L #define TRACE_VERSION 1000 #define TRACE_ON 1 ''#define SQL_ODBC_KEYWORDS "ABSOLUTE,ACTION,ADA,ADD,ALL,ALLOCATE,ALTER,AND,ANY,ARE,AS,ASC,ASSERTION,AT,AUTHORIZATION,AVG,BEGIN,BETWEEN,BIT,BIT_LENGTH,BOTH,BY,CASCADE,CASCADED,CASE,CAST,CATALOG,CHAR,CHAR_LENGTH,CHARACTER,CHARACTER_LENGTH,CHECK,CLOSE,COALESCE,COLLATE,COLLATION,COLUMN,COMMIT,CONNECT,CONNECTION,CONSTRAINT,CONSTRAINTS,CONTINUE,CONVERT,CORRESPONDING,COUNT,CREATE,CROSS,CURRENT,CURRENT_DATE,CURRENT_TIME,CURRENT_TIMESTAMP,CURRENT_USER,CURSOR,DATE,DAY,DEALLOCATE,DEC,DECIMAL,DECLARE,DEFAULT,DEFERRABLE,DEFERRED,DELETE,DESC,DESCRIBE,DESCRIPTOR,DIAGNOSTICS,DISCONNECT,DISTINCT,DOMAIN,DOUBLE,DROP,ELSE,END,END-EXEC,ESCAPE,EXCEPT,EXCEPTION,EXEC,EXECUTE,EXISTS,EXTERNAL,EXTRACT,FALSE,FETCH,FIRST,FLOAT,FOR,FOREIGN,FORTRAN,FOUND,FROM,FULL,GET,GLOBAL,GO,GOTO,GRANT,GROUP,HAVING,HOUR,IDENTITY,IMMEDIATE,IN,INCLUDE,INDEX,INDICATOR,INITIALLY,INNER,INPUT,INSENSITIVE,INSERT,INT,INTEGER,INTERSECT,INTERVAL,INTO,IS,ISOLATION,JOIN,KEY,LANGUAGE,LAST,LEADING,LEFT,LEVEL,LIKE,LOCAL,LOWER,MATCH,MAX,MIN,MINUTE,MODULE,MONTH,NAMES,NATIONAL,NATURAL,NCHAR,NEXT,NO,NONE,NOT,NULL,NULLIF,NUMERIC,OCTET_LENGTH,OF,ON,ONLY,OPEN,OPTION,OR,ORDER,OUTER,OUTPUT,OVERLAPS,PAD,PARTIAL,PASCAL,PLI,POSITION,PRECISION,PREPARE,PRESERVE,PRIMARY,PRIOR,PRIVILEGES,PROCEDURE,PUBLIC,READ,REAL,REFERENCES,RELATIVE,RESTRICT,REVOKE,RIGHT,ROLLBACK,ROWSSCHEMA,SCROLL,SECOND,SECTION,SELECT,SESSION,SESSION_USER,SET,SIZE,SMALLINT,SOME,SPACE,SQL,SQLCA,SQLCODE,SQLERROR,SQLSTATE,SQLWARNING,SUBSTRING,SUM,SYSTEM_USER,TABLE,TEMPORARY,THEN,TIME,TIMESTAMP,TIMEZONE_HOUR,TIMEZONE_MINUTE,TO,TRAILING,TRANSACTION,TRANSLATE,TRANSLATION,TRIM,TRUE,UNION,UNIQUE,UNKNOWN,UPDATE,UPPER,USAGE,USER,USING,VALUE,VALUES,VARCHAR,VARYING,VIEW,WHEN,WHENEVER,WHERE,WITH,WORK,WRITE,YEAR,ZONE" declare function SQLDriverConnect alias "SQLDriverConnect" (byval as SQLHDBC, byval as SQLHWND, byval as SQLCHAR ptr, byval as SQLSMALLINT, byval as SQLCHAR ptr, byval as SQLSMALLINT, byval as SQLSMALLINT ptr, byval as SQLUSMALLINT) as SQLRETURN declare function SQLBrowseConnect alias "SQLBrowseConnect" (byval as SQLHDBC, byval as SQLCHAR ptr, byval as SQLSMALLINT, byval as SQLCHAR ptr, byval as SQLSMALLINT, byval as SQLSMALLINT ptr) as SQLRETURN declare function SQLColumnPrivileges alias "SQLColumnPrivileges" (byval as SQLHSTMT, byval as SQLCHAR ptr, byval as SQLSMALLINT, byval as SQLCHAR ptr, byval as SQLSMALLINT, byval as SQLCHAR ptr, byval as SQLSMALLINT, byval as SQLCHAR ptr, byval as SQLSMALLINT) as SQLRETURN declare function SQLColAttributes alias "SQLColAttributes" (byval as SQLHSTMT, byval as SQLUSMALLINT, byval as SQLUSMALLINT, byval as SQLPOINTER, byval as SQLSMALLINT, byval as SQLSMALLINT ptr, byval as SQLINTEGER ptr) as SQLRETURN declare function SQLDescribeParam alias "SQLDescribeParam" (byval as SQLHSTMT, byval as SQLUSMALLINT, byval as SQLSMALLINT ptr, byval as SQLUINTEGER ptr, byval as SQLSMALLINT ptr, byval as SQLSMALLINT ptr) as SQLRETURN declare function SQLExtendedFetch alias "SQLExtendedFetch" (byval as SQLHSTMT, byval as SQLUSMALLINT, byval as SQLINTEGER, byval as SQLUINTEGER ptr, byval as SQLUSMALLINT ptr) as SQLRETURN declare function SQLForeignKeys alias "SQLForeignKeys" (byval as SQLHSTMT, byval as SQLCHAR ptr, byval as SQLSMALLINT, byval as SQLCHAR ptr, byval as SQLSMALLINT, byval as SQLCHAR ptr, byval as SQLSMALLINT, byval as SQLCHAR ptr, byval as SQLSMALLINT, byval as SQLCHAR ptr, byval as SQLSMALLINT, byval as SQLCHAR ptr, byval as SQLSMALLINT) as SQLRETURN declare function SQLMoreResults alias "SQLMoreResults" (byval as SQLHSTMT) as SQLRETURN declare function SQLNativeSql alias "SQLNativeSql" (byval as SQLHDBC, byval as SQLCHAR ptr, byval as SQLINTEGER, byval as SQLCHAR ptr, byval as SQLINTEGER, byval as SQLINTEGER ptr) as SQLRETURN declare function SQLNumParams alias "SQLNumParams" (byval as SQLHSTMT, byval as SQLSMALLINT ptr) as SQLRETURN declare function SQLParamOptions alias "SQLParamOptions" (byval as SQLHSTMT, byval as SQLUINTEGER, byval as SQLUINTEGER ptr) as SQLRETURN declare function SQLPrimaryKeys alias "SQLPrimaryKeys" (byval as SQLHSTMT, byval as SQLCHAR ptr, byval as SQLSMALLINT, byval as SQLCHAR ptr, byval as SQLSMALLINT, byval as SQLCHAR ptr, byval as SQLSMALLINT) as SQLRETURN declare function SQLProcedureColumns alias "SQLProcedureColumns" (byval as SQLHSTMT, byval as SQLCHAR ptr, byval as SQLSMALLINT, byval as SQLCHAR ptr, byval as SQLSMALLINT, byval as SQLCHAR ptr, byval as SQLSMALLINT, byval as SQLCHAR ptr, byval as SQLSMALLINT) as SQLRETURN declare function SQLProcedures alias "SQLProcedures" (byval as SQLHSTMT, byval as SQLCHAR ptr, byval as SQLSMALLINT, byval as SQLCHAR ptr, byval as SQLSMALLINT, byval as SQLCHAR ptr, byval as SQLSMALLINT) as SQLRETURN declare function SQLSetPos alias "SQLSetPos" (byval as SQLHSTMT, byval as SQLUSMALLINT, byval as SQLUSMALLINT, byval as SQLUSMALLINT) as SQLRETURN declare function SQLTablePrivileges alias "SQLTablePrivileges" (byval as SQLHSTMT, byval as SQLCHAR ptr, byval as SQLSMALLINT, byval as SQLCHAR ptr, byval as SQLSMALLINT, byval as SQLCHAR ptr, byval as SQLSMALLINT) as SQLRETURN declare function SQLDrivers alias "SQLDrivers" (byval as SQLHENV, byval as SQLUSMALLINT, byval as SQLCHAR ptr, byval as SQLSMALLINT, byval as SQLSMALLINT ptr, byval as SQLCHAR ptr, byval as SQLSMALLINT, byval as SQLSMALLINT ptr) as SQLRETURN declare function SQLBindParameter alias "SQLBindParameter" (byval as SQLHSTMT, byval as SQLUSMALLINT, byval as SQLSMALLINT, byval as SQLSMALLINT, byval as SQLSMALLINT, byval as SQLUINTEGER, byval as SQLSMALLINT, byval as SQLPOINTER, byval as SQLINTEGER, byval as SQLINTEGER ptr) as SQLRETURN declare function SQLSetScrollOptions alias "SQLSetScrollOptions" (byval as SQLHSTMT, byval as SQLUSMALLINT, byval as SQLINTEGER, byval as SQLUSMALLINT) as SQLRETURN declare function ODBCGetTryWaitValue alias "ODBCGetTryWaitValue" () as DWORD declare function ODBCSetTryWaitValue alias "ODBCSetTryWaitValue" (byval as DWORD) as BOOL declare function TraceOpenLogFile alias "TraceOpenLogFile" (byval as LPWSTR, byval as LPWSTR, byval as DWORD) as RETCODE declare function TraceCloseLogFile alias "TraceCloseLogFile" () as RETCODE declare sub TraceReturn alias "TraceReturn" (byval as RETCODE, byval as RETCODE) declare function TraceVersion alias "TraceVersion" () as DWORD declare function SQLBulkOperations alias "SQLBulkOperations" (byval as SQLHSTMT, byval as SQLSMALLINT) as SQLRETURN declare function SQLAllocHandleStd alias "SQLAllocHandleStd" (byval as SQLSMALLINT, byval as SQLHANDLE, byval as SQLHANDLE ptr) as SQLRETURN #include once "win/sqlucode.bi" #endif