Re: Can "RUNQRY *N SomeLF" be displayed in key sequence?

[Vernon Hamberg <vhamberg@xxxxxxxxxxx>]

Not sure I understand this - sounds as if you're saying that RUNQRY 
DOES use the index of an LF. The original question suggests it does 
not, and I just verified that it does not. I have a PF with 1 packed 
field, 2 records. First record has value 5, second has value -4, so 
it is in descending order in arrival sequence. Created an LF on this 
field, so it should be in order of -4, 5. But RUNQRY shows the same 
sequence for both the PF and the LF.

BPCS must be using a program around the display of data, not the raw 
RUNQRY command.

Am I missing something?

At 02:18 AM 2/7/2006, you wrote:

> If you look at the same physical file via RUNQRY N file_name(LF) then F4,
> via a variety of different logical files, it displays the data in the
> logical sequence of the LF's definition of what is the keys.  That is how
> it works in BPCS where the physical file is NOT indexed, just a collection
> of data, using different logical definitions of what to include and what is
> the key sequence.
>
> Keys and Key sequence being defined by the logical file.
>
> I have no idea what would happen if the physical file itself is indexed.
> When I look at the physical data via RUNQRY N then name of physical file, I
> get the helter skelter sequence of how the data was originally added to the
> file.
>
> You better off using a query definition to dictate sequence.
>
> >Can "RUNQRY *N SomeLF" be displayed in key  sequence?
> >
> >Is it somehow possible to use the runqry command against a logical file
> >and have the records displayed in key  sequence?
> >
> >--
> >-----------------------------------
> >Booth Martin
> >http://martinvt.com
> >-----------------------------------
> >--
> >This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
> >To post a message email: MIDRANGE-L@xxxxxxxxxxxx
> >To subscribe, unsubscribe, or change list options,
> >visit: http://lists.midrange.com/mailman/listinfo/midrange-l
> >or email: MIDRANGE-L-request@xxxxxxxxxxxx
> >Before posting, please take a moment to review the archives
> >at http://archive.midrange.com/midrange-l.
>
>
> --
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
> To post a message email: MIDRANGE-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/midrange-l.