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