How to Interpret ExportWidthRuleSet Column Values - Teradata Vantage

Teradata® VantageCloud Lake
Deployment
VantageCloud
Edition
Lake
Product
Teradata Vantage
Published
January 2023
Language
English (United States)
Last Update
2024-04-03
dita:mapPath
phg1621910019905.ditamap
dita:ditavalPath
pny1626732985837.ditaval
dita:id
phg1621910019905

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

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