Client Application Restrictions on USING With Large Objects - Advanced SQL Engine - Teradata Database

SQL Data Manipulation Language
Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Published
July 2021
ft:locale
en-US
ft:lastEdition
2021-07-27
dita:mapPath
vjt1596846980081.ditamap
dita:ditavalPath
vjt1596846980081.ditaval
dita:id
B035-1146
lifecycle
previous
Product Category
Teradata Vantage™
The following client applications support USING with large objects with no restrictions:
  • CLIv2
  • Archive/Recovery

The following client applications support USING with large objects with the noted restrictions:

Application Restrictions
BTEQ Inline mode only.
Teradata Parallel Transport Deferred and Locator modes for these operators only:
  • DataConnector
  • SQL Inserter
  • SQL Selector
  • The following Teradata Tools and Utilities applications do not support USING with large objects:
    • FastLoad
    • FastExport
    • MultiLoad
    • Embedded SQL
  • Vantage stored procedures do not support USING with large objects.

Consult the appropriate documentation for additional restrictions on LOB use with Vantage features.