RE: STRSQL SELECT * on a logical file: keys not recognized

[vhamberg@xxxxxxxxxxx]

Sorry, did not mean to link the 2 things. I can see that if grouping happened 
in parallel that order would not be guaranteed. It seems in my experience with 
non-parallel that grouping does sort - it has to sort things in order to get 
things in groups, but parallelism could involve segmentation, hence differing 
orders

Thanks for the clarification!

Vern

-------------- Original message -------------- 

> >This is especially important with parallel access methods. 
> >Normally, with no parallel processing, the order is that of 
> >the physical file. Grouping imposes an order. 
> 
> Vern, 
> 
> I'm confused by what you're saying. Were the "parallel processing" and 
> "grouping" sentences related to eachother? AFAIK, even grouping is NOT a 
> promise of an order. I would think this is especially true with parallel 
> processing, but you seem to be implying the reverse. 
> 
> You don't have to process rows in group by order to do group by 
> processing, and even if you did, with parallel processing two (or more) 
> tasks could be assembling the data at the same time and the first one 
> done doesn't have to be the first on in the sort order. 
> 
> -Walden 
> 
> ------------ 
> Walden H Leverich III 
> President & CEO 
> Tech Software 
> (516) 627-3800 x11 
> WaldenL@xxxxxxxxxxxxxxx 
> http://www.TechSoftInc.com 
> 
> Quiquid latine dictum sit altum viditur. 
> (Whatever is said in Latin seems profound.) 
> 
> -- 
> 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. 
>