Re: SQL Question - ILE

[Vernon Hamberg <vhamberg@xxxxxxxxxxx>]

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.