All Forums Tools
Greyghost 51 posts Joined 07/09
29 Mar 2011
SQL Assistant truncating View definition


I thought this was covered earlier but could not find in the archives.

When I use SQL Assistnat to "show definition" of a very large View, part of the view is displayed and the remainder is not. It is sort of truncated or cut-off. This looks to me like a buffer size issue or answer set size issue, but I cannot find the option on how to increase the output size for SQL Assistant.

Any help would be appreciated.



robpaller 159 posts Joined 05/09
29 Mar 2011

Sounds like you are using SQLA 13.10 and the 13.10 ODBC driver. There is an issue with the ODBC driver prior to the 13.10.05 release that causes this behavior. You can either update to the latest release of the ODBC driver or use the Teradata .NET Provider which does not exhibit this behavior.

gpittenger 1 post Joined 05/11
20 May 2011

I have the same issue, and have the latest ODBC drivers posted in the ODBC section of the Teradata downloads page. Is the more recent driver you mention located elsewhere?

zamin 1 post Joined 10/12
29 Oct 2012

Please help me with it
 query to determine if user/proxy accounts that are not classified as “adhoc” are connecting from desktop computers using SQL Assistant

whitestorm2k 8 posts Joined 09/04
30 Oct 2012

Please try to access the requesttext column in dbc.tabletext, then you will see the ddl of those large view.

You must sign in to leave a comment.