Re: SQL Question - ILE

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.