Setting 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

Use the following procedure to set import options in the Options dialog. See Setting Export/Import Options for more information on setting the Export/Import tab and Setting Export Options for Export tab settings.

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

For more information, see Default Preferences (Options).

  1. Select Tools > Options.
  2. Click the Import tab.
  3. Select the options you want.
    Option Description
    Ignore the first record in the file (Skip Header)

    Skips the header when importing the file.

    The default is cleared.

    Convert localized decimal to a period on Import

    Replaces the local decimal point character with a period, allowing data in the local format to be imported to a database that always expects the decimal point to be a period. Clear this check box if the database expects the decimal point to be a localized character.

    The default value is cleared.

    Maximum batch size for simple imports

    The number of data rows that are sent to the database at one time for Batch Import.

    The default batch size is 20 rows.

    Silently discard rows that cause constraint violations

    SQL Assistant ignores any errors that occur during the import operation and reports the number of rows that were imported and the number of rows discarded.

    The default value is cleared.