Variables - FastExport

Teradata FastExport Reference

Product
FastExport
Release Number
15.00
Language
English (United States)
Last Update
2018-09-28
dita:id
B035-2410
lifecycle
previous
Product Category
Teradata Tools and Utilities

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.

 

Table 7: System Variables 

Variable Name

Description

&SYSDATE

Eightcharacter date in yy/mm/dd format

&SYSDATE4

Tencharacter date in yyyy/mm/dd format

&SYSDAY

Threecharacter uppercase day of week specification: MON, TUE, WED, THU, FRI, SAT, or SUN

&SYSOS

Client operating system:

  • For z/OS: VS1, z/OS, z/OS/SP, z/OS/ES
  • UNIX OS
  • Win32
  • &SYSRC

    Completion code of the last response from Teradata Database

    &SYSTIME

    Eightcharacter time in hh:mm:ss format

    &SYSUSER

    Client system dependent:

  • z/OS batch userid. (z/OS batch returns userid only when a security package such as RACF, ACF2, or Top Secret has been installed).
  • 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.

    Note: Do not reference the values in numeric operations since the values are all character data types.