DSXchange

Hi all!

One of the many weaknesses of DB2, which I am being forced to move to kicking and screaming, is the lack of functionality to easily generate a checksum() value of some sort.

SQL Server 2000 has checksum() and binary_checksum(), my personal favorite that spoiled me rotten for it's speed, but DB2 has it available only for internal testing. It is not exposed for clients to use as far as I know.

I have already submitted the capability request to IBM, but is it possible to have that type of functionality in DataStage?

Bestest!

Hi,
Check with "MOD" function in DB2.

Hi Meena,

Thanks for your input. I will definitely take a gander at it and see if I can apply it for what I need.

Bestest!

DataStage includes a CRC32 function, doesn't that count?

Hi Craig,

I've been digging around for it in the documentation. I must be missing it somehow. Do you know where in the Server Edition documentation I would find info on it?

Thanks!

I am not sure if you can find it in the documentation but I am sure that there are quite a number of posts here in dsxchange. A simple search should lead you to them. Especially those by Michael Hester.

Thanks, Kris.

I'll go dig some more.

Toodles,

It's in the BASIC pdf. My version incorrectly documents it as returning a 16-bit value, however. Searching for Michael's posts here - his id is mhester - will get you alot more information on the proper use of it.

John is looking for a database level checksum/crc32 function to facilitate queries in the native database.