I tried calling the stored procedure from Teradata to SAS. But I was getting an error as Invalid session mode. Can anyone help me with this error. Below is the code and error: proc sql;
connect to teradata as tera(user = testuser pass= testpass tpid="XXXXX" connection=global);
Create table work.sasresult as
Select * from connection to tera(call dbname.spname('2016-01-15','2016-01-30','IND',?,?));
disconnect from tera;
quit; proc sql; connect to teradata (user=&ishid password=&ishpass tdpid="XXXXXX" connection=global); Execute( create table work.spresult as Select * From Connection To teradata ( Excute DB.SP('2017-01-01','2017-01-03','XXX',?,?) by teradata; ) ; Disconnect From teradata; quit; ERROR: Teradata prepare: Invalid Session Mode for procedure execution. SQL statement was Call dbname.spname('2016-01-15','2016-01-30','IND',?,?);
... View more