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

Basic Teradata® Query Reference

prodname
Basic Teradata Query
vrm_release
17.00
created_date
June 2020
category
Programming Reference
featnum
B035-2414-220K

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.