Home Page for the TeradataForum

Archives of the TeradataForum

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

  <Prev Next>  
Next> Last>>  

Subj:   Volatile tables in macros
From:   Anomy Anom

<-- 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?


  <Prev Next>  
Next> Last>>  
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 28 Jun 2020