Results 1 to 2 of 2

Thread: Who can tell me

  1. #1
    Join Date
    Nov 2005
    Posts
    1

    Angry Unanswered: Who can tell me

    can i declare tow cursor in the same procedure ?

    an how do that?
    give me a example
    thanks!

  2. #2
    Join Date
    Nov 2004
    Posts
    374

    declare cursor

    you can define as many cursors as needed - there is a limit on open cursors, but anyhow more than 1
    just :
    declare C1 cursor for ...
    declare C2 cursor for
    open C1
    open C2...
    Best Regards, Guy Przytula
    DB2/ORA/SQL Services
    DB2 DBA & Advanced DBA Certified
    DB2 Dprop Certified
    http://users.skynet.be/przytula/dbss.html

Posting Permissions

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