Results 1 to 3 of 3
  1. #1
    Join Date
    Jul 2012
    Posts
    28

    Unanswered: regarding sqlstate

    begin atomic
    declare sqlstate char(5);
    ...
    ...
    end

    i am getting the following error in doing this.

    An SQLSTATE or SQLCODE variable declaration is in a nested compound statement.. SQLCODE

    pls tell how to overcome this problem

  2. #2
    Join Date
    Apr 2012
    Posts
    1,034
    Provided Answers: 18
    db2 "? SQL0056N"

    Don't use the atomic keyword here.

  3. #3
    Join Date
    Jul 2012
    Posts
    28
    thanks... it worked...

Posting Permissions

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