FastExport supports the following variables.
Predefined System Variables
The following table lists the supported predefined system variables.
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 the 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:
- &SYSDAY
- &SYSDATE
- &SYSDATE4
- &SYSTIME
The original values are maintained after a FastExport restart operation.
Do not reference the values in numeric operations since the values are all character data types.