The number of characters or bytes the 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 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 | This is set by the system. |
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.