I am working on a Narrow Cast Server project in Microstrategy; teradata is the database. We have configured an ODBC connection to connect the NCS to teradata.
I get an ODBC error while trying to execute a multi pass sql using the ODBC connection. However, a simple query runs fine.
The complete error is " Database Classes][Error] Execute Query failed. Error type: Odbc error. Odbc operation attempted: SQLExecDirect. [25000:-3932: on SQLHANDLE] [Teradata][ODBC Teradata Driver][Teradata Database] Only an ET or null statement is legal after a DDL Statement."
The sample sql is as belows:
As you wanne use the query band setting only for the one sql try
SET QUERY_BAND = 'Project=Example2;Report=0315-17.11;MSTRUser=MSTRPORTAL_EXXXX;' FOR transaction;
select * from table1;
at least it worked for me in V2R14
You wrote: "The SQL executes fine when run directly against the database using SQL Assistant."
Try "Execute Parallel" (vs. "Execute") in SQL Assistant.
"Execute Parallel" will fail in SQL Assistant. "Execute Parallel" sends one Multi-Statement request to the Teradata Database; while "Execute" sends three single-statement requests.