EXPORTWIDTH - Advanced SQL Engine - Teradata Database

SQL Data Definition Language Syntax and Examples

Product
Advanced SQL Engine
Teradata Database
Release Number
17.05
Published
January 2021
Language
English (United States)
Last Update
2021-01-22
dita:mapPath
ncd1596241368722.ditamap
dita:ditavalPath
hoy1596145193032.ditaval
dita:id
B035-1144
lifecycle
previous
Product Category
Teradata Vantage™

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 .