Setting Export Options - SQL Assistant

Option

Description

Write all exported answer sets to a single file

Writes the output from a query that contains multiple select statements to a single file. The default value of this option is cleared, meaning output from a query that contains multiple select statements is written to multiple files.

Write the SQL and result status to the export file

Writes the SQL and result status to the export file. The result status is the rows processed, elapsed time, and error messages (if any occurred). The default value of this option is cleared, meaning the SQL and result status is not written to the export file.

Write column headers to the export file

Writes column headers to the export file before the data is written. Clearing this option might be useful if you plan to Import the data back into the database at a later time. If this option is not selected, no column headers are written.
The default value is selected.

Replace Carriage Returns in column data with blanks

Replaces carriage returns in column data with blanks when exporting to text files. If this option is not selected, carriage returns are left as is.
The default value is cleared.

Write Byte Order Mark [BOM] to unicode export files

When selected, all unicode or UTF8 export files include a BOM at their beginning.
The default value is selected.

Include a Row Number column in Microsoft Access export tables

When selected, an AutoNumber column is defined as the first column of a new export table. This column contains the row number of that row.
The default value is selected.

Honor the Answerset row return limit during exports

When selected, exported result sets are terminated when they reach the Maximum Row Limit set on the Answer tab. If there are multiple result sets, the limit applies to each individual set.
The default value is cleared.