Archives of the TeradataForum

Message Posted: Fri, 13 Feb 2004 @ 20:50:31 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

Joseph,

Don't worry about the table alias. Behind the scenes Teradata will replace the alias with the full name as indicated by the "after name expansion". The view, once name expanded cannot be more than 26000 characters. So replace your table aliases with the full table name and then put the view into an editor like MS Word and see how many characters you are dealing with.

Then do what you can to cut the view down. A big improvement I find is to alias long column names with a shorter alias or if you are already aliasing columns, try using something even shorter. Of course any naming standards must still be acknowledged. If all else fails, you may have to break your view down into 2 or 3 separate views, using one view to reference the others. Unfortunately it is just a trial and error process until you get the character count down.

To see why you have this limit, take a look at the table dbc.tvm and you will see that the column CreateText is a VARCHAR(26000). The view DDL must fit in this column.

--Jason

	<Prev	Next>		<<First	<Prev	Next>	Last>>