Variables
FastExport supports the following variables.
Predefined System Variables
Table 7 lists the supported predefined system variables.
Note: System variables can only be referenced. They cannot be modified.
Variable Name |
Description |
&SYSDATE |
Eight‑character date in yy/mm/dd format |
&SYSDATE4 |
Ten‑character date in yyyy/mm/dd format |
&SYSDAY |
Three‑character uppercase day of week specification: MON, TUE, WED, THU, FRI, SAT, or SUN |
&SYSOS |
Client operating system: |
&SYSRC |
Completion code of the last response from Teradata Database |
&SYSTIME |
Eight‑character time in hh:mm:ss format |
&SYSUSER |
Client system dependent: |
Date and Time Variables
The four date and time variables reflect the time when FastExport begins execution:
The original values are maintained after a FastExport restart operation.
Note: Do not reference the values in numeric operations since the values are all character data types.