Results 1 to 3 of 3

Thread: Qmf

  1. #1
    Join Date
    Nov 2007
    Posts
    6

    Unanswered: Qmf

    Hi friends,

    Can we able to see SQLCA components after executing a query in QMF...?
    I am using DB2 Version 8.1 on Z/OS...

  2. #2
    Join Date
    Dec 2007
    Location
    Richmond, VA
    Posts
    1,328
    Provided Answers: 5
    You should be able to use the SHOW GLOBALS command and the SQLCA is at the end of the list of globals. If, I remember correctly a +100 will show up with a SQLRC of 0, something QMF does, not sure the reason behind that.
    Dave Nance

  3. #3
    Join Date
    Nov 2007
    Posts
    6
    Hi Dave,

    I tried using SHOW GLOBALS.....It is listing SQLCODE and SQLSTATE values...But it is not showing up other components suchas SQLERRD, SQLERRP, SQLERRM...

    Thanks for your reply....
    Saidulu

Posting Permissions

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