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

Screenshot-2012-04-18_15.50.44

Select the schema, table name

Select the time and operation

Screenshot-2012-04-18_15.50.20

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

Screenshot-2012-04-18_15.51.05

Click Ok