Example 1: Using the INFILE and FORMAT Specifications - 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

This example specifies that the using data for the SELECT statement is contained in /home/fexpuser/tests/data1 and that the format of each record is binary.

.IMPORT INFILE /home/fexpuser/tests/data1
FORMAT BINARY
Layout layl;