The UPDATE statement fails if the modified document is not valid.
如果更新后的文档是无效的，update语句就会失败。
To ensure that all existing rows are handled properly, the UPDATE statement is run.
为了确保所有已有的行都得到适当的处理，运行update语句。
The structure of the combined plan is nearly identical to that of the UPDATE statement alone.
这个组合的计划在结构上与单独的update语句几乎一样。
Most of the examples in this article show the transform expression in an SQL UPDATE statement.
本文中的大多数示例在SQLupdate语句中使用转换表达式。
Next you used the SQL UPDATE statement to modify the column values for selected rows in a table.
然后使用SQLupdate语句来修改表中选定行的列值。
If you move the position update statement to a different package it is necessary to perform a configure.
如果将位置更新语句移动到不同的包，则需要进行相应的配置。
At a high level, you see the familiar "update... set... where..." syntax of an SQL update statement.
SQLupdate语句的总体结构仍然是大家熟悉的“update…set…。where…”语法。
The naive approach USES a cursor to scan the table and execute a positioned update statement for each row.
初级的方法是使用一个游标对表进行扫描，并为每一行执行一个定位的更新语句。
The set clause of the UPDATE statement replaces the existing document in a given row with a new document.
UPDATE语句的set子句用一个新文档替换给定行中的现有文档。
The application submits an SQL update statement and transmits the updated document to the database server.
应用程序提交一个SQLupdate语句，把更新后的文档传输给数据库服务器。
The import utility uses the SQL INSERT statement (or the SQL UPDATE statement) to write data to the target table.
import工具使用SQLINSERT语句（或 SQLUPDATE 语句）将数据写到目标表中。
Next, specify the field (s) to include in the overqualified update statement when modified data is committed.
接下来，指定在提交已修改数据时需要包含到严格限定的update语句中的字段。
This example wraps a single UPDATE statement with SELECT statements to demonstrate the change to the target row.
本示例在update语句的前后都使用了select语句，以证实对目标行的更改。
Issuing an UPDATE statement is fairly easy, as shown in Listing 4, where you modify two columns of a single row.
执行update语句相当容易，如清单4所示，其中修改了单个行的两列。
If the WHERE clause isn't included, the UPDATE statement modifies the indicated columns for all rows in the table.
如果没有包括where子句，则update语句将修改表中所有行的指定列。
Two types of queries can be used in the WHERE clause of an UPDATE statement: a scalar subquery and a table subquery.
两种查询可以用于update语句的where子句中：标量子查询和表子查询。
The null indicator values are set by the RPG HANDLE_UPDATE sub-procedure prior to executing the SQL UPDATE statement.
空指示符值在执行SQLupdate语句之前通过RPG handle_update子过程设置。
The parameter object will be used to set input values in an UPDATE statement, or WHERE clause values in a query (etc.).
这个参数对象将用于设置update语句中的输入值，或者用于设置某一查询中的where子句的值(等等)。
The corresponding error message is returned for the UPDATE statement in the victim transaction, as shown in Listing 19.
出错的事务的update语句返回相应错误信息，如清单19所示。
From the query results, shown in Listing 8, you can see that one audit record was generated for the failed update statement.
在清单8中显示的查询结果中，您可以看到有一条关于失败的更新语句的审计记录。
From the query results, shown in Listing 5, you can see that one audit record was generated for the failed update statement.
从清单5显示的查询结果可以看出，针对失败的更新语句有一条审计记录。
Thus the UPDATE statement fails to find the row with the row CHANGE TOKEN that was retrieved before the REORG occurred.
因此，update语句无法找到具有ROWCHANGETOKEN的行，这些行是在发生REORG之前检索得到的。
The customer profile data from the HTTP request is passed as a parameter to the update statement; no modifications are needed.
来自HTTP请求的客户个人数据作为参数传递给更新语句；不需要修改。
From the query results, shown in Listing 8, you can see that one audit record was generated for the failed update statement.
在翕清单8中显示的查询结果中，您可以看到有一条关于失败的更新语句的审计记录。
The SIGNAL statement rolls back the changes that were attempted by the triggering statement (that is, our update statement).
SIGNAL语句回滚由触发语句（也就是我们的update 语句）尝试的更改。
After you have the object in XML format, you can issue a regular SQL update statement to update the record in the table EMPLOYEE.
把对象转换为xml格式之后，可以通过执行常规的SQL更新语句更新employee表中的记录。
Next, you construct an SQL command to update the target row by using an SQL update statement, with a WHERE CURRENT OF clause.
接下来，构造SQL命令来更新目标行，方法为使用带有WHERECURRENTOF子句的SQLupdate语句。
The application simply sends an SQL UPDATE statement with an embedded XQuery transform expression to the DB2 server (Figure 2).
应用程序只需向DB 2服务器发送一个包含XQuery转换表达式的SQLupdate语句(图2)。
Similarly, if we want to update the city attribute value, we can invoke its mutator method in the UPDATE statement ( Listing 2).
同样的，如果想更新城市属性值，可以调用UPDATE语句中的 mutator方法（清单2）。
When DB2 9.5 executes the UPDATE statement, it locates the relevant document (s) and modifies the specified elements or attributes.
在DB 2 9.5执行这个update语句时，它找到相关的文档？修改指定的元素或属性。
应用推荐