Re: SQL: Inconsistent "order by"

[rob@xxxxxxxxx]

This is a multipart message in MIME format.
--
[ Picked text/plain from multipart/alternative ]
Thanks for further research.  Actually IBM has me doing some intense
tracing right now on this.  A lot of weird stuff in the query options file
to generate numerous dumps, etc.

Ergo - it should work.

Rob Berendt
--
"They that can give up essential liberty to obtain a little temporary
safety deserve neither liberty nor safety."
Benjamin Franklin




"Carel Teijgeler" <coteijgeler@chello.nl>
Sent by: midrange-l-admin@midrange.com
11/06/2002 01:42 PM
Please respond to midrange-l

        To:     midrange-l@midrange.com
        cc:
        Fax to:
        Subject:        Re: SQL:  Inconsistent "order by"


Rob,

A late reaction. (And this question popped up twice last week)

I tried (in Query Manager) an SQL statement with parameter markers on the
ORDER BY clause and it returned MSGID SQL0208: The parameter marker is not
an element in the result set, defined in the SELECT clause.

I do not know, if there is an equivalent value for SQLSTT.

Methinks, it is usefull to check SQL syntax in an pure SQL environment,
like Query Manager, before using it in embedded SQL, prepared statements
and host variables. That may compile.

Regards,
Carel Teijgeler.

*********** REPLY SEPARATOR  ***********

On 1-11-02 at 14:33 rob@dekko.com wrote:

>Then why doesn't it tell us that via SQLSTT?
>
>"Carel Teijgeler" <coteijgeler@chello.nl>

>I do not think you can use parameter markers on the ORDER BY clause. You
>can only use it in the WHERE clause.
>
>Try something like:
>
>  SqlStmt='Select ccust, cnme, cad1, cad2, cste, czip ' +
>               'From rcm ' +
>               'Order by' + %char(Parm1);




_______________________________________________
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
list
To post a message email: MIDRANGE-L@midrange.com
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/cgi-bin/listinfo/midrange-l
or email: MIDRANGE-L-request@midrange.com
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.