Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Fri, 23 Nov 2007 @ 13:20:35 GMT

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

Subj:   Re: Coalesce on timestamps
From:   Victor Sokovin

  The following statement gives a 2800 error  

  select COALESCE(ins_dtm, CURRENT_TIMESTAMP) FROM table1  

  The field ins_dtm is of the type timestamp(6). Any one an idea?  

2800? My manual is not the latest so I only find something on "invalidated secondary index" under 2800. What is the text message that you get, if any?

If this is indeed related to the problem with SI you just need to ask your DBA to rebuild the index.



  <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