Archives of the TeradataForum
Message Posted: Fri, 18 Mar 2005 @ 09:48:28 GMT
| 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';
Dieter
| 
