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

Tools
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.