Different types of exports can be created using a combination of the EXPORT command along with one of the response mode commands (INDICATORMODE, LARGEDATAMODE, or RECORDMODE). The format (DATA, INDICDATA, REPORT, or DIF) specified in the EXPORT command determines how data will be written to the export file. The response mode command determines the format of the data returned by the database.
To produce Record Mode output in a readable hex format to a text export file, specify REPORT for the EXPORT format type and then turn the RECORDMODE command on.
To produce Indicator Mode output in a readable hex format to a text export file, specify REPORT for the EXPORT format type and then turn the INDICATORMODE command on.
To produce Multipart Indicator Mode output in a readable hex format to a text export file, specify REPORT for the EXPORT format type and then turn the LARGEDATAMODE command on.
To produce an export file in Field Mode without any column titles or titledashes, specify DATA for the EXPORT format type and then turn the RECORDMODE command off. On z/OS, when the dataset supports ASA carriage-control characters (as indicated by usage of FBA/VBA), and FORMAT is set to OFF, BTEQ considers the contents being written out to be data in text format as opposed to a report. So it will use a space for all ASA carriage control characters. For 16.00 BTEQ, this behavior requires the use of efix version 16.00.00.01.
On Windows, backdoor export files may not include carriage returns, since BTEQ is writing the data exactly how it is sent from the database.