📄 sqlcli1.h
字号:
/* SQLGetTypeInfo define */#define SQL_ALL_TYPES 0/* Options for SQLGetStmtOption/SQLSetStmtOption */#define SQL_ATTR_AUTO_IPD 10001#define SQL_ATTR_APP_ROW_DESC 10010#define SQL_ATTR_APP_PARAM_DESC 10011#define SQL_ATTR_IMP_ROW_DESC 10012#define SQL_ATTR_IMP_PARAM_DESC 10013#define SQL_ATTR_METADATA_ID 10014#define SQL_ATTR_CURSOR_SCROLLABLE (-1)#define SQL_ATTR_CURSOR_SENSITIVITY (-2)/* SQL_ATTR_CURSOR_SCROLLABLE values */#define SQL_NONSCROLLABLE 0#define SQL_SCROLLABLE 1/* Options for SQLGetStmtOption/SQLSetStmtOption extensions */#define SQL_CURSOR_HOLD 1250#define SQL_ATTR_CURSOR_HOLD 1250#define SQL_NODESCRIBE_OUTPUT 1251#define SQL_ATTR_NODESCRIBE_OUTPUT 1251#define SQL_NODESCRIBE_INPUT 1264#define SQL_ATTR_NODESCRIBE_INPUT 1264#define SQL_NODESCRIBE SQL_NODESCRIBE_OUTPUT#define SQL_ATTR_NODESCRIBE SQL_NODESCRIBE_OUTPUT#define SQL_CLOSE_BEHAVIOR 1257#define SQL_ATTR_CLOSE_BEHAVIOR 1257#define SQL_ATTR_CLOSE_BEHAVIOR 1257#define SQL_ATTR_CLOSEOPEN 1265#define SQL_ATTR_CURRENT_PACKAGE_SET 1276#define SQL_ATTR_DEFERRED_PREPARE 1277#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_USE_2BYTES_OCTET_LENGTH 1299#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/* * 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_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_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 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_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_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/* 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/* * Private SQLSetEnvAttr extensions. */#define SQL_ATTR_LITTLE_ENDIAN_UNICODE 2457/* * 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 CLI_CAP_STATICMODE_DISABLED#define SQL_STATICMODE_CAPTURE CLI_CAP_STATICMODE_CAPTURE#define SQL_STATICMODE_MATCH CLI_CAP_STATICMODE_MATCH/* * 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/* 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/* Defines for SQLStatistics (returned in the result set) */#define SQL_INDEX_CLUSTERED 1#define SQL_INDEX_HASHED 2#define SQL_INDEX_OTHER 3/* Defines for SQLSpecialColumns (returned in the result set) */#define SQL_PC_UNKNOWN 0#define SQL_PC_NON_PSEUDO 1#define SQL_PC_PSEUDO 2/* Reserved value for the IdentifierType argument of SQLSpecialColumns() */#define SQL_ROW_IDENTIFIER 1/* SQLDataSources "fDirection" values, also used on SQLExtendedFetch() *//* See sqlext.h for additional SQLExtendedFetch fetch direction defines */#define SQL_FETCH_NEXT 1#define SQL_FETCH_FIRST 2/* OTHER CODES USED FOR FETCHORIENTATION IN SQLFETCHSCROLL() */#define SQL_FETCH_LAST 3#define SQL_FETCH_PRIOR 4#define SQL_FETCH_ABSOLUTE 5#define SQL_FETCH_RELATIVE 6/* * Environment attributes; note SQL_CONNECTTYPE, SQL_SYNC_POINT are also * environment attributes that are settable at the connection level */#define SQL_ATTR_OUTPUT_NTS 10001/* LOB file reference options */#ifndef SQL_H_SQL /* if sql.h is not included, then... */#define SQL_FILE_READ 2 /* Input file to read from */#define SQL_FILE_CREATE 8 /* Output file - new file to be */⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -