https://info.teradata.com/htmlpubs/DB_TTU_16_00/General_Reference/B035-1098-160K/dyw1473446449359.ht... has the following statement:
The export width of Unicode columns with the UTF-8 client character set could limit PERM rows to less than 1 MB because record parcels are limited to 1 MB. This occurs because the default export width for Unicode columns with the UTF-8 client character set is 3 bytes per character. Change the export width to 2 bytes per character to work around this issue.
My question is: how to change export width in TPT and BTEQ?
Solved! Go to Solution.
See the International Character Set Support manual. You can't do it specifically for TPT or BTEQ, or a specific export.
You would use the ReplaceExportDefinition stored procedure to add a custom definition, and then specify that EXPORTWIDTH definition name at the user level (MODIFY USER).
See the International Character Set Support manual. You can't do it specifically for TPT or BTEQ, or a specific export.
You would use the ReplaceExportDefinition stored procedure to add a custom definition, and then specify that EXPORTWIDTH definition name at the user level (MODIFY USER).
Thank you @Fred,
So this is a user-level setting, can I apply it to at role level? I have a dozen of ETL IDs, it is easy to miss a few ID when I add new one to the group.
A custom export width definition can only be specified at the individual User level, and not at the Profile level.
(Role level is only for permissions.)