How to Specify an Import File in BTEQ | Basic Teradata Query - Specifying an Import File - Basic Teradata Query

Basic Teradata® Query Reference - 20.00

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
Lake
VMware
Product
Basic Teradata Query
Release Number
20.00
Published
October 2023
ft:locale
en-US
ft:lastEdition
2025-04-02
dita:mapPath
gxl1691484661681.ditamap
dita:ditavalPath
obe1474387269547.ditaval
dita:id
psp1479308573013
Product Category
Teradata Tools and Utilities

An import file is an input file that contains data records to be transferred along with associated SQL requests that contain a USING modifier. That clause maps out how each record is to be interpreted for expansion of the statements to be processed by Analytics Database.

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.