17.20 - Creating a Custom Export Width Definition - Advanced SQL Engine - Teradata Database

Teradata Vantageā„¢ - Advanced SQL Engine International Character Set Support

Advanced SQL Engine
Teradata Database
Release Number
June 2022
Last Update
Content Type
User Guide
Publication ID
English (United States)

You can create a custom export width definition by executing the ReplaceExportDefinition stored procedure, which is included with an installation of or upgrade to the current Vantage release.

The user executing the stored procedure must have EXECUTE privileges on the stored procedure or on the SYSLIB database.
  1. Supply values for the required stored procedure arguments. For example:
    Ex. call syslib.ReplaceExportDefinition('export_definition_name',


    Stored Procedure Argument Description
    export_definition_name A unique name for the custom export definition that conforms to the requirements for database object names.
    export_width_rule_set A byte string of 40 hexadecimal digits; 10 digits for each of the 4 server character sets. For the meaning of each position n the string, see Export Width Rules.

    Each position can have a value of 1, 2, 3, or 4, except the fourth position in each 10 character set (UTF16), which must have a value of either 2 or 4.

    xb The standard literal suffix.
    • x = hexadecimal
    • b = bytes
    msg The output value of the stored procedure.
  2. Execute the stored procedure.

    The system returns an error message for any arguments that are not valid. If all arguments are valid, the system writes the new rule set to the DBC.ExportWidth table.