Setting the Global Export Width - Advanced SQL Engine - Teradata Database

International Character Set Support

Product
Advanced SQL Engine
Teradata Database
Release Number
17.05
17.00
Published
June 2020
Language
English (United States)
Last Update
2021-01-23
dita:mapPath
ywb1588027283948.ditamap
dita:ditavalPath
lze1555437562152.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 .