User Profile

Collapse

Profile Sidebar

Collapse
jp140768
jp140768
Last Activity: Feb 26 '10, 03:53 PM
Joined: Feb 26 '10
Location: Clane, Kildare, Ireland
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • jp140768
    replied to Db2 stored procedure fetch multiple rows
    in DB2
    Hi,

    If you are using DB2/400, this link may help (see chapter 5.5).
    http://www.redbooks.ibm.com/redbooks...tml/wwhelp.htm

    It suggests that once you have opened the cursor that you want returned, to the calling progam, you issue something similar to:
    Code:
    DECLARE c1 CURSOR FOR SELECT cusnam FROM customer ORDER BY cusnam;      
OPEN c1;      
SET RESULT SETS CURSOR
    ...
    See more | Go to post

      Leave a comment:

    • jp140768
      started a topic Using returned results from a stored procedure
      in DB2

      Using returned results from a stored procedure

      Hi,

      I am developing a Cobol/400 system, which will use information contained within a DB2/400 system, its possible that some of this information will also be used within a PC front end system. Because of this I thought I'd do all my I/O via stored procedures which can then be called from either system / platform and leave me only having to develop the I/O functionality once.

      Its all going well until I tried to set up...
      See more | Go to post
      No activity results to display
      Show More
      Working...