Archives of the TeradataForum
Message Posted: Tue, 14 Sep 1999 @ 14:47:17 GMT
| Subj: || || Re: Archive Processing |
| From: || || Fred Pluebell |
The utility processes statements in sequence. If you are using multiple COPY statements (one per table), then the input DD will be
closed when the first statement completes. If the second COPY statement happens to reference the same DDNAME, it will be re-opened for
input. This requires repositioning to the start of the dataset; I think NOREWIND would only defer this from the CLOSE to the subsequent
OPEN. If you are restoring a list of tables in the same COPY statement, then one sequential pass should be sufficient.
Yes, the Archive utility requires a TDP to be available, even if you are only doing something like ANALYZE. The same is currently true
of the SQL Pre-Processor PP2.