Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Fri, 18 Feb 2005 @ 16:11:25 GMT


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


Subj:   Missing Character in Long View Definition
 
From:   Yonina Schuchman

  Regarding this, we've found another little problem with really long views shown via the TD Administrator. If you click on 'show definition' in the statement one character is cut somewhere in the bottom of the statement. (i.e. instead of from appears fom). This looks like an overflow. Because if you put lets say five blanks in the beginning of the create view, the missing char is five positions earlier. (Open Case to this is: RECBHTWUU)  


We noticed this also. When an object is stored in DBC.TextTbl and it requires more than one row in the table(>32000 chars), the SHOW DDL does not return the last character of the first line. This causes the missing character in the returned definition.



     
  <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