Setting the Global Export Width - 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 the DBS Control utility to set field 23, the Export Width Table ID field, to define the default export width definition the system uses when returning a result set to a client.

Export Width Table ID DBSControl Setting Description
Expected Defaults
(default setting) 0 Provides reasonable default widths for the character data type and client form of use.
Compatibility Default 1 Enables Unicode data to be processed by applications that written to process Latin or KANJI1 data.
Maximum Default 2 Provides maximum default width of the character data type and client form of use.

Also see the next topic, About Export Width Rules, and “Export Width Table ID” in Teradata Vantage™ - Database Utilities, B035-1102.