15.00 - About Export Widths - Teradata Database

Teradata Database SQL Functions, Operators, Expressions, and Predicates

Product
Teradata Database
Release Number
15.00
Content Type
Programming Reference
Publication ID
B035-1145-015K
Language
English (United States)
Last Update
2018-09-24

About Export Widths

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 Utilities: Volume 1 (A-K).

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

    International Character Set Support.

    specifying a user-level export width setting

    “CREATE USER” or “MODIFY USER” in SQL Data Definition Language.

    setting the system default for the export width

    “DBS Control (dbscontrol)” in Utilities: Volume 1 (A-K).