Archives of the TeradataForum
Message Posted: Fri, 23 Mar 2007 @ 15:08:13 GMT
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.
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|