Is SQL Commitment level extended to non SQL programs called
I have an SQLRPGLE program that calls an RPG program. I know that the SQLRPGLE program has an internal commitment control engine activated, but will it extend onto the RPG program I call from here?
Software/Hardware used:
Software/Hardware used:
ASKED:
July 8, 2009 10:16 AM
UPDATED:
July 8, 2009 1:12 PM
Answer Wiki:
Yes .. to SQL commands in SQLRPGLE
No, I don't beleieve it extends to F-Spec based commands
You need the STRCMT and the COMMIT of the F-Spec
I think you will need two commit's and two rollbacks
Remember. records will be locked by both processes and not available for change until the commit/rollback.
Phil
To see all answers submitted to the Answer Wiki: View Answer History.
RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
