Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Thu, 21 Oct 2004 @ 08:19:10 GMT


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


Subj:   V2R5 Upgrade and CHECKSUM
 
From:   Anomy Anom

<-- Anonymously Posted: Wednesday, October 20, 2004 21:00 -->

We upgraded to V2R5 on our test box this weekend, and I have two questions.

1. Tables that are being created are adding a parameter called CHECKSUM.

     CREATE MULTISET TABLE xxxxxxx, NO FALLBACK,
                   NO BEFORE JOURNAL,
                   NO AFTER JOURNAL,
                   CHECKSUM = DEFAULT

Can someone explain CHECKSUM?

2. Our multiload that has an Update statement is not working. It works in our production box that still have V2R4, with the same data and same multiload script. The error is:

RDBMS failure, 3754: Precision error in FLOAT type constant or during implicit conversions

I do have decimal data, but no float data. Any ideas?



     
  <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: 27 Dec 2016