You can define the source of export widths for a user with the CREATE USER or MODIFY USER statement, for example:
CREATE USER username
...
EXPORTWIDTH = ‘export_width_definition_name’;
where export_width_definition_name can be:
- One of the standard export width tables used for DBSControl settings:
- EXPECTED
- COMPATIBILITY
- MAXIMUM
- DEFAULT (defers to the current DBSControl global setting)
- A custom ExportDefinitionName name. See Creating a Custom Export Width Definition.
See “CREATE USER” in Teradata Vantage™ - SQL Data Definition Language Syntax and Examples, B035-1144.