All Forums Tools
bilal.farooq 28 posts Joined 08/10
31 Jul 2012
TPT ODBC Operator - select data into a TPT "variable"

Hi,

I got to know that I can use TPT ODBC Operator to select data from another ODBC DB and then load that data into TD DB, using the LOAD Operator.

I am writing to ask if it is possible to use the ODBC operator to select data and put it into "variables" e.g., select a, b into :A, :B from tab; and then be able to use :A and :B in the TPT Script itself, to get some dynamic behavior.

 

Thanks,

Bilal

 

markhay 10 posts Joined 06/10
31 Jul 2012

TPT does not yet have the feature to allow what we call "system variables". This feature is on the list to be implemented in a future release. You can use the Partners Advisory Council as a forum for submitting enhancement requests and have customers vote on them to determine priority.

bilal.farooq 28 posts Joined 08/10
31 Jul 2012

Hi Mark,

Thank you. Just some thoughts, I have heard of a "Teradata Partners Conference" that's probably held annually.

Do you mean to say that this enhancement should be raised on that conference, or, is there any on-line web-site/Portal, where this can be raised...?

 

Thanks & Regards,

Bilal

ulrich 816 posts Joined 09/09
31 Jul 2012

check 

http://www.teradata-partners.com/About/ProductAdvisoryCouncil

there is also a link to submit a request

feel free to donate bitcoin:12kgAUHFUqvG2sQgaRBXFhCwyf9HXdkGud

bilal.farooq 28 posts Joined 08/10
06 Aug 2012

@Ulrich: Thank you

 

Regards,

Bilal

You must sign in to leave a comment.