incomplete result by show view

Database
Enthusiast

incomplete result by show view

Hi all,

While running show view viewname in TD I am getting incomplete result.
Don't know why may be DDL of view is exceeding the space available for answer set.

So is there anybody who knows solution for this.

Please suggest.

Regards,
Subhash
2 REPLIES
SN
Enthusiast

Re: incomplete result by show view

hi,

Try to export the resultset to a file using the 'File -> Export Results' option, if you are using Teradata SQL Assistant.

HTH,
Enthusiast

Re: incomplete result by show view

I have also tried this option.

But also not working...........