hi,
i am working on a migration project from Oracle to db2 8.1. i was able to
migrate the stored procedures and functions in oracle to db2 with the help
of the migration tool kit.
now finally when i came to the trigger i am having problems. the trigger is
not getting compiled. Triggers call the stored procedures and functions in
them.
For example.
--the values passed in the parameter are all varchar only
CREATE TRIGGER t_content NO CASCADE BEFORE DELETE ON TCAT_CONTENT_COLLATERAL
REFERENCING OLD AS OLD FOR EACH ROW MODE DB2SQL
BEGIN ATOMIC
CALL sp_delete ('Category', old.category_id, old.collateral_id );
CALL sp_update ('DCS_CATEGORY', 'category_id', old.category_id);
END;
The error received was.
DB21034E The command was processed as an SQL statement because it was not
avalid Command Line Processor command. During SQL processing it returned:
SQL0104N An unexpected token "CALL sp_delete" was found
following "DB2SQL BEGIN ATOMIC". Expected tokens may
include:"<compound_return>". LINE NUMBER=1. SQLSTATE=42601
Thanx in advance
mail to pj*@srasys.co.in
regards
Premnath
--
Message posted via http://www.dbmonster.com