You can use a SIGNAL statement to raise an error condition if the business rule defined in your trigger is violated.
如果违反了您在触发器中定义的业务规则,就可以使用signal语句来抛出一个错误条件信号。
In the case of the DB2 example in the left column of Table 3, if a particular SQL statement fails and generates an error, control is passed to the condition handler.
对于表3左侧列的DB 2示例,如果某条sql语句失败并生成一个错误,那么控制将被传递给条件处理程序。
This code relies on the assertion statement to handle the error condition.
这段代码依赖断言语句来处理错误条件。
This code relies on the assertion statement to handle the error condition.
这段代码依赖断言语句来处理错误条件。
应用推荐