如果您只希望移动其中一部分数据，那么您应该相应地修改select子句。
If you want to move a subset of data, you should modify the SELECT clause accordingly.
含有value子句的任意数据项将在此时被初始化为一个适当的值。
Any data items that have value clauses are initialized to the appropriate value at that time.
您可以使用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.
让数据更改操作留在with子句中，实际上便强加了一个非常自然的顺序，这样可用于解决冲突。
Keeping data change operations in the WITH clause imposes a very natural order which can be used to solve conflicts.
通过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.
函数返回类型的数据类型可以直接指定，或使用references子句指定。
The data type for the function return type can be specified directly or using the REFERENCES clause.
该函数的for子句循环通过包含在临时XML数据中的实体节点。
The FOR clause of this function loops through the entity nodes contained in the transient XML data.
DB 2依据时态表的开始和结束列中使用的数据类型，使用合适的where子句谓词自动重写查询。
DB2 automatically rewrites the queries with appropriate WHERE clause predicates depending on the data types used in the start and end columns of the temporal tables.
例如，只需在列出监控表函数返回的应用程序数据的查询中添加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.
在上述例子中，整个过程是这样的：DATA执行一个数据更改操作，并作为CTE放在with子句中。
This is what is happening in this case: data performs a data change operation and has been banned as a CTE into the WITH clause.
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.
在装载数据时它并不使用FOR update子句，所以行并不会被锁定。
It will not use a FOR UPDATE clause when loading the data, so the rows will not be locked.
WHERE 子句基于资产名称联接临时和永久XML数据。
The WHERE clause joins the transient and persistent XML data based on asset names.
使用筛选器(例如sql子句)筛选掉不属于当前租户的数据记录。
A filter (e.g., SQL statement sub-clause) is used to filter out data records not belonging to the current tenant.
也可以将经常被访问的数据作为include子句中的列包含在索引中。
Frequently accessed data can also be included within an index as included columns.
结果保存在into子句中指定的数据结构中。
The results are saved in the data structure that is specified in the INTO clause.
也可以是类型与select子句相匹配的数据结构。
It can also be a data structure of a type that is fitting to the SELECT clause.
在DB 2UDBV 7中创建分区的表空间时，DB 2根据CREATEindex语句的part子句将数据划分到几个分区上。
When creating a partitioned table space in DB2 UDB V7, DB2 divides the data among the partitions according to the part clause of the CREATE INDEX statement.
在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.
DATAFILES是每个外部表的必需子句，它指定读写数据的文件路径。
DATAFILES is a mandatory clause for each external table. It specifies the file path where the data can be read from or written to.
直接的语句执行方法包括：sql语句中在where子句之后剥离数据的附加逻辑。
The direct statement execution method includes additional logic to strip the data after the where clause in the SQL statement.
要避免这种情况，使用CREATEPROCEDURE语句的returns子句来将数据返回给调用者。
To avoid this scenario, use the RETURNS clause of the CREATE PROCEDURE statement to return data to the caller.
在load期间可以使用XMLVALIDATE USING子句对XML数据进行验证。
XML data can be validated during load using the XMLVALIDATE USING clause.
可以使用FROM 子句为XML数据指定路径。
You can specify the path for XML data using the XML FROM clause.
XMLEXISTS对XML数据应用谓词，常常用在WHERE 子句中。
XMLEXISTS applies predicates to XML data and would often be used in a WHERE clause.
CREATEtable语句的PARTITIONBY子句指定了表数据的分区。
TABLE data is partitioned as specified in the partition BY clause of the CREATE TABLE statement.
'REFRESHDEFERRED '子句指出，使用' REFRESH '语句将用数据填充m QT。
The 'REFRESH DEFERRED' clause indicates that use of a 'REFRESH' statement will populate the MQT with data.
事情还没有完结，如果数据提供者是一个SQL数据库的话，WHERE子句必须应用在每条记录上。
But we're not done yet. If the data provider is an SQL database, the WHERE clause must be applied to each record.
如果数据提供程序是一个SQL数据库，则必须将where子句应用于每条记录。
If the data provider is an SQL database, the WHERE clause must be applied to each record.
如果数据提供程序是一个SQL数据库，则必须将where子句应用于每条记录。
If the data provider is an SQL database, the WHERE clause must be applied to each record.
应用推荐