 |
 |
Archives of the TeradataForum
Message Posted: Fri, 12 Apr 2013 @ 13:49:10 GMT
| Subj: | | Re: How to increase the size of text o/p from sql assistant |
| |
| From: | | Dieter Noeth |
Anomy.Anom wrote:
| | Now that none other than you saying that there is no data truncation, I'm in doubt whether this is my query ! | |
Strike!
This is a common problem for recursion on strings due to the Union. Add a typecast to a VARCHAR with an appropriate size to the first
select.
The first select of a Union determines the resulting data type and Teradata does a silent truncation :-)
Dieter
| |
