RE: RUNQRY *N (logicalfile)

[Buck Calabro <mcalabro@xxxxxxxxxxxx>]

On Monday, July 06, 1998 10:49 PM, Walden Leverich 
[SMTP:walden@techsoftinc.com] wrote:
> -----Original Message-----
> From: Tim Truax [mailto:truax@usaor.net]
> Sent: Friday, July 03, 1998 7:23 PM
> To: MIDRANGE-L@midrange.com
> Subject: Re: RUNQRY *N (logicalfile)
>
> Hi Vernon,
> As usual you are a deep well of knowledge.  I am also assuming that if I
> use a
> logical file in the F spec of an RPG program without the (K) for process
> by key
> that the program will also revert to accessing the file by arrival
> sequence?
> ---
> Tim & Dana Truax... and Caleb 4 years old.

> True. But unlike the QQQQRY based tools (Query, SQL, OPNQRYF) this never
> made sense to me. Why does a setting in RPG govern how data management
> return rows to the HLL?
>
> -Walden

Walden,
  I like to think of the "K" as an "ORDER BY" clause.  If it's missing, 
you get an (officially) unpredictable order.  With it there, you get 
"ORDER BY key1,key2,key3..."

Buck Calabro
Commsoft, Albany, NY
mailto:mcalabro@commsoft.net

+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to MIDRANGE-L@midrange.com.
| To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
| To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---