需要执行多个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过程中有一个语句发出SQLWARNING或NOTFOUND条件，并且为相应的条件声明了一个处理程序，那么DB 2将把控制转移到相应的处理程序。
If a statement in your SQL procedure raises an SQLWARNING or NOT FOUND condition and if you have declared a handler for the respective condition, DB2 passes control to the corresponding handler.
转移条件就是一条是或者否的语句，处理器借以判定任何一个特定活动的当前状态。
A transition condition is a true or false statement that the processor may use to determine the current state of any particular activity.
当完成故障转移时，就可以使用该实例，应用程序中的连接语句就会成功。
When the failover is complete, the instance is available, and the connect statement in the application is successful.
定义者拥有对象的所有权，直到对象的所有权因使用transferownershipsql语句而被转移给另一个用户权限ID。
The definer has the ownership of the object until the object's ownership is transferred to another user authorization ID using the transfer ownership SQL statement.
GO TO标签语句可以无条件地退出循环，并将控制权转移到跟在指定的语句标签之后的可执行语句或语句块。
The GOTO label statement can unconditionally exit from a loop and transfer control to the executable statement or statement block that follows the specified statement label.
在这个示例中，该方法是一个if语句序列，这些语句将控制权转移到我们的实用程序类中的不同位置。
In this example the method is a series of if statements that divert control to different locations within our utility class.
有4种语句可以在DB 2SQL过程中转移控制。
There are four statements that can transfer control within a DB2 SQL procedure. These statements are.
为了描述控制转移，引入一个变量REASON，它记录每个语句执行结束后，该语句的执行状态。
To the control transfer, a variable REASON is introduced, which is recorded every state of statement execution.
为了描述控制转移，引入一个变量REASON，它记录每个语句执行结束后，该语句的执行状态。
To the control transfer, a variable REASON is introduced, which is recorded every state of statement execution.
应用推荐