Purpose
Defines one or more variable parameter names used to import data to Teradata Database from a client system or to export data from Teradata Database to a client system. Also specifies how imported or exported LOB data is to be handled.
See also:
- Basic Teradata Query Reference
- Teradata SQL Assistant for Microsoft Windows User Guide
Required Privileges
None.
Syntax
Syntax Elements
- using_variable_name
- Name of a USING variable that is to be referenced as a parameter in the SQL request associated with the modifier.
- data_type
- Data type of the constant value substituted for using_variable_name.
- data_type_attribute
- One of the data type attributes listed below.
- AS DEFERRED
- LOB data is to be sent to Teradata Database from the client application when it is elicited, and separately from other row data.
- BY NAME
- Interpret the data in the USING row as a client file name. When the system detects the BY NAME option following AS DEFERRED, the following events occur in the order indicated:
- AS LOCATOR
- The client application passes a locator for the LOB, generated from a previous SELECT request for the session, to Teradata Database.
- SQL_request
- The SQL request with which the USING request modifier is associated.
ANSI Compliance
USING is a Teradata extension to the ANSI SQL:2011 standard.