journaling of files in SQLRPGLE programming

[inimdap]

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

[BVining]

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

[D.Abramowitz]

One way is to add "WITH NC" to the end of your statement. e.g. - Update xxxx set y to z with NC.

Dave

[tstephens55]

You might also include the following statement: "Exec sql Set Option Commit=*none". This will ensure when the program is compiled, that one doesn't have to remember to override the compile option each time.