How to call teradata macro/procedure from routine.
Posted: Thu Mar 17, 2005 4:35 am
Hello all,
I work on project where we use DataStage (7.1) together with Teradata DB. In some cases I ideally need call Teradata macro inside the DataStage routine , check the result and return answer value based on this result. We don't use ODBC connection to Teradata but only native Teradata utilities that utilize CLI interface. I am able to achieve this task calling BTEQ (command line utility) and then parse result log, but it's not ideal way from my point of view. Is there any possibility how to do that? I mean especially something like BASIC SQL Client Interface. But as far as I know BCI can be used only for ODBC connections and this is native CLI interface.
Any help is appreciated.
Thanks in advance
Lubomir.
I work on project where we use DataStage (7.1) together with Teradata DB. In some cases I ideally need call Teradata macro inside the DataStage routine , check the result and return answer value based on this result. We don't use ODBC connection to Teradata but only native Teradata utilities that utilize CLI interface. I am able to achieve this task calling BTEQ (command line utility) and then parse result log, but it's not ideal way from my point of view. Is there any possibility how to do that? I mean especially something like BASIC SQL Client Interface. But as far as I know BCI can be used only for ODBC connections and this is native CLI interface.
Any help is appreciated.
Thanks in advance
Lubomir.