17.10 - Export Width Rules - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - SQL Operators and User-Defined Functions

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Release Date
July 2021
Content Type
Administration
Programming Reference
Publication ID
B035-1210-171K
Language
English (United States)
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:

This position in a set of 10 digits... Is the conversion multiplier for....
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.