I am having the same trouble. I am trying to call it from SAS. It says 'Invalid Session Mode for procedure execution' Any suggestions? I did some research and found out i should have executed the macro using ANSI session mode is that true?
Thanks for your time.
go to ODBC configuration on windows control panel.
go to teradata configuration and set the option "Session Character Set" to UTF-8. Then click the button "Options" and set the option "Session Mode:" to ANSI.
it worked for me.
Hello all .. Any idea how to set this it SQL assistant
Getting same error : CALL Failed. 5510: Invalid session mode for procedure execution.
If you are using .NET Provider (recommended) then in the connection dialog just click the "Advanced" tab and select ANSI from the Session Mode drop-down. If you are using ODBC, then you will need to use the ODBC Data Source Administrator to configure this in the DSN Options.
Thanks Fred , I was able to change it in below option and it worked
ODBC ADministrator --> Configure --> Options --> Session Mode