I dont know what else to do....everything seems to work.
The trigger created ok and the procedure was ok as well. if i query the DB the systribody table shows the trigger....but when I add records to program....nothing happens
here is the trigger
CREATE TRIGGER licno_trig
INSERT ON aplic
REFERENCING NEW AS new_licno
FOR EACH ROW WHEN(new_licno.apdefnkey = 1043 )
(EXECUTE PROCEDURE licno(new_licno.apkey ));
CREATE PROCEDURE licno (pakey INTEGER)
DEFINE nexno VARCHAR(10);
LET nexno = (SELECT nextval from huff_seq1);
UPDATE cobcoo
SET trcertno = nexno
WHERE apkey = pakey;
UPDATE huff_seq1 SET nextval = nextval + 1;
END PROCEDURE;
NOTHING HAPPENS WHEN THIS IS RUN
The trigger created ok and the procedure was ok as well. if i query the DB the systribody table shows the trigger....but when I add records to program....nothing happens
here is the trigger
CREATE TRIGGER licno_trig
INSERT ON aplic
REFERENCING NEW AS new_licno
FOR EACH ROW WHEN(new_licno.apdefnkey = 1043 )
(EXECUTE PROCEDURE licno(new_licno.apkey ));
CREATE PROCEDURE licno (pakey INTEGER)
DEFINE nexno VARCHAR(10);
LET nexno = (SELECT nextval from huff_seq1);
UPDATE cobcoo
SET trcertno = nexno
WHERE apkey = pakey;
UPDATE huff_seq1 SET nextval = nextval + 1;
END PROCEDURE;
NOTHING HAPPENS WHEN THIS IS RUN