Listing 1 shows an example of an SQL procedure with a case statement with a simple-case-statement-when-clause.
清单1展示了一个SQL过程的示例,包含一个case语句和一个simple - case - statement - when - clause。
It turns out that when you get to this clause, one player has won.
结果证明当您获得这样的一个子句时,就有一个选手会赢。
Only if the WHEN clause evaluates to true will the action part of trigger statement be executed.
仅当when子句的计算结果为真时,触发器语句的操作部分才会执行。
Currently translations of statements containing the range partitioning clause are supported only when these statements are provided in an input file using the import option in the MTK.
目前,对包含范围分区子句的语句的转换,只有当使用MT K中的导入选项在一个输入文件中提供这些语句时才受支持。
The syntax is similar to the IMPORT example just shown in that you specify a registered (and completed) XML schema when invoking the XMLVALIDATE clause.
语法类似于刚刚显示的IMPORT示例,因为您在调用xmlvalidate子句时指定了一个已注册(或已完成的)XML模式。
It will not use a FOR UPDATE clause when loading the data, so the rows will not be locked.
在装载数据时它并不使用FOR update子句,所以行并不会被锁定。
When creating a partitioned table space in DB2 UDB V7, DB2 divides the data among the partitions according to the part clause of the CREATE INDEX statement.
在DB 2UDBV 7中创建分区的表空间时,DB 2根据CREATEindex语句的part子句将数据划分到几个分区上。
It is important to note that file system caching was disabled by specifying the no file system CACHE clause when each table space in the database was created.
重要的是,要注意当每一个数据库表空间创建时,文件系统缓存已经通过指定NOFILESYSTEM cache子句并被禁用。
Usage: This parameter controls the decision on whether or not to apply a NON EMPTY clause on member requests when the number of tuples exceeds the set threshold.
用法:当元组数超过设定的阈值时,该参数控制是否对成员请求应用NONempty子句的决策。
Then in 1909, the decree was further watered down when an extra clause was added to allow women in trousers on condition they were "on a bicycle or holding it by the handlebars".
后来到1909年,这一法令进一步放松,增添了一个额外条款,女性骑自行车时可以穿裤子。
The LIMIT clause is helpful when you want to limit the number of records returned by an SQL statement.
想要限制一个SQL 语句返回的记录数,可以使用 LIMIT 子句。
When you have determined that the table contains data that is not uniformly distributed, run RUNSTATS with the WITH DISTRIBUTION clause.
当您已确定表中包含不是统一分布的数据时,可以运行包含WITHDISTRIBUTION子句的RUNSTATS。
When reorganizing XML indexes, database administrators can use the allow write ACCESS clause in the reorg indexes command to allow concurrent writes on the table.
在重组xml索引时,数据库管理员可以通过在REORGINDEXES命令中使用ALLOWWRITEaccess子句允许并发的写操作。
The while loop, as was the case with the if statement, supports an optional else clause containing a block of program statements executed when the expression is False.
while循环与if语句一样,支持一个可选的else子句,其中包含一个当表达式计算为False时执行的程序语句块。
When using the CREATE FIELD statement, make sure to specify each clause in the correct order (TYPE, NAMESPACE, NAME, VALUE).
当使用CREATEfield语句时,请确保按照正确的顺序指定每个子句(TYPE、NAMESPACE、NAME和VALUE)。
When the if clause has more than one condition, you can choose to have it evaluate to true when any of the conditions are true or when all of the conditions are true.
当if子句有多个条件时,您可以选择让它在任何条件为true时求值为 true,或者在所有条件都为 true 时才求值为 true。
The 'data INITIALLY DEFERRED' clause indicates that when the MQT is created, it is not populated with data as a part of create table statement.
'DATAINITIALLY DEFERRED '子句指出,当创建MQT时,不会作为createtable语句的一部分填充m QT。
Similarly, when a FETCH statement includes the BULK COLLECT clause, the variable used in the FETCH must be an array.
同样,FETCH语句包括BULKCOLLECT子句时,用于 FETCH的变量必须是阵列。
Create the trigger (add checking for the global variable in the WHEN clause).
创建触发器(在when子句中添加对全局变量的检查)。
If so, it skips the validation process by using the WHEN clause in the trigger body.
如果已经执行了验证,那么在触发器代码体中使用when子句跳过验证过程。
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 子句中进行筛选。
When the BULK COLLECT clause is included, the statement can return multiple rows; the variable in the INTO clause must be an array, and each row is stored in an array element.
在包括BULKCOLLECT子句后,该语句可返回多行;INTO 子句中的变量必须是阵列,且每一行存储在一个阵列元素中。
The following example demonstrates the use of the WHEN clause in the trigger.
下面的例子演示了在触发器中使用WHEN 子句。
A simpler syntax is generated when ROWNUM is specified in the WHERE clause.
当在where子句中指定ROWNUM时,可生成更简单的语法。
The WHEN clause of the trigger can be used to check if the new value is validated or not validated according to any of the specified schemas.
触发器的when子句可以用来检查是否根据任何指定模式对新值进行了验证。
The attribute FIRST in the ACCESS guideline element specifies that the table CUSTACC must appear as the outermost table when the tables in the FROM clause are joined.
ACCESS准则元素中的属性FIRST指定在连接from子句中的表时,表CUSTACC必须作为最外层的表出现。
Usage: This parameter controls the decision on when the NON EMPTY clause is applied to the query MDX.
用法:该参数控制何时向查询MDX应用NONempty子句的决策。
In code listing 11, the WHEN clause checks to determine whether or not the XML document INFO is not validated against the EMPLOYEE schema.
在清单11的代码中,when子句检查确定XML文档INFO是否根据EMPLOYEE模式进行了验证。
SeenGuardClauseAt: the value of the program counter when the logging guard clause is discovered in the analyzed code.
seenGuardClauseAt:在所分析的代码中发现日志监护子句时,程序计数器的值。
SeenGuardClauseAt: the value of the program counter when the logging guard clause is discovered in the analyzed code.
seenGuardClauseAt:在所分析的代码中发现日志监护子句时,程序计数器的值。
应用推荐