如果您在队列上启用触发机制，一个触发器将立即触发，然后，队列再次被重置为NOTRIGGER。
If you enable triggering on the queue, a trigger immediately fires and the queue is reset back to NOTRIGGER again.
带有表参数的过程只能从触发器的触发操作调用。
A procedure with a table parameter can only be invoked from the triggered action of a trigger.
队列深度超过TRIGDEPTH设置的阈值时，触发器触发。
The queue depth exceeds the threshold set by TRIGDEPTH; a trigger fires.
另一方面，“foreachstatement ”选项(“before ”型触发器是不允许的)则意味着触发器定义的操作只在调用一次sql语句后执行一次。
On the other hand, the "for each statement" (not allowed for "before" triggers) would mean that the actions defined by a trigger would only be performed once for the invoking SQL statement.
另外，触发器现在可以在单一子句中同时包含UPDATE、DELETE和INSERT操作，作为一个触发器事件。
In addition, triggers can now contain UPDATE, DELETE, and INSERT operations together in a single clause as the trigger event. For example.
而且，由于DB 2触发器的功能集大于MySQL所提供的功能集，所以您可以很容易重建触发器。
And because DB2 trigger functionality provides a superset of what is available in MySQL, you can easily recreate triggers.
使用从数据库日志文件或数据库触发器触发的存储并发送 (store-and-forward)技术将操作发送给复制。
The operation is sent to replicate using store-and-forward techniques triggered from a database log file or database triggers.
最后一步很关键，因为当一个队列在深度上被触发时，WebSphereMQ将在触发器触发后仅用触发机制。
The last step is crucial because when a queue is triggered on depth, WebSphere MQ disables triggering when the trigger is fired.
如果Chom pQ . pl最终没有采取任何操作，一个新触发器将立即触发，导致一个循环。
If ChompQ.pl ended without taking any action, a new trigger would immediately fire, resulting in a loop.
标记创建这样的触发器：当用户单击时，该触发器会调用在标记内定义的操作。
The tag creates a trigger that, when clicked by the user, invokes the action defined within the tag.
如果pluto队列管理器正在运行且启动队列已定义，那么您应该能看到一条消息，说明触发器监控器已启动，且正在等待触发器消息。
If the PLUTO queue manager is running and the initiation queue is defined, you should see a message stating that the trigger monitor is started and waiting for a trigger message.
如果避免触发器的执行是可接受的，您可以通过参考资料中列出的文章里所描述的技术来临时禁用触发器。
Where it is acceptable, you may wish to temporarily disable triggers using one of the techniques described in the article listed in the References section.
而在本例中，自动触发并非理想的行为，所以需要定义转换的触发器。
In this case, automatic is not the desired behavior, so you need to define the trigger for the transitions.
数据库触发器是驻留在数据库中的程序，当数据库中的表发生更新之类的事件时会运行该触发器。
A database trigger is program residing in the database that runs when an event, such as an update, occurs on a table in the database.
触发器视图允许您指定触发器的类型、触发器文本以及其他触发器属性，如下面的图13 所示。
The trigger view allows you to specify the type of trigger, the trigger text, and several other trigger properties, as shown in Figure 13 below.
你现在已经建立了触发器处理程序项目，并准备好修改您的触发器处理程序文件。
You have now finished setting up your trigger handler project and are ready to modify your trigger handler file.
表示可以有零个或多个事件触发器，这些触发器可以识别状态更改。
An indication may have zero or more event triggers, which are recognitions of changes in state.
在本文中，您将在触发器的世界里遨游，看看如何通过触发器来增强数据库中的业务规则。
In this article, you'll explore the world of triggers and see how they can be used to enforce business rules in your database.
触发器视图允许您指定触发器的类型、触发器文本以及其他触发器属性。
The trigger view allows you to specify the type of trigger, the trigger text, and several other trigger properties.
触发器支持行前触发器、行后触发器和语句触发器，触发器语句用过程语言复合语句编写。
Triggers Supports before row triggers, after row and statement triggers with trigger statements written in procedure language compound statements.
触发器的启动是在触发事件之前还是之后则称为触发器的激活时间。
Whether a trigger fires before or after the triggering event is known as the activation time of the trigger.
当一个语句执行时(1)，触发器被调用(2)。触发器注册一个回调函数(3)，以便将结果写入一个文件。
When a statement executes (1), the trigger is called (2). The trigger registers a callback function (3) to write the result to a file.
把触发器逻辑转移到存储过程中并从触发器调用存储过程。
Move the trigger logic to a stored procedure and call the stored procedure from the trigger.
如前所述，当触发器触发后，队列管理器基于队列深度禁用触发机制。
As noted earlier, the queue manager disables triggering when a trigger is fired, based on queue depth.
一个可选的更深的考虑是使用数据库触发器来跟踪变化，让拦截器访问触发器所写入的表。
One option for further consideration would tracking modifications using database triggers, and having the interceptor access the table the triggers write to.
一个名为触发器监控器的特殊程序接收来自队列管理器的触发器消息，读取进程定义，然后运行进程定义中指定的命令行。
A special program called a trigger monitor receives the trigger message from the queue manager, reads the process definition, and then runs the command line task specified there.
第三种方法是把触发器逻辑转移到应用程序层，放弃触发器。
The third option is to move trigger logic to application layer and get from the trigger.
一些队列属性决定何时出发触发器，一个进程定义包含用于响应触发器的命令行。
Queue attributes determine when the trigger is fired and a process definition contains the command line to be executed in response to the trigger.
另一种方法是把BEFORE触发器转换为after触发器，前提条件是这不会影响功能。
Another option is to convert a BEFORE trigger to an AFTER trigger, as long as it does not affect the functionality.
另一种方法是把BEFORE触发器转换为after触发器，前提条件是这不会影响功能。
Another option is to convert a BEFORE trigger to an AFTER trigger, as long as it does not affect the functionality.
应用推荐