Re: Order by in SPL routines

Krishna wrote: > The section on 'Order by' in the 10.x documentation blankly mentions > that: > "The ORDER BY clause is not valid in queries within an SPL routine." > > (The last line in the page below > http://publib.boulder.ibm.com/infocenter/ids9help/index.jsp?topic=/com.ibm.sqls.doc/sqls684.htm) > > What is the context here? I have been using Order by's in queries > within SPL routines and so > far it seems to producing the proper ordered results. Would be great > it someone can clarify. > > Krishna > As someone already answered, it's clarified in the V11 docs... And note that the paragraph you pointed was in a section dedicated to "Using select numbers"... Not that this excuses the fact that it's a mistake :) And don't bother with the doc-bug... It's idsdb00013610 and as we can see in the V11 docs, it's fixed. It also shows the fix in 10.00.UC5 documentation notes: http://publib.boulder.ibm.com/infocenter/idshelp/v10/topic/com.ibm.docnotes.doc/uc5/ids_sqls_docnotes_10.0.html#wq9 So, the support, R&D and documentation teams *are* paying attention... Unfortunately most of us (me included) don't usually read the release/doc notes :) Regards, -- Fernando Nunes Portugal http://informix-technology.blogspot.com My email works... but I don't check it frequently...