×
The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.
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)
--
A&K Wholesale
Murfreesboro, TN
615-867-5070
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2024 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].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.
midrange.com
