SQL Assistant "execute the query one statement at a time"

Tools

SQL Assistant "execute the query one statement at a time"

SQL Assistant 15.0 on Win7 32 bit enterprise connected to TD 14.10.

Tried to create simple macro: create macro testdb.test as (select 1;); returns "Execute the query one statement at a time"

I thought this might have something to do with ODBC/JDBC, but, Administrator connected to the same ODBC connection works.  So does Studio.

Any suggestions (other than don't use SQL Assistant) (doctor, doctor it hurts when I do that -- Then don't do that).

2 REPLIES
Teradata Employee

Re: SQL Assistant "execute the query one statement at a time"

To execute multiple statements you must put SQL Assistant in Teradata mode rather than ASCII mode.  Execute this command to put the Assistant in the right mode:

.set session trans BTET;

Re: SQL Assistant "execute the query one statement at a time"

iam new to teradata ,i have created a simple macro ,when i execute it,iam getting the below error

"execite the query one statement at a time"

as mentioned in the above post i have tried with 

.set session trans BTET;

still getting the same error.pls help