Midrange News for the IBM i Community

Posted by: Chris Proctor
Programmer Analyst
Columbia Sports Company
Portland, OR
Updating the result set in a stored procedure
has no ratings.
Published: 07 Jan 2013
Revised: 23 Jan 2013 - 2805 days ago
Last viewed on: 27 Sep 2020 (3529 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.

Updating the result set in a stored procedure Published by: Chris Proctor on 07 Jan 2013 view comments(1)

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


(Sign in to Post a Comment)
Posted by: Ringer
Premium member *
Comment on: Updating the result set in a stored procedure
Posted: 7 years 8 months 18 days 12 hours 9 minutes ago

> if I use "where current of myCursor" for the UPDATE command, they will not

> get updated because they are locked by the cursor. 

Why? If you have the row locked, you can update the record.

Did you add FOR UPDATE OF STATUS to the SELECT statement? That fetched row is locked until you fetch the next record, hit end of file, close the cursor, or the program ends and was compiled with CLOSQLCSR=*ENDMOD.

Chris Ringer