RE: Variable ORDER BY

[michael@xxxxxxxxxxxxxxxxxx]

I wanted a variable order by so I could get records in a different order
depending on an input criteria.

> -------- Original Message --------
> Subject: Re: Variable ORDER BY
> From: "Dave Boettcher" <DBoettch@xxxxxxxxxxxxxxxx>
> Date: Wed, December 08, 2004 3:50 pm
> To: midrange-l@xxxxxxxxxxxx
> 
> 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...
> 
> --
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
> To post a message email: MIDRANGE-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/midrange-l.