RE: Subfile loading time tips needed

OPQRYF may be able to do this or you can simulate this with control
break logic. Embedded SQL is probably the easiest way to go if you have
DB2 Query Mgr and SQL DevKit on your machine. You'll want a logical file
keyed by your selection criteria and then the fields that you consider
distinct regardless of how you do this.

Matt

-----Original Message-----
From: rpg400-l-bounces@xxxxxxxxxxxx
[mailto:rpg400-l-bounces@xxxxxxxxxxxx] On Behalf Of steema@xxxxxxxxxxxxx
Sent: Wednesday, January 04, 2006 3:21 PM
To: RPG programming on the AS400 / iSeries
Subject: RE: Subfile loading time tips needed

THank you Mohammed, but can this be incorporated into the RPG?

> I am not sure what you are looking for but I think this SQL can you
help u
>
> "select distinct fieldnames from yourlib/file where ?=?"
>
>
> -----Original Message-----
> From: rpg400-l-bounces@xxxxxxxxxxxx
[mailto:rpg400-l-bounces@xxxxxxxxxxxx]
> On Behalf Of steema@xxxxxxxxxxxxx
> Sent: Wednesday, January 04, 2006 12:55 PM
> To: RPG programming on the AS400 / iSeries
> Subject: Re: Subfile loading time tips needed
>
> What is your problem, moron? I asked a legitimate question, if you
have no
> need to answer then don't. If you have a proper response, please do.
>
>> haven't we passed the final exam yet?
>>
>> steema@xxxxxxxxxxxxx wrote:  IOW, I would like to use the SQL unique
>> attribute for this file, as this
>> would cut down on the # of recs to read.
>> Can this be done w/ in the RPG ?
>>> HI I have a subfile that I am building in full, bec. there are some
>>> related factors between records. If there is for example, a BOL
number,
>>> this same BOL could appear later on, and it is desired to have it
>>> grouped
>>> together, in the subfile. But this way, takes some time. There is a
>>> definete pause of a few seconds, for each load, for each F12, etc...
>>>
>>> Perhaps I am lacking some understanding of subfiles so as to speed
this
>>> up?
>>>
>>> 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.

>>>
>>>
>>
>> --
>> 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.
>>
>>
>>
>>
>>
>>     Mark Allen
>>   allenmar@xxxxxxxxx
>>   Home: 859 635 5980
>>
>>
>>
>>
>> ---------------------------------
>>  Yahoo! DSL Something to write home about. Just $16.99/mo. or less
>> --
>> 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.
>>
>>
>
> --
> 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.
>
>
>
> --
> 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.
>
>