incomplete result by show view
Teradata Teradata Discussion Forums Teradata.com Discussion Forum
Visit Teradata.com
Home       Guidelines    Member List
Welcome Guest ( Login | Register )
        


This online forum is for user-to-user discussions of Teradata products, and is not an official customer support channel for Teradata. If you require direct assistance, please contact Teradata support.


incomplete result by show view Expand / Collapse
Author
Message
Posted 7/30/2008 8:03:20 AM
Forum Member

Forum MemberForum MemberForum MemberForum MemberForum MemberForum MemberForum MemberForum Member

Group: Forum Members
Last Login: 9/6/2008 8:42:44 AM
Posts: 41, Visits: 93
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


Regards,
Subhash
Post #12360
Posted 7/30/2008 2:03:48 PM
Supreme Being

Supreme BeingSupreme BeingSupreme BeingSupreme BeingSupreme BeingSupreme BeingSupreme BeingSupreme Being

Group: Forum Members
Last Login: 8/11/2008 3:00:36 PM
Posts: 76, Visits: 147
hi,

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

HTH,


-SN

Post #12372
Posted 7/31/2008 12:03:54 AM
Forum Member

Forum MemberForum MemberForum MemberForum MemberForum MemberForum MemberForum MemberForum Member

Group: Forum Members
Last Login: 9/6/2008 8:42:44 AM
Posts: 41, Visits: 93
I have also tried this option.

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


Regards,
Subhash
Post #12389
« Prev Topic | Next Topic »


Reading This Topic Expand / Collapse
Active Users: 0 ( 0 guests, 0 members, 0 anonymous members )
No members currently viewing this topic.


All times are GMT -5:00, Time now is 6:34pm

Powered By InstantForum.NET v4.1.4 © 2008
Execution: 0.063. 10 queries. Compression Disabled.