Re: Logical file in RPG

Thanks for the advise. The MQT looks quite interesting but I see it can
only be used as read only.

I agree with you that the date as the first key would be fine, but what
happens if I don't want to use the date as a key? I may want to set up
logicals using different key lists, but only over records in the file
that have a date within the past year.

I don't want to loop through all records that match my key and check the
date. For my purposes this would be very inefficent.
Is there nothing that allows you to setup select criteria on date fields
where the system will maintain the selection criteria *IMMED? I know
this is available in other databases like SQL Server...

Thanks again
Luke



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

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.

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