UNIX and Windows Examples - FastExport

Teradata® FastExport Reference

Product
FastExport
Release Number
17.10
Published
June 2021
Language
English (United States)
Last Update
2021-07-01
dita:mapPath
qja1608578437326.ditamap
dita:ditavalPath
gel1618411995444.ditaval
dita:id
B035-2410
lifecycle
previous
Product Category
Teradata Tools and Utilities
The following are examples of four ways to invoke FastExport on workstation-attached UNIX and Windows client systems:
  • fexp < /home/fexpuser/tests/test1
    > /home/fexpuser/tests/out1 
    This command specifies both an input file and an output file:
    • /home/fexpuser/tests/test1 is the input file that provides the FastExport job script
    • /home/fexpuser/tests/out1 is the destination file for output data
  • fexp < /home/fexpuser/tests/test1

    This command specifies only an input file. In this case, the output is written to the standard output device, which is usually a terminal.

  • fexp

    This command specifies neither an input nor an output file. In this case, the terminal. provides both the command input and output data destination.

  • fexp -r '.RUN FILE exp.startup;' 

    Single quotes surrounding the above command line are only valid in a UNIX environment. Double quotes surrounding the above command line are valid in both the UNIX and Microsoft Windows environments.

    This command uses the -r invocation option to specify the FastExport RUN FILE command. In this case, the FastExport job script is in the exp.startup file.