RE: Display file dynamically

["Phil Kestenbaum" <pkestenbaum@xxxxxxxxxxx>]

How do you access a table where the name of the field to be used in the
ORDER BY clause is a variable ?
(we are using SQLCobol)

          EXEC SQL                       

               DECLARE my-cursor CURSOR FOR   

               SELECT *                  

               FROM my-table 

               ORDER BY :my-order-by-field        




This message contains information proprietary to our company. It is intended to 
be read only by the individual or entity named above or their designee.
Any distribution of this message or the information contained herein without 
written permission from our company is strictly prohibited. If the reader of 
this message is not the intended recipient or an agent responsible for 
delivering it to the intended recipient, you are hereby notified that you have 
received this document in error and that any review, dissemination, 
distribution, or copying of this message is strictly prohibited. If you have 
received this communication in error, please notify us immediately by e-mail, 
and delete the original message.