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