需要执行多个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或NOT FOUND条件,并且为相应的条件声明了一个处理程序,那么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.
应用推荐