You have coded this: SELECT trng_id,trng_skill_level_id,code_value FROM ot,
code_misc
Should it not be: SELECT trng_id,trng_skill_level_id,code_value,code_misc
FROM ot
Regards, Pierre.


-----Message d'origine-----
De : SangeethaPriya R.
[mailto:db2udbdba-ezmlmshield-x45220525.[Email address protected]
Envoyé : 23 mars, 2007 05:11
À : LazyDBA Discussion
Objet : Reg. Triggers

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.




---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html




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