Help with generating a checksum

[rickholc]

Is there a built in way of computing a checksum on a field, a group of fields or a whole record in a Teradata table?
Example:
Select Checksum(field1) as check_1, checksum(*) as check_2
from table

 

[dnoeth]

You mean MS SQL Server checksum?

The closest thing to checksum is the HashRow function, the resulting Datatype is BYTE(4):

sel hashrow('bla');

*** Query completed. One row found. One column returned.
*** Total elapsed time was 1 second.

HASHROW('bla')
--------------
22C3F10B


sel hashrow('bla', 1, 123.45, 'foo');

*** Query completed. One row found. One column returned.
*** Total elapsed time was 1 second.

HASHROW('bla',1,123.45,'foo')
-----------------------------
D8BE2563



Dieter

 

[rickholc]

That will work fine. Thanks for your help.