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.