您可以为CGTT创建触发器。
创建触发器处理程序文件包。
在示例表上创建触发器。
创建触发器(在when子句中添加对全局变量的检查)。
Create the trigger (add checking for the global variable in the WHEN clause).
若要基于KPI相对于其目标或范围的值发送出站事件,请在kpi上下文中创建触发器和出站事件。
To send outbound events based on the value of the KPI relative to its target or ranges, create triggers and outbound events in the KPI context.
提供了SQL编辑器来编辑触发器文本,并且为了便于使用,还预填充了骨架 SQL 来创建触发器。
The SQL editor is provided to edit the trigger text and, for ease of use, it is pre-filled with a skeleton SQL to create a trigger.
其中的每个元素都能够稍后用于创建触发器和加载元素,它们使用每个链接元素中的hre f属性来决定在哪里发送浏览器。
Each of those elements can then be used to create a trigger and a load element that USES the data in the href attribute of each link element to determine where to send the browser.
在之前的版本中,必须为每个触发器事件创建单独的触发器。
In previous versions, you had to create separate triggers for each trigger event.
该例中创建了两个输入控件和一个触发器。
下面的说明逐步地为该客户订单示例完成新的DB 2数据库以及必要的表和触发器的创建。
The following instructions walk through the creation of a new DB2 database along with the necessary tables and triggers for the Customer Order Example.
下一个我们将要创建的组件就是触发器处理程序。
您可以在sql函数、触发器、索引和视图中引用已创建的临时表。
You can reference a created temporary table in SQL functions, triggers, indexes, and views.
您还需要为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.
令牌可由时间触发器创建,这是缺省设置。
Tokens can be created by a time trigger, which is the default.
这会导致前面创建的触发器运行,并将事件放入事件数据库。
This causes the trigger you created earlier to run, and places an event in the event database.
如果访问级别是MODIFIESSQLDATA,那么它在触发器、动态合成语句、sql体函数中或在创建保存点时会阻塞,并返回原因码为22的错误SQL 30090。
IF it has MODIFIES SQL DATA, it is blocked in triggers, dynamic compound statements, SQL-bodied functions, or when a save point has been created, and error SQL30090 with reason code 22 is returned.
例如,如果由于卷创建而触动触发器,此事件将得到一个卷创建的生命周期表示。
For example, when a trigger is engaged due to volume creation, this event results in a lifecycle indication that the volume has been created.
如果希望创建其他类型的触发器,可单击信封图标旁边的下箭头,显示其他选项。
If we'd wanted to create a different kind of trigger, we'd have clicked on the down arrow next to the envelope to reveal additional choices.
每种设计器允许创建索引、约束、键和触发器(如适用)。
Each designer allows creating indexes, constraints, keys, and triggers (where applicable).
创建运行触发器的存储过程。
创建运行触发器的存储过程。
创建db2表和触发器。
在示例代码中,我们在customer表上创建了三个触发器,分别用于Insert、Update和Delete操作。
In the sample code, we have created three Triggers on the customer table for Insert, Update, and Delete.
如果您在过渡变量上使用XMLVALIDATE之外的其他任意xml函数,触发器的创建将失败。
If you use any other XML functions on transition variables other than XMLVALIDATE, the trigger creation will fail. For example.
如果Hibernate不是独占数据库用户,乐观锁会失效,除非创建数据库触发器为其他应用程序对相同数据的变更增加版本字段值。
Optimistic locking will not work if Hibernate is not the sole database user, unless you create database triggers to increment the version column for the same data change by other applications.
比如可以在CLPPlus 中无缝地执行创建和删除包、过程、函数、触发器等的语句。
Statements like create and drop package, procedure, function, trigger, etc. can be executed seamlessly in CLPPlus.
清单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.
应用推荐