Setting Export/Import Options - Teradata SQL Assistant

Teradata® SQL Assistant for Windows User Guide

Product
Teradata SQL Assistant
Release Number
16.20
Published
October 2018
Language
English (United States)
Last Update
2020-01-03
dita:mapPath
gfk1537201040714.ditamap
dita:ditavalPath
ft:empty
dita:id
B035-2430
Product Category
Teradata Tools and Utilities

This section explains the Export/Import tab in the Options dialog. See Setting Export Options for more information on setting the Export tab and Setting Import Options for setting the Import tab.

After selecting any of these options, follow the instructions on Exporting Results to learn how to export results.

After exporting an Answerset, the status bar across the bottom of the main window provides the status of the action.

For more information, see Default Preferences (Options).

  1. Select Tools > Options.
  2. Click the Export/Import tab.
  3. Select the options you want.
    Option Description
    Use this delimiter between columns Defines the column delimiter. The default value is Tab. This same character is expected to delimit the data fields in an Import file. For Import operations, make sure this character does not occur within any of the data fields unless all data values are enclosed in quotes.
    Enclose column data in
    • Double Quotes – Encloses column data values in double-quotes.
    • Single Quotes – Encloses column data values in single-quotes.
    • Nothing – The data values are not enclosed in quotes. This is the default value.