UNIX and Windows Examples | Stand Alone utility - UNIX and Windows Examples - FastExport

Teradata® FastExport Reference - 20.00

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
Lake
VMware
Product
FastExport
Release Number
20.00
Published
October 2023
ft:locale
en-US
ft:lastEdition
2024-03-18
dita:mapPath
jaa1691573250507.ditamap
dita:ditavalPath
gel1618411995444.ditaval
dita:id
rto1478610027076
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 this command line are only valid in a UNIX environment. Double quotes surrounding the previous 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.