16.20 - Before You Begin - 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 data values required in a query are normally entered as part of the query. The import mode allows you to enter a query containing one or more parameter markers. The data to be used in place of these parameter markers is read from a delimited text file. The query is submitted one time for every record in this input file. The entire query or selected portion is submitted as a single request.

Types of Statements You Can Issue

You can issue any SQL, Data Manipulation Language (DML) or Data Definition Language (DDL) statement containing one or more placeholders. The statement is executed one time for each record in the supplied import file. The placeholders are replaced with data values in the corresponding record of the file.

DML usually refers to INSERT, UPDATE, or DELETE statements. DDL statement usually refers to CREATE, DROP, ALTER, SHOW, HELP, and other statements.

Type of File You Can Import

The import file can be any delimited text file containing the correct number of data values in each record. You can create such a file from a query, using a text editor, or by saving spreadsheet data in a delimited text format.