神通数据库支持的sql语句特性¶
神通数据库支持的sql语句特性可以通过查询系统视图 v_sys_support_sql 获取， 具体取值如下:
| 特性名 | 特性值 | 描述 |
|---|---|---|
| AGGREGATE_FUNCTIONS | 64 | 数据库支持的聚集函数(SQL_AF_AVG: 0x00000001L,SQL_AF_COUNT:0x00000002L,SQL_AF_MAX: 0x00000004L,SQL_AF_MIN: 0x00000008L,SQL_AF_SUM: 0x00000010L,SQL_AF_DISTINCT: 0x00000020L,SQL_AF_ALL: 0x00000040L) |
| ALTER_DOMAIN | 0 | 数据库对ALTER DOMAIN的支持度(SQL_AD_CONSTRAINT_NAME_DEFINITION:0x00000001L,SQL_AD_ADD_DOMAIN_CONSTRAINT: 0x00000002L,SQL_AD_DROP_DOMAIN_CONSTRAINT:0x00000004L,SQL_AD_ADD_DOMAIN_DEFAULT:0x00000008L,SQL_AD_DROP_DOMAIN_DEFAULT:0x00000010L,SQL_AD_ADD_CONSTRAINT_NON_DEFERRABLE: 0x00000100L,SQL_AD_ADD_CONSTRAINT_INITIALLY_DEFERRED: 0x00000020L,SQL_AD_ADD_CONSTRAINT_INITIALLY_IMMEDIATE: 0x00000040L,SQL_AD_ADD_CONSTRAINT_DEFERRABLE:0x00000080L) |
| ALTER_TABLE | 1048424 | 数据库对ALTER_TABLE的支持度(SQL_AT_ADD_CONSTRAINT: 0x00000008L,SQL_AT_ADD_COLUMN_SINGLE: 0x00000020L,SQL_AT_ADD_COLUMN_DEFAULT: 0x00000040L,SQL_AT_ADD_COLUMN_COLLATION: 0x00000080L,SQL_AT_SET_COLUMN_DEFAULT: 0x00000100L,SQL_AT_DROP_COLUMN_DEFAULT: 0x00000200L,SQL_AT_DROP_COLUMN_CASCADE: 0x00000400L,SQL_AT_DROP_COLUMN_RESTRICT: 0x00000800L,SQL_AT_ADD_TABLE_CONSTRAINT: 0x00001000L,SQL_AT_DROP_TABLE_CONSTRAINT_CASCADE: 0x00002000L,SQL_AT_DROP_TABLE_CONSTRAINT_RESTRICT: 0x00004000L,SQL_AT_CONSTRAINT_NAME_DEFINITION: 0x00008000L,SQL_AT_CONSTRAINT_INITIALLY_DEFERRED:0x00010000L,SQL_AT_CONSTRAINT_INITIALLY_IMMEDIATE: 0x00020000L,SQL_AT_CONSTRAINT_DEFERRABLE: 0x00040000L,SQL_AT_CONSTRAINT_NON_DEFERRABLE: 0x00080000L) |
| CATALOG_LOCATION | 0 | 如何使用数据字典名修饰表名,如果数据库不支持数据字典,返回0。。(NOT_SUPPORTED: 0,SQL_CL_START:1,SQL_CL_END:2) |
| CATALOG_NAME | 0 | 数据库是否支持数据字典(1:是,0:否) |
| CATALOG_USAGE | 0 | 数据库支持在哪些SQL语句中使用数据字典(SQL_CU_DML_STATEMENTS: 0x00000001L,SQL_CU_PROCEDURE_INVOCATION: 0x00000002L,SQL_CU_TABLE_DEFINITION: 0x00000004L,SQL_CU_INDEX_DEFINITION: 0x00000008L,SQL_CU_PRIVILEGE_DEFINITION: 0x00000010L) |
| COLUMN_ALIAS | 1 | 是否支持列的别名(1:是,0:否) |
| CORRELATION_NAME | 2 | 是否支持表的别名以及支持的程度(SQL_CN_NONE:0,SQL_CN_DIFFERENT:1,SQL_CN_ANY:2) |
| CREATE_ASSERTION | 0 | 数据库对CREATE ASSERTION的支持程度(SQL_CA_CREATE_ASSERTION: 0x00000001L,SQL_CA_CONSTRAINT_INITIALLY_DEFERRED: 0x00000010L, SQL_CA_CONSTRAINT_INITIALLY_IMMEDIATE: 0x00000020L,SQL_CA_CONSTRAINT_DEFERRABLE: 0x00000040L,SQL_CA_CONSTRAINT_NON_DEFERRABLE:0x00000080L) |
| CREATE_CHARACTER_SET | 0 | 数据库对CREATE CHARACTER SET的支持程度(SQL_CCS_CREATE_CHARACTER_SET: 0x00000001L,SQL_CCS_COLLATE_CLAUSE: 0x00000002L,SQL_CCS_LIMITED_COLLATION: 0x00000004L) |
| CREATE_COLLATION | 0 | 数据库对CREATE COLLATION的支持程度(SQL_CCOL_CREATE_COLLATION:0x00000001L) |
| CREATE_DOMAIN | 23 | 数据库对CREATE DOMAIN的支持程度(SQL_CDO_CREATE_DOMAIN: 0x00000001L,SQL_CDO_DEFAULT:0x00000002L,SQL_CDO_CONSTRAINT: 0x00000004L,SQL_CDO_COLLATION:0x00000008L,SQL_CDO_CONSTRAINT_NAME_DEFINITION:0x00000010L,SQL_CDO_CONSTRAINT_INITIALLY_DEFERRED: 0x00000020L,SQL_CDO_CONSTRAINT_INITIALLY_IMMEDIATE: 0x00000040L,SQL_CDO_CONSTRAINT_DEFERRABLE: 0x00000080L,SQL_CDO_CONSTRAINT_NON_DEFERRABLE:0x00000100L) |
| CREATE_SCHEMA | 3 | 数据库对CREATE SCHEMA的支持程度(SQL_CS_CREATE_SCHEMA: 0x00000001L,SQL_CS_AUTHORIZATION:0x00000002L,SQL_CS_DEFAULT_CHARACTER_SET: 0x00000004L) |
| CREATE_TABLE | 14333 | 数据库对CREATE TABLE的支持程度(SQL_CT_CREATE_TABLE: 0x00000001L ,SQL_CT_COMMIT_PRESERVE: 0x00000002L,SQL_CT_COMMIT_DELETE: 0x00000004L,SQL_CT_GLOBAL_TEMPORARY: 0x00000008L,SQL_CT_LOCAL_TEMPORARY: 0x00000010L,SQL_CT_CONSTRAINT_INITIALLY_DEFERRED: 0x00000020L,SQL_CT_CONSTRAINT_INITIALLY_IMMEDIATE: 0x00000040L,SQL_CT_CONSTRAINT_DEFERRABLE : 0x00000080L,SQL_CT_CONSTRAINT_NON_DEFERRABLE: 0x00000100L,SQL_CT_COLUMN_CONSTRAINT: 0x00000200L,SQL_CT_COLUMN_DEFAULT: 0x00000400L,SQL_CT_COLUMN_COLLATION: 0x00000800L,SQL_CT_TABLE_CONSTRAINT: 0x00001000L,SQL_CT_CONSTRAINT_NAME_DEFINITION: 0x00002000L) |
| CREATE_TRANSLATION | 0 | 数据库对CREATE TRANSLATION的支持程度(SQL_CTR_CREATE_TRANSLATION: 0x00000001L) |
| CREATE_VIEW | 15 | 数据库对CREATE VIEW的支持程度(SQL_CV_CREATE_VIEW: 0x00000001L,SQL_CV_CHECK_OPTION: 0x00000002L,SQL_CV_CASCADED: 0x00000004L,SQL_CV_LOCAL: 0x00000008L) |
| DDL_INDEX | 3 | 数据库对索引DDL的支持程度(SQL_DI_CREATE_INDEX: 0x00000001L,SQL_DI_DROP_INDEX: 0x00000002L) |
| DROP_ASSERTION | 0 | 数据库对DROP ASSERTION的支持程度(SQL_DA_DROP_ASSERTION: 0x00000001L) |
| DROP_CHARACTER_SET | 0 | 数据库对DROP CHARACTER_SET的支持程度(SQL_DCS_DROP_CHARACTER_SET: 0x00000001L) |
| DROP_CHARACTER_SET | 0 | 数据库对DROP CHARACTER_SET的支持程度(SQL_DCS_DROP_CHARACTER_SET: 0x00000001L) |
| DROP_COLLATION | 0 | 数据库对DROP COLLATION的支持程度(SQL_DC_DROP_COLLATION: 0x00000001L) |
| DROP_DOMAIN | 7 | 数据库对DROP DOMAIN的支持程度(SQL_DD_DROP_DOMAIN: 0x00000001L,SQL_DD_RESTRICT:0x00000002L,SQL_DD_CASCADE:0x00000004L) |
| DROP_SCHEMA | 7 | 数据库对DROP SCHEMA的支持程度(SQL_DS_DROP_SCHEMA: 0x00000001L,SQL_DS_RESTRICT:0x00000002L,SQL_DS_CASCADE:0x00000004L) |
| DROP_TABLE | 7 | 数据库对DROP TABLE的支持程度(SQL_DT_DROP_TABLE:0x00000001L,SQL_DT_RESTRICT:0x00000002L,SQL_DT_CASCADE:0x00000004L) |
| DROP_TRANSLATION | 0 | 数据库对DROP TRANSLATION的支持程度(SQL_DTR_DROP_TRANSLATION: 0x00000001L) |
| DROP_VIEW | 7 | 数据库对DROP VIEW的支持程度(SQL_DV_DROP_VIEW:0x00000001L,SQL_DV_RESTRICT:0x00000002L,SQL_DV_CASCADE:0x00000004L) |
| EXPRESSIONS_IN_ORDERBY | 2 | 数据库是对ORDER BY表达式的支持程度(这里的三个macro不在msdn内)SQL_OB_NOT_SUPPORT=不支持orderby,SQL_OB_RELATED=支持orderby,但orderby中的column必须在select中,SQL_OB_UNRELATED=支持orderby,但orderby中的column可以不在select中(SQL_OB_NOT_SUPPORT:0,SQL_OB_RELATED:1,SQL_OB_UNRELATED:2) |
| GROUP_BY | 2 | GROUP BY子句中的列和SELECT的列的关系(SQL_GB_NOT_SUPPORTED:0,SQL_GB_GROUP_BY_EQUALS_SELECT:1,SQL_GB_GROUP_BY_CONTAINS_SELECT:2,SQL_GB_NO_RELATION:3,SQL_GB_COLLATE:4) |
| IDENTIFIER_CASE | 1 | SQL语句中的Identifier的大小写敏感性(SQL_IC_UPPER:1,SQL_IC_LOWER:2,SQL_IC_SENSITIVE:3,SQL_IC_MIXED:4) |
| INDEX_KEYWORDS | 0 | 在CREATE INDEX语句中可以使用的关键字(SQL_IK_NONE: 0x00000000L,SQL_IK_ASC:0x00000001L,SQL_IK_DESC:0x00000002L,SQL_IK_ALL:(SQL_IK_ASC SQL_IK_DESC)) |
| INSERT_STATEMENT | 2 | 数据库对INSERT语句的支持程度(SQL_IS_INSERT_LITERALS: 0x00000001L,SQL_IS_INSERT_SEARCHED: 0x00000002L,SQL_IS_SELECT_INTO:0x00000004L) |
| INTEGRITY | 0 | Retrieves whether this database supports the SQL Integrity Enhancement Facility.(1:是,0:否) |
| LIKE_ESCAPE_CLAUSE | 1 | LIKE子句中是否可使用模式匹配符(1:是,0:否) |
| NON_NULLABLE_COLUMNS | 1 | 数据库是否支持CREATETABLE中使用NOT NULL(SQL_NNC_NULL:0,SQL_NNC_NON_NULL:1 ) |
| OJ_CAPABILITIES | 7 | 数据库对OUTER JOIN的支持性(SQL_OJ_LEFT:0x00000001L, SQL_OJ_RIGHT:0x00000002L,SQL_OJ_FULL:0x00000004L,SQL_OJ_NESTED:0x00000008L,SQL_OJ_NOT_ORDERED: 0x00000010L,SQL_OJ_INNER: 0x00000020L,SQL_OJ_ALL_COMPARISON_OPS: 0x00000040L) |
| ORDER_BY_COLUMNS_IN_SELECT | 0 | ODER_BY子句中的列和SELECT的列的关系(1:是,0:否) |
| OUTER_JOINS | 1 | 是否支持外连接(1:是,0:否) |
| PROCEDURES | 1 | 是否支持存储过程(1:是,0:否) |
| QUOTED_IDENTIFIER_CASE | 1 | 引用标识符是否大小写敏感(SQL_IC_UPPER:1,SQL_IC_LOWER:2,SQL_IC_SENSITIVE:3,SQL_IC_MIXED:4) |
| SCHEMA_USAGE | 29 | 对在SQL语句中使用模式的支持程度(SQL_SU_DML_STATEMENTS: 0x00000001L,SQL_SU_PROCEDURE_INVOCATION: 0x00000002L,SQL_SU_TABLE_DEFINITION: 0x00000004L,SQL_SU_INDEX_DEFINITION:0x00000008L,SQL_SU_PRIVILEGE_DEFINITION: 0x00000010L) |
| SQL92_DATETIME_FUNCTIONS | 0 | 按照SQL92标准对datatime标量函数的支持性(SQL_SDF_CURRENT_DATE: 0x00000001L,SQL_SDF_CURRENT_TIME: 0x00000002L,SQL_SDF_CURRENT_TIMESTAMP: x00000004L) |
| SQL92_FOREIGN_KEY_DELETE_RULE | 15 | 按照SQL92标准对delete语句中有foreignkey的支持性(SQL_SFKD_CASCADE:0x00000001L,SQL_SFKD_NO_ACTION: 0x00000002L,SQL_SFKD_SET_DEFAULT: 0x00000004L,SQL_SFKD_SET_NULL: 0x00000008L) |
| SQL92_FOREIGN_KEY_UPDATE_RULE | 15 | 按照SQL92标准对update语句中有foreignkey的支持性(SQL_SFKU_CASCADE:0x00000001L ,SQL_SFKU_NO_ACTION: 0x00000002L,SQL_SFKU_SET_DEFAULT: 0x00000004L,SQL_SFKU_SET_NULL: 0x00000008L) |
| SQL92_GRANT | 8048 | 按照SQL92标准对grant语句的支持性(SQL_SG_USAGE_ON_DOMAIN: 0x00000001L,SQL_SG_USAGE_ON_CHARACTER_SET: 0x00000002L,SQL_SG_USAGE_ON_COLLATION: 0x00000004L,SQL_SG_USAGE_ON_TRANSLATION: 0x00000008L,SQL_SG_WITH_GRANT_OPTION: 0x00000010L,SQL_SG_DELETE_TABLE: 0x00000020L,SQL_SG_INSERT_TABLE: 0x00000040L,SQL_SG_INSERT_COLUMN: 0x00000080L,SQL_SG_REFERENCES_TABLE: 0x00000100L,SQL_SG_REFERENCES_COLUMN: 0x00000200L,SQL_SG_SELECT_TABLE: 0x00000400L,SQL_SG_UPDATE_TABLE: 0x00000800L,SQL_SG_UPDATE_COLUMN:0x00001000L) |
| SQL92_NUMERIC_VALUE_FUNCTIONS | 0 | 按照SQL92标准对numeric标量函数的支持性(SQL_SNVF_BIT_LENGTH: 0x00000001L,SQL_SNVF_CHAR_LENGTH: 0x00000002L,SQL_SNVF_CHARACTER_LENGTH: 0x00000004L,SQL_SNVF_EXTRACT: 0x00000008L,SQL_SNVF_OCTET_LENGTH: 0x00000010L,SQL_SNVF_POSITION: 0x00000020L) |
| SQL92_PREDICATES | 7815 | 按照SQL92标准对select语句中谓词的支持性(SQL_SP_EXISTS: 0x00000001L,SQL_SP_ISNOTNULL: 0x00000002L,SQL_SP_ISNULL: 0x00000004L,SQL_SP_LIKESQL_SP_MATCH_FULL: 0x00000008L,SQL_SP_MATCH_PARTIAL:0x00000010L,SQL_SP_MATCH_UNIQUE_FULL : 0x00000020L,SQL_SP_MATCH_UNIQUE_PARTIAL: 0x00000040L,SQL_SP_OVERLAPS: 0x00000080L,SQL_SP_UNIQUE: 0x00000100L,SQL_SP_LIKE:0x00000200L,SQL_SP_EXISTSSQL_SP_IN: 0x00000400L,SQL_SP_BETWEEN: 0x00000800L,SQL_SP_COMPARISON:0x00001000L,SQL_SP_QUANTIFIED_COMPARISON:0x00002000L) |
| SQL92_RELATIONAL_JOIN_OPERATORS | 472 | 按照SQL92标准对select语句中连接的支持性(SQL_SRJO_CORRESPONDING_CLAUSE: 0x00000001L,SQL_SRJO_CROSS_JOIN: 0x00000002L,SQL_SRJO_EXCEPT_JOIN: 0x00000004L,SQL_SRJO_FULL_OUTER_JOIN: 0x00000008L,SQL_SRJO_INNER_JOIN: 0x00000010L,SQL_SRJO_INTERSECT_JOIN: 0x00000020L,SQL_SRJO_LEFT_OUTER_JOIN: 0x00000040L,SQL_SRJO_NATURAL_JOIN: 0x00000080L,SQL_SRJO_RIGHT_OUTER_JOIN: 0x00000100L,SQL_SRJO_UNION_JOIN:0x00000200L) |
| SQL92_REVOKE | 32240 | 按照SQL92标准对revoke语句中连接的支持性(SQL_SR_USAGE_ON_DOMAIN: 0x00000001L,SQL_SR_USAGE_ON_CHARACTER_SET: 0x00000002L,SQL_SR_USAGE_ON_COLLATION: 0x00000004L,SQL_SR_USAGE_ON_TRANSLATION: 0x00000008L,SQL_SR_GRANT_OPTION_FOR: 0x00000010L,SQL_SR_CASCADE: 0x00000020L,SQL_SR_RESTRICT: 0x00000040L,SQL_SR_DELETE_TABLE:0x00000080L,SQL_SR_INSERT_TABLE: 0x00000100L,SQL_SR_INSERT_COLUMN: 0x00000200L,SQL_SR_REFERENCES_TABLE:0x00000400L,SQL_SR_REFERENCES_COLUMN: 0x00000800L,SQL_SR_SELECT_TABLE: 0x00001000L,SQL_SR_UPDATE_TABLE:0x00002000L,SQL_SR_UPDATE_COLUMN: 0x00004000L) |
| SQL92_ROW_VALUE_CONSTRUCTOR | 3 | 按照SQL92标准对select语句中含有行值表达式的支持性(SQL_SRVC_VALUE_EXPRESSION: 0x00000001L,SQL_SRVC_NULL: 0x00000002L,SQL_SRVC_DEFAULT:0x00000004L,SQL_SRVC_ROW_SUBQUERY: 0x00000008L) |
| SQL92_STRING_FUNCTIONS | 255 | 按照SQL92标准对string标量函数的支持性(SQL_SSF_CONVERT:0x00000001L,SQL_SSF_LOWER:0x00000002L,SQL_SSF_UPPER:0x00000004L,SQL_SSF_SUBSTRING:0x00000008L,SQL_SSF_TRANSLATE: 0x00000010L,SQL_SSF_TRIM_BOTH:0x00000020L,SQL_SSF_TRIM_LEADING: 0x00000040L,SQL_SSF_TRIM_TRAILING: 0x00000080L) |
| SQL92_VALUE_EXPRESSIONS | 11 | 按照SQL92标准对表达式的支持性(SQL_SVE_CASE: 0x00000001L,SQL_SVE_CAST: 0x00000002L,SQL_SVE_COALESCE: 0x00000004L,SQL_SVE_NULLIF: 0x00000008L) |
| SQL_CONFORMANCE | 1 | 数据库支持的SQL语句标准等级(SQL_SC_SQL92_ENTRY:1,SQL_SC_FIPS127_2_TRANSITIONAL:2,SQL_SC_SQL92_INTERMEDIATE:4,SQL_SC_SQL92_FULL:8) |
| SUBQUERIES | 7 | 数据库对查询子句的支持性(SQL_SQ_COMPARISON:0x00000001L,SQL_SQ_EXISTS:0x00000002L,SQL_SQ_IN:0x00000004L,SQL_SQ_QUANTIFIED:0x00000008L,SQL_SQ_CORRELATED_SUBQUERIES: 0x00000010L) |
| UNION | 3 | 数据库对UNION的支持程度(SQL_U_UNION: 0x00000001L,SQL_U_UNION_ALL:0x00000002L) |