Re: Variable ORDER BY

When I have used an order by in embedded SQL it has always been a field
in the file like this
<snip>
FROM PrsnXref                              
where (xrssn1 = 0                          
          or xrssn2 = 0                    
          or xrssn3 = 0                    
          or xrssn1 > 776)                 
ORDER By xplname, xpfname, xpinit, xpsuffx 
<snip>

The where clause can have a variable but I don't see the use for a host
variable in the order by

HTH, 

Dave Boettcher


>>> michael@xxxxxxxxxxxxxxxxxx 12/08/2004 2:42:03 PM >>>
How can I use a  variable ORDER BY clause in an embedded SQL
statement?
This doesn't work...

C/EXEC SQL              
C+ Declare MyCursor Cursor For
C+   Select *           
C+     From Myfile     
C+     Order By :MyField   
C+   For Read Only      
C/End-Exec              

I know I have to do something different because it's a variable that
contains a field name, but I dunno what that different thing is.

TIA...