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.