Problem with DATABASE and SET SESSION DATABASE.

Database
Enthusiast

Problem with DATABASE and SET SESSION DATABASE.

Hi

      When i run the folowing query in the sql assistant.The query didnt fetch any rows.

Database database_name;

select * from tablename1 left outer join tablename2 on join condition;

But when i rewrote the same query

select * from database_name.tablename 1 left outer join database_name.tablename2 on join conditon;

I got more than 25000 rows;

I even tried SET SESSION DATABASE . but i didnt get the result. i am using teradata 12.0  What is the problem here?

Regards

Hari

1 REPLY
Junior Contributor

Re: Problem with DATABASE and SET SESSION DATABASE.

There's an option to disconnect after every query, maybe this is set?

tools -> options -> query -> disconnect from database when no query is running.

Dieter