modification of the existing trigger to add date validation
after insert or update on user.table
for each row
declare
v_reflag char(1) :='0';
begin
if INSERTING then
insert into user2.table_copy
(T$QONO,
T$REVI,
T$COMP,
T$CUNO,
T$CCOR,
T$CDEL,
T$QSTA,
T$QDAT,
T$EXPD,
T$DDAT,
T$DTME,
T$ODIS,
T$CCUR,
T$FCRT,
T$RATS,
T$RATF,
T$COTP,
T$CREP,
T$CVYN,
T$CCRS,
T$CFRW,
T$CPLS,
T$PLDD,
T$PCPR,
T$PCTX,
T$CCTY,
T$CLAN,
T$CDEC,
T$CRTE,
T$CPAY,
T$CBRN,
T$CREG,
T$REFA,
T$REFB,