>>
>>set schema CAT1.SCHM;

--- SQL operation complete.
>>obey TEST_1_4_1_2(set_up);
>>
>>
>>INSERT INTO tab1A VALUES (1,2,3,4);

--- 1 row(s) inserted.
>>INSERT INTO tab1A VALUES (2,3,4,5);

--- 1 row(s) inserted.
>>
>>CREATE TRIGGER trig1 AFTER UPDATE 
+>	ON tab1A
+>	REFERENCING NEW AS newrow, OLD AS oldrow
+>	FOR EACH ROW
+>		WHEN (newrow.b > oldrow.b)
+>		INSERT INTO tab1A VALUES (oldrow.a+10 , oldrow.b, oldrow.c, oldrow.d);

--- SQL operation complete.
>>
>>obey TEST_1_4_1_2(tests);
>>------------------------------------------------------------------
>>-- 	TEST CASE
>>------------------------------------------------------------------
>>-- the following command should add another 2 rows to tab1A
>>
>>UPDATE tab1A SET b=20;

--- 2 row(s) updated.
>>
>>--------------------------------------------------------
>>-- RESULT: tab1A:
>>-- 1  20  3  4
>>-- 2  20  4  5
>>-- 11  2  3  4
>>-- 12  3  4  5
>>
>>--------------------------------------------------------
>>SELECT * FROM tab1A order by a;

A            B            C            D            
-----------  -----------  -----------  -----------  

          1           20            3            4  
          2           20            4            5  
         11            2            3            4  
         12            3            4            5  

--- 4 row(s) selected.
>>
>>
>>--------------------------------------------------------
>>obey TEST_1_4_1_2(clean_up);
>>DROP TRIGGER trig1;

--- SQL operation complete.
>>obey clearTables;
>>SET SCHEMA cat1.schm;

--- SQL operation complete.
>>DELETE FROM tab1A;

--- 4 row(s) deleted.
>>DELETE FROM tab1B;

--- 0 row(s) deleted.
>>
>>DELETE FROM cat2.schm.tab2A;

--- 0 row(s) deleted.
>>DELETE FROM cat2.schm.tab2B;

--- 0 row(s) deleted.
>>DELETE FROM cat3.schm.tab3A;

--- 0 row(s) deleted.
>>
>>SET SCHEMA cat1.schm_alt;

--- SQL operation complete.
>>DELETE FROM tab1A;

--- 0 row(s) deleted.
>>DELETE FROM tab1B;

--- 0 row(s) deleted.
>>
>>SET SCHEMA cat1.schm;

--- SQL operation complete.
>>
>>
>>-- switch schemas
>>set schema CAT1.SCHM_ALT;

--- SQL operation complete.
>>obey TEST_1_4_1_2(set_up);
>>
>>
>>INSERT INTO tab1A VALUES (1,2,3,4);

--- 1 row(s) inserted.
>>INSERT INTO tab1A VALUES (2,3,4,5);

--- 1 row(s) inserted.
>>
>>CREATE TRIGGER trig1 AFTER UPDATE 
+>	ON tab1A
+>	REFERENCING NEW AS newrow, OLD AS oldrow
+>	FOR EACH ROW
+>		WHEN (newrow.b > oldrow.b)
+>		INSERT INTO tab1A VALUES (oldrow.a+10 , oldrow.b, oldrow.c, oldrow.d);

--- SQL operation complete.
>>
>>obey TEST_1_4_1_2(tests);
>>------------------------------------------------------------------
>>-- 	TEST CASE
>>------------------------------------------------------------------
>>-- the following command should add another 2 rows to tab1A
>>
>>UPDATE tab1A SET b=20;

--- 2 row(s) updated.
>>
>>--------------------------------------------------------
>>-- RESULT: tab1A:
>>-- 1  20  3  4
>>-- 2  20  4  5
>>-- 11  2  3  4
>>-- 12  3  4  5
>>
>>--------------------------------------------------------
>>SELECT * FROM tab1A order by a;

A            B            C            D            
-----------  -----------  -----------  -----------  

          1           20            3            4  
          2           20            4            5  
         11            2            3            4  
         12            3            4            5  

--- 4 row(s) selected.
>>
>>
>>--------------------------------------------------------
>>
>>-- end logging
>>LOG;
