16.20 - Import Rules - 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
The following import rules are important:
  • If the option Submit only the selected Query text, when highlighted is selected in the Options dialog, only the highlighted portion of the query is submitted. For more information, see also Submitting Part of a Query.
  • The query might contain multiple statements only if it contains Teradata INSERT, UPDATE, or DELETE statements. For other databases, or statements, it is limited to a single SQL statement.
  • The import file must be a delimited text file containing data values that are separated from each other with a delimiter character. To set the delimiter character, see Setting Export/Import Options.
  • The number of data values on each record must be the same as the number of parameter markers in the SQL query.
  • The maximum number of parameters in a query is database dependent. For Teradata V2R5, it is 2,048.
  • The data values must be enclosed within quotes unless the Export option Enclose Exported/Imported Column Data in is set to None. To set this option, see Setting Export/Import Options.
  • Data values must not contain the delimiter character unless they are enclosed in quotes. Data values that are enclosed in quotes must not contain the delimiter character as their first character.
  • Data values must not contain carriage return (end of line) characters.
  • Date, time and timestamp values must be in the following format:
    • YYYY-MM-DD
    • HH:MM:SS
    • YYYY-MM-DD HH:MM:SS

    When using an ODBC connection with a Teradata data source, they must be in the format specified for the corresponding column on the CREATE TABLE statement. Either ‘-‘ or ‘/’ can, however, be used as the date separator.

You can create the import file using the export feature of Teradata SQL Assistant. Be sure when importing the file to select the option to skip the first row (header) of the file. See Skipping the First Line (Header) of Imported Files.

Alternatively, you can create the file using a text editor or by saving a spreadsheet in the appropriate delimited format.