17.10 - Creating 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 create a custom export width definition by executing the ReplaceExportDefinition stored procedure, which is included with an installation of or upgrade to the current Teradata Database 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',
    'export_width_rule_set'xb,msg);

    where:

    Stored Procedure Argument Description
    export_definition_name A unique name for the custom export definition that conforms to the requirements for Teradata 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 About 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.