 |
 |
Archives of the TeradataForum
Message Posted: Fri, 23 Nov 2007 @ 13:20:35 GMT
| 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.
Regards,
Victor
| |
