Results 1 to 3 of 3
  1. #1
    Join Date
    Sep 2008
    Location
    Toronto,Canada
    Posts
    655

    Unanswered: Error 901 when using INSTEAD OF TRIGGER

    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

    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
    Attached Files Attached Files
    Last edited by DBFinder; 01-31-10 at 20:44. Reason: Simplified test example

  2. #2
    Join Date
    Jan 2007
    Location
    Jena, Germany
    Posts
    2,721
    SQL0901 is typically a bug in DB2. Please call IBM support and open a PMR. That's the only option you have on this.
    Knut Stolze
    IBM DB2 Analytics Accelerator
    IBM Germany Research & Development

  3. #3
    Join Date
    Sep 2008
    Location
    Toronto,Canada
    Posts
    655
    IBM has notfied me that they were able to replicate the error. They agreed that this is a db2 bug. They are still trying to locate the code.

    Regards

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •