In addition to the output data destination, FastExport accesses four different data sets/files or input/output devices. The following table lists Data Sets, Files and Devices for Teradata FastExport.
Data Set/File or Device | Provides |
---|---|
Standard input | FastExport commands and Teradata SQL statements that make up a FastExport job |
Standard output | Destination for FastExport output responses and messages |
Standard error | Destination for FastExport errors |
Configuration | Optional specification of FastExport utility default values |
When running FastExport in interactive mode, the terminal keyboard functions as the standard input device and the display screen is the standard output/error device. When running FastExport in batch mode, a data set or file name must be specified for each of these functions. The method of doing this varies, depending on the configuration of the client system:
- On workstation-attached client systems, use the standard redirection mechanism (< infilename and > outfilename), the recommended approach, to specify the FastExport files when invoking the utility. Teradata FastExport script files can also be piped to Teradata FastExport when invoking the utility.
- On mainframe-attached client systems, use standard z/OS JCL control statements (DD) to allocate and create the FastExport data sets or files before invoking the utility.On z/OS client systems, the export file should not be a member of a partitioned data set (PDS). If it is, and a database or client system failure interrupts the FastExport job, the restart operation will fail.