Submit Output as Input | Specify REPORT Format | Basic Teradata Query - Specifying REPORT Format - Basic Teradata Query

Basic Teradata® Query Reference

Product
Basic Teradata Query
Release Number
17.00
Published
December 2020
Language
English (United States)
Last Update
2020-12-12
dita:mapPath
zqt1544831938740.ditamap
dita:ditavalPath
obe1474387269547.ditaval
dita:id
B035-2414
lifecycle
previous
Product Category
Teradata Tools and Utilities

If REPORT format is specified for the EXPORT command, set the BTEQ FORMAT command option to OFF before entering the SQL SELECT statements. This makes it easier to manually reformat the file later.

In REPORT format, BTEQ uses Field Mode to return all data values, including numeric data, in character format. Un-intended results might occur with numeric data fields when this data is re-imported.