16.10 - Modifying a Custom Export Width Definition - Teradata Database

Teradata Database International Character Set Support

prodname
Teradata Database
vrm_release
16.10
created_date
June 2017
category
Configuration
User Guide
featnum
B035-1125-161K

You can modify an export definition with the ReplaceExportDefinition stored procedure, using the same arguments shown in Creating a Custom Export Width Definition.

  1. Specify the name of an existing definition that you want to modify.
    You can modify only custom definitions that you create, and cannot modify the global default definitions EXPECTED, COMPATIBILITY and MAXIMUM.
  2. Specify a new export width rule set. All 40 digits are required, even if some of them have not changed.
  3. Execute the stored procedure.

    The new definition overwrites the old definition in the DBC.ExportWidth table.

The new export width definition takes effect at the next transaction for each affected user. In process transactions continue with the existing export width definition.

For information about the DBC.ExportWidth table, see Data Dictionary.