Specifying REPORT Format - 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

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.