Query Development | Set Export Preferences | Teradata Studio/Studio Express - Setting Export Preferences - Teradata Studio

Teradata® Studio™ Express User Guide - 17.20

Teradata Studio
Release Number
September 2022
English (United States)
Last Update
Product Category
Teradata Tools and Utilities
Use the Export Preferences dialog to specify export file settings.
"Append" and "Replace" functionality are independent of this preference. If no changes are made to the export file settings, "append" and "replace" will happen in the same file.
  1. Select Window > Preferences > Teradata Datatools > Export.
  2. Set any of the following export file settings:
    1. Select Open After Export is Complete to open the file after export operation completes.
    2. Select Write Byte Order Mark [BOM] to Unicode Export Files to include BOM data in exported Unicode files.
    3. Select Write SQL and Result Status to the Export File to include SQL and result status data in exported files.
    4. Select Write all Exported result sets to a single file to export multiple results sets into a single file.
    5. Do the following in the Excel Export Options section:
      1. Select Alternate Row Colors to alternate row background colors when exporting to Excel. Select a different background color by clicking color. The default for this option is cleared.
      2. In Big Int/Decimal Format, select an output format for Big Integers and Decimals. If you choose number, some precision may be lost. The default for this option is String.
  3. Click Apply, then OK to save your changes.