BTEQ field separator.

Tools
Enthusiast

BTEQ field separator.

Hi,

In my BTEQ statement, I'm selecting two columns of a table and using this statement .SET SEPARATOR "|" and I'm exporting the output to local file. When I check that file only one column is present. Please help me on this.

Thanks in advance,
Vinay.
3 REPLIES
Teradata Employee

Re: BTEQ field separator.

If you are exporting in REPORT format, be sure you have set the maximum WIDTH large enough to contain the data.

Enthusiast

Re: BTEQ field separator.

After you follow Fred's suggestion, if you still have the issue, can you share your export and select command to verify. It would be easy if you can provide the log also to identify the issue.

Enthusiast

Re: BTEQ field separator.

Ya now its working fine..... Thanks for your help Fred and Satyanarayana.....