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)
7 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

Enthusiast

Re: Convert Teradata Mode Procedure to ANSI Mode

Hi Guys,  

 

when i try to run the procedure in sql assistant or even BTEQ, in what ever mode i.e ANSI, DEFAULT etc, can we check for any dbc table about that procidure , it ran in what mode?

Junior Apprentice

Re: Convert Teradata Mode Procedure to ANSI Mode

If you're on TD15 (possibly 14) then use column TxnMode in table DBC.DBQLogtbl.

Cheers,

Dave

Ward Analytics Ltd - information in motion
www: http://www.ward-analytics.com

Re: Convert Teradata Mode Procedure to ANSI Mode

Thanks Dave.