CREATE TRIGGER SC.UpdCustOutDate
AFTER UPDATE OF CUSTOUTDATE ON SC.TABLE1
REFERENCING NEW AS N OLD AS O
FOR EACH ROW MODE DB2SQL
WHEN(O.CUSTOUTDATE IS NULL AND N.CUSTOUTDATE IS NOT NULL)
BEGIN ATOMIC
  DECLARE OUTCODE INTEGER;
  CALL SC.ADDCAR(O.ID,OUTCODE);
END@

CREATE PROCEDURE SC.ADDCAR(
  IN CarOrderID INT,
  OUT ErrorCode INTEGER )
      DYNAMIC RESULT SETS  0 
      LANGUAGE C
      PARAMETER STYLE SQL
      NO DBINFO
      FENCED
      MODIFIES SQL DATA
      PROGRAM TYPE SUB
      EXTERNAL NAME 'addcar!addcar';

SQL0056N  Объявление переменной SQLSTATE или SQLCODE находится во вложенном 
составном операторе.  LINE NUMBER= 7 .  SQLSTATE= 42630 

CREATE TRIGGER SC.UpdCustOutDate
AFTER UPDATE OF CUSTOUTDATE ON SC.TABLE1
REFERENCING NEW AS N OLD AS O
FOR EACH ROW MODE DB2SQL
WHEN(O.CUSTOUTDATE IS NULL AND N.CUSTOUTDATE IS NOT NULL)
BEGIN
  DECLARE OUTCODE INTEGER;
  CALL SC.ADDCAR(O.ID,OUTCODE);
  GET DIAGNOSTICS OUTCODE=RETURN_STATUS;
  VALUES(CASE WHEN OUTCODE !=  0  THEN RAISE_ERROR('70001', 'PROC CALL failed'));
END@