Convert Teradata Mode Procedure to ANSI Mode

Database
Enthusiast

Convert Teradata Mode Procedure to ANSI Mode

Hi - I have Created it using SQL Assistant but getting error that ..'the proc. is in Teradta Mode' for some other user who was trying to execute it. 

After Changing View--> ANSI SQL and when i do a HELP PROCEDURE <<Proc_Name>> ATTRIBUTES, I see 'Transaction Semantics as 'TERADATA'.

All other Procs. are in ANSI Mode, Can someone help me how i can Convert this to ANSI.

Thanks

Tags (1)
4 REPLIES
Enthusiast

Re: Convert Teradata Mode Procedure to ANSI Mode

You need to change the Session Transaction mode to ANSI, and then recompile the procedure. 

Khurram
Enthusiast

Re: Convert Teradata Mode Procedure to ANSI Mode

I Changed my ODBC Connection to use 'ANSI' instead of 'System Default' and it worked fine, Thanks for all Help.

Re: Convert Teradata Mode Procedure to ANSI Mode

Can you tell me how to change ODBC connection by using 'ANSI' instead of 'System Default?

Junior Contributor

Re: Convert Teradata Mode Procedure to ANSI Mode

ODBC Options: Session Mode

Or within the connection steing: SessionMode=ANSI