Specifying an Export 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 export file is an output file that is used primarily for storing data read from a Teradata Database in response to an SQL request.

The following table explains how to specify an export file:

System Type Export File
Mainframe-attached Use a z/OS DD statement to define an export file, then execute a BTEQ EXPORT command to open the file before entering an SQL request.

If an export file name is not defined, the default file name for the exported data is FILE ddname.

SYSPRINT is not a valid ddname for the BTEQ EXPORT command. Data cannot be exported to the SYSPRINT file.
Workstation-attached Export files do not have to be defined, but the EXPORT command must be used to open an export file before submitting an SQL request.