17.00 - EXPORTWIDTH - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - SQL Data Definition Language Syntax and Examples

Product
Advanced SQL Engine
Teradata Database
Release Number
17.00
Release Date
September 2020
Content Type
Programming Reference
Publication ID
B035-1144-170K
Language
English (United States)

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. For more information about DBC.ExportWidth, see Teradata Vantage™ - Data Dictionary, B035-1092.

export_definition_name
Export width for this user, enclosed in SINGLE QUOTATION MARK characters.
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.
For detailed information about export widths and how to define your own export width table, see Teradata Vantage™ - Advanced SQL Engine International Character Set Support, B035-1125.
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 .