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.
- Teradata Database supports the keyword DEFAULT as an export width definition string as well as the following predefined export width definition strings:
- 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.
- 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;