📄 odbc.pm
字号:
, SQL_QU_PROCEDURE_INVOCATION => 0x00000002, SQL_QU_TABLE_DEFINITION => 0x00000004, SQL_QU_INDEX_DEFINITION => 0x00000008, SQL_QU_PRIVILEGE_DEFINITION => 0x00000010};$ReturnValues{SQL_QUOTED_IDENTIFIER_CASE} = $ReturnValues{SQL_IDENTIFIER_CASE};$ReturnValues{SQL_SCHEMA_USAGE} ={ SQL_SU_DML_STATEMENTS => 0x00000001 # SQL_OU_DML_STATEMENTS, SQL_SU_PROCEDURE_INVOCATION => 0x00000002 # SQL_OU_PROCEDURE_INVOCATION, SQL_SU_TABLE_DEFINITION => 0x00000004 # SQL_OU_TABLE_DEFINITION, SQL_SU_INDEX_DEFINITION => 0x00000008 # SQL_OU_INDEX_DEFINITION, SQL_SU_PRIVILEGE_DEFINITION => 0x00000010 # SQL_OU_PRIVILEGE_DEFINITION};$ReturnValues{SQL_SCROLL_CONCURRENCY} ={ SQL_SCCO_READ_ONLY => 0x00000001, SQL_SCCO_LOCK => 0x00000002, SQL_SCCO_OPT_ROWVER => 0x00000004, SQL_SCCO_OPT_VALUES => 0x00000008};$ReturnValues{SQL_SCROLL_OPTIONS} ={ SQL_SO_FORWARD_ONLY => 0x00000001, SQL_SO_KEYSET_DRIVEN => 0x00000002, SQL_SO_DYNAMIC => 0x00000004, SQL_SO_MIXED => 0x00000008, SQL_SO_STATIC => 0x00000010};$ReturnValues{SQL_SQL92_DATETIME_FUNCTIONS} ={ SQL_SDF_CURRENT_DATE => 0x00000001, SQL_SDF_CURRENT_TIME => 0x00000002, SQL_SDF_CURRENT_TIMESTAMP => 0x00000004};$ReturnValues{SQL_SQL92_FOREIGN_KEY_DELETE_RULE} ={ SQL_SFKD_CASCADE => 0x00000001, SQL_SFKD_NO_ACTION => 0x00000002, SQL_SFKD_SET_DEFAULT => 0x00000004, SQL_SFKD_SET_NULL => 0x00000008};$ReturnValues{SQL_SQL92_FOREIGN_KEY_UPDATE_RULE} ={ SQL_SFKU_CASCADE => 0x00000001, SQL_SFKU_NO_ACTION => 0x00000002, SQL_SFKU_SET_DEFAULT => 0x00000004, SQL_SFKU_SET_NULL => 0x00000008};$ReturnValues{SQL_SQL92_GRANT} ={ SQL_SG_USAGE_ON_DOMAIN => 0x00000001, SQL_SG_USAGE_ON_CHARACTER_SET => 0x00000002, SQL_SG_USAGE_ON_COLLATION => 0x00000004, SQL_SG_USAGE_ON_TRANSLATION => 0x00000008, SQL_SG_WITH_GRANT_OPTION => 0x00000010, SQL_SG_DELETE_TABLE => 0x00000020, SQL_SG_INSERT_TABLE => 0x00000040, SQL_SG_INSERT_COLUMN => 0x00000080, SQL_SG_REFERENCES_TABLE => 0x00000100, SQL_SG_REFERENCES_COLUMN => 0x00000200, SQL_SG_SELECT_TABLE => 0x00000400, SQL_SG_UPDATE_TABLE => 0x00000800, SQL_SG_UPDATE_COLUMN => 0x00001000};$ReturnValues{SQL_SQL92_NUMERIC_VALUE_FUNCTIONS} ={ SQL_SNVF_BIT_LENGTH => 0x00000001, SQL_SNVF_CHAR_LENGTH => 0x00000002, SQL_SNVF_CHARACTER_LENGTH => 0x00000004, SQL_SNVF_EXTRACT => 0x00000008, SQL_SNVF_OCTET_LENGTH => 0x00000010, SQL_SNVF_POSITION => 0x00000020};$ReturnValues{SQL_SQL92_PREDICATES} ={ SQL_SP_EXISTS => 0x00000001, SQL_SP_ISNOTNULL => 0x00000002, SQL_SP_ISNULL => 0x00000004, SQL_SP_MATCH_FULL => 0x00000008, SQL_SP_MATCH_PARTIAL => 0x00000010, SQL_SP_MATCH_UNIQUE_FULL => 0x00000020, SQL_SP_MATCH_UNIQUE_PARTIAL => 0x00000040, SQL_SP_OVERLAPS => 0x00000080, SQL_SP_UNIQUE => 0x00000100, SQL_SP_LIKE => 0x00000200, SQL_SP_IN => 0x00000400, SQL_SP_BETWEEN => 0x00000800, SQL_SP_COMPARISON => 0x00001000, SQL_SP_QUANTIFIED_COMPARISON => 0x00002000};$ReturnValues{SQL_SQL92_RELATIONAL_JOIN_OPERATORS} ={ SQL_SRJO_CORRESPONDING_CLAUSE => 0x00000001, SQL_SRJO_CROSS_JOIN => 0x00000002, SQL_SRJO_EXCEPT_JOIN => 0x00000004, SQL_SRJO_FULL_OUTER_JOIN => 0x00000008, SQL_SRJO_INNER_JOIN => 0x00000010, SQL_SRJO_INTERSECT_JOIN => 0x00000020, SQL_SRJO_LEFT_OUTER_JOIN => 0x00000040, SQL_SRJO_NATURAL_JOIN => 0x00000080, SQL_SRJO_RIGHT_OUTER_JOIN => 0x00000100, SQL_SRJO_UNION_JOIN => 0x00000200};$ReturnValues{SQL_SQL92_REVOKE} ={ SQL_SR_USAGE_ON_DOMAIN => 0x00000001, SQL_SR_USAGE_ON_CHARACTER_SET => 0x00000002, SQL_SR_USAGE_ON_COLLATION => 0x00000004, SQL_SR_USAGE_ON_TRANSLATION => 0x00000008, SQL_SR_GRANT_OPTION_FOR => 0x00000010, SQL_SR_CASCADE => 0x00000020, SQL_SR_RESTRICT => 0x00000040, SQL_SR_DELETE_TABLE => 0x00000080, SQL_SR_INSERT_TABLE => 0x00000100, SQL_SR_INSERT_COLUMN => 0x00000200, SQL_SR_REFERENCES_TABLE => 0x00000400, SQL_SR_REFERENCES_COLUMN => 0x00000800, SQL_SR_SELECT_TABLE => 0x00001000, SQL_SR_UPDATE_TABLE => 0x00002000, SQL_SR_UPDATE_COLUMN => 0x00004000};$ReturnValues{SQL_SQL92_ROW_VALUE_CONSTRUCTOR} ={ SQL_SRVC_VALUE_EXPRESSION => 0x00000001, SQL_SRVC_NULL => 0x00000002, SQL_SRVC_DEFAULT => 0x00000004, SQL_SRVC_ROW_SUBQUERY => 0x00000008};$ReturnValues{SQL_SQL92_STRING_FUNCTIONS} ={ SQL_SSF_CONVERT => 0x00000001, SQL_SSF_LOWER => 0x00000002, SQL_SSF_UPPER => 0x00000004, SQL_SSF_SUBSTRING => 0x00000008, SQL_SSF_TRANSLATE => 0x00000010, SQL_SSF_TRIM_BOTH => 0x00000020, SQL_SSF_TRIM_LEADING => 0x00000040, SQL_SSF_TRIM_TRAILING => 0x00000080};$ReturnValues{SQL_SQL92_VALUE_EXPRESSIONS} ={ SQL_SVE_CASE => 0x00000001, SQL_SVE_CAST => 0x00000002, SQL_SVE_COALESCE => 0x00000004, SQL_SVE_NULLIF => 0x00000008};$ReturnValues{SQL_SQL_CONFORMANCE} ={ SQL_SC_SQL92_ENTRY => 0x00000001, SQL_SC_FIPS127_2_TRANSITIONAL => 0x00000002, SQL_SC_SQL92_INTERMEDIATE => 0x00000004, SQL_SC_SQL92_FULL => 0x00000008};$ReturnValues{SQL_STANDARD_CLI_CONFORMANCE} ={ SQL_SCC_XOPEN_CLI_VERSION1 => 0x00000001, SQL_SCC_ISO92_CLI => 0x00000002};$ReturnValues{SQL_STATIC_SENSITIVITY} ={ SQL_SS_ADDITIONS => 0x00000001, SQL_SS_DELETIONS => 0x00000002, SQL_SS_UPDATES => 0x00000004};$ReturnValues{SQL_STRING_FUNCTIONS} ={ SQL_FN_STR_CONCAT => 0x00000001, SQL_FN_STR_INSERT => 0x00000002, SQL_FN_STR_LEFT => 0x00000004, SQL_FN_STR_LTRIM => 0x00000008, SQL_FN_STR_LENGTH => 0x00000010, SQL_FN_STR_LOCATE => 0x00000020, SQL_FN_STR_LCASE => 0x00000040, SQL_FN_STR_REPEAT => 0x00000080, SQL_FN_STR_REPLACE => 0x00000100, SQL_FN_STR_RIGHT => 0x00000200, SQL_FN_STR_RTRIM => 0x00000400, SQL_FN_STR_SUBSTRING => 0x00000800, SQL_FN_STR_UCASE => 0x00001000, SQL_FN_STR_ASCII => 0x00002000, SQL_FN_STR_CHAR => 0x00004000, SQL_FN_STR_DIFFERENCE => 0x00008000, SQL_FN_STR_LOCATE_2 => 0x00010000, SQL_FN_STR_SOUNDEX => 0x00020000, SQL_FN_STR_SPACE => 0x00040000, SQL_FN_STR_BIT_LENGTH => 0x00080000, SQL_FN_STR_CHAR_LENGTH => 0x00100000, SQL_FN_STR_CHARACTER_LENGTH => 0x00200000, SQL_FN_STR_OCTET_LENGTH => 0x00400000, SQL_FN_STR_POSITION => 0x00800000};$ReturnValues{SQL_SUBQUERIES} ={ SQL_SQ_COMPARISON => 0x00000001, SQL_SQ_EXISTS => 0x00000002, SQL_SQ_IN => 0x00000004, SQL_SQ_QUANTIFIED => 0x00000008, SQL_SQ_CORRELATED_SUBQUERIES => 0x00000010};$ReturnValues{SQL_SYSTEM_FUNCTIONS} ={ SQL_FN_SYS_USERNAME => 0x00000001, SQL_FN_SYS_DBNAME => 0x00000002, SQL_FN_SYS_IFNULL => 0x00000004};$ReturnValues{SQL_TIMEDATE_ADD_INTERVALS} ={ SQL_FN_TSI_FRAC_SECOND => 0x00000001, SQL_FN_TSI_SECOND => 0x00000002, SQL_FN_TSI_MINUTE => 0x00000004, SQL_FN_TSI_HOUR => 0x00000008, SQL_FN_TSI_DAY => 0x00000010, SQL_FN_TSI_WEEK => 0x00000020, SQL_FN_TSI_MONTH => 0x00000040, SQL_FN_TSI_QUARTER => 0x00000080, SQL_FN_TSI_YEAR => 0x00000100};$ReturnValues{SQL_TIMEDATE_FUNCTIONS} ={ SQL_FN_TD_NOW => 0x00000001, SQL_FN_TD_CURDATE => 0x00000002, SQL_FN_TD_DAYOFMONTH => 0x00000004, SQL_FN_TD_DAYOFWEEK => 0x00000008, SQL_FN_TD_DAYOFYEAR => 0x00000010, SQL_FN_TD_MONTH => 0x00000020, SQL_FN_TD_QUARTER => 0x00000040, SQL_FN_TD_WEEK => 0x00000080, SQL_FN_TD_YEAR => 0x00000100, SQL_FN_TD_CURTIME => 0x00000200, SQL_FN_TD_HOUR => 0x00000400, SQL_FN_TD_MINUTE => 0x00000800, SQL_FN_TD_SECOND => 0x00001000, SQL_FN_TD_TIMESTAMPADD => 0x00002000, SQL_FN_TD_TIMESTAMPDIFF => 0x00004000, SQL_FN_TD_DAYNAME => 0x00008000, SQL_FN_TD_MONTHNAME => 0x00010000, SQL_FN_TD_CURRENT_DATE => 0x00020000, SQL_FN_TD_CURRENT_TIME => 0x00040000, SQL_FN_TD_CURRENT_TIMESTAMP => 0x00080000, SQL_FN_TD_EXTRACT => 0x00100000};$ReturnValues{SQL_TXN_CAPABLE} ={ SQL_TC_NONE => 0, SQL_TC_DML => 1, SQL_TC_ALL => 2, SQL_TC_DDL_COMMIT => 3, SQL_TC_DDL_IGNORE => 4};$ReturnValues{SQL_TRANSACTION_ISOLATION_OPTION} ={ SQL_TRANSACTION_READ_UNCOMMITTED => 0x00000001 # SQL_TXN_READ_UNCOMMITTED, SQL_TRANSACTION_READ_COMMITTED => 0x00000002 # SQL_TXN_READ_COMMITTED, SQL_TRANSACTION_REPEATABLE_READ => 0x00000004 # SQL_TXN_REPEATABLE_READ, SQL_TRANSACTION_SERIALIZABLE => 0x00000008 # SQL_TXN_SERIALIZABLE};$ReturnValues{SQL_DEFAULT_TRANSACTION_ISOLATION} = $ReturnValues{SQL_TRANSACTION_ISOLATION_OPTION};$ReturnValues{SQL_TXN_ISOLATION_OPTION} ={ SQL_TXN_READ_UNCOMMITTED => 0x00000001, SQL_TXN_READ_COMMITTED => 0x00000002, SQL_TXN_REPEATABLE_READ => 0x0⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -