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