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 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. |
- 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. |