Viewing the Current Export Widths for a Session - Advanced SQL Engine - Teradata Database

International Character Set Support

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Published
July 2021
Language
English (United States)
Last Update
2021-07-28
dita:mapPath
xnf1627504141606.ditamap
dita:ditavalPath
xnf1627504141606.ditaval
dita:id
B035-1125
lifecycle
previous
Product Category
Teradata Vantageā„¢

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.