Could anyone else use a checksum() type ability for DB2?

Do you have features you'd like to see in future releases of DataStage, MetaStage, Parameter Manager, Version Control or one of the other tools represented on this forum? Post your ideas here!

Moderators: chulett, rschirm

Post Reply
jdmiceli
Premium Member
Premium Member
Posts: 309
Joined: Wed Feb 22, 2006 10:03 am
Location: Urbandale, IA

Could anyone else use a checksum() type ability for DB2?

Post by jdmiceli »

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

John Miceli
System Specialist, MCP, MCDBA
Berkley Technology Services


"Good Morning. This is God. I will be handling all your problems today. I will not need your help. So have a great day!"
meena
Participant
Posts: 430
Joined: Tue Sep 13, 2005 12:17 pm

Post by meena »

Hi,
Check with "MOD" function in DB2.
jdmiceli
Premium Member
Premium Member
Posts: 309
Joined: Wed Feb 22, 2006 10:03 am
Location: Urbandale, IA

Post by jdmiceli »

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

John Miceli
System Specialist, MCP, MCDBA
Berkley Technology Services


"Good Morning. This is God. I will be handling all your problems today. I will not need your help. So have a great day!"
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

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

"You can never have too many knives" -- Logan Nine Fingers
jdmiceli
Premium Member
Premium Member
Posts: 309
Joined: Wed Feb 22, 2006 10:03 am
Location: Urbandale, IA

Where would I find it in the Server Edition?

Post by jdmiceli »

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

John Miceli
System Specialist, MCP, MCDBA
Berkley Technology Services


"Good Morning. This is God. I will be handling all your problems today. I will not need your help. So have a great day!"
kris007
Charter Member
Charter Member
Posts: 1102
Joined: Tue Jan 24, 2006 5:38 pm
Location: Riverside, RI

Post by kris007 »

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

Where's the "Any" key?-Homer Simpson
jdmiceli
Premium Member
Premium Member
Posts: 309
Joined: Wed Feb 22, 2006 10:03 am
Location: Urbandale, IA

Post by jdmiceli »

Thanks, Kris.

I'll go dig some more.

Toodles,
Bestest!

John Miceli
System Specialist, MCP, MCDBA
Berkley Technology Services


"Good Morning. This is God. I will be handling all your problems today. I will not need your help. So have a great day!"
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

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

"You can never have too many knives" -- Logan Nine Fingers
kcbland
Participant
Posts: 5208
Joined: Wed Jan 15, 2003 8:56 am
Location: Lutz, FL
Contact:

Post by kcbland »

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

Rank: Sempai
Belt: First degree black
Fight name: Captain Hook
Signature knockout: right upper cut followed by left hook
Signature submission: Crucifix combined with leg triangle
Post Reply