Results 1 to 2 of 2
  1. #1
    Join Date
    Dec 2007
    Posts
    49

    Unanswered: Difference between DYNAMIC RESULT SET and RESULT SET

    Can some one explain me if we really have a difference between mentioning DYNAMIC RESULT SET and RESULT SET in DB2 Stored Procedures.

    And also will it error out if I have specfied DYNAMIC RESULT SET 3 and Declared 4 CURSORS in the Procedure with "WITH RETURN TO CLIENT FOR" Clause.

  2. #2
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650
    Quote Originally Posted by Neharao View Post
    Can some one explain me if we really have a difference between mentioning DYNAMIC RESULT SET and RESULT SET in DB2 Stored Procedures.
    Technically none
    DYNAMIC RESULT SETS is the correct db2 syntax
    An equivalent is "RESULT SETS" that has been provided for compatibility with previous versions of DB2 and with other database products

    Quote Originally Posted by Neharao View Post
    And also will it error out if I have specfied DYNAMIC RESULT SET 3 and Declared 4 CURSORS in the Procedure with "WITH RETURN TO CLIENT FOR" Clause.
    Please try an example yourself and let us know ;-)

    HTH
    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
  •