Re: Logical by date problem

[Robert Cozzi <cozzi@xxxxxxxxx>]

When you say "date" do you mean date or do you mean "numeric"?
Unless a zoned/packed "date" value is stored in YYYYMMDD format, you'll have
to do something like you described. I'm sure there are alternatives--this is
software after all.

If by "date" you really mean date, then just order the logical by the date
field and do a SETLL followed by a READ loop until the number of records in
the subfile is the number you prefer.

I like page = size subfiles myself. Then I tend to load the data I'm going
to display, into a multiple occurrence DS or (today) into a Data Structure
Array. Then just use the subfile page as a Window to the
data-shifting/sorting the data as needed.

Another approach is to move to a Web Browser-based interface, where you
don't have the limitations of DSPF DDS's subfiles.

-Bob Cozzi
www.iseriestv.com


On 6/6/06 7:27 AM, "steema@xxxxxxxxxxxxx" <steema@xxxxxxxxxxxxx> wrote:

> HI I have a subfile program looking at EDI data, masses of it. I built a
> logical file, but the data load was too large. I was told to Select on the
> date starting from this past May so of course it loads straight away. I
> was told to build a small program to mark the EDI records so that I will
> only be loading 2 months or so. Now there must be a better way to do this?
>
> I am thinking of embedded SQL in the RPG program. Is this the preferred
> method?
>
> Thanks,
> Steve