The SIGNAL statement is used to explicitly raise an error and force the invocation of a handler.
signal语句用于显式地发出一个错误并强制调用处理程序。
Any valid SQLSTATE value can be used in the SIGNAL statement, including user-defined SQLSTATEs and conditions.
任何有效sqlstate值都可以用于signal语句中,包括用户定义的SQLSTATE和条件。
The SIGNAL statement rolls back the changes that were attempted by the triggering statement (that is, our update statement).
SIGNAL语句回滚由触发语句(也就是我们的update 语句)尝试的更改。
In the DB2 procedure example in Table 6, the SIGNAL statement is used to generate a user-defined SQLSTATE and a message that is returned to the caller through the SQLCA.
在表6的DB 2过程示例中,signal语句用于生成用户定义的SQLSTATE和一条消息,该消息通过SQLCA返回给调用方。
In the DB2 procedure example in Table 6, the SIGNAL statement is used to generate a user-defined SQLSTATE and a message that is returned to the caller through the SQLCA.
在表6的DB 2过程示例中,signal语句用于生成用户定义的SQLSTATE和一条消息,该消息通过SQLCA返回给调用方。
应用推荐