Setting Export Preferences - Teradata Studio

Teradata® Studio™ User Guide

Product
Teradata Studio
Release Number
16.20
Published
September 2019
Language
English (United States)
Last Update
2019-10-10
dita:mapPath
pfg1542649412202.ditamap
dita:ditavalPath
ft:empty
dita:id
B035-2041
lifecycle
previous
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.