Archives of the TeradataForum
Message Posted: Thu, 01 Aug 2002 @ 06:22:39 GMT
| Subj: | | Re: Volatile table & VB |
| |
| From: | | Barbara George |
Volatile tables are only available for the session in which they are created (unless the rows are preserved as Margaret replied) and the
3 commands from VB are possibly treated as 3 sessions, so the results are not available to the second/third statements.
Where possible I create macros which handle all parameters and run all commands as 1 session. Sometimes the main macro merely calls
subsidiary macros but it is all handles as 1 call from the source program.
Barbara
| 
