Archives of the TeradataForum

Message Posted: Thu, 03 Sep 2009 @ 13:15:21 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

<-- Anonymously Posted: Thursday, September 03, 2009 09:14 -->

Hello,

Could someone please explain me the macro behavior ( TD12 ) :

Macro consist of one statement : create volatile table aa as ....

It works OK. if called by creator.

But when I call it from different user I get the message 5340: "Database name, if specified, must be the login user name for a volatile table".

As I know from doc, nonqualified names in DDL statements in macros are left unresolved and table referenced in CREATE VOLATILE TABLE statement is created in the current session.

So what is wrong?

Thanks!

	<Prev	Next>		<<First	<Prev	Next>	Last>>