As per your suggestion I have just tried with .set width 720;
But no luck. The result is still the same(truncated).
WIDTH 720 should not truncate.
Double check the result, did you forget to delete the output file and BTEQ appended the result?
I am sorry. As Dieter said I missed to delete the old file when tried with width 720 option..Now the output is of full length and as expected.
Thank you both. Appreciate your help.
I am having a same problem. The only difference is my output is a SQL query of 10230 characters which is generated by executing a Macro. That macro gives correct result when directly run in the d/b. But the O/P is getting trimmed when written in a file.
I tried the with the Width=720 and also deleted the old file. But it's still not working for me.
The problem has been resolved.
Sorry for the inconvenience.
I just found out, there is a variable that was setting a different width, which was overiding the one that I set.
Thanks for the help though.
Thanks & Regards,