× 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.



Does the module end? If so, then check the CLOSQLCSR setting on the
compile. If not, then have you tried using aliases? If you must, RPG
does an implicit connect. Try disconnecting and reconnecting to the
database.


On Fri, 2006-12-08 at 12:39 -0800, Jeff Young wrote:
I have an ILE RPG SQL module that selects data from files using SQL.
The data is selected either by the Select INTO or other methods that do not 
use a cursor.
Based on a field in my input, the actual files I am using will be overriden 
to different files with the exact same format, but different names.
The problem I seem to be having, is that even though the override is in 
effect at the activation group level, the open files for the job show only 
the first set of files.
In addition, when I attempt to retreive data from the 2nd set of files, the 
query seems to be ignoring the override and using the first set.
Is there any way I can force the files to close when I need to change 
overrides?

Thanks,
 
Jeff Young 
Sr. Programmer Analyst
Dynax Solutions, Inc.
A wholly owned subsidiary of enherent Corp.
IBM -e(logo) server Certified Systems Exper - iSeries Technical Solutions 
V5R2 
IBM  Certified Specialist- e(logo) server i5Series Technical Solutions 
Designer V5R3
IBM  Certified Specialist- e(logo)server i5Series Technical Solutions 
Implementer V5R3


 
____________________________________________________________________________________
Yahoo! Music Unlimited
Access over 1 million songs.
http://music.yahoo.com/unlimited


As an Amazon Associate we earn from qualifying purchases.

This thread ...

Replies:

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

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.