 |
 |
Archives of the TeradataForum
Message Posted: Wed, 22 Nov 2006 @ 16:42:44 GMT
| Subj: | | Re: Length of timestamp |
| |
| From: | | Victor Sokovin |
| | To answer to Dieter, if you look in the Data Dictionnary manual, you can find the ColumnLength description. The descrition is : Returns the
length of a column as the maximum number of bytes used to physically store a column value in a table row. | |
OK, then you are not alone on R6. I thought you were on an earlier release when you said that the column you recently created was the only one
which deviated from the rest. Apparently, this was the fist column of this kind created in your DB. In R6, this behavior is typical as the meaning
of the data in ColumnLength changed.
You are right that the change was never documented in the Database Dictionary manual. What does not help either is that when you look at the
ColumnLength for standard DBC tables you still see the column lengths in their old meaning.
Probably this was meant as a surprise for users then. Not a bad idea to keep us entertained!
Regards,
Victor
| |
