Import Rules
The following import rules are important:
If the option Submit only the selected Query text, when highlighted is selected in the Options dialog box, only the highlighted portion of the query
is submitted. For more information, see also “Submitting Part of a Query” on page 78.
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” on page 131.
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” on page 131.
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.
Alternatively, you can create the file using a text editor or by saving a spreadsheet
in the appropriate delimited format.