Midrange News for the IBM i Community

Posted by: Chris Proctor
Programmer Analyst
Columbia Sports Company
Portland, OR
RPG Stored Procedure bypass returning result set?
has no ratings.
Published: 04 Jan 2013
Revised: 23 Jan 2013 - 2493 days ago
Last viewed on: 20 Nov 2019 (4128 views) 

Using IBM i? Need to create Excel, CSV, HTML, JSON, PDF, SPOOL reports? Learn more about the fastest and least expensive tool for the job: SQL iQuery.

RPG Stored Procedure bypass returning result set? Published by: Chris Proctor on 04 Jan 2013 view comments(3)

I'm am working on my first RPG stored procedure thanks to Chris Ringer :-) and I have a situation where I want to check for a couple of conditions before allowing the cursor to open and return the result set. Well, if those conditions aren't met I want to bypass the processing.

Since I'm passing the return of the result set I'm getting an SQLSTATE of 38501, stating that there was a problem with the program.

Is there a way of handling this? Thanks for any input.


Return to midrangenews.com home page.
Sort Ascend | Descend