16.10 - Viewing the Current Export Widths for a Session - Teradata Database

Teradata Database International Character Set Support

prodname
Teradata Database
vrm_release
16.10
created_date
June 2017
category
Configuration
User Guide
featnum
B035-1125-161K

You can use HELP SESSION to view the current export widths for the session. Based on the rule set shown in About Export Width Rules, and an EXPECTED user default export width, the request returns output similar to the following:

HELP SESSION ;
User Name SPEC2
Account Name DBC
Logon Date 02/08/11
Logon Time 10:58:56
Current DataBase DBC
Collation UTF8
Character Set UTF8
Current DateForm IntegerDate
Session Time Zone -08:00
Default Character Type LATIN
Export Latin 2
Export Unicode 3
Export Unicode Adjust 0
Export KanjiSJIS 1
Export Graphic 3
Export Width Rules 2313
...

where:

Value Description
Export Latin 2 Reports the export width value for each server character data type for the session character set (UTF8).
A 0 value means that character conversion between server and client character sets is not possible, for example, from Graphic (double-byte) to ASCII (single-byte).
Export Unicode 3
Export Unicode Adjust 0
Export KanjiSJIS 1
Export Graphic 3
Export Width Rules 2313 The export width values for converting the session character set to Latin, Unicode, KanjiSJIS, and Graphic.
No export width is reported for the Kanji1 character data type because the export width is always 1.