Archives of the TeradataForum

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

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

<-- 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>>