The UEN parameter specifies the value that defines %UEN% in a RESTORE/COPY operation. UEN is automatically generated during an archive.
where:
Syntax Element |
Definition |
n |
Utility event number, for example, UEN=12345 |
In a RESTORE/COPY statement, %UEN%, if used, is expanded using the Utility Event Number specified in UEN.
If FILEDEF is defined as follows in an environment variable or in a default configuration file:
FILEDEF=(archive,ARCHIVE_%UEN%.DAT)
then in the following Teradata ARC script, ARCHIVE is the internal name, and ARCHIVE_%UEN%.DAT is the external name:
ARCHIVE DATA TABLES (DB), RELEASE LOCK, FILE=ARCHIVE
The final external name of this ARC script is ARCHIVE_1234.DAT, assuming that the UEN is 1234. (The output of this archive displays the UEN.)
Therefore, if a restore is run with UEN=1234 and the above FILEDEF is used, the external name is ARCHIVE_1234.DAT in the following Teradata ARC script:
RESTORE DATA TABLES (DB), RELEASE LOCK, FILE=ARCHIVE