Re: LGL FILES was(subfile query)

[coder96@xxxxxxxxxxxxx]

Wouldn't be easyer just to make an array. If it's never going to be displayed.

10/14/2002 9:06:42 AM, "Booth Martin" <Booth@MartinVT.com> wrote:

>
>
>(please let me know in private e-mail if this e-mail is badly formed.  I am
>using a different e-mail and am worried it may not work like the salesman
>said it would)
>
>Visual Age RPG sorts subfiles with a click on the heading.
>
>Here's my question though:  Can a subfile be built in RPGIV without any
>Screen for it?
>
>
>---------------------------------------------------------
>Booth Martin   http://www.MartinVT.com
>Booth@MartinVT.com
>---------------------------------------------------------
>
>-------Original Message-------
>
>From: rpg400-l@midrange.com
>Date: Monday, October 14, 2002 03:46:18 AM
>To: rpg400-l@midrange.com
>Subject: LGL FILES was(subfile query)
>
>Hi Murali,
>I am probably just guessing but it seems to me that your
>questions show that you dont understand how the AS400 database
>'SORTS' data. Basically you dont understand what a LF is.
>
>A 'maint(*immed)' LF is a sorted index on a PF that
>the OS maintains dynamically.
>You subfile question is not clear to me as to what you are
>trying to do.
>I can try to guess, but basically you need to load the subfile
>in the correct order. There is no 'resorting' of a subfile
>done by the system, if you need to resort the subfile you have
>to code this yourself.
>
>To access data from a PF efficiently you must have LF
>or SQL INDEXES over the PF. OpenQueryFile will then try to use
>the LF or INDEXES before it will create its own temporary indexes.
>
>Hope that I am not too far off the mark, if so I apologise.
>
>Frank Kolmann
>
>
>
>>Hi
>>I am reading PF records using subfile....I want one particular
>>record (I mean one random record with cust#50,i ve 1000records in
>>that) to come first in the sfl page when displayed..(when i
>>display the page the cust#50 record should occupy first place of
>>the records display )..what should i do?
>>advise me
>>Best Regards
>>Murali
>>
>>
>>I ve to generate monthly reports from accessing records from PF
>>which is having million records...do u suggest me openquery or
>>logical file...I dont mind abt system overhead...
>>Can u advise me
>>Best Regards,
>>Murali
>
>
>
>
>
>_______________________________________________
>This is the RPG programming on the AS400 / iSeries (RPG400-L) mailing list
>To post a message email: RPG400-L@midrange.com
>To subscribe, unsubscribe, or change list options,
>visit: http://lists.midrange.com/cgi-bin/listinfo/rpg400-l
>or email: RPG400-L-request@midrange.com
>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@midrange.com
>To subscribe, unsubscribe, or change list options,
>visit: http://lists.midrange.com/cgi-bin/listinfo/rpg400-l
>or email: RPG400-L-request@midrange.com
>Before posting, please take a moment to review the archives
>at http://archive.midrange.com/rpg400-l.
>
>
>