Actions Performed by USING - Teradata Database - Teradata Vantage NewSQL Engine

SQL Data Manipulation Language

Product
Teradata Database
Teradata Vantage NewSQL Engine
Release Number
16.20
Published
March 2019
Language
English (United States)
Last Update
2019-05-03
dita:mapPath
fbo1512081269404.ditamap
dita:ditavalPath
TD_DBS_16_20_Update1.ditaval
dita:id
B035-1146
lifecycle
previous
Product Category
Teradata Vantage™

USING imports data rows from a client system as follows:

  1. Each value is retrieved from a client system-resident data source, such as a disk file, that you must specify using a client utility such as BTEQ.

    For example, if you submit a USING-modified request through BTEQ, you must precede the request with something like the following BTEQ command:

         .IMPORT DATA FILE=c:\temp\t1

    See Basic Teradata® Query Reference, B035-2414 for documentation on the .IMPORT command.

  2. The values are passed to Teradata Database as a data parcel along with the text of the request. Iterated requests can pack multiple data parcels with the text of a request.
  3. A value is substituted for each parameter name when the modified SQL request is processed.
You can import data from a client system by preceding any of the following SQL statements with a USING request modifier:
  • DELETE
  • INSERT
  • MERGE
  • SELECT
  • UPDATE

For exporting Teradata Database data to a client, the process is essentially the reverse of that used for data import.

You can export data to a client system using a client utility such as BTEQ and specifying the BTEQ .EXPORT command, then preceding a SELECT request to retrieve the data to be exported from Teradata Database with an appropriately specified USING request modifier.

See Basic Teradata® Query Reference, B035-2414 for documentation on the .EXPORT command.