Results 1 to 4 of 4

Thread: DB2 Cursor

  1. #1
    Join Date
    Jan 2004
    Posts
    9

    Unanswered: DB2 Cursor

    Running DB2 on AIX ver 9.5

    Is it possible to reset a cursor back to the first row without closing it and repopening it?

  2. #2
    Join Date
    Jun 2003
    Location
    Toronto, Canada
    Posts
    5,516
    Provided Answers: 1
    Yes, if it's a scrollable cursor.

  3. #3
    Join Date
    Jan 2004
    Posts
    9

    db2 cursor

    can you send me the syntax as it will be in a stored proc

  4. #4
    Join Date
    Jun 2003
    Location
    Toronto, Canada
    Posts
    5,516
    Provided Answers: 1
    You can find many examples if you search for "scrollable cursor" in the DB2 Information Center.

Posting Permissions

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