Export Width Rules - Teradata Vantage

Teradata® VantageCloud Lake
Deployment
VantageCloud
Edition
Lake
Product
Teradata Vantage
Published
January 2023
ft:locale
en-US
ft:lastEdition
2024-12-11
dita:mapPath
phg1621910019905.ditamap
dita:ditavalPath
pny1626732985837.ditaval
dita:id
phg1621910019905
export_width_rule_set is a BYTE string of 40 hexadecimal digits with the following format:
  • The 1st ten digits define the export width for LATIN strings.
  • The 2nd ten digits define the export width for UNICODE strings.
  • The 3rd ten digits define the export width for KANJISJIS strings.
  • The 4th ten digits define the export width for GRAPHIC strings.
For example, if export_width_rule_set is '1112211111222232222211121111112222322222'XB, then:
  • The 1st ten digits (1112211111) define the export width for LATIN strings.
  • The 2nd ten digits (2222322222) define the export width for UNICODE strings.
  • The 3rd ten digits (1112111111) define the export width for KANJISJIS strings.
  • The 4th ten digits (2222322222) define the export width for GRAPHIC strings.

Each position in a set of 10 digits specify the export width conversion multiplier for a session character set:

Position in 10-Digit Set To What Conversion Multiplier Applies
1st
  • Any session character set that ends in the string '_0I'.
  • The session character set 'KATAKANAEBCDIC'.
2nd Any session character set that ends in the string '_0U'.
3rd Any session character set that ends in the string '_0S'.
4th The session character set 'UTF16'.
5th The session character set 'UTF8'.
6th Any site-defined session character set with STATEMACHINE EUC1211.
7th Any site-defined session character set with STATEMACHINE EUC1223.
8th Any site-defined session character set with STATEMACHINE S80.
9th Any site-defined session character set with STATEMACHINE S80A1E0.
10th Any site-defined session character set with STATEMACHINE SOSI0E0F.

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

For example, if export_width_rule_set is '1112211111222232222211121111112222322222'XB:
  • When exporting from the LATIN server character set (1st set of 10 digits, 1112211111), for the UTF8 session character set (the 5th position in the 1st set of 10 digits), the export width is 2.
  • When exporting from the UNICODE server character set (2nd set of 10 digits, 2222322222), for the UTF8 session character set (the 5th position in the 2nd set of 10 digits), the export width is 3.
  • When exporting from the KANJISJIS server character set (3rd set of 10 digits, 1112111111), for the UTF16 session character set (the 4th position in the 3rd set of 10 digits), the export width is 2.