RE: Embedded SQL Order By with host variables

[darren@xxxxxxxxx]

Thank you for the responses.  I am aware of the dynamic prepare option.
Static SQL statements offer a number of benefits in performance and error
checking, and I was hoping, by the debug message I had seen about host
variable in the order by clause, that it was something new we could do.
We're at V5R2 by the way.






                      "Bob Slaney"
                      <rjslaney@us.ibm.        To:       rpg400-l@midrange.com
                      com>                     cc:
                      Sent by:                 Fax to:
                      rpg400-l-admin@mi        Subject:  RE: Embedded SQL Order 
By with host variables
                      drange.com


                      10/30/2002 07:05
                      AM
                      Please respond to
                      rpg400-l







What about looking at dynamic preparation of the select? You could build a
character string and supply the value for the ORDER BY as a variable.