17.10 - Modifying a Custom Export Width Definition - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - Advanced SQL Engine International Character Set Support

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Release Date
July 2021
Content Type
Configuration
User Guide
Publication ID
B035-1125-171K
Language
English (United States)

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