cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Venky22
‎11-23-2020
  • 3 Posts
  • 0 Likes Given
  • 0 Solutions
  • 0 Likes Received

Re: Exection Teradata Stored procedure from SAS

by Calcite | Level 5 in SAS Programming
‎11-23-2020 12:08 PM
‎11-23-2020 12:08 PM
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.  ... View more

Exection Teradata Stored procedure from SAS

by Calcite | Level 5 in SAS Programming
‎11-23-2020 10:24 AM
‎11-23-2020 10:24 AM
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     ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎11-23-2020 03:48 PM
Quick links