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.