/IF NOT DEFINED(SQL_H_SQLCLI) /DEFINE SQL_H_SQLCLI *************************************************************** * Source File Name = CSQLCLI_H * Adapted from IBM source member QSYSINC/H(SQLCLI) * * Descriptive Name: Structured Query Language (SQL) * Call Level Interface (CLI). * * Description: The SQL Call Level Interface provides access * to most SQL functions, without the need for a * precompiler. * * Function Prototype List: SQLAllocConnect * SQLAllocEnv * SQLAllocStmt * SQLBindCol * SQLBindParameter * SQLConnect * SQLDisconnect * SQLExecDirect * SQLExecute * SQLFetch * SQLFreeConnect * SQLFreeEnv * SQLFreeStmt * SQLPrepare * *************************************************************** * Copyright 2005, Bits & Bytes Programming, Inc. * ALL RIGHTS RESERVED * * This source member is licensed for use only within your * enterprise. You may not redistribute this source member * in any format on any media. *************************************************************** /INCLUDE QSQLCLI,CTYPES *************************************************************** * generally useful constants * * SQL_NTS - null terminated string * SQL_SQLSTATE_SIZE - size of SQLSTATE, not including * null terminating byte *************************************************************** D SQL_FALSE... D c 0 D SQL_TRUE... D c 1 D SQL_NTS... D c -3 D SQL_SQLSTATE_SIZE... D c 5 D SQL_MAX_MESSAGE_LENGTH... D c 512 D SQL_MAX_OPTION_STRING_LENGTH... D c 128 *************************************************************** * return code values *************************************************************** D SQL_SUCCESS... D c 0 D SQL_SUCCESS_WITH_INFO... D c 1 D SQL_NO_DATA_FOUND... D c 100 D SQL_NEED_DATA... D c 99 D SQL_NO_DATA... D c 100 D** SQL_NO_DATA_FOUND D SQL_ERROR... D c -1 D SQL_INVALID_HANDLE... D c -2 D SQL_STILL_EXECUTING... D c 2 *************************************************************** * SQLFreeStmt option values *************************************************************** D SQL_CLOSE... D c 0 D SQL_DROP... D c 1 D SQL_UNBIND... D c 2 D SQL_RESET_PARAMS... D c 3 *************************************************************** * SQLSetParam defines *************************************************************** D SQL_C_DEFAULT... D c 99 *************************************************************** * SQLEndTran option values *************************************************************** D SQL_COMMIT... D c 0 D SQL_ROLLBACK... D c 1 D SQL_COMMIT_HOLD... D c 2 D SQL_ROLLBACK_HOLD... D c 3 D SQL_SAVEPOINT_NAME_RELEASE... D c 4 D SQL_SAVEPOINT_NAME_ROLLBACK... D c 5 *************************************************************** * SQLDriverConnect option values *************************************************************** D SQL_DRIVER_COMPLETE... D c 1 D SQL_DRIVER_COMPLETE_REQUIRED... D c 1 D SQL_DRIVER_NOPROMPT... D c 1 D SQL_DRIVER_PROMPT... D c 0 *************************************************************** * Valid option codes for GetInfo procedure *************************************************************** D SQL_ACTIVE_CONNECTIONS... D c 0 D SQL_MAX_DRIVER_CONNECTIONS... D c 0 D SQL_MAX_CONCURRENT_ACTIVITIES... D c 1 D SQL_ACTIVE_STATEMENTS... D c 1 D SQL_PROCEDURES... D c 2 D SQL_DRIVER_NAME... D c 6 D SQL_ODBC_API_CONFORMANCE... D c 9 D SQL_ODBC_SQL_CONFORMANCE... D c 10 D SQL_DBMS_NAME... D c 17 D SQL_DBMS_VER... D c 18 D SQL_DRIVER_VER... D c 18 D SQL_IDENTIFIER_CASE... D c 28 D SQL_IDENTIFIER_QUOTE_CHAR... D c 29 D SQL_MAX_COLUMN_NAME_LEN... D c 30 D SQL_MAX_CURSOR_NAME_LEN... D c 31 D SQL_MAX_OWNER_NAME_LEN... D c 32 D SQL_MAX_SCHEMA_NAME_LEN... D c 33 D SQL_MAX_TABLE_NAME_LEN... D c 35 D SQL_MAX_COLUMNS_IN_GROUP_BY... D c 36 D SQL_MAX_COLUMNS_IN_ORDER_BY... D c 37 D SQL_MAX_COLUMNS_IN_SELECT... D c 38 D SQL_MAX_COLUMNS_IN_TABLE... D c 39 D SQL_MAX_TABLES_IN_SELECT... D c 40 D SQL_COLUMN_ALIAS... D c 41 D SQL_DATA_SOURCE_NAME... D c 42 D SQL_DATASOURCE_NAME... D c 42 D SQL_DATABASE_NAME... D c 42 D SQL_MAX_COLUMNS_IN_INDEX... D c 43 D SQL_PROCEDURE_TERM... D c 44 D SQL_QUALIFIER_TERM... D c 45 D SQL_TXN_CAPABLE... D c 46 D SQL_OWNER_TERM... D c 47 D SQL_DATA_SOURCE_READ_ONLY... D c 48 D SQL_DEFAULT_TXN_ISOLATION... D c 49 D SQL_MULTIPLE_ACTIVE_TXN... D c 55 D SQL_QUALIFIER_NAME_SEPARATOR... D c 65 D SQL_CORRELATION_NAME... D c 74 D SQL_NON_NULLABLE_COLUMNS... D c 75 D SQL_DRIVER_ODBC_VER... D c 77 D SQL_GROUP_BY... D c 88 D SQL_ORDER_BY_COLUMNS_IN_SELECT... D c 90 D SQL_OWNER_USAGE... D c 91 D SQL_QUALIFIER_USAGE... D c 92 D SQL_QUOTED_IDENTIFIER_CASE... D c 93 D SQL_MAX_ROW_SIZE... D c 104 D SQL_QUALIFIER_LOCATION... D c 114 D SQL_MAX_CATALOG_NAME_LEN... D c 115 D SQL_MAX_STATEMENT_LEN... D c 116 D SQL_SEARCH_PATTERN_ESCAPE... D c 117 D SQL_OUTER_JOINS... D c 118 D SQL_LIKE_ESCAPE_CLAUSE... D c 119 D SQL_CATALOG_NAME... D c 120 D SQL_DESCRIBE_PARAMETER... D c 121 D SQL_STRING_FUNCTIONS... D c 50 D SQL_NUMERIC_FUNCTIONS... D c 51 D SQL_CONVERT_FUNCTIONS... D c 52 D SQL_TIMEDATE_FUNCTIONS... D c 53 D SQL_SQL92_PREDICATES... D c 160 D SQL_SQL92_VALUE_EXPRESSIONS... D c 165 D SQL_AGGREGATE_FUNCTIONS... D c 169 D SQL_SQL_CONFORMANCE... D c 170 D SQL_CONVERT_CHAR... D c 171 D SQL_CONVERT_NUMERIC... D c 172 D SQL_CONVERT_DECIMAL... D c 173 D SQL_CONVERT_INTEGER... D c 174 D SQL_CONVERT_SMALLINT... D c 175 D SQL_CONVERT_FLOAT... D c 176 D SQL_CONVERT_REAL... D c 177 D SQL_CONVERT_DOUBLE... D c 178 D SQL_CONVERT_VARCHAR... D c 179 D SQL_CONVERT_LONGVARCHAR... D c 180 D SQL_CONVERT_BINARY... D c 181 D SQL_CONVERT_VARBINARY... D c 182 D SQL_CONVERT_BIT... D c 183 D SQL_CONVERT_TINYINT... D c 184 D SQL_CONVERT_BIGINT... D c 185 D SQL_CONVERT_DATE... D c 186 D SQL_CONVERT_TIME... D c 187 D SQL_CONVERT_TIMESTAMP... D c 188 D SQL_CONVERT_LONGVARBINARY... D c 189 D SQL_CONVERT_INTERVAL_YEAR_MONTH... D c 190 D SQL_CONVERT_INTERVAL_DAY_TIME... D c 191 D SQL_CONVERT_WCHAR... D c 192 D SQL_CONVERT_WLONGVARCHAR... D c 193 D SQL_CONVERT_WVARCHAR... D c 194 D SQL_CONVERT_BLOB... D c 195 D SQL_CONVERT_CLOB... D c 196 D SQL_CONVERT_DBCLOB... D c 197 D SQL_CURSOR_COMMIT_BEHAVIOR... D c 198 D SQL_CURSOR_ROLLBACK_BEHAVIOR... D c 199 D SQL_POSITIONED_STATEMENTS... D c 200 D SQL_KEYWORDS... D c 201 D SQL_CONNECTION_JOB_NAME... D c 202 *************************************************************** * Unsupported codes for SQLGetInfo *************************************************************** D SQL_LOCK_TYPES... D c -1 D SQL_POS_OPERATIONS... D c -1 D SQL_USER_NAME... D c -1 *************************************************************** * Output values for cursor behavior *************************************************************** D SQL_CB_DELETE... D c 1 D SQL_CB_CLOSE... D c 2 D SQL_CB_PRESERVE... D c 3 *************************************************************** * Aliased option codes (ODBC 3.0) *************************************************************** D SQL_SCHEMA_TERM... D c 47 D** SQL_OwNER_TERM D SQL_SCHEMA_USAGE... D c 91 D** SQL_OWNER_USAGE D SQL_CATALOG_LOCATION... D c 114 D** SQL_QUALIFIER_LOCATION D SQL_CATALOG_TERM... D c 45 D** SQL_QUALIFIER_TERM D SQL_CATALOG_USAGE... D c 92 D** SQL_QUALIFIER_USAGE D SQL_CATALOG_NAME_SEPARATOR... D c 65 D** SQL_QUALIFIER_NAME_SEPARATOR *************************************************************** * Output values for SQL_ODBC_API_CONFORMANCE * info type in SQLGetInfo *************************************************************** D SQL_OAC_NONE... D c 0 D SQL_OAC_LEVEL1... D c 1 D SQL_OAC_LEVEL2... D c 2 *************************************************************** * Output values for SQL_ODBC_SQL_CONFORMANCE * info type in SQLGetInfo *************************************************************** D SQL_OSC_MINIMUM... D c 0 D SQL_OSC_CORE... D c 1 D SQL_OSC_EXTENDED... D c 2 *************************************************************** * Output values for SQL_QUALIFIER_USAGE * info type in SQLGetInfo *************************************************************** D SQL_QU_NOT_SUPPORTED... D c x'00000000' D SQL_QU_DML_STATEMENTS... D c x'00000001' D SQL_QU_PROCEDURE_INVOCATION... D c x'00000002' D SQL_QU_TABLE_DEFINITION... D c x'00000004' D SQL_QU_INDEX_DEFINITION... D c x'00000008' D SQL_QU_PRIVILEGE_DEFINITION... D c x'00000010' *************************************************************** * Output values for SQL_QUALIFIER_LOCATION * info type in SQLGetInfo *************************************************************** D SQL_QL_START... D c 1 D SQL_QL_END... D c 2 *************************************************************** * Output values for SQL_OWNER_USAGE * info type in SQLGetInfo *************************************************************** D SQL_OU_DML_STATEMENTS... D c x'00000001' D SQL_OU_PROCEDURE_INVOCATION... D c x'00000002' D SQL_OU_TABLE_DEFINITION... D c x'00000004' D SQL_OU_INDEX_DEFINITION... D c x'00000008' D SQL_OU_PRIVILEGE_DEFINITION... D c x'00000010' *************************************************************** * Output values for SQL_TXN_CAPABLE * info type in SQLGetInfo *************************************************************** D SQL_TC_NONE... D c 0 D SQL_TC_DML... D c 1 D SQL_TC_ALL... D c 2 D SQL_TC_DDL_COMMIT... D c 3 D SQL_TC_DDL_IGNORE... D c 4 *************************************************************** * Output values for SQL_TXN_ISOLATION * info type in SQLGetInfo *************************************************************** D SQL_TXN_READ_UNCOMMITTED_MASK... D c x'00000001' D SQL_TXN_READ_COMMITTED_MASK... D c x'00000002' D SQL_TXN_REPEATABLE_READ_MASK... D c x'00000004' D SQL_TXN_SERIALIZABLE_MASK... D c x'00000008' ************************************************************** * Output values for SQL_STRING_FUNCTIONS * info type in SQLGetInfo ************************************************************** D SQL_FN_STR_CONCAT... D c x'00000001' D SQL_FN_STR_UCASE... D c x'00000002' D SQL_FN_STR_LCASE... D c x'00000004' D SQL_FN_STR_SUBSTRING... D c x'00000008' D SQL_FN_STR_LENGTH... D c x'00000010' D SQL_FN_STR_POSITION... D c x'00000020' D SQL_FN_STR_LTRIM... D c x'00000040' D SQL_FN_STR_RTRIM... D c x'00000080' ************************************************************** * Output values for SQL_POS_OPERATIONS * info type in SQLGetInfo (not currently supported) ************************************************************** D SQL_POS_POSITION... D c x'00000001' D SQL_POS_REFRESH... D c x'00000002' D SQL_POS_UPDATE... D c x'00000004' D SQL_POS_DELETE... D c x'00000008' D SQL_POS_ADD... D c x'00000010' ************************************************************** * Output values for SQL_NUMERIC_FUNCTIONS * info type in SQLGetInfo ************************************************************** D SQL_FN_NUM_ABS... D c x'00000001' D SQL_FN_NUM_ACOS... D c x'00000002' D SQL_FN_NUM_ASIN... D c x'00000004' D SQL_FN_NUM_ATAN... D c x'00000008' D SQL_FN_NUM_ATAN2... D c x'00000010' D SQL_FN_NUM_CEILING... D c x'00000020' D SQL_FN_NUM_COS... D c x'00000040' D SQL_FN_NUM_COT... D c x'00000080' D SQL_FN_NUM_EXP... D c x'00000100' D SQL_FN_NUM_FLOOR... D c x'00000200' D SQL_FN_NUM_LOG... D c x'00000400' D SQL_FN_NUM_MOD... D c x'00000800' D SQL_FN_NUM_SIGN... D c x'00001000' D SQL_FN_NUM_SIN... D c x'00002000' D SQL_FN_NUM_SQRT... D c x'00004000' D SQL_FN_NUM_TAN... D c x'00008000' D SQL_FN_NUM_PI... D c x'00010000' D SQL_FN_NUM_RAND... D c x'00020000' D SQL_FN_NUM_DEGREES... D c x'00040000' D SQL_FN_NUM_LOG10... D c x'00080000' D SQL_FN_NUM_POWER... D c x'00100000' D SQL_FN_NUM_RADIANS... D c x'00200000' D SQL_FN_NUM_ROUND... D c x'00400000' D SQL_FN_NUM_TRUNCATE... D c x'00800000' ************************************************************** * SQL_SQL92_VALUE_EXPRESSIONS bitmasks ************************************************************** D SQL_SVE_CASE... D c x'00000001' D SQL_SVE_CAST... D c x'00000002' D SQL_SVE_COALESCE... D c x'00000004' D SQL_SVE_NULLIF... D c x'00000008' ************************************************************** * SQL_SQL92_PREDICATES bitmasks ************************************************************** D SQL_SP_EXISTS... D c x'00000001' D SQL_SP_ISNOTNULL... D c x'00000002' D SQL_SP_ISNULL... D c x'00000004' D SQL_SP_MATCH_FULL... D c x'00000008' D SQL_SP_MATCH_PARTIAL... D c x'00000010' D SQL_SP_MATCH_UNIQUE_FULL... D c x'00000020' D SQL_SP_MATCH_UNIQUE_PARTIAL... D c x'00000040' D SQL_SP_OVERLAPS... D c x'00000080' D SQL_SP_UNIQUE... D c x'00000100' D SQL_SP_LIKE... D c x'00000200' D SQL_SP_IN... D c x'00000400' D SQL_SP_BETWEEN... D c x'00000800' D SQL_SP_COMPARISON... D c x'00001000' D SQL_SP_QUANTIFIED_COMPARISON... D c x'00002000' ************************************************************** * SQL_AGGREGATE_FUNCTIONS bitmasks ************************************************************** D SQL_AF_AVG... D c x'00000001' D SQL_AF_COUNT... D c x'00000002' D SQL_AF_MAX... D c x'00000004' D SQL_AF_MIN... D c x'00000008' D SQL_AF_SUM... D c x'00000010' D SQL_AF_DISTINCT... D c x'00000020' D SQL_AF_ALL... D c x'00000040' ************************************************************** * SQL_SQL_CONFORMANCE bitmasks ************************************************************** D SQL_SC_SQL92_ENTRY... D c x'00000001' D SQL_SC_FIPS127_2_TRANSITIONAL... D c x'00000002' D SQL_SC_SQL92_INTERMEDIATE... D c x'00000004' D SQL_SC_SQL92_FULL... D c x'00000008' ************************************************************** * SQL_CONVERT_FUNCTIONS functions ************************************************************** D SQL_FN_CVT_CONVERT... D c x'00000001' D SQL_FN_CVT_CAST... D c x'00000002' ************************************************************** * SQL_POSITIONED_STATEMENTS bitmasks ************************************************************** D SQL_PS_POSITIONED_DELETE... D c x'00000001' D SQL_PS_POSITIONED_UPDATE... D c x'00000002' D SQL_PS_SELECT_FOR_UPDATE... D c x'00000004' ************************************************************** * SQL supported conversion bitmasks ************************************************************** D SQL_CVT_CHAR... D c x'00000001' D SQL_CVT_NUMERIC... D c x'00000002' D SQL_CVT_DECIMAL... D c x'00000004' D SQL_CVT_INTEGER... D c x'00000008' D SQL_CVT_SMALLINT... D c x'00000010' D SQL_CVT_FLOAT... D c x'00000020' D SQL_CVT_REAL... D c x'00000040' D SQL_CVT_DOUBLE... D c x'00000080' D SQL_CVT_VARCHAR... D c x'00000100' D SQL_CVT_LONGVARCHAR... D c x'00000200' D SQL_CVT_BINARY... D c x'00000400' D SQL_CVT_VARBINARY... D c x'00000800' D SQL_CVT_BIT... D c x'00001000' D SQL_CVT_TINYINT... D c x'00002000' D SQL_CVT_BIGINT... D c x'00004000' D SQL_CVT_DATE... D c x'00008000' D SQL_CVT_TIME... D c x'00010000' D SQL_CVT_TIMESTAMP... D c x'00020000' D SQL_CVT_LONGVARBINARY... D c x'00040000' D SQL_CVT_INTERVAL_YEAR_MONTH... D c x'00080000' D SQL_CVT_INTERVAL_DAY_TIME... D c x'00100000' D SQL_CVT_WCHAR... D c x'00200000' D SQL_CVT_WLONGVARCHAR... D c x'00400000' D SQL_CVT_WVARCHAR... D c x'00800000' D SQL_CVT_BLOB... D c x'01000000' D SQL_CVT_CLOB... D c x'02000000' D SQL_CVT_DBCLOB... D c x'04000000' ************************************************************** * SQL_TIMEDATE_FUNCTIONS bitmasks ************************************************************** D SQL_FN_TD_NOW... D c x'00000001' D SQL_FN_TD_CURDATE... D c x'00000002' D SQL_FN_TD_DAYOFMONTH... D c x'00000004' D SQL_FN_TD_DAYOFWEEK... D c x'00000008' D SQL_FN_TD_DAYOFYEAR... D c x'00000010' D SQL_FN_TD_MONTH... D c x'00000020' D SQL_FN_TD_QUARTER... D c x'00000040' D SQL_FN_TD_WEEK... D c x'00000080' D SQL_FN_TD_YEAR... D c x'00000100' D SQL_FN_TD_CURTIME... D c x'00000200' D SQL_FN_TD_HOUR... D c x'00000400' D SQL_FN_TD_MINUTE... D c x'00000800' D SQL_FN_TD_SECOND... D c x'00001000' D SQL_FN_TD_TIMESTAMPADD... D c x'00002000' D SQL_FN_TD_TIMESTAMPDIFF... D c x'00004000' D SQL_FN_TD_DAYNAME... D c x'00008000' D SQL_FN_TD_MONTHNAME... D c x'00010000' D SQL_FN_TD_CURRENT_DATE... D c x'00020000' D SQL_FN_TD_CURRENT_TIME... D c x'00040000' D SQL_FN_TD_CURRENT_TIMESTAMP... D c x'00080000' D SQL_FN_TD_EXTRACT... D c x'00100000' ************************************************************** * Output values for SQL_CORRELATION_NAME * info type in SQLGetInfo ************************************************************** D SQL_CN_NONE... D c 0 D SQL_CN_DIFFERENT... D c 1 D SQL_CN_ANY... D c 2 ************************************************************** * Output values for SQL_IDENTIFIER_CASE * info type in SQLGetInfo ************************************************************** D SQL_IC_UPPER... D c 1 D SQL_IC_LOWER... D c 2 D SQL_IC_SENSITIVE... D c 3 D SQL_IC_MIXED... D c 4 ************************************************************** * Output values for SQL_NON_NULLABLE_COLUMNS * info type in SQLGetInfo ************************************************************** D SQL_NNC_NULL... D c 0 D SQL_NNC_NON_NULL... D c 1 ************************************************************** * Output values for SQL_GROUP_BY * info type in SQLGetInfo ************************************************************** D SQL_GB_NO_RELATION... D c 0 D SQL_GB_NOT_SUPPORTED... D c 1 D SQL_GB_GROUP_BY_EQUALS_SELECT... D c 2 D SQL_GB_GROUP_BY_CONTAINS_SELECT... D c 3 ************************************************************** * Standard SQL data types ************************************************************** D SQL_CHAR... D c 1 D SQL_NUMERIC... D c 2 D SQL_DECIMAL... D c 3 D SQL_INTEGER... D c 4 D SQL_SMALLINT... D c 5 D SQL_FLOAT... D c 6 D SQL_REAL... D c 7 D SQL_DOUBLE... D c 8 D SQL_DATETIME... D c 9 D SQL_VARCHAR... D c 12 D SQL_BLOB... D c 13 D SQL_CLOB... D c 14 D SQL_DBCLOB... D c 15 D SQL_DATALINK... D c 16 D SQL_WCHAR... D c 17 D SQL_WVARCHAR... D c 18 D SQL_BIGINT... D c 19 D SQL_BLOB_LOCATOR... D c 20 D SQL_CLOB_LOCATOR... D c 21 D SQL_DBCLOB_LOCATOR... D c 22 D SQL_UTF8_CHAR... D c 23 D SQL_WLONGVARCHAR... D c 18 D** SQL_WVARCHAR D SQL_LONGVARCHAR... D c 12 D** SQL_VARCHAR D SQL_GRAPHIC... D c 95 D SQL_VARGRAPHIC... D c 96 D SQL_LONGVARGRAPHIC... D c 96 D** SQL_VARGRAPHIC D SQL_BINARY... D c 97 D SQL_VARBINARY... D c 98 D SQL_LONGVARBINARY... D c 98 D** SQL_VARBINARY D SQL_DATE... D c 91 D SQL_TYPE_DATE... D c 91 D SQL_TIME... D c 92 D SQL_TYPE_TIME... D c 92 D SQL_TIMESTAMP... D c 93 D SQL_TYPE_TIMESTAMP... D c 93 D SQL_CODE_DATE... D c 1 D SQL_CODE_TIME... D c 2 D SQL_CODE_TIMESTAMP... D c 3 D SQL_ALL_TYPES... D c 0 ************************************************************** * Standard handle types ************************************************************** D SQL_UNUSED... D c 0 D SQL_HANDLE_ENV... D c 1 D SQL_HANDLE_DBC... D c 2 D SQL_HANDLE_STMT... D c 3 D SQL_HANDLE_DESC... D c 4 D SQL_NULL_HANDLE... D c 0 D SQL_HANDLE_DBC_UNICODE... D c 100 ************************************************************** * NULL status defines; these are used in SQLColAttributes, * SQLDescribeCol, to describe the nullability of a column * in a table. ************************************************************** D SQL_NO_NULLS... D c 0 D SQL_NULLABLE... D c 1 D SQL_NULLABLE_UNKNOWN... D c 2 ************************************************************** * Special length values ************************************************************** D SQL_NO_TOTAL... D c 0 D SQL_NULL_DATA... D c -1 D SQL_DATA_AT_EXEC... D c -2 D SQL_BIGINT_PREC... D c 19 D SQL_NULL_HANDLE_PRE... D c 10 D SQL_SMALLINT_PREC... D c 5 ************************************************************** * SQLColAttributes defines ************************************************************** D SQL_ATTR_READONLY... D c 0 D SQL_ATTR_WRITE... D c 1 D SQL_ATTR_READWRITE_UNKNOWN... D c 2 ************************************************************** * Valid concurrency values ************************************************************** D SQL_CONCUR_LOCK... D c 0 D SQL_CONCUR_READ_ONLY... D c 1 D SQL_CONCUR_ROWVER... D c 3 D SQL_CONCUR_VALUES... D c 4 ************************************************************** * Valid environment attributes ************************************************************** D SQL_ATTR_OUTPUT_NTS... D c 10001 D SQL_ATTR_SYS_NAMING... D c 10002 D SQL_ATTR_DEFAULT_LIB... D c 10003 D SQL_ATTR_SERVER_MODE... D c 10004 D SQL_ATTR_JOB_SORT_SEQUENCE... D c 10005 D SQL_ATTR_ENVHNDL_COUNTER... D c 10009 D SQL_ATTR_ESCAPE_CHAR... D c 10010 D SQL_ATTR_INCLUDE_NULL_IN_LEN... D c 10031 D SQL_ATTR_UTF8... D c 10032 D SQL_ATTR_SYSCAP... D c 10033 D SQL_ATTR_REQUIRE_PROFILE... D c 10034 D SQL_ATTR_UCS2... D c 10035 D SQL_ATTR_TRUNCATION_RTNC... D c 10036 ************************************************************** * Valid environment/connection attributes ************************************************************** D SQL_ATTR_EXTENDED_COL_INFO... D c 10019 D SQL_ATTR_DATE_FMT... D c 10020 D SQL_ATTR_DATE_SEP... D c 10021 D SQL_ATTR_TIME_FMT... D c 10022 D SQL_ATTR_TIME_SEP... D c 10023 D SQL_ATTR_DECIMAL_SEP... D c 10024 D SQL_ATTR_TXN_INFO... D c 10025 D SQL_ATTR_TXN_EXTERNAL... D c 10026 D SQL_ATTR_2ND_LEVEL_TEXT... D c 10027 D SQL_ATTR_SAVEPOINT_NAME... D c 10028 D SQL_ATTR_TRACE... D c 10029 D SQL_ATTR_MAX_PRECISION... D c 10040 D SQL_ATTR_MAX_SCALE... D c 10041 D SQL_ATTR_MIN_DIVIDE_SCALE... D c 10042 D SQL_ATTR_HEX_LITERALS... D c 10043 D SQL_ATTR_CORRELATOR... D c 10044 ************************************************************** * Valid transaction info operations ************************************************************** D SQL_TXN_FIND... D c 1 D SQL_TXN_CREATE... D c 2 D SQL_TXN_CLEAR... D c 3 D SQL_TXN_END... D c 4 D SQL_TXN_HOLD... D c 5 ************************************************************** * Valid environment/connection values ************************************************************** D SQL_FMT_ISO... D c 1 D SQL_FMT_USA... D c 2 D SQL_FMT_EUR... D c 3 D SQL_FMT_JIS... D c 4 D SQL_FMT_MDY... D c 5 D SQL_FMT_DMY... D c 6 D SQL_FMT_YMD... D c 7 D SQL_FMT_JUL... D c 8 D SQL_FMT_HMS... D c 9 D SQL_FMT_JOB... D c 10 D SQL_SEP_SLASH... D c 1 D SQL_SEP_DASH... D c 2 D SQL_SEP_PERIOD... D c 3 D SQL_SEP_COMMA... D c 4 D SQL_SEP_BLANK... D c 5 D SQL_SEP_COLON... D c 6 D SQL_SEP_JOB... D c 7 D SQL_HEX_IS_CHAR... D c 1 D SQL_HEX_IS_BINARY... D c 2 ************************************************************** * Valid values for type in GetCol ************************************************************** D SQL_DEFAULT... D c 99 D SQL_ARD_TYPE... D c -99 ************************************************************** * Valid values for UPDATE_RULE, DELETE_RULE in SQLForeignKeys ************************************************************** D SQL_CASCADE... D c 1 D SQL_RESTRICT... D c 2 D SQL_NO_ACTION... D c 3 D SQL_SET_NULL... D c 4 D SQL_SET_DEFAULT... D c 5 ************************************************************** * Valid values for COLUMN_TYPE in SQLProcedureColumns ************************************************************** D SQL_PARAM_INPUT... D c 1 D SQL_PARAM_OUTPUT... D c 2 D SQL_PARAM_INPUT_OUTPUT... D c 3 ************************************************************** * statement attributes ************************************************************** D SQL_ATTR_APP_ROW_DESC... D c 10010 D SQL_ATTR_APP_PARAM_DESC... D c 10011 D SQL_ATTR_IMP_ROW_DESC... D c 10012 D SQL_ATTR_IMP_PARAM_DESC... D c 10013 D SQL_ATTR_FOR_FETCH_ONLY... D c 10014 D SQL_ATTR_CONCURRENCY... D c 10014 D SQL_CONCURRENCY... D c 10014 D SQL_ATTR_CURSOR_SCROLLABLE... D c 10015 D SQL_ATTR_ROWSET_SIZE... D c 10016 D SQL_ROWSET_SIZE... D c 10016 D SQL_ATTR_ROW_ARRAY_SIZE... D c 10016 D SQL_ATTR_CURSOR_HOLD... D c 10017 D SQL_ATTR_FULL_OPEN... D c 10018 D SQL_ATTR_BIND_TYPE... D c 10049 D SQL_BIND_TYPE... D c 10049 D SQL_ATTR_CURSOR_TYPE... D c 10050 D SQL_CURSOR_TYPE... D c 10050 D SQL_ATTR_CURSOR_SENSITIVITY... D c 10051 D SQL_CURSOR_SENSITIVE... D c 10051 ************************************************************** * values for setting statement attributes ************************************************************** D SQL_BIND_BY_ROW... D c 0 D SQL_BIND_BY_COLUMN... D c 1 D SQL_CURSOR_FORWARD_ONLY... D c 0 D SQL_CURSOR_STATIC... D c 1 D SQL_CURSOR_DYNAMIC... D c 2 D SQL_CURSOR_KEYSET_DRIVEN... D c 3 D SQL_UNSPECIFIED... D c 0 D SQL_INSENSITIVE... D c 1 D SQL_SENSITIVE... D c 2 ************************************************************** * Codes used in FetchScroll ************************************************************** D SQL_FETCH_NEXT... D c 1 D SQL_FETCH_FIRST... D c 2 D SQL_FETCH_LAST... D c 3 D SQL_FETCH_PRIOR... D c 4 D SQL_FETCH_ABSOLUTE... D c 5 D SQL_FETCH_RELATIVE... D c 6 ************************************************************** * SQLColAttributes defines ************************************************************** D SQL_DESC_COUNT... D c 1 D SQL_DESC_TYPE... D c 2 D SQL_DESC_LENGTH... D c 3 D SQL_DESC_LENGTH_PTR... D c 4 D SQL_DESC_PRECISION... D c 5 D SQL_DESC_SCALE... D c 6 D SQL_DESC_DATETIME_INTERVAL_CODE... D c 7 D SQL_DESC_NULLABLE... D c 8 D SQL_DESC_INDICATOR_PTR... D c 9 D SQL_DESC_DATA_PTR... D c 10 D SQL_DESC_NAME... D c 11 D SQL_DESC_UNNAMED... D c 12 D SQL_DESC_DISPLAY_SIZE... D c 13 D SQL_DESC_AUTO_INCREMENT... D c 14 D SQL_DESC_SEARCHABLE... D c 15 D SQL_DESC_UPDATABLE... D c 16 D SQL_DESC_BASE_COLUMN... D c 17 D SQL_DESC_BASE_TABLE... D c 18 D SQL_DESC_BASE_SCHEMA... D c 19 D SQL_DESC_LABEL... D c 20 D SQL_DESC_MONEY... D c 21 D SQL_DESC_ALLOC_TYPE... D c 99 D SQL_DESC_ALLOC_AUTO... D c 1 D SQL_DESC_ALLOC_USER... D c 2 D SQL_COLUMN_COUNT... D c 1 D SQL_COLUMN_TYPE... D c 2 D SQL_COLUMN_LENGTH... D c 3 D SQL_COLUMN_LENGTH_PTR... D c 4 D SQL_COLUMN_PRECISION... D c 5 D SQL_COLUMN_SCALE... D c 6 D SQL_COLUMN_DATETIME_INTERVAL_CODE... D c 7 D SQL_COLUMN_NULLABLE... D c 8 D SQL_COLUMN_INDICATOR_PTR... D c 9 D SQL_COLUMN_DATA_PTR... D c 10 D SQL_COLUMN_NAME... D c 11 D SQL_COLUMN_UNNAMED... D c 12 D SQL_COLUMN_DISPLAY_SIZE... D c 13 D SQL_COLUMN_AUTO_INCREMENT... D c 14 D SQL_COLUMN_SEARCHABLE... D c 15 D SQL_COLUMN_UPDATABLE... D c 16 D SQL_COLUMN_BASE_COLUMN... D c 17 D SQL_COLUMN_BASE_TABLE... D c 18 D SQL_COLUMN_BASE_SCHEMA... D c 19 D SQL_COLUMN_LABEL... D c 20 D SQL_COLUMN_MONEY... D c 21 D SQL_COLUMN_ALLOC_TYPE... D c 99 D SQL_COLUMN_ALLOC_AUTO... D c 1 D SQL_COLUMN_ALLOC_USER... D c 2 ************************************************************** * Valid codes for SpecialColumns procedure ************************************************************** D SQL_SCOPE_CURROW... D c 0 D SQL_SCOPE_TRANSACTION... D c 1 D SQL_SCOPE_SESSION... D c 2 D SQL_PC_UNKNOWN... D c 0 D SQL_PC_NOT_PSEUDO... D c 1 D SQL_PC_PSEUDO... D c 2 ************************************************************** * Valid values for connect attribute ************************************************************** D SQL_ATTR_AUTO_IPD... D c 10001 D SQL_ATTR_ACCESS_MODE... D c 10002 D SQL_ACCESS_MODE... D c 10002 D SQL_ATTR_AUTOCOMMIT... D c 10003 D SQL_AUTOCOMMIT... D c 10003 D SQL_ATTR_DBC_SYS_NAMING... D c 10004 D SQL_ATTR_DBC_DEFAULT_LIB... D c 10005 D SQL_ATTR_ADOPT_OWNER_AUTH... D c 10006 D SQL_ATTR_SYSBAS_CMT... D c 10007 D SQL_ATTR_COMMIT... D c 0 D SQL_MODE_READ_ONLY... D c 0 D SQL_MODE_READ_WRITE... D c 1 D SQL_MODE_DEFAULT... D c 1 D SQL_AUTOCOMMIT_OFF... D c 0 D SQL_AUTOCOMMIT_ON... D c 1 D SQL_TXN_ISOLATION... D c 0 D SQL_ATTR_TXN_ISOLATION... D c 0 D SQL_COMMIT_NONE... D c 1 D SQL_TXN_NO_COMMIT... D c 1 D SQL_TXN_NOCOMMIT... D c 1 D SQL_COMMIT_CHG... D c 2 D SQL_COMMIT_UR... D c 2 D SQL_TXN_READ_UNCOMMITTED... D c 2 D SQL_COMMIT_CS... D c 3 D SQL_TXN_READ_COMMITTED... D c 3 D SQL_COMMIT_ALL... D c 4 D SQL_COMMIT_RS... D c 4 D SQL_TXN_REPEATABLE_READ... D c 4 D SQL_COMMIT_RR... D c 5 D SQL_TXN_SERIALIZABLE... D c 5 ************************************************************** * Valid index flags ************************************************************** D SQL_INDEX_UNIQUE... D c 0 D SQL_INDEX_ALL... D c 1 D SQL_INDEX_OTHER... D c 3 D SQL_TABLE_STAT... D c 0 D SQL_ENSURE... D c 1 D SQL_QUICK... D c 0 ************************************************************** * Valid trace values ************************************************************** D SQL_ATTR_TRACE_CLI... D c 1 D SQL_ATTR_TRACE_DBMON... D c 2 D SQL_ATTR_TRACE_DEBUG... D c 4 D SQL_ATTR_TRACE_JOBLOG... D c 8 D SQL_ATTR_TRACE_STRTRC... D c 16 ************************************************************** * Valid file options * DEFINED IN SQL_H ************************************************************** D*SQL_FILE_READ... D** c 2 D*SQL_FILE_CREATE... D* c 8 D*SQL_FILE_OVERWRITE... D* c 16 D*SQL_FILE_APPEND... D* c 32 ************************************************************** * Valid types for GetDiagField ************************************************************** D SQL_DIAG_RETURNCODE... D c 1 D SQL_DIAG_NUMBER... D c 2 D SQL_DIAG_ROW_COUNT... D c 3 D SQL_DIAG_SQLSTATE... D c 4 D SQL_DIAG_NATIVE... D c 5 D SQL_DIAG_MESSAGE_TEXT... D c 6 D SQL_DIAG_DYNAMIC_FUNCTION... D c 7 D SQL_DIAG_CLASS_ORIGIN... D c 8 D SQL_DIAG_SUBCLASS_ORIGIN... D c 9 D SQL_DIAG_CONNECTION_NAME... D c 10 D SQL_DIAG_SERVER_NAME... D c 11 D SQL_DIAG_MESSAGE_TOKEN... D c 12 D SQL_DIAG_AUTOGEN_KEY... D c 14 ************************************************************** * SQLColAttributes defines * These are also used by SQLGetInfo ************************************************************** D SQL_UNSEARCHABLE... D c 0 D SQL_LIKE_ONLY... D c 1 D SQL_ALL_EXCEPT_LIKE... D c 2 D SQL_SEARCHABLE... D c 3 ************************************************************** * GetFunctions() values to identify CLI functions ************************************************************** D SQL_API_SQLALLOCCONNECT... D c 1 D SQL_API_SQLALLOCENV... D c 2 D SQL_API_SQLALLOCHANDLE... D c 1001 D SQL_API_SQLALLOCSTMT... D c 3 D SQL_API_SQLBINDCOL... D c 4 D SQL_API_SQLBINDFILETOCOL... D c 2002 D SQL_API_SQLBINDFILETOPARAM... D c 2003 D SQL_API_SQLBINDPARAM... D c 1002 D SQL_API_SQLBINDPARAMETER... D c 1023 D SQL_API_SQLCANCEL... D c 5 D SQL_API_SQLCLOSECURSOR... D c 1003 D SQL_API_SQLCOLATTRIBUTES... D c 6 D SQL_API_SQLCOLUMNPRIVILEGES... D c 2010 D SQL_API_SQLCOLUMNS... D c 40 D SQL_API_SQLCONNECT... D c 7 D SQL_API_SQLCOPYDESC... D c 1004 D SQL_API_SQLDATASOURCES... D c 57 D SQL_API_SQLDESCRIBECOL... D c 8 D SQL_API_SQLDESCRIBEPARAM... D c 58 D SQL_API_SQLDISCONNECT... D c 9 D SQL_API_SQLDRIVERCONNECT... D c 68 D SQL_API_SQLENDTRAN... D c 1005 D SQL_API_SQLERROR... D c 10 D SQL_API_SQLEXECDIRECT... D c 11 D SQL_API_SQLEXECUTE... D c 12 D SQL_API_SQLEXTENDEDFETCH... D c 1022 D SQL_API_SQLFETCH... D c 13 D SQL_API_SQLFETCHSCROLL... D c 1021 D SQL_API_SQLFOREIGNKEYS... D c 60 D SQL_API_SQLFREECONNECT... D c 14 D SQL_API_SQLFREEENV... D c 15 D SQL_API_SQLFREEHANDLE... D c 1006 D SQL_API_SQLFREESTMT... D c 16 D SQL_API_SQLGETCOL... D c 43 D SQL_API_SQLGETCONNECTATTR... D c 1007 D SQL_API_SQLGETCONNECTOPTION... D c 42 D SQL_API_SQLGETCURSORNAME... D c 17 D SQL_API_SQLGETDATA... D c 43 D SQL_API_SQLGETDESCFIELD... D c 1008 D SQL_API_SQLGETDESCREC... D c 1009 D SQL_API_SQLGETDIAGFIELD... D c 1010 D SQL_API_SQLGETDIAGREC... D c 1011 D SQL_API_SQLGETENVATTR... D c 1012 D SQL_API_SQLGETFUNCTIONS... D c 44 D SQL_API_SQLGETINFO... D c 45 D SQL_API_SQLGETLENGTH... D c 2004 D SQL_API_SQLGETPOSITION... D c 2005 D SQL_API_SQLGETSTMTATTR... D c 1014 D SQL_API_SQLGETSTMTOPTION... D c 46 D SQL_API_SQLGETSUBSTRING... D c 2006 D SQL_API_SQLGETTYPEINFO... D c 47 D SQL_API_SQLLANGUAGES... D c 2001 D SQL_API_SQLMORERESULTS... D c 61 D SQL_API_SQLNATIVESQL... D c 62 D SQL_API_SQLNEXTRESULT... D c 2009 D SQL_API_SQLNUMPARAMS... D c 63 D SQL_API_SQLNUMRESULTCOLS... D c 18 D SQL_API_SQLPARAMDATA... D c 48 D SQL_API_SQLPARAMOPTIONS... D c 2007 D SQL_API_SQLPREPARE... D c 19 D SQL_API_SQLPRIMARYKEYS... D c 65 D SQL_API_SQLPROCEDURECOLUMNS... D c 66 D SQL_API_SQLPROCEDURES... D c 67 D SQL_API_SQLPUTDATA... D c 49 D SQL_API_SQLRELEASEENV... D c 1015 D SQL_API_SQLROWCOUNT... D c 20 D SQL_API_SQLSETCONNECTATTR... D c 1016 D SQL_API_SQLSETCONNECTOPTION... D c 50 D SQL_API_SQLSETCURSORNAME... D c 21 D SQL_API_SQLSETDESCFIELD... D c 1017 D SQL_API_SQLSETDESCREC... D c 1018 D SQL_API_SQLSETENVATTR... D c 1019 D SQL_API_SQLSETPARAM... D c 22 D SQL_API_SQLSETSTMTATTR... D c 1020 D SQL_API_SQLSETSTMTOPTION... D c 51 D SQL_API_SQLSPECIALCOLUMNS... D c 52 D SQL_API_SQLSTARTTRAN... D c 2008 D SQL_API_SQLSTATISTICS... D c 53 D SQL_API_SQLTABLEPRIVILEGES... D c 2011 D SQL_API_SQLTABLES... D c 54 D SQL_API_SQLTRANSACT... D c 23 ************************************************************** * Unsupported APIs ************************************************************** D SQL_API_SQLSETPOS... D c -1 ************************************************************** * NULL handle defines ************************************************************** D SQL_NULL_HENV... D c 0 D SQL_NULL_HDBC... D c 0 D SQL_NULL_HSTMT... D c 0 ************************************************************** * TYPEDEFs ************************************************************** D SQL_TYPEDEFS... D ds based(ptrNull) D HDBC_... D like(ctypes.long) D HDESC_... D like(ctypes.long) D HENV_... D like(ctypes.long) D HSTMT_... D like(ctypes.long) D PTR_... D like(ctypes.pointer) D SDWORD_... D like(ctypes.signedLongInt) D SFLOAT_... D like(ctypes.float) D SWORD_... D like(ctypes.signedShortInt) D RETCODE_... D like(SQLINTEGER) D SQLCHAR... D like(ctypes.char) D SQLDOUBLE... D like(ctypes.double) D SQLHANDLE... D like(ctypes.long) D SQLHDBC... D like(HDBC_) D SQLHDESC... D like(HDESC_) D SQLHENV... D like(HENV_) D SQLHSTMT... D like(HSTMT_) D SQLHWND... D like(SQLPOINTER) D SQLINTEGER... D like(ctypes.longInt) D SQLPOINTER... D like(PTR_) D SQLREAL... D like(ctypes.float) D SQLRETURN... D like(RETCODE_) D SQLSMALLINT... D like(ctypes.shortInt) D SQLUINTEGER... D like(UDWORD_) D SQLUSMALLINT... D like(UWORD_) D UDWORD_... D like(ctypes.unsignedLongInt) D UWORD_... D like(ctypes.unsignedShortInt) ************************************************************** * Additional defines * * SQL_MAX_DSN_LENGTH - maximum data source name size * SQL_MAX_ID_LENGTH - maximum identifier name size, * e.g. cursor names * SQL_MAXLSTR - maximum length of an LSTRING * SQL_LVCHAROH - overhead for LONG VARCHAR in record * SQL_LOBCHAROH - overhead for LOB in record ************************************************************** D SQL_MAX_DSN_LENGTH... D c 18 D SQL_MAX_ID_LENGTH... D c 18 D SQL_MAXLSTR... D c 255 D SQL_LVCHAROH... D c 26 D SQL_LOBCHAROH... D c 312 ************************************************************** * SQL extended data types (negative means unsupported) ************************************************************** D SQL_TINYINT... D c -6 D SQL_BIT... D c -7 ************************************************************** * C data type to SQL data type mapping ************************************************************** D SQL_C_CHAR... D c 1 D** SQL_CHAR D SQL_C_LONG... D c 4 D** SQL_NULL_HANDLE D SQL_C_SLONG... D c 4 D** SQL_NULL_HANDLE D SQL_C_SHORT... D c 5 D** SQL_SMALLINT D SQL_C_FLOAT... D c 7 D** SQL_REAL D SQL_C_DOUBLE... D c 8 D** SQL_DOUBLE D SQL_C_DATE... D c 91 D** SQL_DATE D SQL_C_TIME... D c 92 D** SQL_TIME D SQL_C_TIMESTAMP... D c 93 D** SQL_TIMESTAMP D SQL_C_BINARY... D c 97 D** SQL_BINARY D SQL_C_BIT... D c -7 D** SQL_BIT D SQL_C_TINYINT... D c -6 D** SQL_TINYINT D SQL_C_BIGINT... D c 19 D** SQL_BIGINT D SQL_C_DBCHAR... D c 15 D** SQL_DBCLOB D SQL_C_WCHAR... D c 17 D** SQL_WCHAR D SQL_C_DATETIME... D c 9 D** SQL_DATETIME D SQL_C_BLOB... D c 13 D** SQL_BLOB D SQL_C_CLOB... D c 14 D** SQL_CLOB D SQL_C_DBCLOB... D c 15 D** SQL_DBCLOB D SQL_C_BLOB_LOCATOR... D c 20 D** SQL_BLOB_LOCATOR D SQL_C_CLOB_LOCATOR... D c 21 D** SQL_CLOB_LOCATOR D SQL_C_DBCLOB_LOCATOR... D c 22 D** SQL_DBCLOB_LOCATOR ************************************************************** * miscellaneous constants and unsupported functions ************************************************************** D SQL_ADD... D c -1 D SQL_ATTR_PARAMSET_SIZE... D c -1 D SQL_ATTR_PARAMS_PROCESSED_PTR... D c -1 D SQL_ATTR_PARAM_BIND_TYPE... D c -1 D SQL_ATTR_PARAM_STATUS_PTR... D c -1 D SQL_DELETE... D c -1 D SQL_KEYSET_SIZE... D c -1 D SQL_LCK_NO_CHANGE... D c -1 D SQL_LOCK_NO_CHANGE... D c -1 D SQL_LOCK_EXCLUSIVE... D c -1 D SQL_LOCK_UNLOCK... D c -1 D SQL_METH_D... D c -1 D SQL_POSITION... D c -1 D SQL_QUERY_TIMEOUT... D c -1 D SQL_ROW_ADDED... D c -1 D SQL_ROW_NOROW... D c -1 D SQL_ROW_ERROR... D c -1 D SQL_ROW_SUCCESS... D c 0 D SQL_ROW_SUCCESS_WITH_INFO... D c -1 D SQL_SC_TRY_UNIQUE... D c -1 D SQL_SIMULATE_CURSOR... D c -1 D SQL_UNKNOWN_TYPE... D c -1 D SQL_UPDATE... D c -1 D SQL_WARN_VAL_TRUNC... D c 01004 ************************************************************** * DATE, TIME, and TIMESTAMP structures. These are for * compatibility purposes only. When actually specifying or * retrieving DATE, TIME, and TIMESTAMP values, character * strings must be used. ************************************************************** D DATE_STRUCT... D ds based(ptrNull) D qualified D year... D like(SQLSMALLINT) D month... D like(SQLSMALLINT) D day... D like(SQLSMALLINT) D TIME_STRUCT... D ds based(ptrNull) D qualified D hour... D like(SQLSMALLINT) D minute... D like(SQLSMALLINT) D second... D like(SQLSMALLINT) D TIMESTAMP_STRUCT... D ds based(ptrNull) D qualified D year... D like(SQLSMALLINT) D month... D like(SQLSMALLINT) D day... D like(SQLSMALLINT) D hour... D like(SQLSMALLINT) D minute... D like(SQLSMALLINT) D second... D like(SQLSMALLINT) D fraction... D like(SQLINTEGER) ************************************************************** * Transaction info structure ************************************************************** D TXN_STRUCT... D ds based(ptrNull) D qualified D operation... D like(SQLINTEGER) D tminfo... D like(SQLCHAR) D dim(10) D reserved1... D like(SQLCHAR) D dim(2) D XID... D like(ctypes.pointer) D timeoutval... D like(SQLINTEGER) D locktimeout... D like(SQLINTEGER) D reserved2... D like(SQLCHAR) D dim(8) ************************************************************** * SQL_EXTERN SQLRETURN SQLAllocConnect ( * SQLHENV henv, * SQLHDBC *phdbc); ************************************************************** D SQLAllocConnect... D pr extproc(*cnowiden : D 'SQLAllocConnect') D like(SQLRETURN) D henv... D like(SQLHENV) D value D phdbc... D like(SQLHDBC) ************************************************************** * SQL_EXTERN SQLRETURN SQLAllocEnv ( * SQLHENV *phenv); ************************************************************** D SQLAllocEnv... D pr extproc(*cnowiden : D 'SQLAllocEnv') D like(SQLRETURN) D phenv... D like(SQLHENV) ************************************************************** * SQL_EXTERN SQLRETURN SQLAllocStmt ( * SQLHDBC hdbc, * SQLHSTMT *phstmt); ************************************************************** D SQLAllocStmt... D pr extproc(*cnowiden : D 'SQLAllocStmt') D like(SQLRETURN) D hdbc... D like(SQLHDBC) D value D phstmt... D like(SQLHSTMT) ************************************************************** * SQL_EXTERN SQLRETURN SQLBindCol ( * SQLHSTMT hstmt, * SQLSMALLINT icol, * SQLSMALLINT iType, * SQLPOINTER rgbValue, * SQLINTEGER cbValueMax, * SQLINTEGER *pcbValue); ************************************************************** D SQLBindCol... D pr extproc(*cnowiden : D 'SQLBindCol') D like(SQLRETURN) D hstmt... D like(SQLHSTMT) D value D icol... D like(SQLSMALLINT) D value D fCType... D like(SQLSMALLINT) D value D rgbValue... D like(SQLPOINTER) D value D cbValueMax... D like(SQLINTEGER) D value D pcbValue... D like(SQLINTEGER) ************************************************************** * SQL_EXTERN SQLRETURN SQLBindParameter ( * SQLHSTMT StatementHandle, * SQLSMALLINT ParameterNumber, * SQLSMALLINT InputOutputType, * SQLSMALLINT ValueType, * SQLSMALLINT ParameterType * SQLINTEGER ColumnSize, * SQLSMALLINT DecimalDigits, * SQLPOINTER ParameterValuePtr, * SQLINTEGER BufferLength, * SQLINTEGER *StrLen_or_IndPtr ************************************************************** D SQLBindParameter... D pr extproc(*cnowiden : D 'SQLBindParameter') D like(SQLRETURN) D StatementHandle... D like(SQLHSTMT) D value D ParameterNumber... D like(SQLSMALLINT) D value D InputOutputType... D like(SQLSMALLINT) D value D ValueType... D like(SQLSMALLINT) D value D ParameterType... D like(SQLSMALLINT) D value D ColumnSize... D like(SQLINTEGER) D value D DecimalDigits... D like(SQLSMALLINT) D value D ParameterValuePtr... D like(SQLPOINTER) D value D BufferLength... D like(SQLINTEGER) D value D StrLen_or_IndPtr... D like(SQLINTEGER) ************************************************************** * SQL_EXTERN SQLRETURN SQLConnect ( * SQLHDBC hdbc, * SQLCHAR *szDSN, * SQLSMALLINT cbDSN, * SQLCHAR *szUID, * SQLSMALLINT cbUID, * SQLCHAR *szAuthStr, * SQLSMALLINT cbAuthStr); ************************************************************** D SQLConnect... D pr extproc(*cnowiden : D 'SQLConnect') D like(SQLRETURN) D hdbc... D like(SQLHDBC) D value D szDSN... D like(SQLPOINTER) D options(*string) D value D cbDSN... D like(SQLSMALLINT) D value D szUID... D like(SQLPOINTER) D options(*string) D value D cbUID... D like(SQLSMALLINT) D value D szAuthStr... D like(SQLPOINTER) D options(*string) D value D cbAuthStr... D like(SQLSMALLINT) D value ************************************************************** * SQL_EXTERN SQLRETURN SQLDisconnect ( * SQLHDBC hdbc); ************************************************************** D SQLDisconnect... D pr extproc(*cnowiden : D 'SQLDisconnect') D like(SQLRETURN) D hdbc... D like(SQLHDBC) D value ************************************************************** * SQL_EXTERN SQLRETURN SQLExecDirect ( * SQLHSTMT hstmt, * SQLCHAR *szSqlStr, * SQLINTEGER cbSqlStr); ************************************************************** D SQLExecDirect... D pr extproc(*cnowiden : D 'SQLExecDirect') D like(SQLRETURN) D hstmt... D like(SQLHSTMT) D value D szSqlStr... D like(SQLPOINTER) D options(*string) D value D cbSqlStr... D like(SQLSMALLINT) D value ************************************************************** * SQL_EXTERN SQLRETURN SQLExecute ( * SQLHSTMT hstmt); ************************************************************** D SQLExecute... D pr extproc(*cnowiden : D 'SQLExecute') D like(SQLRETURN) D hstmt... D like(SQLHSTMT) D value ************************************************************** * SQL_EXTERN SQLRETURN SQLFetch ( * SQLHSTMT hstmt); ************************************************************** D SQLFetch... D pr extproc(*cnowiden : D 'SQLFetch') D like(SQLRETURN) D hstmt... D like(SQLHSTMT) D value ************************************************************** * SQL_EXTERN SQLRETURN SQLFreeConnect ( * SQLHDBC hdbc); ************************************************************** D SQLFreeConnect... D pr extproc(*cnowiden : D 'SQLFreeConnect') D like(SQLRETURN) D hdbc... D like(SQLHDBC) D value ************************************************************** * SQL_EXTERN SQLRETURN SQLFreeEnv ( * SQLHENV henv); ************************************************************** D SQLFreeEnv... D pr extproc(*cnowiden : D 'SQLFreeEnv') D like(SQLRETURN) D henv... D like(SQLHENV) D value ************************************************************** * SQL_EXTERN SQLRETURN SQLFreeStmt ( * SQLHSTMT hstmt, * SQLSMALLINT fOption); ************************************************************** D SQLFreeStmt... D pr extproc(*cnowiden : D 'SQLFreeStmt') D like(SQLRETURN) D hstmt... D like(SQLHSTMT) D value D fOption... D like(SQLSMALLINT) D value ************************************************************** * SQL_EXTERN SQLRETURN SQLPrepare ( * SQLHSTMT hstmt, * SQLCHAR *szSqlStr, * SQLSMALLINT cbSqlStr); ************************************************************** D SQLPrepare... D pr extproc(*cnowiden : D 'SQLPrepare') D like(SQLRETURN) D hstmt... D like(SQLHSTMT) D value D szSqlStr... D like(SQLPOINTER) D options(*string) D value D cbSqlStr... D like(SQLSMALLINT) D value /ENDIF