A heterogeneous batch update lets you combine several SQL statements with or without parameter markers into a single network call.
通过异构批量更新,可以将有或没有参数占位符的多个sql语句组合到一个单独的网络调用中。
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 子句中进行筛选。
Relational update feeds consist of a single SQL statement.
关系型更新数据源包含单个sql语句。
This update does not use an SQL WHERE clause to select a specific row.
这个更新并不使用SQLwhere子句选择特定的一行。
The modified XML document is bound to the update SQL as a runtime parameter.
修改的XML文档作为运行时参数被绑定到更新sql。
Using the new support for SQL, positioned update is faster than searched update or delete.
使用新的SQL支持,定位的更新比搜索的更新或删除更快。
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表中的记录。
If you use the JDBC or sqlimport method of the loader, it does not provide the desired results because existing database records are overwritten by the SQL update.
如果你使用JDBC或者是loader的sqlimport方法,它们并没有提供所期望的结果,因为已经惨哉的数据库记录已经被sql更新所覆盖了。
UpdateSQL — It represents a parameterized update SQL.
updateSQL——它表示参数化的更新sql。
Modifying stored XML in DB2, using SQL XML update, in response to a request; for example, a change of address.
使用SQLxml更新修改DB 2中存储的XML,以响应一个请求;例如,更改地址。
updateSQL - It represents a parameterized update SQL.
updateSQL ——它表示参数化的更新SQL。
Full document update using the SQL update statement.
使用SQL update语句进行全文档更新。
To update and delete XML data stored in DB2, you use SQL update and delete statements.
要更新和删除存储在DB 2中的XML数据,可使用SQL UPDATE和delete语句。
Listing 8 shows how to extract the customerid from the XML and use it to create an update SQL command for the database.
清单8演示如何从XML中提取出customerid并用它创建更新数据库的sql语句。
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语句。
The application submits an SQL update statement and transmits the updated document to the database server.
应用程序提交一个SQL update语句,把更新后的文档传输给数据库服务器。
The database manager (DBM) handles data retrieval and update by decomposing SQL requests automatically into sub-requests.
数据库管理器(DBM)通过自动地将SQL请求分解成子请求,来处理数据的检索和更新。
The article provides a guide to setting up the OGSA-DAI system along with DB2, for relational data access and update through SQL requests in OGSA-DAI perform documents.
文章提供了OGSA -DAI系统和DB2的设置方法,以及通过OGSA - DAI执行文档中的SQL请求来存取和更新关系数据的指南。
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语句的联合,因为您必须选择要修改的行,还必须指定如何修改它们。
In fact, you can use SQL UPDATE statements to change the values of statistical columns in updatable catalog views.
实际上,您可以使用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语句进行编码。
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操作来修改当前行并移到第二行。
If this attribute is present and set to SQL, then the update value (child node of the element) is considered to be an SQL query.
如果这个属性存在并设置为SQL,那么updatevalue(元素的子节点)被视为一个SQL查询。
Recreate any 1.0 database from scratch or contact the Proven Practices team to obtain an update SQL script.
从头重新创建任何的1.0数据库或联系provenPractices团队获得最新的sql脚本。
Listing 7. SQL for the update operation.
清单7.update操作的SQL代码。
Listing 15. SQL for the update operation.
清单15.update操作的SQL代码。
Listing 15 shows the SQL code for the update operation.
清单15显示了update操作的SQL代码。
应用推荐