Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Fri, 18 Mar 2005 @ 09:48:28 GMT

  <Prev Next>   <<First <Prev

Subj:   Re: Changing a default database within a macro
From:   Dieter Noeth

Naveen Ram Prasanna Kambhoji wrote:

  I tried executing the statement  

          Show qualified exec mymacro;
  But throws an error "something expected between the qualified keyword and exec keyword".  

I don't know in which version they enhanced the syntax to allow "show exec macro", but you can retrieve the same info be querying the system tables:

     sel createtext from dbc.tvm
     where tvmname = 'mymacro';


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