I'm working with a legacy transaction file from our ERP (i.e.
My SQLRPGLE service program procedure inserts two records/rows into the
file (they are complementary rows - both are necessary)
If the first insert fails, I simply exit the procedure with an error.
But I'm not sure how to handle the situation where the first insert is
successful, but the second insert fails. If this occurs, I need to remove
the row I successfully inserted.
Is there some way to capture the exact row I inserted successfully? Like
maybe the relative record number? Or am I out of luck here.
[Logo]<https://www.totalbizfulfillment.com/> Greg Wilburn
Director of IT
301.895.3792 ext. 1231
1 Corporate Dr
Grantsville, MD 21536
This is the RPG programming on IBM i (RPG400-L) mailing list
To post a message email: RPG400-L@xxxxxxxxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
or email: RPG400-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives
Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription related
Help support midrange.com by shopping at amazon.com with our affiliate
As an Amazon Associate we earn from qualifying purchases.
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.