Actions Performed by USING - Advanced SQL Engine - Teradata Database

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.

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.