Run File (-r) Parameter - 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 typical selection is:

fexp -r '.RUN FILE fexp.startup;' < infilename > outfilename

Sample Command:

fexp -r '.run file logon;' < job.fexp

Sample Output:

 ========================================================================
     =                                                                      =
     =          FastExport Utility    Release FEXP.15.10.00.00												=
     =          Platform WIN32                                              =
     =          PID      19396                                              =
     =                                                                      =
     ========================================================================
     =                                                                      =
     =     Copyright 1990-2015 Teradata Corporation. ALL RIGHTS RESERVED.   =
     =                                                                      =
     ========================================================================
**** 16:07:26 UTY2411 Processing start date: FRI JAN 10, 2014
     ========================================================================
     =                                                                      =
     =          Logon/Connection                                            =
     =                                                                      =
     ========================================================================
0001 .run file logon;
0002 .logtable testrunfile;
0003 .logon TDPID/FEXPUSER,;
**** 16:07:31 UTY8400 Teradata Database Release: 15.00.00.00
**** 16:07:31 UTY8400 Teradata Database Version: 15.00.00.00
**** 16:07:31 UTY8400 Default character set: ASCII
**** 16:07:31 UTY8400 Current RDBMS has UDT support
**** 16:07:31 UTY8400 Current RDBMS has Large Decimal support
**** 16:07:31 UTY8400 Current RDBMS has Statement Info Parcel support
**** 16:07:31 UTY8400 Current RDBMS has FEXP w/o Spooling support
**** 16:07:31 UTY8400 Current RDBMS has TASM support
**** 16:07:31 UTY8400 Maximum supported buffer size: 1M
**** 16:07:31 UTY8400 Data Encryption supported by RDBMS server
**** 16:07:34 UTY6211 A successful connect was made to the RDBMS.
**** 16:07:34 UTY6217 Logtable 'FEXPUSER.testrunfile' has been created.