Results 1 to 4 of 4
  1. #1
    Join Date
    Jul 2004
    Posts
    40

    Unanswered: cursor%ROWCOUNT equvialent in DB2

    Hi,

    Is there Oracle cursor%ROWCOUNT equivalent in DB2? If it is not so, how can this be implemented?.

    Thanks,
    Kartik.

  2. #2
    Join Date
    Nov 2004
    Posts
    374

    rowcount

    there is none
    we are missing this...
    the only solution for this : select count(*) from xx where ....
    this would return the answerset size
    Best Regards, Guy Przytula
    Best Regards, Guy Przytula
    DB2/ORA/SQL Services
    DB2 DBA & Advanced DBA Certified
    DB2 Dprop Certified
    http://users.skynet.be/przytula/dbss.html

  3. #3
    Join Date
    Jul 2004
    Posts
    40
    Hi Guy,

    Thanks for reminding me!!!

  4. #4
    Join Date
    Nov 2004
    Posts
    23
    Hi BKamesh!

    I am sorry for mine poor English.

    I while the beginner in DB2 (9 years of experience in Oracle) also.
    Though in DB2 there are no attributes for a cursor as in Oracle, but i think sometimes you may to use the GET DIAGNOSTICS statement to to obtain
    information about the previously executed SQL statement.


    Best regards, Dmitriy.
    Last edited by kdima71; 11-30-04 at 08:54.

Posting Permissions

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