Need an urgent help. I am trying to create a SP in Tera mode but it is giving Invalid Session mode error. When I am creating the SP with ANSI mode it is getting created, but while executing the SP using UNIX script, I am getting the same error:Invalid Session Mode.
A SP must be executed in the same session mode used during creation.
You can set the session mode explicitly, e.g.
BTEQ -> .SET SESSION TRANSACTION BTET/ANSI"
ODBC -> Options
.NET -> Advanced tab