SQLRPGLE example of Fetch, use data for report, then Update

Major brain fade here...  Is it possible to use embedded SQL that will
fetch data, let RPG use the fetched data, then modify & update the
data with SQL Update?  I need to print an audit report of the records
being updated with the original values before updating them.  If
someone has an example, I'd love to see it.

BTW, I found the reference to the redbook "Modernizing IBM eServer
iSeries Application Data Access - A Roadmap Cornerstone" from a post
few weeks ago -- excellent resource!  (But didn't answer this question
that I could see.)

And I just now discovered the Accelerator Keys in the archives!!! 
AWESOME!  Now I can keep my fingers on the keyboard!!!

TIA,
Dan