executing imported teradata stored procedure from DATASERVICES

Connectivity
Enthusiast

executing imported teradata stored procedure from DATASERVICES

I am importing a teradata stored procedure into DATA SERVICES called sb_calc_sum and i am trying to use it in a script inside a dataservices job.
It gives me the following error when i try to execute the data services job.

ODBC data source error message for operation : <[Teradata][ODBC Teradata Driver][Teradata Database] 'sb_calc_sum' is not a macro. >.

1 REPLY
Teradata Employee

Re: executing imported teradata stored procedure from DATASERVICES

Use "ODBC Data Source Administrator" to disable "Call to Exec Conversion".
Snippet from the ODBC Manual:

Default = Cleared

When cleared, ODBC Driver for Teradata converts CALL statements
within an escape clause (that is, {CALL (..)}) to EXEC
statements.

When selected, CALL statements remain as CALL statements.