I have an SQLRPGLE program that uses embedded SQL to update multiple
records (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 F-specs.
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
still 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)
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,
or email: RPG400-L-request@xxxxxxxxxxxx Before posting, please take a
moment to review the archives at http://archive.midrange.com/rpg400-l.