How to skip BOM (Byte Order Mark )in BTeq scripts

Tools & Utilities
Enthusiast

How to skip BOM (Byte Order Mark )in BTeq scripts

Hi Experts,

My script (generated by automated process) has BOM characters. After generation, I need to run it in Bteq. The script is faling because of BOM character. Is there any command / provison / setting in Bteq so that I can recognize / skip the BOM character while execution.

Thanks and Regards,

Arindam




3 REPLIES
Teradata Employee

Re: How to skip BOM (Byte Order Mark )in BTeq scripts

Did you tell BTEQ the input script was Unicode, e.g. with -c UTF16 option on the command line?

Enthusiast

Re: How to skip BOM (Byte Order Mark )in BTeq scripts

No, I didn't. So what should i write in the command line so that I can skip BOM present in the script? Thanks - Arindam

Teradata Employee

Re: How to skip BOM (Byte Order Mark )in BTeq scripts

Either -c UTF16 or -c UTF8, as appropriate.