15.10 - EXPORTWIDTH - Teradata Database

Teradata Database SQL Data Definition Language Syntax and Examples

prodname
Teradata Database
vrm_release
15.10
created_date
December 2015
category
Programming Reference
featnum
B035-1144-151K

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

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. See Data Dictionary, B035-1092 for more information about DBC.ExportWidth.

export_definition_name
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.
Also see 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, 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.

Example: Creating a New User With an EXPECTED Export Width Table Name

This example creates a new user who is defined using the EXPECTED export width definition.

     CREATE USER fc1
     FROM r_n_d AS
     PERMANENT = 1000000,
     PASSWORD = bub279,
     SPOOL = 2200000,
     FALLBACK PROTECTION,
     DUAL AFTER JOURNAL,
     DEFAULT JOURNAL TABLE = r_n_d.journals,
     DEFAULT DATABASE = r_n_d,
     STARTUP = 'EXEC setpf;'
     ACCOUNT = '$mr_n_d','$hr_n_d',
     TIME ZONE = 'Africa Egypt'
     EXPORTWIDTH = EXPECTED;