CREATE TABLE "SERVEIT"."CORPESCALATIONDETAILS"  (
    "CORPTICKETESCALATION_ID"   INTEGER NOT NULL,
    "ESCALATIONLEVEL"           VARCHAR(20),
    "TIMEOFESCALATION"          TIMESTAMP,
    "TICKET_ID"                 INTEGER,
    "NAME"                      VARCHAR(30),
    "EMAILID"                   VARCHAR(100),
    "SEQUENCE"                  SMALLINT,
    "CC_EMAIL_LIST"             VARCHAR(1000),
    "CC_NAME_LIST"              VARCHAR(1000),
    CONSTRAINT "CORPESCALPK" PRIMARY KEY("CORPTICKETESCALATION_ID")
)

CREATE SEQUENCE serveit.CORP_SEQ
START WITH 1
INCREMENT BY 1
CACHE 10;

CREATE OR REPLACE TRIGGER SERVEIT.CORP_TRIG
  BEFORE INSERT ON SERVEIT.CORPESCALATIONDETAILS
  FOR EACH ROW
BEGIN
  if(:new.CORPTICKETESCALATION_ID is null) then
  SELECT serveit.CORP_SEQ.nextval
  INTO :new.CORPTICKETESCALATION_ID
  FROM dual;

DB2 SQL Error: SQLCODE=-104, SQLSTATE=42601, SQLERRMC=:new;EACH ROW
BEGIN
  if(;<cast_spec>, DRIVER=4.21.29