16.20 - About Export Width - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - SQL Operators and User-Defined Functions

Product
Advanced SQL Engine
Teradata Database
Release Number
16.20
Release Date
April 2020
Content Type
Administration
Programming Reference
Publication ID
B035-1210-162K
Language
English (United States)

The number of characters or bytes the Teradata Database exports can exceed or be less than the number of characters or bytes the client application expects to receive unless the export width is set properly. The export width defines how the system reserves space for each character field in result set rows returned to Teradata clients.

You can set the DBS Control field, Export Width Table ID, to define the default export width the system uses when returning a result set to a client. For more information, see “DBS Control (dbscontrol)” in Teradata Vantage™ - Database Utilities , B035-1102 .

You can override the system-level export width by using the EXPORTWIDTH option in the CREATE USER or MODIFY USER statements. The EXPORTWIDTH option accepts the following values:

Export Definition Name Description
'Expected' Provides reasonable default widths for the character data type and client form of use.
'Compatibility' Enables Unicode data to be processed by applications that are written to process Latin or KANJI1 data.
'Maximum' Provides maximum default width of the character data type and client form of use.
'user-defined name ' Provides user-defined default widths for the character data type and client form of use.
DEFAULT Uses the setting of the DBS Control field: Export Width Table ID.
You can use the ReplaceExportDefinition stored procedure to:
  • Create a new user-defined export definition name and the associated export width rules.
  • Update the export width rules associated with an existing user-defined export definition name.

You can use the RemoveExportDefinition stored procedure to delete a user-defined export definition name and the associated export width rules.

For more information about... See...
export widths and creating user-defined export width definitions Teradata Vantage™ - Advanced SQL Engine International Character Set Support, B035-1125.
specifying a user-level export width setting “CREATE USER” or “MODIFY USER” in Teradata Vantage™ - SQL Data Definition Language Syntax and Examples, B035-1144.
setting the system default for the export width “DBS Control (dbscontrol)” in Teradata Vantage™ - Database Utilities , B035-1102 .