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