16.10 - Setting the Byte Order Mark - Parallel Transporter

Teradata Parallel Transporter Reference

Product
Parallel Transporter
Release Number
16.10
Published
July 2017
Content Type
Programming Reference
Publication ID
B035-2436-077K
Language
English (United States)

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.