Re: Logical by date problem

Bob, its YYMMDD numeric. I like the idea of the web based.

But I don't think we are ready for that but I will look into that soon.

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

--
This is the RPG programming on the AS400 / 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.