C-LANG Statements › TRIG_TYPE Statement—Specify the Type of Database Change to Monitor For

TRIG_TYPE Statement—Specify the Type of Database Change to Monitor For

The TRIG_TYPE statement specifies the type of database change to monitor for.

Supported Job Type

This statement is required for the Database Trigger job type.

Syntax

This statement has the following formats:

TRIG_TYPE INSERT
TRIG_TYPE DELETE
TRIG_TYPE UPDATE

INSERT

Monitors for the insertion of a row in the database table.

DELETE

Monitors for the deletion of a row in the database table.

UPDATE

Monitors for an update to any of the rows in the database table.

Notes:

• Enclose values that contain delimiters (such as spaces) in double quotation marks.
• You can specify multiple trigger types for Oracle and Microsoft SQL Server:
  • For Oracle, separate the trigger types using "OR", for example, TRIG_TYPE 'INSERT OR UPDATE'.
  • For Microsoft SQL Server, separate the trigger types using a comma, for example, TRIG_TYPE 'INSERT, UPDATE'.
• For IBM DB2, you can specify multiple column names with the UPDATE operand to monitor for updates to those columns. For example, 'UPDATE of DEPT, JOB' monitors for updates to the DEPT and JOB columns.
• Each Database Trigger job creates a trigger on the database. We recommend that you speak to your database administrator before creating a Database Trigger job.
• TRIGTYPE is an alias of TRIG_TYPE.

Example: Specify Trigger Type for MS SQL Server

In the following example, a Database Trigger job monitors the stores table for an added row or a deleted row. When a row is either added or deleted, the job completes.

AGENT CYBDB
TABLE_NAME stores
TRIG_TYPE 'INSERT, DELETE'

Example: Specify Trigger Type for IBM DB2

In the following example, a Database Trigger job monitors the STAFF table for changes to the DEPT and JOB columns. The job completes once DEPT or JOB is updated.

AGENT DB_AGENT
USER entadm
DB_URL jdbc:db2://10.1.4.131:50000/SAMPLE
TABLE_NAME STAFF
TRIG_TYPE 'UPDATE of DEPT, JOB'

Example: Specify Trigger Type for Oracle

In the following example, the table Inventory_List is monitored continuously for the insertion of a row in the table. When a row is inserted, the scheduling manager triggers the predefined alert INC.

AGENT CYBDB1
TABLE_NAME Inventory_List CONTINUOUS(INC)
TRIG_TYPE INSERT