Re: Variable ORDER BY

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.