Using SQL statements in CL

[ukpi1b]

Try COMMIT option as *NONE. Your code should look like RUNSQLSTM SRCFILE(xxxLIB/QCLSRC) SRCMBR(WHEDR) COMMIT(*NONE)

[gary.shipp@s3t.co.uk]

I have been experimenting this morning with RUNSQLSTM in a CL pgm. I have created a source SQL statement then try to execute it from within the CL. The statement is trying to update a record in a file. However, I receive the following error message "Member WHEDR not journaled to journal *N. WHEDREXP in TESTLIB not valid for operation." If a journal is created over the file, the CL works. Why am I having to create a journal? Thanks in anticipation

[gary.shipp@s3t.co.uk]

Sweet Will obviously have to consider issues with regards to individual cases as to whether it is appropriate to use commitment control or not. Thanks again