About Availabality of CRC32 in PX

somu_june · Post by **somu_june** » Fri Feb 10, 2006 1:45 pm

Hi,

I want to know wether there is a function called CRC32 available in PX. I have a requirement like this in stage variable in transformer I have to calculate duplicate records with CRC32 and I have to assaign to other variable TotRejRec = If Dupcheck = 'Y' Then TotalRejRec+1 Else TotRejRec. In functions in pX ...... there is no conversion option . In server I found the function CRC32 under functions .... conversion....CRC32 . can any one help me how to use CRC32 in Px and where can I found that function

thanks,
Somaraju

ray.wurlod · Post by **ray.wurlod** » Fri Feb 10, 2006 2:50 pm

It's not available out of the box. The technology is well-known - do a Google search and create a parallel routine.

somu_june · Post by **somu_june** » Fri Feb 10, 2006 3:00 pm

Hi Ray,

Can you tell me in detail what to search in google and also can you tell me what I have to do in parallel routine to achieve CRC32 function

Thanks,
Somaraju

ArndW · Post by **ArndW** » Fri Feb 10, 2006 3:08 pm

<sarcasm=on>
Ray, the google search of "crc32 c++ function" returned over 81,000 pages to me. I think that is too much. Could you help me and Somaraju out? Please write (and of course debug) the parallel routine and post it here for us?
<sarcasm=off>

Somaraju,

the CRC32 algorithm is not only available in many libraries, but the C++ code is written in many places, including thousands of pages available through a google or yahoo! search. The method of writing c++ code for DataStage parallel extender is documented.

If you were to try to write a CRC32 function for Parallel extender and encounter problems in either the coding or the embedding there are many here who would help and assist you. But asking someone else to do this for you without having researched the matter is not going to get you much help from experts such as Ray.

shawn_ramsey · Post by **shawn_ramsey** » Fri Feb 10, 2006 3:34 pm

You can always ask IBM to develop it, assuming that you have a support contract with IBM.

ray.wurlod · Post by **ray.wurlod** » Fri Feb 10, 2006 3:37 pm

You could ask one of the professionals here to develop it, in exchange for money - probably for less than IBM would ask.

shawn_ramsey · Post by **shawn_ramsey** » Fri Feb 10, 2006 4:24 pm

ray.wurlod wrote:You could ask one of the professionals here to develop it, in exchange for money - probably for less than IBM would ask.

I am thinking about the rest of us.

somu_june · Post by **somu_june** » Fri Feb 10, 2006 4:38 pm

Hi Ray,

Iam a poor consultant. I can't pay you or IBM. Any how thanks for the forum for being so help full in solving my other problems in PX.

Thanks,
Somaraju.

sanjay · Post by **sanjay** » Fri Feb 10, 2006 9:22 pm

use change capture stage if change_code is 3 then rej +1 change_code is 1 then rej

Thanks
Sanjay