Re: Logical file in RPG

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.