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



Have you tried a VIEW? Maybe a MQT table?
http://www.ibm.com/developerworks/data/library/techarticle/dm-0509melnyk/

Personally, you should make the date the first key field and select on it.




On Thu, Apr 11, 2013 at 8:16 AM, Klugman, Luke
<LKlugman@xxxxxxxxxxxxxxxxx>wrote:

I really need an index on the file that is maintained immediately. I
don't want the system to select my records dynamically as the file will
potentially hold millions of records and there could be quite a
performance hit.

-----Original Message-----
From: rpg400-l-bounces@xxxxxxxxxxxx
[mailto:rpg400-l-bounces@xxxxxxxxxxxx] On Behalf Of Marc Couture
Sent: 11 April 2013 12:28
To: RPG programming on the IBM i (AS/400 and iSeries)
Subject: Re: Logical file in RPG

Why use a F specs?

I will use an SQL cursor where you could select records and set the
order.

Sent from my iPad

On Apr 11, 2013, at 7:20, "Klugman, Luke" <LKlugman@xxxxxxxxxxxxxxxxx>
wrote:

Hi,

Can anyone recommend the best way to create/use a logical file that I
can use in the F specs of an RPG program that will allow me to key a
file with a selection on a date field.

Basically I have a field with a date filed but I only want to include
dates within the current year to date. I thought the best way to do
this would be to create a sql index as follows:

CREATE INDEX ATABLEI1 ON ATABLE (DATE_FIELD) where Date_Field >=
(CURRENT DATE - 1 YEARS)

but you cannot use the current date function with the create index
command.

I also thought of creating a view with a sub-select which contains an
order by statement, but this doesn't give me any key fields.

Any help would be greatly appreciated.

Kind regards
Luke



Tullett Prebon - Risk Magazine #1 Overall Interdealer Broker 2012 &
FOW Winner


----------------------------------------------------------------------
- The information contained in this email is confidential and may also

contain privileged information. Sender does not waive confidentiality
or legal privilege. If you are not the intended recipient please notify
the sender immediately; you should not retain this message or disclose
its content to anyone.
Internet communications are not secure or error free and the sender
does not accept any liability for the content of the email. Although
emails are routinely screened for viruses, the sender does not accept
responsibility for any damage caused. Replies to this email may be
monitored.
For more information about the Tullett Prebon group of companies
please visit the following web site: www.tullettprebon.com

----------------------------------------------------------------------
-
--
This is the RPG programming on the IBM i (AS/400 and 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.

--
This is the RPG programming on the IBM i (AS/400 and 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.

--
This is the RPG programming on the IBM i (AS/400 and 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-Ups:
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.