17.05 - USING Support for Large Objects - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - SQL Data Manipulation Language

Advanced SQL Engine
Teradata Database
Release Number
Release Date
January 2021
Content Type
Programming Reference
Publication ID
English (United States)

The USING request modifier supports passing LOBs to the Vantage platform. The documentation for each Vantage-supported API specifies how this functionality is presented to the application.

You can specify three different modes for handling large objects by the USING request modifier:
  • Inline
  • Deferred
  • Locator

Deferred and locator modes defer the transfer of data between client and server, transmitting non-LOB data separately from LOB data. The appropriate deferred mode depends on the application. Neither deferred or locator mode passes the entire LOB field with the non-LOB data from a row.