Re: LGL FILES was(subfile query)

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

.