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

International Character Set Support

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Published
July 2021
Language
English (United States)
Last Update
2021-07-28
dita:mapPath
xnf1627504141606.ditamap
dita:ditavalPath
xnf1627504141606.ditaval
dita:id
B035-1125
lifecycle
previous
Product Category
Teradata Vantage™

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.