Export Data from Aster | Teradata Studio - Exporting Data from Aster - Teradata Studio

Teradata® Studio™ User Guide

Product
Teradata Studio
Release Number
17.00
Published
January 2021
Language
English (United States)
Last Update
2021-01-11
dita:mapPath
lex1576517377362.ditamap
dita:ditavalPath
ft:empty
dita:id
B035-2041
lifecycle
previous
Product Category
Teradata Tools and Utilities
  1. Open Data Source Explorer, right-click the table name and select Data > Export Data.
  2. Select External File as the Destination Type and click Launch.
  3. Click Browse and specify and Output File.
  4. Select a File Type from the drop-down menu.
  5. [Optional] Select the Column Labels in First Row check box to specify to use the first row of data as the column labels for the new table.
  6. If you selected Delimited Text as the file type:
    Field Description
    Column Delimiter Type of delimiter to use in the output file using the list. The options are:
    • Comma
    • Semicolon
    • Space
    • Tab
    • | (vertical bar)
    Character String Delimiter Distinguishes a string text. The options are:
    • " (double-quotes)
    • ' (single quote)
    • None
    File Encoding Character set used to encode the data. The options are:
    • UTF-8
    • utf-16
    • ISO-8859-1
    • UTF-16BE
    • UTF-16LE
    • US-ASCB
    • Cp1252

    If you selected Excel (.xlsx) or Excel 97-2003 (.xls), there are no additional options to complete.

  7. Click Next then indicate how to filter data for each column to be exported:
    Option Action
    Filter by a column Check the box beside the column name
    Filter by data For each table column select a filter value from the Select By list and type the paired value. For example, the filter "> 200"" includes only those values greater than the numeric value 200.
  8. [Optional] Click Next to preview the generated SQL.
  9. Click Finish.