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



The problem is not a library list issue.
All of the files I am using are in my library list, but based on data from 
other sources, I will be accessing different names.
There are 2 separate EDI systems at the client I am working at, and although 
they use the same data format for their order work files, the actual file names 
are different.
This is something that is not within my control to change, so my application is 
attempting to get the data from the correct file each time.
It seems that since the files were open initialy one way using a cursor within 
the module, that even though I have closed the cursor, the OVRDBF command is 
being ingored when either opening the cursor again, or accessing the same file 
using a SELECT INTO function.

What I am looking for is a way (if possible) to fully close the files that were 
opened with *any* SQL function, so that I can then use the OVRDBF command 
before using them again.

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 


  
 





----- Original Message ----
From: Vernon Hamberg <vhamberg@xxxxxxxxxxx>
To: RPG programming on the AS400 / iSeries <rpg400-l@xxxxxxxxxxxx>
Sent: Sunday, December 10, 2006 9:54:56 AM
Subject: Re: SQL Question - ILE


Any reason that you are not changing the library list? Just jumping 
at the end here.

At 03:42 PM 12/9/2006, you wrote:

My problem is that I am attempting to use the same SQL statement for 
either file, using the OVRDBF command to switch between them.
This is all happening in the same module.
It seems that since RPG shows the files as Open (under the open 
files option for DSPJOB), it is not accepting my OVRDBF command.
I have not been able to find any method to close the files opened by SQL.
Some of the files were in fact opened using a cursor, but the cursor 
was closed prior to a new OVRDBF being issued.
If there is no way to close these files completly prior to the end 
of the module, I may have to try using the PREPARE with the actual 
file name, rather than normal static SQL statements.

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









----- Original Message ----
From: R Bruce Hoffman <bruce.hoffman@xxxxxxxxxxxxxxxxx>
To: RPG programming on the AS400 / iSeries <rpg400-l@xxxxxxxxxxxx>
Sent: Friday, December 8, 2006 5:30:50 PM
Subject: Re: SQL Question - ILE


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

--
This is the RPG programming on the AS400 / iSeries (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.



____________________________________________________________________________________
Need a quick answer? Get one in minutes from people who know.
Ask your question on www.Answers.yahoo.com
--
This is the RPG programming on the AS400 / iSeries (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.


As an Amazon Associate we earn from qualifying purchases.

This thread ...


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.