15.10 - EXPORTWIDTH - Teradata Database

Teradata Database SQL Data Definition Language Syntax and Examples

Product
Teradata Database
Release Number
15.10
Published
December 2015
Content Type
Programming Reference
Publication ID
B035-1144-151K
Language
English (United States)
Last Update
2018-06-05

Teradata Database 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 Data Dictionary, B035-1092.

export_definition_name
Export width for this user, enclosed in SINGLE QUOTATION MARK characters.
Teradata Database 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 International Character Set Support, B035-1125.
DEFAULT
If you do not specify an EXPORTWIDTH value for a user or specify the keyword DEFAULT, Teradata Database uses the export width currently specified by the DBSControl Export Width Table ID parameter. See Export Width Table ID in Utilities, B035-1102.