>>obey TEST_1_1_1_13(tests);
>>
>>set schema CAT1.SCHM;

--- SQL operation complete.
>>
>>create schema test_schema ;

--- SQL operation complete.
>>
>>--Caroline: correct scripting errors 
>>set schema cat1.test_schema ;

--- SQL operation complete.
>>
>>create table t1 (x int, y int);

--- SQL operation complete.
>>create table t2 like t1 ;

--- SQL operation complete.
>>
>>create trigger trg1 after insert on t1
+>    referencing new as mynew
+>      insert into t2 select * from mynew ;

--- SQL operation complete.
>>
>>create trigger trg2 before update of (j) on cat1.schm.t11113
+>    referencing new as myrow
+>      set myrow.i = (select MAX(x) from t2);

--- SQL operation complete.
>>
>>showddl cat1.test_schema.t1;

CREATE TABLE CAT1.TEST_SCHEMA.T1
  (
    X                                INT DEFAULT NULL
  , Y                                INT DEFAULT NULL
  )
  LOCATION \NSK.$DATA4.ZSDFFLD7.W7LD7Q00
  NAME NSK_DATA4_ZSDFFLD7_W7LD7Q00
  ;
CREATE TRIGGER CAT1.TEST_SCHEMA.TRG1 AFTER INSERT ON CAT1.TEST_SCHEMA.T1
  REFERENCING NEW AS MYNEW INSERT INTO CAT1.TEST_SCHEMA.T2 SELECT MYNEW.X,
  MYNEW.Y FROM MYNEW;

--- SQL operation complete.
>>
>>showddl schm.t11113;

CREATE TABLE CAT1.SCHM.T11113
  (
    I                                INT DEFAULT NULL
  , J                                INT DEFAULT NULL
  )
  LOCATION \NSK.$DATA2.ZSDVJ3ZS.L1KD7Q00
  NAME NSK_DATA2_ZSDVJ3ZS_L1KD7Q00
  ;
CREATE TRIGGER CAT1.TEST_SCHEMA.TRG2 BEFORE UPDATE OF (J) ON CAT1.SCHM.T11113
  REFERENCING NEW AS MYROW SET MYROW.I = (SELECT MAX(CAT1.TEST_SCHEMA.T2.X)
  FROM CAT1.TEST_SCHEMA.T2);

--- SQL operation complete.
>>
>>log;
