Execute Teradata Stored Procedure from SQL Server

Database

Execute Teradata Stored Procedure from SQL Server

Hello,

I need to execute a Teradata stored procedure in SQL Server.

I tried so far the following:

1) exec ('call CIONESCU.stp_agg_3 ();') at [Teradata_CIONESCU]

2) select 1 from openquery (Teradata_CIONESCU,'call CIONESCU.stp_agg_3 ();')

error: OLE DB provider "MSDASQL" for linked server "Teradata_CIONESCU" returned message "[Teradata][ODBC Teradata Driver][Teradata Database] Invalid session mode for procedure execution. ".

Any ideas?

1 REPLY
Teradata Employee

Re: Execute Teradata Stored Procedure from SQL Server

A stored procedure can only be called in the same mode (Teradata BTET or ANSI) used to define the procedure. Change the Session Mode option in the ODBC DSN configuration.