UNIX and Windows Examples - FastExport

Teradata FastExport Reference

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

The following are examples of four ways to invoke FastExport on network‑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;'
  • Note: 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.