神通数据库的数据源特性¶
神通数据库的数据源特性可以通过查询系统视图 v_sys_datasource_info 获取， 具体取值如下:
| 特性名 | 特性值 | 描述 |
|---|---|---|
| ACCESSIBLE_PROCEDURES | 0 | 当前用户在系统表sys_proc中查出的procedure是否都可以被该用户调用。(1:是,0:否) |
| ACCESSIBLE_TABLES | 0 | 当前用户在系统表sys_class中查出的table和view是否都可以被该用户SELECT。(1:是,0:否) |
| ANSI92_SQL_LEVEL | 1 | 数据库对ANSI92SQL语句的支持程度.SQL_ANSI92_ENTRYLEVEL=支持entry级SQL_ANSI92_INTERMEDIATE=支持intermediate级 SQL_ANSI92_FULL=支持full级(SQL_ANSI92_ENTRYLEVEL:1,SQL_ANSI92_INTERMEDIATE:2,SQL_ANSI92_FULL:4) |
| CONCAT_NULL_BEHAVIOR | 0 | 含有空值的列和另一列concat时的行为,SQL_CB_NULL = Result is NULL valued.SQL_CB_NON_NULL = Result is concatenation of non-NULL valuedcolumn or columns.(SQL_CB_NULL:0,SQL_CB_NON_NULL:1) |
| CURSOR_COMMIT_BEHAVIOR | 2 | 服务器游标和执行计划在事务提交的行为。SQL_CB_DELETE = Close cursors anddelete prepared statements. To use thecursor again, the application must reprepare and reexecute the statement.SQL_CB_CLOSE = Close cursors. For prepared statements, the application can call SQLExecute on the statement without calling SQLPrepareagain.SQL_CB_PRESERVE = Preserve cursors in the same position asbefore the COMMIT operation. The application can continue to fetch data, or it can close the cursor andreexecute the statement without repreparing it.(SQL_CB_DELETE:0,SQL_CB_CLOSE:1,SQL_CB_PRESERVER:2) |
| CURSOR_ROLLBACK_BEHAVIOR | 2 | 服务器游标和执行计划在事务回滚时的行为。SQL_CB_DELETE = Close cursors and delete prepared statements. To use the cursor again, the application must reprepare and reexecute the statement.SQL_CB_CLOSE = Close cursors.For preparedstatements, the application can call SQLExecute on the statementwithout calling SQLPrepare again.SQL_CB_PRESERVE = Preserve cursors in the same position as before the ROLLBACK operation. The application cancontinue to fetch data, or it can close the cursor and reexecutethe statement without repreparing it.(SQL_CB_DELETE:0,SQL_CB_CLOSE:1,SQL_CB_PRESERVER:2) |
| CURSOR_SENSITIVITY | 2 | 服务器游标的敏感度。SQL_INSENSITIVE = All cursorson the statement handle show the result set withoutreflecting any changes made to it by any other cursor within thesame transaction.SQL_UNSPECIFIED = It is unspecified whether cursors on the statement handle make visible the changes made to a result set by another cursor within the same transaction. Cursors on the statement handle may make visible none, some,or all such changes.SQL_SENSITIVE = Cursors are sensitive to changes made by other cursorswithin the same transaction.(SQL_UNSPECIFIED:0,SQL_INSENSITIVE:1,SQL_SENSITIVE:2) |
| DEFAULT_TXN_ISOLATION | 2 | 数据库默认使用的事务隔离级别。SQL_TXN_READ_UNCOMMITTED= Dirty reads, nonrepeatable reads, and phantoms are possible.SQL_TXN_READ_COMMITTED = Dirty reads are not possible.Nonrepeatable reads and phantoms are possible.SQL_TXN_REPEATABLE_READ = Dirtyreads and nonrepeatable reads are not possible. Phantoms are possible.SQL_TXN_SERIALIZABLE= Transactions are serializable. Serializable transactions do not allow dirtyreads, nonrepeatable reads, or phantoms.(SQL_TXN_READ_UNCOMMITTED:1,SQL_TXT_READ_COMMITED:2,SQL_TXN_REPEATABLE_READ:4,SQL_TXN_SERIALIZABLE:8) |
| DESCRIBE_PARAMETER | 0 | An int: 1 if parameters can be described; 0, if not.(1:是,0:否) |
| LOCAL_FILE | 1 | 数据库是否将数据存储在本地文件内(1:是,0:否) |
| LOCAL_FILE_PER_TABLE | 0 | 数据库是否将数据存储在本地文件内,并且每个表对应一个文件(1:是,0:否) |
| MULTIPLE_ACTIVE_TXN | 1 | 是否支持事务的并发。An int: 1 if thedriver supports more thanone active transaction atthe same time, 0 if only one transaction can be active at any time.(1:是,0:否) |
| MULT_RESULT_SETS | 0 | An int:1 if the data source supports multiple resultsets, 0 if it does not.(1:是,0:否) |
| NEED_LONG_DATA_LEN | 0 | An int : 1 ifthe data source needs thelength of a long data value (the data type is SQL_LONGVARCHAR, SQL_LONGVARBINARY, or a long data source-specific data type) before that value is sent to the data source, 0 if it does not.(1:是,0:否) |
| NULL_COLLATION | 0 | NULL在结果集中排序后的位置。SQL_NC_END= NULLs are sorted at theend of the result set, regardless of the ASC or DESC keywords.SQL_NC_HIGH = NULLs are sorted at the high end of the result set, depending on the ASC or DESC keywords.SQL_NC_LOW = NULLs are sorted at the low end of the result set, depending on theASC or DESC keywords.SQL_NC_START = NULLs are sorted at the start of the result set, regardless of the ASC or DESC keywords.(SQL_NC_HIGH:0,SQL_NC_LOW:1,SQL_NC_START:2,SQL_NC_END:4) |
| ODBC_SQL_GRAMMAR | 1 | 数据库对ODBC－SQL语法的支持程度.SQL_MINIMUM_GRAMMAR=支持ODBC最小SQL语法SQL_CORE_GRAMMAR=支持ODBC核心SQL语法SQL_EXTENDED_GRAMMAR=ODBC扩展SQL语法(SQL_MINIMUM_GRAMMAR: 1,SQL_CORE_GRAMMAR:2,SQL_EXTENDED_GRAMMAR: 4) |
| POSITION_DELETE | 1 | 是否支持定位删除语句(1:是,0:否) |
| POSITION_UPDATE | 1 | 是否支持定位更新语句(1:是,0:否) |
| SCROLL_OPTIONS | 0 | 服务器端Scollablecursor游标的特性。SQL_SO_FORWARD_ONLY = The cursor only scrolls forward. SQL_SO_STATIC = The data in the result set is static.SQL_SO_KEYSET_DRIVEN =The driver saves and usesthe keys forevery row inthe result set.SQL_SO_DYNAMIC = The driver keeps the keys for every row in the rowset (thekeyset size is the same as the rowset size).SQL_SO_MIXED = The driver keeps the keys for every row in the keyset, and the keyset size is greater than the rowset size. The cursor is keyset-driveninside the keyset and dynamic outside the keyset.(SQL_SO_FORWARD_ONLY:1,SQL_SO_KEYSET_DRIVEN:2, SQL_SO_DYNAMIC:4,SQL_SO_MIXED:8,SQL_SO_STATIC:16) |
| SELECT_FOR_UPDATE | 1 | Select for update 语句是否可用(1:是,0:否) |
| TXN_CAPABLE | 2 | 事务的特性。SQL_TC_NONE = Transactions not supportedSQL_TC_DML = Transactions can contain only Data Manipulation Language (DML) statements (SELECT, INSERT, UPDATE, DELETE). Data DefinitionLanguage (DDL) statementsencountered in a transaction cause an error.SQL_TC_DDL_COMMIT = Transactions can contain only DML statements. DDL statements (CREATE TABLE, DROP INDEX, andso on) encountered in a transaction cause the transaction to be committed. SQL_TC_DDL_IGNORE = Transactions can contain only DML statements. DDL statementsencountered in a transaction are ignored.SQL_TC_ALL= Transactions can contain DDL statements and DML statements in any order.(SQL_TC_NONE:0, SQL_TC_DML:1,SQL_TC_ALL:2,SQL_TC_DDL_COMMIT:3,SQL_TC_DDL_IGNORE:4) |
| TXN_ISOLATION_OPTION | 15 | 可选的事务隔离级别。(SQL_TXN_READ_UNCOMMITTED:1,SQL_TXN_READ_COMMITTED:2,SQL_TXN_REPEATABLE_READ:4,SQL_TXN_SERIALIZABLE:8,默认:15) |