TRIGGER function

Return Values

TEXT

Syntax

TRIGGER (NAME | EVENT | SUBEVENT)

Parameters

NAME

For a program identified as a trigger program using the TRIGGER command, returns the object for which the trigger program is association. For a TRIGGER_AW, TRIGGER_DEFINE, TRIGGER_AFTER_UPDATE, or TRIGGER_BEFORE_UPDATE program, returns the name of the analytic workspace that caused the program to execute.

EVENT

Returns the name of the event (DML statement) that triggered the execution of the program.

AW

MAINTAIN

DELETE

DEFINE

PROPERTY

ASSIGN

BEFORE_UPDATE

AFTER_UPDATE

See also:

For more information on events, see"Trigger Programs" and TRIGGER command

SUBEVENT

When the value returned by EVENT is MAINTAIN, AFTER_UPDATE or BEFORE_UPDATE, returns more information on the OLAP DML statement that triggered the execution of the program. Valid subevents for AW are outlined in Table 8-18, "Subevents for the AW Event". Valid subevents for MAINTAIN are outlined in Table 8-19, "Subevents for the MAINTAIN Event". Valid subevents for UPDATE are outlined in Table 8-20, "Subevents for UPDATE Events".

Table 8-18 Subevents for the AW Event

Subevent	Description
CREATE	Returned when an AW CREATE statement triggered the execution of the program.
ATTACH	Returned when an AW ATTACH statement triggered the execution of the program.
DELETE	Returned when an AW DELETE statement triggered the execution of the program.
DETACH	Returned when an AW DETACH statement triggered the execution of the program.

Table 8-19 Subevents for the MAINTAIN Event

Subevent	Description
ADD	Returned when a MAINTAIN ADD statement triggered the execution of the program.
DELETE	Returned when any MAINTAIN DELETE statement except a MAINTAIN DELETE ALL statement triggered the execution of the program.
DELETE ALL	Returned when a MAINTAIN DELETE ALL statement triggered the execution of the program.
MERGE	Returned when a MAINTAIN MERGE statement triggered the execution of the program.
MOVE	Returned when a MAINTAIN MOVE statement triggered the execution of the program.
RENAME	Returned when a MAINTAIN RENAME statement triggered the execution of the program.

Table 8-20 Subevents for UPDATE Events

Subevent	Description
AW	Returned when an UPDATE command triggered the execution of a TRIGGER_AFTER_UPDATE or TRIGGER_BEFORE_UPDATE program.
MULTI	Returned when an UPDATE command triggered the execution of a program identified as a trigger program using the TRIGGER command when an object is acquired in multiwriter mode.

Examples

For examples of using the TRIGGER function, see Example 6-3, "TRIGGER_BEFORE_UPDATE Program" and Example 10-166, "Assigning an Alternative Value using an Assign Trigger".