Hello,
I'm having a big problem on one very important table in the system I'm
developing. Everything started when I tried to insert some columns to
this table, and AS400 DB2 told me that there was a corrupt trigger. So
I recreated the triggers for that table and nothing happened. I've
retaken this issue now and did a Generate SQL thru the iSeries Nav and
got a nameless trigger. WHAT the hell I said! ... I was supposed to
recreate that table with all the data and triggers, but I prefer to
just try to delete this trigger. Now since I don't have a name for the
trigger:
(this is how I got it from the iSeries)
CREATE TRIGGER
AFTER INSERT ON MY_TABLE
REFERENCING NEW AS INSERTED
I can't do a drop trigger directly right? Now I do know that there are
some files where one can find this relationships between the table and
the triggers. If I could somehow manually edit those files, maybe I
can get this error fixed right?
Now, the reasons why it got nameless, we have no clue on that also.
Has anyone seen something like this?
I'm not that experienced in as400 Db2 so answers for newbies please!
=)
Thanks a lot in advance
KATLIM