完成验证后,实用程序即创建一个增量值为1的序列对象,并为相关联的表创建一个触发器。
After this verification, the utility creates a sequence object with an increment value of 1, and then creates a trigger for the associated table.
您还需要为update操作创建一个类似的触发器,以确保位列上的值是正确的。
A similar trigger for UPDATE needs to be created to ensure the correct values of bit columns.
注意:您也可以选择创建一个数据库触发器来捕捉表上的每个INSERT操作,并告诉它在执行INSERT之前使用XMLVALIDATE函数验证XML数据。
Note: Alternatively you can create a database trigger to capture every INSERT on your table and tell it to validate the data as XML using the XMLVALIDATE function before performing the INSERT.
例如,如果由于卷创建而触动触发器,此事件将得到一个卷创建的生命周期表示。
For example, when a trigger is engaged due to volume creation, this event results in a lifecycle indication that the volume has been created.
清单2提供了一个触发器创建示例,该示例来自Informixsql语法手册。
Listing 2 provides an example of a trigger creation from the Informix SQL syntax manual.
以下代码是一个DDL语句,用于创建customer表和根据该表定义的触发器。
The following code is a DDL statement to create the customer table and a trigger defined on the table.
使用一个简单的XForms触发器创建一个提交按钮,激活的时候调用两个(还可以更多)提交动作,如清单4所示。
A simple XForms trigger is used to create the submit button that upon activation will invoke the two (or more if defined and invoked) submission actions, as shown Listing 4.
您还将学习如何使用DB 2UDBVersion 8.1的控制中心来帮助您创建一个应用于简单业务场景的简单触发器。
You'll also learn how the DB2 UDB Version 8.1 Control Center can help you build a simple trigger that can be applied to a simple business scenario.
运行完上述命令后,实用程序即创建一个DB 2序列对象和一个触发器,以便自动生成序号。
After you run the above command, the utility creates a DB2 sequence object and a trigger to facilitate the automatic generation of sequence Numbers.
您已经在一个假想的业务场景中创建了一个DB2触发器。
You've created a DB2 trigger in the context of a mock business scenario.
您已经在一个假想的业务场景中创建了一个DB2触发器。
You've created a DB2 trigger in the context of a mock business scenario.
应用推荐