sqlcli1.h
来自「SQLAPI C/C++ 连接Oracle 数据库！」· C头文件 代码 · 共 1,550 行 · 第 1/4 页
H
1,550 行
#define SQL_ATTR_EARLYCLOSE 1268#define SQL_ATTR_PROCESSCTL 1278#define SQL_ATTR_PREFETCH 1285#define SQL_ATTR_ENABLE_IPD_SETTING 1286/* * Descriptor value for setting the descriptor type. */#define SQL_DESC_DESCRIPTOR_TYPE 1287#define SQL_ATTR_OPTIMIZE_SQLCOLUMNS 1288#define SQL_ATTR_MEM_DEBUG_DUMP 1289#define SQL_ATTR_CONNECT_NODE 1290#define SQL_ATTR_CONNECT_WITH_XA 1291#define SQL_ATTR_GET_XA_RESOURCE 1292#define SQL_ATTR_DB2_SQLERRP 2451#define SQL_ATTR_SERVER_MSGTXT_SP 2452#define SQL_ATTR_OPTIMIZE_FOR_NROWS 2450#define SQL_ATTR_QUERY_OPTIMIZATION_LEVEL 1293#define SQL_ATTR_USE_LIGHT_OUTPUT_SQLDA 1298#define SQL_ATTR_CURSOR_BLOCK_NUM_ROWS 2453#define SQL_ATTR_CURSOR_BLOCK_EARLY_CLOSE 2454#define SQL_ATTR_SERVER_MSGTXT_MASK 2455#define SQL_ATTR_USE_LIGHT_INPUT_SQLDA 2458#define SQL_ATTR_BLOCK_FOR_NROWS 2459#define SQL_ATTR_OPTIMIZE_ROWS_FOR_BLOCKING 2460#define SQL_ATTR_STATICMODE 2467#define SQL_ATTR_DB2_MESSAGE_PREFIX 2468#define SQL_ATTR_CALL_RETVAL_AS_PARM 2469#define SQL_ATTR_CALL_RETURN 2470#define SQL_ATTR_RETURN_USER_DEFINED_TYPES 2471#define SQL_ATTR_ENABLE_EXTENDED_PARAMDATA 2472#define SQL_ATTR_APP_TYPE 2473#define SQL_ATTR_TRANSFORM_GROUP 2474#define SQL_ATTR_DESCRIBE_CALL 2476#define SQL_ATTR_AUTOCOMMCLEANUP 2477#define SQL_ATTR_USEMALLOC 2478#define SQL_ATTR_PRESERVE_LOCALE 2479#define SQL_ATTR_MAPGRAPHIC 2480#define SQL_ATTR_INSERT_BUFFERING 2481#define SQL_ATTR_USE_LOAD_API 2482#define SQL_ATTR_LOAD_RECOVERABLE 2483#define SQL_ATTR_LOAD_COPY_LOCATION 2484#define SQL_ATTR_LOAD_MESSAGE_FILE 2485#define SQL_ATTR_LOAD_SAVECOUNT 2486#define SQL_ATTR_LOAD_CPU_PARALLELISM 2487#define SQL_ATTR_LOAD_DISK_PARALLELISM 2488#define SQL_ATTR_LOAD_INDEXING_MODE 2489#define SQL_ATTR_LOAD_STATS_MODE 2490#define SQL_ATTR_LOAD_TEMP_FILES_PATH 2491#define SQL_ATTR_LOAD_DATA_BUFFER_SIZE 2492#define SQL_ATTR_LOAD_MODIFIED_BY 2493#define SQL_ATTR_DB2_RESERVED_2494 2494#define SQL_ATTR_DESCRIBE_BEHAVIOR 2495#define SQL_ATTR_FETCH_SENSITIVITY 2496#define SQL_ATTR_DB2_RESERVED_2497 2497#define SQL_ATTR_CLIENT_LOB_BUFFERING 2498#define SQL_ATTR_SKIP_TRACE 2499#define SQL_ATTR_LOAD_INFO 2501#define SQL_ATTR_DESCRIBE_INPUT_ON_PREPARE 2505#define SQL_ATTR_DESCRIBE_OUTPUT_LEVEL 2506#define SQL_ATTR_CURRENT_PACKAGE_PATH 2509#define SQL_ATTR_INFO_PROGRAMID 2511#define SQL_ATTR_INFO_PROGRAMNAME 2516#define SQL_ATTR_FREE_LOCATORS_ON_FETCH 2518#define SQL_ATTR_KEEP_DYNAMIC 2522#define SQL_ATTR_LOAD_ROWS_READ_PTR 2524#define SQL_ATTR_LOAD_ROWS_SKIPPED_PTR 2525#define SQL_ATTR_LOAD_ROWS_COMMITTED_PTR 2526#define SQL_ATTR_LOAD_ROWS_LOADED_PTR 2527#define SQL_ATTR_LOAD_ROWS_REJECTED_PTR 2528#define SQL_ATTR_LOAD_ROWS_DELETED_PTR 2529#define SQL_ATTR_LOAD_INFO_VER 2530#define SQL_ATTR_SET_SSA 2531#define SQL_ATTR_BLOCK_LOBS 2534#define SQL_ATTR_LOAD_ACCESS_LEVEL 2536#define SQL_ATTR_MAPCHAR 2546#define SQL_ATTR_ARM_CORRELATOR 2554#define SQL_ATTR_CLIENT_DEBUGINFO 2556/* * SQL_ATTR_DESCRIBE_INPUT / SQL_ATTR_DESCRIBE_OUTPUT values */#define SQL_DESCRIBE_NONE 0#define SQL_DESCRIBE_LIGHT 1#define SQL_DESCRIBE_REGULAR 2#define SQL_DESCRIBE_EXTENDED 3/* * Use load values. */#define SQL_USE_LOAD_OFF 0#define SQL_USE_LOAD_INSERT 1#define SQL_USE_LOAD_REPLACE 2#define SQL_USE_LOAD_RESTART 3#define SQL_USE_LOAD_TERMINATE 4/* * SQL_ATTR_PREFETCH_ENABLE values. */#define SQL_PREFETCH_ON 1#define SQL_PREFETCH_OFF 0#define SQL_PREFETCH_DEFAULT SQL_PREFETCH_OFF/* SQL_CLOSE_BEHAVIOR values. */#define SQL_CC_NO_RELEASE 0#define SQL_CC_RELEASE 1#define SQL_CC_DEFAULT SQL_CC_NO_RELEASE/* SQL_ATTR_DEFERRED_PREPARE values */#define SQL_DEFERRED_PREPARE_ON 1#define SQL_DEFERRED_PREPARE_OFF 0#define SQL_DEFERRED_PREPARE_DEFAULT SQL_DEFERRED_PREPARE_ON/* SQL_ATTR_EARLYCLOSE values */#define SQL_EARLYCLOSE_ON 1#define SQL_EARLYCLOSE_OFF 0#define SQL_EARLYCLOSE_SERVER 2#define SQL_EARLYCLOSE_DEFAULT SQL_EARLYCLOSE_ON/* SQL_ATTR_APP_TYPE values */#define SQL_APP_TYPE_ODBC 1#define SQL_APP_TYPE_OLEDB 2#define SQL_APP_TYPE_JDBC 3#define SQL_APP_TYPE_ADONET 4#define SQL_APP_TYPE_DEFAULT SQL_APP_TYPE_ODBC/* SQL_ATTR_PROCESSCTL masks */#define SQL_PROCESSCTL_NOTHREAD 0x00000001L#define SQL_PROCESSCTL_NOFORK 0x00000002L#define SQL_PROCESSCTL_SHARESTMTDESC 0x00000004L/* CLI attribute/option values */#define SQL_FALSE 0#define SQL_TRUE 1/* Options for SQL_CURSOR_HOLD */#define SQL_CURSOR_HOLD_ON 1#define SQL_CURSOR_HOLD_OFF 0#define SQL_CURSOR_HOLD_DEFAULT SQL_CURSOR_HOLD_ON/* Options for SQL_NODESCRIBE_INPUT/SQL_NODESCRIBE_OUTPUT */#define SQL_NODESCRIBE_ON 1#define SQL_NODESCRIBE_OFF 0#define SQL_NODESCRIBE_DEFAULT SQL_NODESCRIBE_OFF/* Options for SQL_ATTR_DESCRIBE_CALL */#define SQL_DESCRIBE_CALL_NEVER 0#define SQL_DESCRIBE_CALL_BEFORE 1#define SQL_DESCRIBE_CALL_ON_ERROR 2#define SQL_DESCRIBE_CALL_DEFAULT (-1)/* Options for SQL_ATTR_CLIENT_LOB_BUFFERING */#define SQL_CLIENTLOB_USE_LOCATORS 0#define SQL_CLIENTLOB_BUFFER_UNBOUND_LOBS 1#define SQL_CLIENTLOB_DEFAULT SQL_CLIENTLOB_USE_LOCATORS/* Options for SQL_ATTR_PREPDESC_BEHAVIOR *//* To be determined *//* Options for SQLGetConnectOption/SQLSetConnectOption extensions */#define SQL_WCHARTYPE 1252#define SQL_LONGDATA_COMPAT 1253#define SQL_CURRENT_SCHEMA 1254#define SQL_DB2EXPLAIN 1258#define SQL_DB2ESTIMATE 1259#define SQL_PARAMOPT_ATOMIC 1260#define SQL_STMTTXN_ISOLATION 1261#define SQL_MAXCONN 1262#define SQL_ATTR_CLISCHEMA 1280#define SQL_ATTR_INFO_USERID 1281#define SQL_ATTR_INFO_WRKSTNNAME 1282#define SQL_ATTR_INFO_APPLNAME 1283#define SQL_ATTR_INFO_ACCTSTR 1284#define SQL_ATTR_AUTOCOMMIT_NOCOMMIT 2462#define SQL_ATTR_QUERY_PATROLLER 2466#define SQL_ATTR_CHAINING_BEGIN 2464#define SQL_ATTR_CHAINING_END 2465#define SQL_ATTR_EXTENDEDBIND 2475#define SQL_ATTR_GRAPHIC_UNICODESERVER 2503#define SQL_ATTR_RETURN_CHAR_AS_WCHAR_OLEDB 2517#define SQL_ATTR_GATEWAY_CONNECTED 2537#define SQL_ATTR_SQLCOLUMNS_SORT_BY_ORDINAL_OLEDB 2542#define SQL_ATTR_REPORT_ISLONG_FOR_LONGTYPES_OLEDB 2543#define SQL_ATTR_PING_DB 2545#define SQL_ATTR_RECEIVE_TIMEOUT 2547#define SQL_ATTR_REOPT 2548#define SQL_ATTR_LOB_CACHE_SIZE 2555#define SQL_ATTR_STREAM_GETDATA 2558#define SQL_ATTR_APP_USES_LOB_LOCATOR 2559#define SQL_ATTR_MAX_LOB_BLOCK_SIZE 2560#define SQL_ATTR_USE_TRUSTED_CONTEXT 2561#define SQL_ATTR_TRUSTED_CONTEXT_USERID 2562#define SQL_ATTR_TRUSTED_CONTEXT_PASSWORD 2563#define SQL_ATTR_USER_REGISTRY_NAME 2564#define SQL_ATTR_DECFLOAT_ROUNDING_MODE 2565#define SQL_ATTR_APPEND_FOR_FETCH_ONLY 2573#define SQL_ATTR_ONLY_USE_BIG_PACKAGES 2577#define SQL_ATTR_WCHARTYPE SQL_WCHARTYPE#define SQL_ATTR_LONGDATA_COMPAT SQL_LONGDATA_COMPAT#define SQL_ATTR_CURRENT_SCHEMA SQL_CURRENT_SCHEMA#define SQL_ATTR_DB2EXPLAIN SQL_DB2EXPLAIN#define SQL_ATTR_DB2ESTIMATE SQL_DB2ESTIMATE#define SQL_ATTR_PARAMOPT_ATOMIC SQL_PARAMOPT_ATOMIC#define SQL_ATTR_STMTTXN_ISOLATION SQL_STMTTXN_ISOLATION#define SQL_ATTR_MAXCONN SQL_MAXCONN/* Options for SQLSetConnectOption, SQLSetEnvAttr */#define SQL_CONNECTTYPE 1255#define SQL_SYNC_POINT 1256#define SQL_MINMEMORY_USAGE 1263#define SQL_CONN_CONTEXT 1269#define SQL_ATTR_INHERIT_NULL_CONNECT 1270#define SQL_ATTR_FORCE_CONVERSION_ON_CLIENT 1275#define SQL_ATTR_INFO_KEYWORDLIST 2500#define SQL_ATTR_CONNECTTYPE SQL_CONNECTTYPE#define SQL_ATTR_SYNC_POINT SQL_SYNC_POINT#define SQL_ATTR_MINMEMORY_USAGE SQL_MINMEMORY_USAGE#define SQL_ATTR_CONN_CONTEXT SQL_CONN_CONTEXT/* Options for SQL_LONGDATA_COMPAT */#define SQL_LD_COMPAT_YES 1#define SQL_LD_COMPAT_NO 0#define SQL_LD_COMPAT_DEFAULT SQL_LD_COMPAT_NO/* Options for SQL_ATTR_EXTENDEDBIND */#define SQL_ATTR_EXTENDEDBIND_COPY 1#define SQL_ATTR_EXTENDEDBIND_NOCOPY 0#define SQL_ATTR_EXTENDEDBIND_DEFAULT SQL_ATTR_EXTENDEDBIND_NOCOPY/* SQL_NULL_COLLATION values */#define SQL_NC_HIGH 0#define SQL_NC_LOW 1/* Options for SQLGetInfo extentions */#define CLI_MAX_LONGVARCHAR 1250#define CLI_MAX_VARCHAR 1251#define CLI_MAX_CHAR 1252#define CLI_MAX_LONGVARGRAPHIC 1253#define CLI_MAX_VARGRAPHIC 1254#define CLI_MAX_GRAPHIC 1255/* * Private SQLGetDiagField extensions. */#define SQL_DIAG_MESSAGE_TEXT_PTR 2456#define SQL_DIAG_LINE_NUMBER 2461#define SQL_DIAG_ERRMC 2467#define SQL_DIAG_BYTES_PROCESSED 2477#define SQL_DIAG_RELATIVE_COST_ESTIMATE 2504#define SQL_DIAG_ROW_COUNT_ESTIMATE 2507#define SQL_DIAG_ELAPSED_SERVER_TIME 2538#define SQL_DIAG_ELAPSED_NETWORK_TIME 2539#define SQL_DIAG_ACCUMULATED_SERVER_TIME 2540#define SQL_DIAG_ACCUMULATED_NETWORK_TIME 2541#define SQL_DIAG_QUIESCE 2549#define SQL_DIAG_TOLERATED_ERROR 2559/* * Values for SQL_DIAG_QUIESCE */#define SQL_DIAG_QUIESCE_NO 0#define SQL_DIAG_QUIESCE_DATABASE 1#define SQL_DIAG_QUIESCE_INSTANCE 2/* * Private SQLSetEnvAttr extensions. */#define SQL_ATTR_LITTLE_ENDIAN_UNICODE 2457#define SQL_ATTR_DIAGLEVEL 2574#define SQL_ATTR_NOTIFYLEVEL 2575#define SQL_ATTR_DIAGPATH 2576/* * Options for SQL_PARAMOPT_ATOMIC */#define SQL_ATOMIC_YES 1#define SQL_ATOMIC_NO 0#define SQL_ATOMIC_DEFAULT SQL_ATOMIC_YES/* Options for SQL_CONNECT_TYPE */#define SQL_CONCURRENT_TRANS 1#define SQL_COORDINATED_TRANS 2#define SQL_CONNECTTYPE_DEFAULT SQL_CONCURRENT_TRANS/* Options for SQL_SYNCPOINT */#define SQL_ONEPHASE 1#define SQL_TWOPHASE 2#define SQL_SYNCPOINT_DEFAULT SQL_ONEPHASE/* Options for SQL_DB2ESTIMATE */#define SQL_DB2ESTIMATE_ON 1#define SQL_DB2ESTIMATE_OFF 0#define SQL_DB2ESTIMATE_DEFAULT SQL_DB2ESTIMATE_OFF/* Options for SQL_DB2EXPLAIN */#define SQL_DB2EXPLAIN_OFF 0x00000000L#define SQL_DB2EXPLAIN_SNAPSHOT_ON 0x00000001L#define SQL_DB2EXPLAIN_MODE_ON 0x00000002L#define SQL_DB2EXPLAIN_SNAPSHOT_MODE_ON SQL_DB2EXPLAIN_SNAPSHOT_ON+SQL_DB2EXPLAIN_MODE_ON#define SQL_DB2EXPLAIN_ON SQL_DB2EXPLAIN_SNAPSHOT_ON#define SQL_DB2EXPLAIN_DEFAULT SQL_DB2EXPLAIN_OFF/* Options for SQL_WCHARTYPE * Note that you can only specify SQL_WCHARTYPE_CONVERT if you have an * external compile flag SQL_WCHART_CONVERT defined */#ifdef SQL_WCHART_CONVERT#define SQL_WCHARTYPE_CONVERT 1#endif#define SQL_WCHARTYPE_NOCONVERT 0#define SQL_WCHARTYPE_DEFAULT SQL_WCHARTYPE_NOCONVERT/* Options for SQL_ATTR_OPTIMIZE_SQLCOLUMNS * */#define SQL_OPTIMIZE_SQLCOLUMNS_OFF 0#define SQL_OPTIMIZE_SQLCOLUMNS_ON 1#define SQL_OPTIMIZE_SQLCOLUMNS_DEFAULT SQL_OPTIMIZE_SQLCOLUMNS_OFF/* Options for SQL_ATTR_CONNECT_WITH_XA * */#define SQL_CONNECT_WITH_XA_OFF 0#define SQL_CONNECT_WITH_XA_ON 1#define SQL_CONNECT_WITH_XA_DEFAULT SQL_CONNECT_WITH_XA_OFF/* * Options for SQL_ATTR_SERVER_MSGTXT_MASK */#define SQL_ATTR_SERVER_MSGTXT_MASK_LOCAL_FIRST 0x00000000#define SQL_ATTR_SERVER_MSGTXT_MASK_WARNINGS 0x00000001#define SQL_ATTR_SERVER_MSGTXT_MASK_ERRORS 0xFFFFFFFE#define SQL_ATTR_SERVER_MSGTXT_MASK_ALL 0xFFFFFFFF#define SQL_ATTR_SERVER_MSGTXT_MASK_DEFAULT SQL_ATTR_SERVER_MSGTXT_MASK_LOCAL_FIRST/* * Options for SQL_ATTR_QUERY_PATROLLER */#define SQL_ATTR_QUERY_PATROLLER_DISABLE 1#define SQL_ATTR_QUERY_PATROLLER_ENABLE 2#define SQL_ATTR_QUERY_PATROLLER_BYPASS 3/* * Options for SQL_ATTR_STATICMODE */#define SQL_STATICMODE_DISABLED 0#define SQL_STATICMODE_CAPTURE 1#define SQL_STATICMODE_MATCH 2/* * Options for SQL_ATTR_DB2_MESSAGE_PREFIX */#define SQL_ATTR_DB2_MESSAGE_PREFIX_OFF 0#define SQL_ATTR_DB2_MESSAGE_PREFIX_ON 1#define SQL_ATTR_DB2_MESSAGE_PREFIX_DEFAULT SQL_ATTR_DB2_MESSAGE_PREFIX_ON/* * Options for SQL_ATTR_INSERT_BUFFERING */#define SQL_ATTR_INSERT_BUFFERING_OFF 0#define SQL_ATTR_INSERT_BUFFERING_ON 1#define SQL_ATTR_INSERT_BUFFERING_IGD 2/* Column types and scopes in SQLSpecialColumns */#define SQL_SCOPE_CURROW 0#define SQL_SCOPE_TRANSACTION 1#define SQL_SCOPE_SESSION 2/* Defines for SQLStatistics */#define SQL_INDEX_UNIQUE 0#define SQL_INDEX_ALL 1⌨️ 快捷键说明
复制代码Ctrl + C
搜索代码Ctrl + F
全屏模式F11
增大字号Ctrl + =
减小字号Ctrl + -
显示快捷键?