Results 1 to 4 of 4
  1. #1
    Join Date
    May 2003
    Posts
    27

    Question Unanswered: how to check the meaning of a sqlcode?

    there is a command

    db2 ? 12345

    to check meaning of a sqlstate number?
    however, is there any command that can check the meaning of the sqlcode?

    thanks in advance :-)

  2. #2
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650

    Re: how to check the meaning of a sqlcode?

    if you get a error message, you can check ..

    For eg SQL0911N

    db2 "? sql0911n"

    will dispalay the message text and description

    HTH

    Sathyaram
    Visit the new-look IDUG Website , register to gain access to the excellent content.

  3. #3
    Join Date
    May 2003
    Posts
    27

    is it possible to lookup the sqlcode by the sqlstate?

    Thanks

    by the way, is it possible to lookup the sqlcode by the sqlstate?
    Last edited by r390gt1; 02-01-04 at 21:21.

  4. #4
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650

    Re: is it possible to lookup the sqlcode by the sqlstate?

    I don't think it is possible ..



    Cheers
    Sathyaram
    Visit the new-look IDUG Website , register to gain access to the excellent content.

Posting Permissions

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