 |
 |
Archives of the TeradataForum
Message Posted: Mon, 09 Sep 2002 @ 19:47:20 GMT
| Subj: | | Re: Macro to loop thru different databases |
| |
| From: | | Dieter Nöth |
| | (2) Insert/select (note: this is *NOT* a multi-statement request): | |
| | create macro strangular.mac01 as
(
insert into target_table
select stuff from database1.customers;
insert into target_table
select stuff from database2.customers;
etc. ;); | |
It IS a multistatement request, because EVERY macro is a multistatement request, just look at EXPLAIN.
Dieter
| |
