Full document update using the SQL update statement.
使用SQL update语句进行全文档更新。
These SQL UPDATE statements capture all the statistics.
这些SQL update语句捕获所有的统计数据。
This option generates a script containing SQL UPDATE statements.
该选项生成包含了SQL UPDATE语句的脚本。
Coding SQL UPDATE statements that operate against a set of predefined catalog views.
对针对一组预先定义的目录视图进行操作的SQL update语句进行编码。
To update and delete XML data stored in DB2, you use SQL update and delete statements.
要更新和删除存储在DB 2中的XML数据,可使用SQL UPDATE和delete语句。
Most of the examples in this article show the transform expression in an SQL UPDATE statement.
本文中的大多数示例在SQL update语句中使用转换表达式。
Next you used the SQL UPDATE statement to modify the column values for selected rows in a table.
然后使用SQL update语句来修改表中选定行的列值。
At this point, you execute an SQL UPDATE operation to modify the current row and move to the second row.
此时,执行SQL UPDATE操作来修改当前行并移到第二行。
The application submits an SQL update statement and transmits the updated document to the database server.
应用程序提交一个SQL update语句,把更新后的文档传输给数据库服务器。
The import utility uses the SQL INSERT statement (or the SQL UPDATE statement) to write data to the target table.
import工具使用SQLINSERT语句(或 SQL UPDATE 语句)将数据写到目标表中。
In fact, you can use SQL UPDATE statements to change the values of statistical columns in updatable catalog views.
实际上,您可以使用SQL update语句来更改可更新编目视图中的统计列。
The null indicator values are set by the RPG HANDLE_UPDATE sub-procedure prior to executing the SQL UPDATE statement.
空指示符值在执行SQL update语句之前通过RPG handle_update子过程设置。
You may have noticed that Listing 6 never executes the PreparedStatement that you constructed for the SQL UPDATE command.
您可能已经注意到清单6从未执行您为SQL UPDATE 命令构造的PreparedStatement。
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子句的SQL update语句。
At this point, a real application would modify the count column appropriately by issuing the necessary SQL UPDATE statements.
这时,真正的应用程序将通过执行必要的SQL update语句来适当修改count列。
The application simply sends an SQL UPDATE statement with an embedded XQuery transform expression to the DB2 server (Figure 2).
应用程序只需向DB 2服务器发送一个包含XQuery转换表达式的SQL update语句(图2)。
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表中的记录。
When you use transform expressions in SQL update statements, you rarely have a filtering predicate in the COPY clause but rather in the SQL WHERE clause.
在SQL更新语句中使用转换表达式时,很少在COPY子句中使用筛选谓词,通常是在 SQL WHERE 子句中进行筛选。
In the pessimistic locking scheme, explicit locks are taken against rows using the SQL SELECT FOR UPDATE statement. Data is then modified, and an SQL UPDATE is issued.
在悲观锁定方案中,通过使用SQLSELECTFORupdate语句对数据行进行显式锁定,然后更改数据,并执行SQL UPDATE。
Prior to the DB2 for I 6.1 release, SQL Update and Insert statements could use an indicator variable with a value of -1 to set a null capable column to the null value.
在DB 2fori 6.1发布之前,SQL Update和insert语句能够使用一个值为- 1的指示符变量,将支持空值的列设置为空值。
At some level, the SQL UPDATE statement is the union of the SQL INSERT and DELETE statements, because you must select rows to modify as well as specify how to modify them.
在某种程度上,SQL update语句是SQLINSERT和delete语句的联合,因为您必须选择要修改的行,还必须指定如何修改它们。
At some level, the SQL UPDATE statement is the union of the SQL INSERT and DELETE statements, because you must select rows to modify as well as specify how to modify them.
在某种程度上,SQL update语句是SQLINSERT和delete语句的联合,因为您必须选择要修改的行,还必须指定如何修改它们。
应用推荐