如果该表在任何时刻都必须是可用的，那么应该使用该子句。
Use this clause if the table must be up and available at any time.
如果已经执行了验证，那么在触发器代码体中使用when子句跳过验证过程。
If so, it skips the validation process by using the WHEN clause in the trigger body.
您可以任意组合使用这些子句，以达到期望的效果。
You can use these clauses in any combination to achieve the desired effect.
在下面的样本中，where子句使用？
您可以使用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.
函数返回类型的数据类型可以直接指定，或使用references子句指定。
The data type for the function return type can be specified directly or using the REFERENCES clause.
如果需要在一个已有的(并且被填充的)表上创建一个索引，那么可以使用defer子句。
If you need to create an index on an already existing (and populated) table, use the DEFER clause.
下面的例子演示了在触发器中使用WHEN 子句。
The following example demonstrates the use of the WHEN clause in the trigger.
创建一个物理文件，并使用CCSID子句。
IF/THEN/ELSE逻辑是搞清楚如何使用WHERE 子句谓词的良好基础，因此在DB2地址空间中行能够被快速拒绝。
IF/THEN/ELSE logic is fertile ground for figuring out how to use WHERE clause predicates so rows can be rejected sooner in DB2's address space.
下一步是执行适当的SQL查询来构造可更新的游标，方法为根据先前的描述使用 FORUPDATE子句。
The next step is to execute the appropriate SQL query to construct your updateable cursor, which requires using the FOR UPDATE clause as described earlier.
如果使用标准的into子句，那么按选择的字段的次序填充行。
If you use the standard INTO clause, the row is filled in the order of the selected fields.
在装载数据时它并不使用FOR update子句，所以行并不会被锁定。
It will not use a FOR UPDATE clause when loading the data, so the rows will not be locked.
这个更新并不使用SQLwhere子句选择特定的一行。
This update does not use an SQL WHERE clause to select a specific row.
表可以通过使用JOIN关键字显式地连接，也可以通过使用WHERE 子句隐式地连接。
Tables can be joined either explicitly, by using the JOIN keyword, or implicitly, by using a WHERE clause.
还可以使用As子句命名查询中的选定列，从而允许您控制如何显式结果，这也在下一节中讲述。
You can also use an AS clause to name the selected columns in a query. Doing so lets you control how the results are displayed, which is also demonstrated in the next section.
创建MQT时需要仔细地确定要使用的子句。
One needs to carefully determine the clauses to use while creating an MQT.
xmlagg函数使用ORDERBY子句对组内元素进行排序。
XMLAGG functions use the ORDER BY clause to sort the elements within the group.
对于只读游标，使用FORREADONLY子句确保游标无歧义。
FOR read-only cursors, make the cursor unambiguous by using the FOR read only clause.
TOTAL_SORT _ TIME：该语句已经执行的所有排序的总消耗时间(微秒级)(例如，使用ORDERBY子句的查询语句)。
TOTAL_SORT_TIME: the total elapsed time (in milliseconds) for all sorts that have been executed by the statement (e.g. query statement using ORDER by clause).
表示参数的数据类型将被指定为使用like子句，并使用like子句区段中的参数属性指定，如下所示。
LIKE, that indicates that the data type for the parameter will be specified using the LIKE clause and specified using the parameter properties in the LIKE clause section, as shown below.
return：使用return子句允许您操作操作节点集，随后返回除该节点集以外的结果。
Return: Using a return clause lets you operate on a node set, but then return (in results) something other than that node set.
如清单1所示，使用for子句来指定一组笛卡尔元组，表达式的其余部分将对该元组求值。
You use the for clauses to specify a set of Cartesian tuples on which the rest of the expression will be evaluated, shown in Listing 1.
正确的答案是使用 :include子句的哈希语法。
The correct answer is to use a hash syntax for the :include clause.
通过在一个未投射的数据项上的after - aggregation细节过滤器中使用for子句，底层查询会自动将该项目投射并分组为列表的最外层列。
By using the for clause in the after-aggregation detail filter on a non-projected data item, the underlying query automatically projects and groups the item as the outer most column of the list.
对于Sybase现有表，可以使用where子句指定现有表的列名，以限制存储过程的输出。
Sybase existing tables can be used with a WHERE clause specifying column names of the existing table to restrict the output received from the stored procedure.
可以使用FROM 子句为XML数据指定路径。
You can specify the path for XML data using the XML FROM clause.
还可以使用values子句填充变量p2和p3，如下例所示。
You can also populate the variables p2 and p3 using the VALUES clause, as shown in the following example.
而且，通过使用axes子句，plot命令可以使用不同的轴集合，如x2y2。
Also, the plot command can be made to use a different set of axes like x2y2 by using the axes clause.
还可以在db2audit命令中使用ERRORTYPE 子句来配置审计功能处理错误的方式。
You can also configure the way you want the audit facility to handle errors using the ERRORTYPE clause in the db2audit command.
应用推荐