当语句需要重复执行时，一般使用这种方法。
This is used when statements have to be executed repeatedly.
当语句、结果集和游标不再被使用时，pureQuery会自动关闭它们。
pureQuery helps you by automatically closing statements, result sets, and cursors when they are not in use anymore.
当一个语句执行时(1)，触发器被调用(2)。触发器注册一个回调函数(3)，以便将结果写入一个文件。
When a statement executes (1), the trigger is called (2). The trigger registers a callback function (3) to write the result to a file.
当这个语句被包含到一个存储过程中后，将对已执行语句的所有返回值进行错误检查。
When this statement is included in a stored procedure, all return values of executed statements are checked for errors.
仅当when子句的计算结果为真时，触发器语句的操作部分才会执行。
Only if the WHEN clause evaluates to true will the action part of trigger statement be executed.
这样，当sql语句被多次执行时，准备阶段的时间和CPU资源将得以节约。
Thus time and CPU resources are saved in the prepare phase when SQL statements are executed many times.
当这个mqt刚创建且还没有发出REFRESHtable语句的时候，对它的查询将返回一个错误。
A query against this MQT right after it was created, but before the REFRESH TABLE statement was issued, returns an error.
while循环与if语句一样，支持一个可选的else子句，其中包含一个当表达式计算为False时执行的程序语句块。
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.
if语句支持一个可选的else子句，指示当布尔表达式计算为False时应该处理的程序语句块。
The if statement supports an optional else clause that indicates a block of program statements that should be processed if the Boolean expression evaluates False.
在交互式环境中有一件事情值得注意，当写完每个语句组，需要eval它。
One thing to watch out for in the interactive environment is that you need to eval each statement suite as soon as you write it.
当使用该语句时，将回滚到发生在svpt1 保存点之后的操作。
When used, the statement rolls back the part of the transaction that occurred after the savepoint identified by svpt1.
当FETCH游标语句失败并且没有找到另一个要检索的行，SQLSUCCESS的值被设置为 0 并且WHILE LOOP结束。
When the FETCH cursor statement fails and does not find another row to retrieve, the value of SQLSUCCESS is set to 0 and the WHILE LOOP ends.
'DATAINITIALLY DEFERRED '子句指出，当创建MQT时，不会作为createtable语句的一部分填充m QT。
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.
当出现提示时，您可以直接键入查询语句或者使用向导帮助您创建一个查询语句。
When prompted, you can type in your query statement directly or use the wizards to help you create one.
当您在一个已经包含了语句的SQL脚本中设置语句结束符时，编辑器不会自动修改原有的语句结束符。
When you set the statement terminator in an SQL script that contains existing statements, the editor does not update the existing statement terminators automatically.
再次查询总结表，又是没有返回数据，但是当执行了REFRESHtable语句之后，查询得以成功运行。
Another query against the summary table returns no data, but after the REFRESH table statement executes this time, the query runs successfully.
但当一个语句包含太多的选择和代码时，它就可能暗示有需要重构的代码。
But when each statement includes too many choices and too much code, it could be an indication of code that needs to refactored.
当您从单独的sql语句或从包含sql语句的文件生成代码时，可以指定参数类型。
When generating code from single SQL statements or from files containing SQL statements, you can specify parameter types.
当出现提示时，接受默认的项目名称，并为SQL语句指定一个名称。
When prompted, accept the default for your project name and specify a name for your SQL statement.
当程序一切正常时，删除这些语句并且发送该程序以便在生产环境中安装。
When the program was okay, those statements were removed and the program was sent to be installed in production.
当您编写访问DB2数据的sql语句时，要确保遵循以下三个编码sQL的准则以获得最佳性能。
When you write SQL statements that access DB2 data, be sure to follow these three guidelines for coding SQL for performance.
当使用静态SQL时，执行sql语句的准备步骤是在应用程序执行之前就进行的，因此可在运行时取得更好的性能。
With static SQL, the preparation steps for executing a SQL statement occur before the application is ever executed, thus offering the opportunity for better performance at runtime.
当您打开视图时，状态栏将显示创建的整条选择语句。
When you open the view, the status bar shows the entire Select statement that you created.
当您编写sql语句的时候，需要符合SQL编码标准和指导原则。
You need to comply with SQL coding standards and guidelines when you write your SQL statements.
当您提交该语句时，您必须添加RETURN_GENERATED _ KEYS选项，这将返回自动生成的值。
When you submit the statement, you must add the RETURN_GENERATED_KEYS option, which returns the automatically generated value.
经验告诉我们，这需要2条sql语句，并且UPDATE应该在SELECT语句之前执行；否则，当并发增多时，可能会发生死锁。
Conventional wisdom states that this requires 2 SQL statements, and that the UPDATE ought to be done prior to the SELECT; otherwise deadlocks may occur as concurrency increases.
当insert语句失败并且错误代码在DECLAREEXIThandler语句中指定，那么控制将传递到处理程序，而过程将退出。
When the INSERT statement fails with the error code specified in the DECLARE exit handler statement, control passes to the handler, and the procedure is exited.
当执行预编译语句时，IDS检测底层对象的变化，必要时重新准备(重新编译)语句。
When you execute a prepared statement, IDS now detects changes to underlying objects and re-prepares (re-compiles) the statement if needed.
当SQL语句引用对象时，如果没有指定模式名，那么也会隐式地加上调用者的授权ID。
When an object is referenced by an SQL statement, it is also implicitly qualified with the authorization ID of the issuer if no schema name is specified.
因此，当同一个sql语句再次执行时，DB 2在语句缓存中找到此前创建的访问计划并重用它。
So when the same SQL statement is executed again, DB2 finds the previously created access plan in the statement cache and reuses the access plan.
应用推荐