对于目标表中匹配的行,将依据更新或者删除子句规范来进行更新或者删除,如图2所示。
Matched rows in the target table are updated or deleted based on update or delete clause specifications, as shown in Figure 2.
由于这个原因,您应该将'FOR FETCHONLY '子句加在不会成为更新目标的查询的后面,或者使用' BLOCKINGALL '作为应用程序的一个绑定选项。
For this reason, you should append a 'for FETCH ONLY' clause to those queries that will not be update targets, or use 'BLOCKING ALL' as one bind option for your application.
通过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.
SQLwhere子句进一步将目标XML文档限制为只在这样的行中找到的文档,这些行中客户的“status ”是一个确定值(在本例中是“Silver ”)。
The SQL WHERE clause further restricts the target XML documents to those found only in rows in which the client's "status" is of a certain value (" Silver, "in this method).
在Script窗格中选择任何映射语句,这将显示该语句中所引用的所有源和目标可映射对象,如映射源、循环迭代器、条件、where子句,等等。
Selecting any mapping statement in the Script Pane shows all source and target mappables referenced in the statement, such as mapping source, loop iterator, condition, where clause, and so on.
values子句还为用户指定的oid列的值包括了一个casting函数,因为该值必须强制转换成目标表的REFERENCE类型。
The VALUES clause also includes a casting function for the user-specified value of the OID column because the value must be cast into the REFERENCE type of the target table.
从概念上说,merge函数通过应用on子句过滤,将源表行与目标表行进行联接,所有联接的行都在目标中进行更新或者删除。
Conceptually, the merge function joins source table rows with target table rows by applying the on clause filter. All the joined rows are updated or deleted on the target.
然而,XMLTable还包括一些子句,用于将目标XML数据映射到SQL数据类型的结果集列。
However, XMLTable also includes clauses to map the target XML data into result set columns of SQL data types.
对于仅包含更新子句或删除子句的merge语句,内部联接会在源表与目标表之间执行。
For the merge statement that contains only the update clause or the delete clause, the inner join is performed between source and target table.
接下来,构造SQL命令来更新目标行,方法为使用带有WHERECURRENTOF子句的SQLupdate语句。
Next, you construct an SQL command to update the target row by using an SQL update statement, with a WHERE CURRENT OF clause.
目标是编写一个FindBugs检测器,它将找出代码中调用日志框架而未被包装在监护子句中的所有地方。
The goal is to write a FindBugs detector that will find all the places in the code that are making calls to the logging framework without being wrapped in a guard clause.
目标是编写一个FindBugs检测器,它将找出代码中调用日志框架而未被包装在监护子句中的所有地方。
The goal is to write a FindBugs detector that will find all the places in the code that are making calls to the logging framework without being wrapped in a guard clause.
应用推荐