Actions Performed by USING - Analytics Database - Teradata Vantage

SQL Data Manipulation Language

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
VMware
Product
Analytics Database
Teradata Vantage
Release Number
17.20
Published
June 2022
Language
English (United States)
Last Update
2024-04-05
dita:mapPath
pon1628111750298.ditamap
dita:ditavalPath
qkf1628213546010.ditaval
dita:id
esx1472246586715
lifecycle
latest
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 the 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 Vantage 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 Vantage with an appropriately specified USING request modifier.

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