Setting the Byte Order Mark - Parallel Transporter

Teradata® Parallel Transporter Reference

Product
Parallel Transporter
Release Number
17.00
Published
November 2020
Language
English (United States)
Last Update
2022-02-03
dita:mapPath
ric1544831938741.ditamap
dita:ditavalPath
obe1474387269547.ditaval
dita:id
B035-2436
lifecycle
previous
Product Category
Teradata Tools and Utilities

Use this feature to write a BOM at the beginning of a data file. The actual BOM written is determined by the character set in use and, when using UTF-16, the endian aspect of the active platform. BOMs are detected when data is read back to ensure correct processing.

The following conditions must be met:

  • The operator must be a consumer
  • A Unicode character set must be specified in the script (for example, USING CHARACTER SET UTF8)
  • The data format must be either text or delimited (for example, VARCHAR Format = 'Delimited')
  • The WriteBOM attribute must be set to 'Yes' (for example, VARCHAR WriteBOM = 'Yes')
If WriteBOM = 'Yes' and any of the other necessary conditions are not met, the job fails.