Order by in SPL routines
A poster asked about a line in the IDS 10.x manual stating "The ORDER BY clause is not valid in queries within an SPL routine," since he had been using ORDER BY inside stored procedures without problems and getting correctly sorted results. Two other contributors (including Art Kagel) replied that ORDER BY has always worked for them in SPL and that the documentation statement appears to be a mistake, with no plausible explanation for it. No authoritative clarification or official resolution is recorded in the thread.
Auto-generated by DrWatson from the posts below — may be imperfect; read the full thread.
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
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. > Always worked for me. I have no idea what they're talking about. Art S. Kagel Oninit > Krishna > > _______________________________________________ > Informix-list mailing list > Informix-list@iiug.org > http://www.iiug.org/mailman/listinfo/informix-list > > =========================================================================================== > Please access the attached hyperlink for an important electronic communications disclaimer: > > http://www.oninit.com/home/disclaimer.php > > =========================================================================================== > > > =========================================================================================== Please access the attached hyperlink for an important electronic communications disclaimer: http://www.oninit.com/home/disclaimer.php ===========================================================================================
On 14 Mar, 05:21, Krishna <calvinkri...@gmail.com> 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 belowhttp://publib.boulder.ibm.com/infocenter/ids9help/index.jsp?topic=/co...) > > 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 I've never had an issue, must be a mistake, surely? I've tried to imagine what they might have been trying to say...but can't come up with any (even slightly) plausible explanation!