Hi, we would like to use TD studio (version 14.01) which looks like very interesting and powerfull tool. However it seems that the tool does not support stored procedures. At least, we haven't been able to run any stored procedure yet. The Studio returns an error message:
"Executed as a single statement. Failed [5510 : HY000] Invalid session mode for procedure execution. "
It looks like a problem is not in the tool but in a setup of the tool Could anyone tell us what we should do to fix this?
Thanks in advance.
5510 Invalid session mode for procedure execution.
Explanation: The session mode within which the CALL SQL is submitted is different than the one in which the stored procedure was created. A stored procedure created in ANSI mode cannot be executed in Teradata mode and vice versa
I forgot to mention:
To change the TD Studio session mode :
->Connection->JDBC Connection Properties->TMODE