通过检查日志语句的执行时间来查明存储过程的性能问题。
To pinpoint performance problems in the stored procedures by examining execution times of the logging statements.
当这个语句被包含到一个存储过程中后，将对已执行语句的所有返回值进行错误检查。
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.
SQLPL过程包含的sql语句具有一些执行属性，例如隔离级别或优化级别，这些属性只能通过DB2_SQLROUTINE _ PREOPTS注册表变量来覆盖。
SQL PL procedures contain SQL statements that have execution attributes, such as the isolation level or the optimization level that can only be overridden by DB2_SQLROUTINE_PREOPTS registry variable.
在执行该语句时处理将立即停止，而过程返回给调用者的代码是SQLERROR的值。
Processing stops immediately when this statement is executed, and the procedure return code to the caller is the value of SQLERROR.
如果语句执行返回一个错误，过程将自动中断或回滚事务。
If statement execution returns an error, the procedure is automatically aborted or the transaction is rolled back.
该语句在过程虚拟机(PVM)中执行。
The statement was executed within the procedure virtual machine (PVM).
空指示符值在SQLFETCH语句执行过程中填充。
The null indicator values are populated during the execution of the SQL FETCH statement.
在某些条件下，会在merge语句执行过程中创建内部临时表，如清单7所示。
Under certain conditions, internal temporary tables are created during the execution of the merge statement, as shown in Listing 7.
OPENcursor语句作为FETCH过程的一部分执行。
The OPEN CURSOR statement is executed as part of the FETCH process.
如果存储过程不包含任何OUT参数，那么还可以在执行动态sql语句的工具(例如ij工具)中使用CALL来调用它。
If the stored procedure does not include any OUT parameters, it can also be invoked using CALL in a tool that executes dynamic SQL statements, such as the ij tool.
比如可以在CLPPlus 中无缝地执行创建和删除包、过程、函数、触发器等的语句。
Statements like create and drop package, procedure, function, trigger, etc. can be executed seamlessly in CLPPlus.
ADMIN_CMD过程使用SQLcall语句执行db2命令行处理器(CLP)管理命令。
ADMIN_CMD Procedure Executes DB2 command line processor (CLP) administrative commands using the SQL CALL statement.
JDBCCallable Statement用于执行存储的过程，将sql语句写入Derby的消息日志文件。
JDBC Callable statement to execute a stored procedure for writing SQL statements to Derby's message log file.
DB 2 Command-该命令对象支持使用数据连接对象执行任何受支持的sql语句或存储过程。
DB2Command - The command object allows for executing any supported SQL statement or stored procedure using a data connection object.
DB2DataReader-您一般使用DB2DataReader对断开连接的结果集进行单向(forward - only)的快速访问，这些断开连接的结果集是执行sql语句或存储过程调用所返回的。
DB2DataReader - You typically use the DB2DataReader for fast forward-only access to disconnected result sets that are returned from executing SQL statements or stored procedure calls.
RPGselect语句控制基于RPG操作将执行哪些子过程。
The RPG Select statement controls which sub-procedure will be executed based on the RPG operation.
需要执行多个sql语句的大型或复杂的处理可以转移到服务器端存储过程中，从而向企业应用程序提供集中的接口。
Large or complex processing that might require the execution of several SQL statements can be moved into server-side stored procedures to provide a centralized interface to enterprise applications.
存储过程是一组sql语句，这组sql语句形成一个逻辑单元，用于执行特定的任务。
A stored procedure is a group of SQL statements that form a logical unit and perform a particular task.
该编译过程牵涉到授权检查、优化，以及将语句转化为可执行格式时所需的其他一些活动。
This compilation process involves authorization checking, optimization, and other activities necessary to convert the statement into an executable form.
语句输出面板显示了在选中语句执行过程中遇到的错误和异常。
The statement outcome panel displays any failures or exceptions encountered during an execution of the selected statement.
在多个查询语句的执行过程中需要保持数据库连接，否则会抛出一个延迟加载异常，这将导致数据出现问题。
Database connection needs to be maintained for the duration of the multiple query cycle else a lazy loading exception is thrown, resulting in inadequate use of resources.
过程不会自动执行commit语句。
该缓存不仅记住最近执行的过程，还记住了以前执行的语句。
This cache remembers not only recently executed procedures. The cache also remembers previously executed statements, so that after the first compilation of the SQL statement.
清单8.1中的过程回滚到其newcustomer保存点，但是仍然保留在过程执行后添加的新客户，但是在清单8.2中也使用了rollback语句执行了回滚。
The procedure rolls back to its newcustomer savepoint ending up retaining the new customer that was added after the procedure execution, but this is also rolled back with the ROLLBACK statement.
这一技术可能会被用来执行DROPtable语句，或执行创建新用户帐户并将该用户添加到sysadmin角色的系统存储过程。
This same technique might be used to execute a DROP TABLE statement or to execute a system stored procedure that created a new user account and added that user to the sysadmin role.
在装载操作完成之后，目标模式表处于setintegritypending状态，ADMIN_COPY_SCHEMA过程会执行一个setintegrity语句使表脱离这种状态。
After the load operation completes, target schema tables are in set integrity pending state, and the ADMIN_COPY_SCHEMA procedure issues a set integrity statement to get the tables out of this state.
空指示符值在执行SQLupdate语句之前通过RPG handle_update子过程设置。
The null indicator values are set by the RPG HANDLE_UPDATE sub-procedure prior to executing the SQL UPDATE statement.
由于存储过程是在创建时便在服务器上编译了，因此它比单个sql语句执行得更快。
Because a stored procedure is compiled on the server when it is created, it executes faster than individual SQL statements.
在这样一个程序的执行过程中，一条输入语句可以按照逻辑从程序中的其他语句推断出来。许多人工智能程序使用这种语言编写。
In the execution of such a program, an input statement can be logically deduced from other statements in the program. Many artificial intelligence programs are written in such languages.
应用推荐