通过BLOB数据类型或使用FORBITdata子句定义的列将以二进制形式从源传递到目标,所使用的代码页是零。
Columns defined with the BLOB data type, or using the FOR BIT data clause will be passed as binary from the source to the target, and the code page used is zero.
可以使用FROM 子句为XML数据指定路径。
You can specify the path for XML data using the XML FROM clause.
让数据更改操作留在with子句中,实际上便强加了一个非常自然的顺序,这样可用于解决冲突。
Keeping data change operations in the WITH clause imposes a very natural order which can be used to solve conflicts.
结果保存在into子句中指定的数据结构中。
The results are saved in the data structure that is specified in the INTO clause.
在装载数据时它并不使用FOR update子句,所以行并不会被锁定。
It will not use a FOR UPDATE clause when loading the data, so the rows will not be locked.
XMLEXISTS对XML数据应用谓词,常常用在WHERE 子句中。
XMLEXISTS applies predicates to XML data and would often be used in a WHERE clause.
WHERE 子句基于资产名称联接临时和永久XML数据。
The WHERE clause joins the transient and persistent XML data based on asset names.
如果您只希望移动其中一部分数据,那么您应该相应地修改select子句。
If you want to move a subset of data, you should modify the SELECT clause accordingly.
在DB 2 9.7中,只需通过CREATEtable语句的COMPRESSyes子句启用XML数据的压缩功能,这会同时压缩表中的关系和xml列。
In DB2 9.7, the compression capability for XML data is enabled simply through the compress YES clause of the CREATE table statement, which compresses both relational and XML columns in the table.
例如,只需在列出监控表函数返回的应用程序数据的查询中添加where子句,就可以搜索CPU消耗量最大的应用程序。
For example, you can easily search for the applications consuming the highest amount of CPU by simply adding a WHERE clause to a query that lists application data from a monitoring table function.
XML数据的表空间位置由LONGin子句决定,其可在分区级别、表级别、或它们的任何组合中指定。
The table space placement for XML data is determined by the LONG in clause, which can be specified at partition level, table level, or any combination thereof.
除了嵌入的原始sql查询以外,没有保留用于查询数据的一个或多个表的表示(“ FROM ”子句)。
Beyond the embedded original SQL query, no representation is kept of the table or tables that were queried for data (the "FROM" clause).
您可以通过where子句筛选YQL结果,通过使用子选择来合并或“混搭”来自多个服务的数据。
You can filter YQL results with WHERE clauses, and combine or "mash up" data from multiple services through the use of sub-selects.
与DB2UDBforLinux,UNIX,andWindows相似,在 DB2 UDB for z/OS 中,如果您在对象定义上使用了CCSIDUNICODE 子句,就可以存储并检索 Unicode数据,例如
Similar to DB2 UDB for Linux, UNIX, and Windows, in DB2 UDB for z/OS you can store and retrieve Unicode data if you have used the CCSID UNICODE clause on the object definitions, such as the following
REFRESHdeferred子句的意思是,在任何时候都可以用REFRESHtable语句刷新该表中的数据。
The refresh DEFERRED clause means that the data in the table can be refreshed at any time using the refresh table statement.
参数化查询将返回满足查询内的where子句条件的数据。
A parameterized query returns data that meets the conditions of a WHERE clause within the query.
其思想是,在一个描述性级别上,在FROM 子句中建立一个临时表,这个表由在调用任何空间函数之前导入的数据组成。
The idea is, on a descriptive level, to build in the FROM clause a temporary table that consists of the data to be imported before calling any of the spatial functions.
要避免这种情况,使用CREATEPROCEDURE语句的returns子句来将数据返回给调用者。
To avoid this scenario, use the RETURNS clause of the CREATE PROCEDURE statement to return data to the caller.
CREATEtable语句的PARTITIONBY子句指定了表数据的分区。
TABLE data is partitioned as specified in the partition BY clause of the CREATE TABLE statement.
where子句使用DB2的XMLExists函数限制查询所返回的数据。
The WHERE clause USES DB2's XMLExists function to restrict the data to be returned.
只有在查询的from子句包含周期规范时,DB 2才会自动且透明地访问历史数据。
DB2 accesses the historical data automatically and transparently only if the FROM clause of the query includes the period specifications.
也可以是类型与select子句相匹配的数据结构。
It can also be a data structure of a type that is fitting to the SELECT clause.
您可以使用in子句在用户数据所在的表空间上创建一个索引,或者在其他表空间上创建索引。
You can use the in clause to create an index in the same table space where user data resides, or in a different table space.
在load期间可以使用XMLVALIDATE USING子句对XML数据进行验证。
XML data can be validated during load using the XMLVALIDATE USING clause.
含有value子句的任意数据项将在此时被初始化为一个适当的值。
Any data items that have value clauses are initialized to the appropriate value at that time.
还可以使用一个FORPORTION OF business_time子句来更新、删除和查询数据。
You can also update, delete, and query data using a FOR PORTION OF BUSINESS_TIME clause.
当您已确定表中包含不是统一分布的数据时,可以运行包含WITHDISTRIBUTION子句的RUNSTATS。
When you have determined that the table contains data that is not uniformly distributed, run RUNSTATS with the WITH DISTRIBUTION clause.
虽然所有筛选子句都会减小查询的最终结果集,但是某些筛选子句还可以帮助减小所需扫描的数据量。
Although all filter clauses reduce the final result set of a query, some can also help reduce the amount of data that must be scanned.
虽然所有筛选子句都会减小查询的最终结果集,但是某些筛选子句还可以帮助减小所需扫描的数据量。
Although all filter clauses reduce the final result set of a query, some can also help reduce the amount of data that must be scanned.
应用推荐