Results 1 to 4 of 4

Thread: Sqlstate 57053

  1. #1
    Join Date
    Apr 2008
    Location
    Iasi, Romania
    Posts
    561
    Provided Answers: 2

    Unanswered: Sqlstate 57053

    I am facing a strange issue:
    I have an app with triggers, functions and SP that works fine on 9.7 LUW.
    I've migrated the database to 10.5 FP4, but I keep receiving SQLCODE -746 and SQLSTATE 57053 on all the triggers that are calling SP that reads data from the table being changed. The code is the same.
    I've put DB2_RESOLVE_CALL_CONFLICT on YES, then ALL, but did not solve the issue.

    Does anyone have any idea what changed from 9.7 to 10.5 in this area? I'm surprised that the same code works fine on 9.7, but not on 10.5.

    Env: DB2 LUW 9.7 FP 7/ 10.5 FP 4 on Windows 2008
    Florin Aparaschivei
    DB2 9.7, 10.5 on Windows
    Iasi, Romania

  2. #2
    Join Date
    Jul 2013
    Location
    Moscow, Russia
    Posts
    666
    Provided Answers: 55
    Hi,

    Have you restarted the instance after setting this variable and rebound all underlined packages?
    If you created these objects before setting this variable of course...
    Regards,
    Mark.

  3. #3
    Join Date
    Apr 2008
    Location
    Iasi, Romania
    Posts
    561
    Provided Answers: 2
    Quote Originally Posted by mark.b View Post
    Hi,

    Have you restarted the instance after setting this variable and rebound all underlined packages?
    If you created these objects before setting this variable of course...
    Yes, I did that.
    Florin Aparaschivei
    DB2 9.7, 10.5 on Windows
    Iasi, Romania

  4. #4
    Join Date
    Apr 2008
    Location
    Iasi, Romania
    Posts
    561
    Provided Answers: 2
    I know why it works in 9.7 - we've also changed the app and now the ORM does something like:

    SELECT table_ID FROm FINAL TABLE
    (
    INSERT ... -- the INSERT that raises the triggers that calls the SP
    )

    However, I cannot find anywhere in the doc that using FINAL TABLE might raise SQLSTATE 57053
    Florin Aparaschivei
    DB2 9.7, 10.5 on Windows
    Iasi, Romania

Posting Permissions

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