15.10 - ExportWidthV - Teradata Database

Teradata Database Data Dictionary

Product
Teradata Database
Release Number
15.10
Content Type
Administration
User Guide
Publication ID
B035-1092-151K
Language
English (United States)

Schema

DBC

 

View Column

Data Type

Format

Source Table.Column

ExportDefinitionName

VARCHAR(30) LATIN

NOT CASESPECIFIC

NOT NULL

X(30)

ExportWidth.ExportDefinitionName

ExportWidthRuleSet

BYTE(20)

NOT NULL

X(40)

ExportWidth.ExportWidthRuleSet

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.

    Note: 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

    Note: 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 (the digit in brown).
  • 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 (the digit in blue).
  • 4th position digit indicates the UTF16 session character set.
  • Third set of 10 digits indicates the KANJISJIS server character set.
  •  

    For more information about ...

    See ...

    export width and using the DBSControl utility to make export width definition changes

    International Character Set Support.

    using the ReplaceExportDefinition stored procedure to create user-defined export width definitions

    SQL Functions, Operators, Expressions, and Predicates.