All Forums Database
5485993v 19 posts Joined 08/11
09 Oct 2013
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.



M.Saeed Khurram 544 posts Joined 09/12
09 Oct 2013

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


5485993v 19 posts Joined 08/11
09 Oct 2013

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

Jerry_zhang 3 posts Joined 01/14
20 Jan 2014

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

dnoeth 4628 posts Joined 11/04
20 Jan 2014

ODBC Options: Session Mode
Or within the connection steing: SessionMode=ANSI


You must sign in to leave a comment.