EXPORTWIDTH - Advanced SQL Engine - Teradata Database

SQL Data Definition Language Syntax and Examples

Product
Advanced SQL Engine
Teradata Database
Release Number
17.00
Published
September 2020
Language
English (United States)
Last Update
2021-01-23
dita:mapPath
wgr1555383704548.ditamap
dita:ditavalPath
lze1555437562152.ditaval
dita:id
B035-1144
lifecycle
previous
Product Category
Teradata Vantage™

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 .