📄 odbc.pm
字号:
, SQL_DS_RESTRICT => 0x00000002, SQL_DS_CASCADE => 0x00000004};$ReturnValues{SQL_DROP_TABLE} ={ SQL_DT_DROP_TABLE => 0x00000001, SQL_DT_RESTRICT => 0x00000002, SQL_DT_CASCADE => 0x00000004};$ReturnValues{SQL_DROP_TRANSLATION} ={ SQL_DTR_DROP_TRANSLATION => 0x00000001};$ReturnValues{SQL_DROP_VIEW} ={ SQL_DV_DROP_VIEW => 0x00000001, SQL_DV_RESTRICT => 0x00000002, SQL_DV_CASCADE => 0x00000004};$ReturnValues{SQL_CURSOR_ATTRIBUTES1} ={ SQL_CA1_NEXT => 0x00000001, SQL_CA1_ABSOLUTE => 0x00000002, SQL_CA1_RELATIVE => 0x00000004, SQL_CA1_BOOKMARK => 0x00000008, SQL_CA1_LOCK_NO_CHANGE => 0x00000040, SQL_CA1_LOCK_EXCLUSIVE => 0x00000080, SQL_CA1_LOCK_UNLOCK => 0x00000100, SQL_CA1_POS_POSITION => 0x00000200, SQL_CA1_POS_UPDATE => 0x00000400, SQL_CA1_POS_DELETE => 0x00000800, SQL_CA1_POS_REFRESH => 0x00001000, SQL_CA1_POSITIONED_UPDATE => 0x00002000, SQL_CA1_POSITIONED_DELETE => 0x00004000, SQL_CA1_SELECT_FOR_UPDATE => 0x00008000, SQL_CA1_BULK_ADD => 0x00010000, SQL_CA1_BULK_UPDATE_BY_BOOKMARK => 0x00020000, SQL_CA1_BULK_DELETE_BY_BOOKMARK => 0x00040000, SQL_CA1_BULK_FETCH_BY_BOOKMARK => 0x00080000};$ReturnValues{ SQL_DYNAMIC_CURSOR_ATTRIBUTES1} = $ReturnValues{SQL_CURSOR_ATTRIBUTES1};$ReturnValues{SQL_FORWARD_ONLY_CURSOR_ATTRIBUTES1} = $ReturnValues{SQL_CURSOR_ATTRIBUTES1};$ReturnValues{ SQL_KEYSET_CURSOR_ATTRIBUTES1} = $ReturnValues{SQL_CURSOR_ATTRIBUTES1};$ReturnValues{ SQL_STATIC_CURSOR_ATTRIBUTES1} = $ReturnValues{SQL_CURSOR_ATTRIBUTES1};$ReturnValues{SQL_CURSOR_ATTRIBUTES2} ={ SQL_CA2_READ_ONLY_CONCURRENCY => 0x00000001, SQL_CA2_LOCK_CONCURRENCY => 0x00000002, SQL_CA2_OPT_ROWVER_CONCURRENCY => 0x00000004, SQL_CA2_OPT_VALUES_CONCURRENCY => 0x00000008, SQL_CA2_SENSITIVITY_ADDITIONS => 0x00000010, SQL_CA2_SENSITIVITY_DELETIONS => 0x00000020, SQL_CA2_SENSITIVITY_UPDATES => 0x00000040, SQL_CA2_MAX_ROWS_SELECT => 0x00000080, SQL_CA2_MAX_ROWS_INSERT => 0x00000100, SQL_CA2_MAX_ROWS_DELETE => 0x00000200, SQL_CA2_MAX_ROWS_UPDATE => 0x00000400, SQL_CA2_MAX_ROWS_CATALOG => 0x00000800, SQL_CA2_CRC_EXACT => 0x00001000, SQL_CA2_CRC_APPROXIMATE => 0x00002000, SQL_CA2_SIMULATE_NON_UNIQUE => 0x00004000, SQL_CA2_SIMULATE_TRY_UNIQUE => 0x00008000, SQL_CA2_SIMULATE_UNIQUE => 0x00010000};$ReturnValues{ SQL_DYNAMIC_CURSOR_ATTRIBUTES2} = $ReturnValues{SQL_CURSOR_ATTRIBUTES2};$ReturnValues{SQL_FORWARD_ONLY_CURSOR_ATTRIBUTES2} = $ReturnValues{SQL_CURSOR_ATTRIBUTES2};$ReturnValues{ SQL_KEYSET_CURSOR_ATTRIBUTES2} = $ReturnValues{SQL_CURSOR_ATTRIBUTES2};$ReturnValues{ SQL_STATIC_CURSOR_ATTRIBUTES2} = $ReturnValues{SQL_CURSOR_ATTRIBUTES2};$ReturnValues{SQL_FETCH_DIRECTION} ={ SQL_FD_FETCH_NEXT => 0x00000001, SQL_FD_FETCH_FIRST => 0x00000002, SQL_FD_FETCH_LAST => 0x00000004, SQL_FD_FETCH_PRIOR => 0x00000008, SQL_FD_FETCH_ABSOLUTE => 0x00000010, SQL_FD_FETCH_RELATIVE => 0x00000020, SQL_FD_FETCH_RESUME => 0x00000040, SQL_FD_FETCH_BOOKMARK => 0x00000080};$ReturnValues{SQL_FILE_USAGE} ={ SQL_FILE_NOT_SUPPORTED => 0x0000, SQL_FILE_TABLE => 0x0001, SQL_FILE_QUALIFIER => 0x0002, SQL_FILE_CATALOG => 0x0002 # SQL_FILE_QUALIFIER};$ReturnValues{SQL_GETDATA_EXTENSIONS} ={ SQL_GD_ANY_COLUMN => 0x00000001, SQL_GD_ANY_ORDER => 0x00000002, SQL_GD_BLOCK => 0x00000004, SQL_GD_BOUND => 0x00000008};$ReturnValues{SQL_GROUP_BY} ={ SQL_GB_NOT_SUPPORTED => 0x0000, SQL_GB_GROUP_BY_EQUALS_SELECT => 0x0001, SQL_GB_GROUP_BY_CONTAINS_SELECT => 0x0002, SQL_GB_NO_RELATION => 0x0003, SQL_GB_COLLATE => 0x0004};$ReturnValues{SQL_IDENTIFIER_CASE} ={ SQL_IC_UPPER => 1, SQL_IC_LOWER => 2, SQL_IC_SENSITIVE => 3, SQL_IC_MIXED => 4};$ReturnValues{SQL_INDEX_KEYWORDS} ={ SQL_IK_NONE => 0x00000000, SQL_IK_ASC => 0x00000001, SQL_IK_DESC => 0x00000002# SQL_IK_ALL =>};$ReturnValues{SQL_INFO_SCHEMA_VIEWS} ={ SQL_ISV_ASSERTIONS => 0x00000001, SQL_ISV_CHARACTER_SETS => 0x00000002, SQL_ISV_CHECK_CONSTRAINTS => 0x00000004, SQL_ISV_COLLATIONS => 0x00000008, SQL_ISV_COLUMN_DOMAIN_USAGE => 0x00000010, SQL_ISV_COLUMN_PRIVILEGES => 0x00000020, SQL_ISV_COLUMNS => 0x00000040, SQL_ISV_CONSTRAINT_COLUMN_USAGE => 0x00000080, SQL_ISV_CONSTRAINT_TABLE_USAGE => 0x00000100, SQL_ISV_DOMAIN_CONSTRAINTS => 0x00000200, SQL_ISV_DOMAINS => 0x00000400, SQL_ISV_KEY_COLUMN_USAGE => 0x00000800, SQL_ISV_REFERENTIAL_CONSTRAINTS => 0x00001000, SQL_ISV_SCHEMATA => 0x00002000, SQL_ISV_SQL_LANGUAGES => 0x00004000, SQL_ISV_TABLE_CONSTRAINTS => 0x00008000, SQL_ISV_TABLE_PRIVILEGES => 0x00010000, SQL_ISV_TABLES => 0x00020000, SQL_ISV_TRANSLATIONS => 0x00040000, SQL_ISV_USAGE_PRIVILEGES => 0x00080000, SQL_ISV_VIEW_COLUMN_USAGE => 0x00100000, SQL_ISV_VIEW_TABLE_USAGE => 0x00200000, SQL_ISV_VIEWS => 0x00400000};$ReturnValues{SQL_INSERT_STATEMENT} ={ SQL_IS_INSERT_LITERALS => 0x00000001, SQL_IS_INSERT_SEARCHED => 0x00000002, SQL_IS_SELECT_INTO => 0x00000004};$ReturnValues{SQL_LOCK_TYPES} ={ SQL_LCK_NO_CHANGE => 0x00000001, SQL_LCK_EXCLUSIVE => 0x00000002, SQL_LCK_UNLOCK => 0x00000004};$ReturnValues{SQL_NON_NULLABLE_COLUMNS} ={ SQL_NNC_NULL => 0x0000, SQL_NNC_NON_NULL => 0x0001};$ReturnValues{SQL_NULL_COLLATION} ={ SQL_NC_HIGH => 0, SQL_NC_LOW => 1, SQL_NC_START => 0x0002, SQL_NC_END => 0x0004};$ReturnValues{SQL_NUMERIC_FUNCTIONS} ={ SQL_FN_NUM_ABS => 0x00000001, SQL_FN_NUM_ACOS => 0x00000002, SQL_FN_NUM_ASIN => 0x00000004, SQL_FN_NUM_ATAN => 0x00000008, SQL_FN_NUM_ATAN2 => 0x00000010, SQL_FN_NUM_CEILING => 0x00000020, SQL_FN_NUM_COS => 0x00000040, SQL_FN_NUM_COT => 0x00000080, SQL_FN_NUM_EXP => 0x00000100, SQL_FN_NUM_FLOOR => 0x00000200, SQL_FN_NUM_LOG => 0x00000400, SQL_FN_NUM_MOD => 0x00000800, SQL_FN_NUM_SIGN => 0x00001000, SQL_FN_NUM_SIN => 0x00002000, SQL_FN_NUM_SQRT => 0x00004000, SQL_FN_NUM_TAN => 0x00008000, SQL_FN_NUM_PI => 0x00010000, SQL_FN_NUM_RAND => 0x00020000, SQL_FN_NUM_DEGREES => 0x00040000, SQL_FN_NUM_LOG10 => 0x00080000, SQL_FN_NUM_POWER => 0x00100000, SQL_FN_NUM_RADIANS => 0x00200000, SQL_FN_NUM_ROUND => 0x00400000, SQL_FN_NUM_TRUNCATE => 0x00800000};$ReturnValues{SQL_ODBC_API_CONFORMANCE} ={ SQL_OAC_NONE => 0x0000, SQL_OAC_LEVEL1 => 0x0001, SQL_OAC_LEVEL2 => 0x0002};$ReturnValues{SQL_ODBC_INTERFACE_CONFORMANCE} ={ SQL_OIC_CORE => 1, SQL_OIC_LEVEL1 => 2, SQL_OIC_LEVEL2 => 3};$ReturnValues{SQL_ODBC_SAG_CLI_CONFORMANCE} ={ SQL_OSCC_NOT_COMPLIANT => 0x0000, SQL_OSCC_COMPLIANT => 0x0001};$ReturnValues{SQL_ODBC_SQL_CONFORMANCE} ={ SQL_OSC_MINIMUM => 0x0000, SQL_OSC_CORE => 0x0001, SQL_OSC_EXTENDED => 0x0002};$ReturnValues{SQL_OJ_CAPABILITIES} ={ SQL_OJ_LEFT => 0x00000001, SQL_OJ_RIGHT => 0x00000002, SQL_OJ_FULL => 0x00000004, SQL_OJ_NESTED => 0x00000008, SQL_OJ_NOT_ORDERED => 0x00000010, SQL_OJ_INNER => 0x00000020, SQL_OJ_ALL_COMPARISON_OPS => 0x00000040};$ReturnValues{SQL_OWNER_USAGE} ={ SQL_OU_DML_STATEMENTS => 0x00000001, SQL_OU_PROCEDURE_INVOCATION => 0x00000002, SQL_OU_TABLE_DEFINITION => 0x00000004, SQL_OU_INDEX_DEFINITION => 0x00000008, SQL_OU_PRIVILEGE_DEFINITION => 0x00000010};$ReturnValues{SQL_PARAM_ARRAY_ROW_COUNTS} ={ SQL_PARC_BATCH => 1, SQL_PARC_NO_BATCH => 2};$ReturnValues{SQL_PARAM_ARRAY_SELECTS} ={ SQL_PAS_BATCH => 1, SQL_PAS_NO_BATCH => 2, SQL_PAS_NO_SELECT => 3};$ReturnValues{SQL_POSITIONED_STATEMENTS} ={ SQL_PS_POSITIONED_DELETE => 0x00000001, SQL_PS_POSITIONED_UPDATE => 0x00000002, SQL_PS_SELECT_FOR_UPDATE => 0x00000004};$ReturnValues{SQL_POS_OPERATIONS} ={ SQL_POS_POSITION => 0x00000001, SQL_POS_REFRESH => 0x00000002, SQL_POS_UPDATE => 0x00000004, SQL_POS_DELETE => 0x00000008, SQL_POS_ADD => 0x00000010};$ReturnValues{SQL_QUALIFIER_LOCATION} ={ SQL_QL_START => 0x0001, SQL_QL_END => 0x0002};$ReturnValues{SQL_QUALIFIER_USAGE} ={ SQL_QU_DML_STATEMENTS => 0x00000001
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -