Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Fri, 23 Mar 2007 @ 15:08:13 GMT


     
  <Prev Next>  
<<First
<Prev
Next> Last>>  


Subj:   Can fields be passed as param for ORDER BY?
 
From:   zqi

Good morning All,

I'm passing a SELECT statement from a client to retrieve data from our TD warehouse. I need the TD to do a sort before sending back the result to the client. However the field(s) in the ORDER BY clause is/are not static; the client will need to pass the field(s) like a parameter.

I have done some test and read some TD docs, but the more I research the more I feel the ORDER BY won't be able to take a param. Any advice/guidance you can provide will be greatly appreciated.

Fyi, the client is coded on the .Net 2.0 platform. If passing a param for ORDER BY is achievable and you have done it thru the .Net platform before, can you share the coding?


Thanks very much.

John



     
  <Prev Next>  
<<First
<Prev
Next> Last>>  
 
 
 
 
 
 
 
 
  
  Top Home Privacy Feedback  
 
 
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 27 Dec 2016