CheckSum Stage Integer Value

kfb_developer · Post by **kfb_developer** » Tue Aug 17, 2010 12:05 pm

Can CheckSum Stage generate the checksum field in integer/Bigint ? If yes, Can you please explain me how.

kfb_developer · Post by **kfb_developer** » Tue Aug 17, 2010 1:25 pm

Does anyone have answer for this....

ray.wurlod · Post by **ray.wurlod** » Tue Aug 17, 2010 5:09 pm

Learn patience. I typically don't respond to posts at 4am my time.

DSXchange is an all-volunteer site whose members post as and when they can. If you need one hour response, sign up with your official support provider for priority service (and good luck finding one who'll agree to a one hour SLA!) to learn just how much "urgent" costs.

Is there any reason you could not have consulted the manual or on-line help?

ArndW · Post by **ArndW** » Wed Aug 18, 2010 4:22 am

Use the checksum function and then examine the output character field. Do you think that can be converted to an integer or bigint?

kfb_developer · Post by **kfb_developer** » Wed Aug 18, 2010 7:08 am

ray.wurlod wrote:Learn patience. I typically don't respond to posts at 4am my time.

DSXchange is an all-volunteer site whose members post as and when they can. If you need one hour response, sign up with your official support provider for priority service (and good luck finding one who'll agree to a one hour SLA!) to learn just how much "urgent" costs.

Is there any reason you could not have consulted the manual or on-line help?

I am sorry Ray.. It was the pressure I was having at my work place which made me post the second reply. Dont take it bad on me. I tried on-line help and I cannot see much information about this.

kfb_developer · Post by **kfb_developer** » Wed Aug 18, 2010 7:12 am

ArndW wrote:Use the checksum function and then examine the output character field. Do you think that can be converted to an integer or bigint?

I did and the output is alphanumeric and it looks like 'a78hfbge98'. I dont think this can be converted to integer

chulett · Post by **chulett** » Wed Aug 18, 2010 7:23 am

You did not get much in the way of an answer because (honestly) the answer really should have been fairly obvious - no. Unless you were looking for an option or switch of some kind to change the output format and again the answer would be no.

ArndW · Post by **ArndW** » Wed Aug 18, 2010 7:44 am

kfb_developer - Now that you know that the output cannot be easily converted to an integer you have your answer. In a roundabout way, you could now do a checksum or similar conversion on that string and get a bigint value. While server jobs have a CRC32() function, PX does not. One would need to write or adapt c++ code or shell out to the OS in order to do that.

kfb_developer · Post by **kfb_developer** » Wed Aug 18, 2010 8:05 am

Thank You for Your help.