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. ".
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.