17.10 - EXPORTWIDTH - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - SQL Data Definition Language Syntax and Examples

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Release Date
July 2021
Content Type
Programming Reference
Publication ID
B035-1144-171K
Language
English (United States)

The export width for this user, enclosed in SINGLE QUOTATION MARK characters.

Vantage uses the value you assign to a user as a NUPI to access DBC.ExportWidth, which defines the rules associated with the different export width definitions for Latin, Unicode, KanjiSJIS, and Graphic strings. See Teradata Vantage™ - Data Dictionary, B035-1092 for more information about DBC.ExportWidth.

export_definition_name
Vantage supports the keyword DEFAULT as an export width definition string as well as the following predefined export width definition strings:
  • COMPATIBILITY
  • EXPECTED
  • MAXIMUM
For a detailed description of the valid export width specifications, see Valid Export Width Specifications.
Also see Teradata Vantage™ - Advanced SQL Engine International Character Set Support, B035-1125 for detailed information about export widths and how to define your own export width table.
DEFAULT
If you do not specify an EXPORTWIDTH value for a user or specify the keyword DEFAULT, Vantage uses the export width currently specified by the DBSControl Export Width Table ID parameter. See Export Width Table ID in Teradata Vantage™ - Database Utilities, B035-1102.