16.10 - Creating 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 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.