BookmarkSubscribeRSS Feed
Venky22
Calcite | Level 5

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

 

 

3 REPLIES 3
LinusH
Tourmaline | Level 20

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

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

Data never sleeps
Venky22
Calcite | Level 5

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. 

SASKiwi
PROC Star

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=n0tf...

sas-innovate-2024.png

Available on demand!

Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.

 

Register now!

How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

Find more tutorials on the SAS Users YouTube channel.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 3 replies
  • 478 views
  • 0 likes
  • 3 in conversation