bteq export line width

Database
Enthusiast

bteq export line width

Good Morning All,

I am trying to export the contents of a table using BTEQ export in which one of the column width is greater than 1000 characters. Even though I set the width as 5000 using ".set width 5000" the line breaks at the 1002 width mark and no matter what I do, I am unable to increase the line width beyond 1002. Can you please help me?

Thanks

3 REPLIES
Enthusiast

Re: bteq export line width

Can someone please help me on this? No matter what I do, I do not seem to increase the line width and it goes all the way till 1002 and nothing beyond that. Please advise.

Junior Supporter

Re: bteq export line width

Sorry. My crystal ball is out of order today.

You fail to provide the Operating System & version, Teradata version, bteq version, DDL, script... and you still expect that someone can figure out what your problem is and how to solve it...

Cheers.

Carlos.

Enthusiast

Re: bteq export line width

Is there any generic optimal way to declare .set width. So that it must not depends up on the report length..

What i mean is that i donot know the length of all columns. How can i declare .set width in bteq export mode??

Please help..