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

RUNQRY is not SQL as such - it is Query/400. The command is there, no license 
needed. No ordering available when used without a QRYDFN. You are able to use 
record selection if you have the licensed product. Otherwise, it's a great 
substitute for DSPPFM. 

Another reason to use QMQRY to run an SQL SELECT with ORDER BY.

Vern

-------------- Original message -------------- 
From: "Don Tully" <dtully@xxxxxxxxxx> 

> No, record sequence cannot guaranteed by SQL unless Order by clause is 
> specified. 
> 
> Don Tully 
> Tully Consulting LLC 
> 
> 
> 
> -----Original Message----- 
> From: midrange-l-bounces@xxxxxxxxxxxx 
> [mailto:midrange-l-bounces@xxxxxxxxxxxx]On Behalf Of Booth Martin 
> Sent: Monday, February 06, 2006 10:28 AM 
> To: Midrange Systems Technical Discussion 
> Subject: Can "RUNQRY *N SomeLF" be displayed in key 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. 
>