Specifying an Import File - Basic Teradata Query

Basic Teradata Query Reference

Product
Basic Teradata Query
Release Number
16.20
Published
October 2018
Language
English (United States)
Last Update
2020-02-20
dita:mapPath
kil1527114222313.ditamap
dita:ditavalPath
Audience_PDF_include.ditaval
dita:id
B035-2414
lifecycle
previous
Product Category
Teradata Tools and Utilities

An import file is an input file that is used primarily for writing new data to the Teradata Database. BTEQ transfers the import file data to the Teradata Database in response to the USING modifier in a Teradata SQL request.

The following table explain how to specify an import file:

System Type Import File
Mainframe-attached Use a z/OS DD statement to define an import file, then execute a BTEQ IMPORT command to open the file before entering an SQL request.
Workstation-attached Import files do not have to be defined, but the IMPORT command must be used to open an import file before submitting an SQL request.