Archives of the TeradataForum
Message Posted: Thu, 03 Sep 2009 @ 13:15:21 GMT
<-- Anonymously Posted: Thursday, September 03, 2009 09:14 -->
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?
|Copyright 2016 - All Rights Reserved|
|Last Modified: 15 Jun 2023|