Archives of the TeradataForum
Message Posted: Wed, 27 Feb 2003 @ 00:57:30 GMT
| Subj: | | Re: Create temp inside a macro |
| |
| From: | | Barry Hull |
The only way that I'm aware of to do this is to use a "global temporary table". If you define a global temporary table definition and
then in your macro simply reference that table, the table will be substantiated when it's referred to. So, if you want to create the table
and load it with some rows via an insert/select, you could simply code the insert/select into the global temporary table and it will be
substantiated for your session as part of the insert/select.
In this case you wouldn't need to check for the existence of the table at the beginning of the macro because it will exist (if it
doesn't, it will automatically be created). If there is a chance that the table will still contain rows and you want to make sure it's
empty, put a "delete all" at the beginning of your macro.
You can set the global temporary table up to delete rows automatically at the end of the unit of work or keep the rows. In any case, the
substantiated instance for your session will disappear once you end your session.
Don't know if this is what you're looking for, but I hope it helps.
Barry
| 
