Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Wed, 22 Nov 2006 @ 16:42:44 GMT


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


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.  


  We are running V2R6.0.  


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



     
  <Prev Next>   <<First <Prev Next> Last>>  
 
 
 
 
 
 
 
 
  
  Top Home Privacy Feedback  
 
 
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 15 Jun 2023