Have you tried specifying COLSQLCSR(*ENDMOD) on the CRTSQL* command? The
default is CLOSQLCSR(*ENDSQL), I believe, which probably isn't what you

On Mon, Apr 30, 2012 at 9:19 AM, Jerry C. Adams <midrange@xxxxxxxx> wrote:

First, V5R1.

I have an SQLRPGLE program that uses embedded SQL to update multiple
(potentially, anyway) in a master file. I build a string based upon the
user's options and then use EXECUTE IMMEDIATE :sqlstring. The master file
is referenced only in the sqlstring; i.e., it is not defined in the
The string is: UPDATE TSTQS36F/"A.IVMAST" SET impidx = 'X ' , imprcd = '
WHERE impidx = 'CONW' AND imprcd = ' '

I never noticed before that, when the program ends, the master file is
open when I run DSPJOB option 14. Is this normal, some keyword I need to
add to the UPDATE string, or something else to be sure the file is closed?

Jerry C. Adams

IBM i Programmer/Analyst

Everything that can be invented, has been invented. -Charles Duell, U.S.
Patent Office Director (1899)


A&K Wholesale

Murfreesboro, TN


This is the RPG programming on the IBM i / System i (RPG400-L) mailing list
To post a message email: RPG400-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/rpg400-l.

This thread ...


Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2020 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].