USING imports data rows from a client system as follows:
- 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.
- 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.
- 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.