Re: pages are shuffled, " CHGQRYA DEGREE(*NONE) " what this command does?

[Vern Hamberg <vhamberg@xxxxxxxxxxxxxxxxxxxxxxxxx>]

CHGQRYA controls parallel query processing. Do you have SMP installed? 
That's Symmetric Multiple Processing, a licensed option of OS/400. If you 
do and the query does not have ordering specified, the records will be 
returned in unpredictable order. Setting DEGREE to *NONE forces no 
parallelism, hence, records are returned in arrival sequence (probably). It 
will be slower, however. The real solution, usually, is to use an ORDER BY 
in SQL or set up sort specs in Query/400.

I assume this command is in the source? If so, try running it on your 
command line before executing the query, and see whether it fixes things. 
If so, get a sort spec in there.

HTH
Vern

At 11:15 AM 8/6/2004, you wrote:
> These is a strange error which is coming when user is trying to print a 
> statement for some a/c.
>
> The pages are getting shuffled.(1,2,3,81,82....)
> The proc that  is being called is as below:
> QS36PRC/ YXXBT3.
>
> In this the first statement is a runqry
>
>          RUNQRY     QRY(YQAC/YSELECT) QRYFILE((Y3.ST4 +
>                       *FIRST)) RCDSLT(*YES) +
>                       OUTFILE(QTEMP/YSLFAX)
>
> I copied the query to my library and ran the query. The output is perfect.
> But when you issue a runqry from command line(or program) the pages are 
> getting shuffled.
>
>
> Looks like if the number of pages(or records) are more we are encountering 
> this.
> and also I would like to know
> what below command does?
> CHGQRYA DEGREE(*NONE)
>
> Thanks so much for your help,
> Murli.
>
>
>
> --
> 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.