Describes how to use the EXECUTE AS clause to impersonate another user.
描述如何使用EXECUTE A s子句来模拟另一用户。
Unlike the EXECUTE AS clause, it does not change the execution context of the procedure.
与EXECUTEA s子句不同,它不更改过程的执行上下文。
XQuery statements in DB2 support parameter markers that are passed to XQuery by using the passing as clause.
DB 2中的XQuery语句支持使用passing a s子句把参数标志传递给XQuery。
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.
还可以使用As子句命名查询中的选定列,从而允许您控制如何显式结果,这也在下一节中讲述。
Table and use an AS clause to name these columns for the display with the ij tool. Because the query joins these two tables (by using an implicit inner join), you can select columns from both tables.
因为查询(通过使用隐式内连接)将两个表连接,您可以从两个表中选择列。
The SECTION clause as part of the text search criteria identifies the part within the XML document structure where text search shall occur.
SECTION子句作为文本搜索条件的一部分,标识出应该在XML文档结构的哪个部分中进行文本搜索。
Note: These parameters count in the NUMBER of parameters clause but they do not appear as parameters of the federated procedure.
注:NUMBEROFparameters子句中考虑这些参数,但是它们不作为联邦过程的参数出现。
As you see in update 9, the MODIFY clause contains multiple update operations.
如更新9所示,modify子句包含多个更新操作。
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.
下一步是执行适当的SQL查询来构造可更新的游标,方法为根据先前的描述使用 FORUPDATE子句。
Autostrade argues that the clause of the privatisation law banning construction companies as shareholders has expired.
意大利高速公路公司称,这项私有化法律对建筑公司的约束条款已经过期了。
In particular, since the "as" clause overrides the actual table column name, it is possible to continue sending an XML element that no longer has any direct literal meaning in a's database.
尤其是,因为“AS ”子句覆盖了实际的表的列名,所以有可能继续发送在A数据库中不再拥有任何直接文字意义的xml元素。
All of the SQL expressions for any attributes that were selected as columns in the select clause should also be in the GROUP BY clause.
对于作为select子句中的列的任何属性,它们的SQL表达式也应该放在GROUP by子句中。
In addition, triggers can now contain UPDATE, DELETE, and INSERT operations together in a single clause as the trigger event. For example.
另外,触发器现在可以在单一子句中同时包含UPDATE、DELETE和INSERT操作,作为一个触发器事件。
You can also populate the variables p2 and p3 using the VALUES clause, as shown in the following example.
还可以使用values子句填充变量p2和p3,如下例所示。
Update 2 is an SQL SELECT statement with the same XMLQUERY function, transform expression, and WHERE clause, as in Update 1.
更新2是一个SQLselect语句,其中包含与更新1相同的XMLQUERY函数、转换表达式和where子句。
Instead, use a virtual table with a WHERE clause, or define the join as a view in the data source, and execute the rule on this view.
相反,可使用具有where子句的虚拟表,或者将连接作为数据源的视图进行定义,并在这一视图中执行规则。
Matched rows in the target table are updated or deleted based on update or delete clause specifications, as shown in Figure 2.
对于目标表中匹配的行,将依据更新或者删除子句规范来进行更新或者删除,如图2所示。
Also note that use of XHTML reduces problems caused by copy-and-paste editing of large blocks of statements, such as copying an entire clause.
还注意到,使用XHTML将减少对大块语句进行复制-粘贴编辑时所引起的问题,例如复制整个子句。
This tutorial describes subqueries stated as conditions in the WHERE clause, which are useful for simpler comparison queries.
本教程描述在 WHERE 子句中作为条件的子查询,这些子查询对于较简单的比较查询很有用。
For the exceptional situations where the optimizer cannot choose an optimal query execution plan, DB2 has added features such as the SELECTIVITY clause and optimization guidelines.
对于优化器不能选择最佳查询执行计划的例外情况,DB 2已经增加了诸如selectivity子句和优化指南之类的特性。
Multiple slices of data can be returned in a single query by using grouping sets or super-groups (such as ROLLUP) in the GROUP-BY clause of the SQL statement.
通过在sql语句的GROUP BY子句中使用多个分组集或超级组(比如rollup),可以在一个查询中返回数据的多个切片。
In addition, AS correlation specifications in the FROM clause can declare temporary names for columns within the query.
此外,from子句中的AS相关性规范可以为查询中的列声明临时名称。
There are so many anchovies, you can "walk on the sea" without wetting your feet - "or so I am told", said Mr Sarkozy, carefully giving himself a get-out clause even as he pandered.
凤尾鱼是如此之多,你可以不沾湿双脚“行走于大海之上”——“别人就是这么给我说的”,萨科齐如是言道,即使在迎合之时,他也小心翼翼地给自己留有退路。
This is what is happening in this case: data performs a data change operation and has been banned as a CTE into the WITH clause.
在上述例子中,整个过程是这样的:DATA执行一个数据更改操作,并作为CTE放在with子句中。
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.
表示参数的数据类型将被指定为使用like子句,并使用like子句区段中的参数属性指定,如下所示。
We always insure our goods with the People's Insurance Company of China as per their Ocean Marine Cargo Clause, Jan.1, 1981 revision.
我们总是按照中国人民保险公司1981年1月1日的《海洋运输货物保险条款》向他们投保。
There is no other setup required to unload the same table in multiple threads, except to add different WHERE clause as explained.
在多个线程中卸载同一个表不需要其他设置,只需要添加where子句。
There is no other setup required to unload the same table in multiple threads, except to add different WHERE clause as explained.
在多个线程中卸载同一个表不需要其他设置,只需要添加where子句。
应用推荐