Error 901 when using INSTEAD OF TRIGGER

DBFinder · #1 (**permalink**) 01-31-10, 07:51

Hi Friends,

While trouble shooting an issue (another post Any help on this error. . . ), I came across some strange db2 behavior.

When I created a view on a view on a table and the middle one had an instead of trigger to insert data in base table. The inserts are failing with error. However if I drop the trigger OR if I create same trgger on front-end view then the inserts work fine.
To me this seems like a bug.Still want have an advice from someone having such experience.

More to be surpised . . . the update instead of trigger works fine on same view.

The Error

Quote:

D:\SGILL\JunLi>db2 insert into client (GIVEN_NAME) values ('00000')

DB21034E The command was processed as an SQL statement because it was not a

valid Command Line Processor command. During SQL processing it returned:

SQL0901N The SQL statement failed because of a non-severe system error.

Subsequent SQL statements can be processed. (Reason "parent in 1-1 rel.

already has child".) SQLSTATE=58004

DB2 V9.5.5 on Win2K3

Please see the attached script and let me know if it works on your setup.

Regards

DBFinder

PS: Attached file have been submitted to IBM software support