RE: Variable ORDER BY

That's the preferred method here for sorting subfiles. Works pretty well.

Thanks,

Mark

Mark D. Walter
Senior Programmer/Analyst
CCX, Inc.
mwalter@xxxxxxxxxx
http://www.ccxinc.com


                                                                           
             michael@ryantechn                                             
             ology.com                                                     
             Sent by:                                                   To 
             midrange-l-bounce         Midrange Systems Technical          
             s@xxxxxxxxxxxx            Discussion                          
                                       <midrange-l@xxxxxxxxxxxx>           
                                                                        cc 
             12/08/2004 04:00                                              
             PM                                                    Subject 
                                       RE: Variable ORDER BY               
                                                                           
             Please respond to                                             
             Midrange Systems                                              
                 Technical                                                 
                Discussion                                                 
             <midrange-l@midra                                             
                 nge.com>                                                  
                                                                           
                                                                           




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.

--
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.