Midrange News for the IBM i Community


Posted by: Chris Proctor
Programmer Analyst
Columbia Sports Company
Portland, OR
How can I get the number of rows updated by an UPDATE SQL statement?
has no ratings.
Published: 04 Sep 2014
Revised: 04 Sep 2014 - 1869 days ago
Last viewed on: 08 Oct 2019 (3464 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.

How can I get the number of rows updated by an UPDATE SQL statement? Published by: Chris Proctor on 04 Sep 2014 view comments(4)

Good morning. I have the need to retrieve the number of rows updated by and UPDATE SQL statement. I see there's a ROW_COUNT available, but I'm not sure if that's what I should use. I also can't find an example of the syntax, if that is the way to go. Can someone give me a clue? ;-)

Thanks!

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

COMMENTS