Re: SQL Question - ILE

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.