17.00 - How to Interpret ExportWidthRuleSet Column Values - Teradata Database

Teradata Vantageā„¢ - Data Dictionary

prodname
Advanced SQL Engine
Teradata Database
vrm_release
17.00
created_date
June 2020
category
Administration
Programming Reference
featnum
B035-1092-170K

The values stored in the ExportWidthRuleSet column represent the export width rule set for the current export width definitions (pre-defined and user-defined export width definitions). Each export width definition has its own rule set.

An export width rule set is the set of export width conversion multiplier values for all of the fields of the server character sets for a single export width definition. A total of 40 values make up the rule set for one export width definition.

Example Export Width Rule Sets

This is an example of the rule sets for the pre-defined export width definitions.

ExportDefinitionName	 ExportWidthRuleSet
---------------------    ------------------------------------------
EXPECTED                 1112211111222232222211121111112222322222 
MAXIMUM                  1322323221332232322321123111122322323222 
COMPATIBILITY            1112211111111231111111121111112222322222  

What Each Digit Indicates

A single digit in an export width rule set indicates two things:
  • The export width for the server character set.
  • The export width for the session character set.
You can easily identify the export width rules for a server character set. The same 10 digits are always used to indicate the export width rules for the same server character set.
  • First set of 10 digits: LATIN
  • Second set of 10 digits: UNICODE
  • Third set of 10 digits: KANJISJIS
  • Fourth set of 10 digits: GRAPHIC

Each of the 10 digits for a server character set are used to indicate the export width rule for the session character set. The same digit (based on the position of the digit) is always used to indicate the export width rule for the same session character set.

This table lists the export width rule indicated by each digit in the set of 10 digits used for each server character set.

With the exception of the UTF16 session character set export width, the possible values for every digit in an export width rule set are 1, 2, 3, or 4. The possible values for the UTF16 session character set digit are 2 or 4.
Digit (by position) Export Width For...
1
  • Any session character set that ends in the string _0I
  • The KATAKANAEBCDIC session character set
2 Any session character set that ends in the string _0U
3 Any session character set that ends in the string _0S
4 The session character set UTF16
The possible values for this digit are 2 or 4
5 The session character set UTF8
6 Any site-defined session character set with STATEMACHINE EUC1211
7 Any site-defined session character set with STATEMACHINE EUC1223
8 Any site-defined session character set with STATEMACHINE S80
9 Any site-defined session character set with STATEMACHINE S80A1E0
10 Any site-defined session character set with STATEMACHINE SOSI0E0F

If you know how the ExportWidthRuleSet column values are grouped and the meaning of each of the 10 digits described in this table, you can determine the export width for the current server character set and session character set.

This list gives the export width for an export width definition that has this rule set: 1112211111 2222322222 1112111111 2222322222.
  • When exporting from the LATIN server character set and the session character set is UTF8, the export width is 2. The digit that represents the export width for this combination of character sets is in the 5th position in the first set of 10 digits in the rule set.
    • 5th position digit indicates the UTF8 session character set.
    • First set of 10 digits indicates the LATIN server character set.
  • When exporting from the KANJISJIS server character set and the session character set is UTF16, the export width is 2. The digit that represents the export width for this combination of character sets is in the 4th position in the third set of 10 digits in the rule set.
    • 4th position digit indicates the UTF16 session character set.
    • Third set of 10 digits indicates the KANJISJIS server character set.