Hi Friends,

CREATE TRIGGER trng1_update
AFTER UPDATE OF trng_skill_level_id ON training
REFERENCING OLD AS o NEW AS n OLD TABLE AS ot FOR EACH ROW MODE DB2SQL
WHEN( EXISTS
( SELECT trng_id,trng_skill_level_id,code_value FROM ot, code_misc WHERE
trng_id = n.trng_id and code_id=n.trng_skill_level_id ) )
BEGIN ATOMIC UPDATE replacements
SET rpm_with_trng_skl_lvl_id = n.trng_skill_level_id,
rpm_with_trng_skl_lvl=code_value WHERE rpm_with_trng_id = n.trng_id;
END

When I Execute the above trigger its shows the following error.

DB21034E The command was processed as an SQL statement because it was
not a
valid Command Line Processor command. During SQL processing it
returned:
SQL0206N "CODE_VALUE" is not valid in the context where it is used.
LINE NUMBER=1. SQLSTATE=42703

Please help me to solve this issue.

Thanks and Best Regards,
Sangeetha Priya R.



DB2 & UDB email list listserv db2-l LazyDBA home page