为便于说明，请参阅表1第三列中的存储过程语句。
For illustration purposes, refer to the third column of Table 1 for the stored procedure statements.
前者含语言预处理、SQL语句和过程语句分析，及中间代码生成等。
The former contains language pre-compiling, SQL statements and process statements analyzing and creating the intermediate code.
先看一下CREATEPROCEDURE语句，确定每个存储过程所需要的参数。
First look at the CREATE procedure statement to confirm what parameters each of the stored procedures expects.
您可以在存储过程中使用所有保存点语句。
You can use all of the savepoint statements within stored procedures.
存储过程为将语句绑定到块中提供了一种自然的方式。
A stored procedure provides a natural means to bundle statements into a block.
当这个语句被包含到一个存储过程中后，将对已执行语句的所有返回值进行错误检查。
When this statement is included in a stored procedure, all return values of executed statements are checked for errors.
往返次数是在语句执行过程中发送给数据服务器的请求数。
Number of round trips is the number of requests issued to the data server during the execution of the statement.
清单2展示了一个包含IF语句的示例过程。
Listing 2 shows an example procedure that contains an IF statement.
还可以通过GRANT和revoke语句控制对存储过程的访问。
You can also control access to stored procedures through GRANT and REVOKE statements.
存储过程可以封装多个SQL语句，有助于避免网络往返。
Stored procedures can help to avoid network round trips by encapsulating multiple SQL statements.
RDA具有向导、编辑器以及DB2的调试程序，可以帮助开发sql语句、存储过程和用户自定义函数。
RDA has wizards, an editor, and a debugger for DB2 that helps in the development of SQL statements, stored procedures and user-defined functions.
语句输出面板显示了在选中语句执行过程中遇到的错误和异常。
The statement outcome panel displays any failures or exceptions encountered during an execution of the selected statement.
空指示符值在SQLFETCH语句执行过程中填充。
The null indicator values are populated during the execution of the SQL FETCH statement.
如果用户希望删除刚才创建的联邦过程，可以使用drop语句。
If users want to drop the federated procedures you just created, they can use the drop statement.
用户可以使用CREATETYPEMAPPING语句覆盖过程参数的默认类型映射。
The user can use the CREATE TYPE MAPPING statement to override the default type mapping for procedure parameters.
可以使用drop语句删除联邦过程。
Federated procedures can be dropped using the drop statement.
该语句在过程虚拟机(PVM)中执行。
The statement was executed within the procedure virtual machine (PVM).
为了使策略更改生效，必须在调用这些过程后发出commit语句。
In order for the policy changes to take effect, you must issue a COMMIT statement after invoking these procedures.
使用call语句调用联邦过程。
现在，CREATEprocedure语句成功了，存储过程成功运行。
Now the CREATE procedure statement succeeds, and the stored procedure runs successfully.
接受默认的语句类型(SELECT)和开发过程(利用向导指导语句创建过程)。
Accept the defaults for the statement type (SELECT) and development process (guided through statement creation with wizards).
这个过程只用ddl语句填充ddllog表。
The procedure will only populate the DDLLOG table with the DDL statements.
OPENcursor语句作为FETCH过程的一部分执行。
The OPEN CURSOR statement is executed as part of the FETCH process.
预处理语句和存储过程。
这三种类型是基于记录格式、语句和过程的Handler程序。
The three types are format, statement or procedure-based handlers.
JDBCCallable Statement用于执行存储的过程，将sql语句写入Derby的消息日志文件。
JDBC Callable statement to execute a stored procedure for writing SQL statements to Derby's message log file.
可以使用CREATEPROCEDURE (Sourced)语句创建联邦过程。
You can create federated procedures using the create procedure (Sourced) statement.
DB 2SQL过程中的条件语句。
DB 2SQL过程中的循环语句。
本节介绍DB2和solidDBSQL过程在循环语句方面的差异。
This section describes the differences in the looping statements of the DB2 and solidDB SQL procedures.
应用推荐