RE: Variable ORDER BY

You'd think so, wouldn't' you. But there is an upside. If you're doing this
over and over again, you could use parameter markers. That would speed up
your queries dramatically.

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 03:49                                              
             PM                                                    Subject 
                                       RE: Variable ORDER BY               
                                                                           
             Please respond to                                             
             Midrange Systems                                              
                 Technical                                                 
                Discussion                                                 
             <midrange-l@midra                                             
                 nge.com>                                                  
                                                                           
                                                                           




Thanks Mark...thought it would be easy like a select.


> -------- Original Message --------
> Subject: Re: Variable ORDER BY
> From: MWalter@xxxxxxxxxxxxxxx
> Date: Wed, December 08, 2004 3:45 pm
> To: "Midrange Systems Technical Discussion" <midrange-l@xxxxxxxxxxxx>
>
> You need to take a look at the PREPARE and DEFINE CURSOR statements.
>
> 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-l@xxxxxxxxxxxx

>              s@xxxxxxxxxxxx
cc
>

>
Subject
>              12/08/2004 03:42          Variable ORDER BY

>              PM

>

>

>              Please respond to

>              Midrange Systems

>                  Technical

>                 Discussion

>              <midrange-l@midra

>                  nge.com>

>

>

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

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