Wednesday, April 18, 2012

Creating Trigger in DB2 Control Center

to create trigger in DB2 Control Center,

Open Control Center

Open the Database to display the database objects

Right click on triggers and select create


Select the schema, table name

Select the time and operation


Select triggered action tab

Enter the name for old row, name for new row

Enter the When conditions, and the required script to be executed after Begin Atomic


Click Ok