my sql query is >>
------------------------------ Commands Entered ------------------------------
CREATE TRIGGER tU_group_cat NO CASCADE BEFORE UPDATE ON group_cat
REFERENCING OLD AS OLD NEW AS NEW FOR EACH ROW MODE DB2SQL
WHEN (((SELECT count(*) FROM group_cat WHERE group_cat.g_cat _id <> new.g_cat_id) > 0) AND
((SELECT count(*) FROM groups WHERE groups.g_cat_id = old.g_cat_id) > 0));
------------------------------------------------------------------------------
CREATE TRIGGER tU_group_cat NO CASCADE BEFORE UPDATE ON group_cat
REFERENCING OLD AS OLD NEW AS NEW FOR EACH ROW MODE DB2SQL
WHEN (((SELECT count(*) FROM group_cat WHERE group_cat.g_cat _id <> new.g_cat_id) > 0) AND
((SELECT count(*) FROM groups WHERE groups.g_cat_id = old.g_cat_id) > 0))
DB21034E The command was processed as an SQL statement because it was not a
valid Command Line Processor command. During SQL processing it returned:
SQL0104N An unexpected token "END-OF-STATEMENT" was found following
"old.g_cat_ id) > 0))". Expected tokens may include:
"<combined_trig ger_body>". LINE NUMBER=4. SQLSTATE=42601
thnx in advance
------------------------------ Commands Entered ------------------------------
CREATE TRIGGER tU_group_cat NO CASCADE BEFORE UPDATE ON group_cat
REFERENCING OLD AS OLD NEW AS NEW FOR EACH ROW MODE DB2SQL
WHEN (((SELECT count(*) FROM group_cat WHERE group_cat.g_cat _id <> new.g_cat_id) > 0) AND
((SELECT count(*) FROM groups WHERE groups.g_cat_id = old.g_cat_id) > 0));
------------------------------------------------------------------------------
CREATE TRIGGER tU_group_cat NO CASCADE BEFORE UPDATE ON group_cat
REFERENCING OLD AS OLD NEW AS NEW FOR EACH ROW MODE DB2SQL
WHEN (((SELECT count(*) FROM group_cat WHERE group_cat.g_cat _id <> new.g_cat_id) > 0) AND
((SELECT count(*) FROM groups WHERE groups.g_cat_id = old.g_cat_id) > 0))
DB21034E The command was processed as an SQL statement because it was not a
valid Command Line Processor command. During SQL processing it returned:
SQL0104N An unexpected token "END-OF-STATEMENT" was found following
"old.g_cat_ id) > 0))". Expected tokens may include:
"<combined_trig ger_body>". LINE NUMBER=4. SQLSTATE=42601
thnx in advance