Type 2: Direct Substitution - 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

This form applies to all other statements. Parameter markers can be used anywhere in the query. The data values are directly edited into the SQL at the parameter positions. Therefore, some parameter markers might need to be enclosed in quotes.

Create User ? As Perm=0 Password=? Account=’?’

In Direct Substitution, only the “?” parameter is valid.

If an IMPORT statement returns data, the results are written to a file whose name is formed by adding .Log to the end of the import file name. If this file already exists, its contents are replaced with new results. A header record containing the first data value from the corresponding import record is written before each set of returned data.