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



Hi Gary,

I'm not sure referring to Sql Server will help.

I'm just trying to be able to key a file on any field using a subset of
the file based on a separate date field...

In an ideal world I'd like to be able to create a logical file in DDS
with a select/Omit on a date field specifying all records within the
past year, but I know this isn't possible...

Kind rgds
Luke

-----Original Message-----
From: rpg400-l-bounces@xxxxxxxxxxxx
[mailto:rpg400-l-bounces@xxxxxxxxxxxx] On Behalf Of Gary Thompson
Sent: 11 April 2013 14:10
To: RPG programming on the IBM i (AS/400 and iSeries)
Subject: RE: Logical file in RPG

Luke,
Maybe post an example of something you have done in MS Sql Server that
you don't know how to do in DB2 and see if you get a solution ?

-----Original Message-----
From: rpg400-l-bounces@xxxxxxxxxxxx
[mailto:rpg400-l-bounces@xxxxxxxxxxxx] On Behalf Of Klugman, Luke
Sent: Thursday, April 11, 2013 6:59 AM
To: RPG programming on the IBM i (AS/400 and iSeries)
Subject: 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.



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

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.