UNIX and Windows Examples - FastExport

Teradata® FastExport Reference

Product
FastExport
Release Number
16.20
Published
September 2020
Language
English (United States)
Last Update
2020-09-11
dita:mapPath
lki1527114222329.ditamap
dita:ditavalPath
obe1474387269547.ditaval
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;' 

    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.