I get an error while running a SQLRPGLE program that uses SQL statements on files that are not journaled. i don't want to journal the files. Is there a way to use these files in SQLRPGLE without journalling
Unconfigured Ad Widget
Collapse
Announcement
Collapse
No announcement yet.
journaling of files in SQLRPGLE programming
Collapse
X
-
On the CRTSQLRPGI command there is the parameter COMMIT. The default for COMMIT is *CHG, which requires that the tables/files referenced by your imbedded SQL be journaled (plus a few other things). Try specifying COMMIT(*NONE) on the CRTSQLRPGI and then run your program again. You should find that journaling is no longer required.
Hope this helps,
Bruce Vining
Comment