topic Re: Exection Teradata Stored procedure from SAS in SAS Programming

Exection Teradata Stored procedure from SAS

Venky22 — Mon, 23 Nov 2020 15:28:31 GMT

Hi All,

Trying to execute the teradata stored procedure in sas.

libname a teradata user =xx pwd =xxxx server=xxxx db=MNO connection=shared;
proc sql;
connect using a;
execute (call MNO.procedure('202010',0);) by a;
quit;

I've followed changes as shown below

ODBC ADministrator --> Configure --> Options --> Session Mode (Selected ANSI)

Getting below error:

Error:Teradata execute:Invlid Session mode for Procedure execution.

Can some help me to resolve this issue.

Thanks & Regards,

VNKY

Re: Exection Teradata Stored procedure from SAS

LinusH — Mon, 23 Nov 2020 15:51:58 GMT

Just a hunch, does the procedure "stream" output?

If so, that will probably clash with how SAS EXECUTE blocks works.

Re: Exection Teradata Stored procedure from SAS

Venky22 — Mon, 23 Nov 2020 17:08:21 GMT

What procedure does is :

It cretes tables with 202010 data and eports to an excel file. After the data is being populated Business Objects will use those tables to generate the report.

Currently we are manually triggering each procedure(there are around 20 procedures) and create tables.

Re: Exection Teradata Stored procedure from SAS

SASKiwi — Mon, 23 Nov 2020 20:00:41 GMT

There are two modes you can specify with Teradata: ANSI (default) and TERADATA. I suggest you try MODE = TERADATA on your LIBNAME statement: https://documentation.sas.com/?cdcId=pgmsascdc&cdcVersion=9.4_3.5&docsetId=acreldb&docsetTarget=n0tfqr5qd1ryizn1hkohz7fs1g3k.htm&locale=en