Page 1 of 1

About Availabality of CRC32 in PX

Posted: Fri Feb 10, 2006 1:45 pm
by somu_june
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

Posted: Fri Feb 10, 2006 2:50 pm
by ray.wurlod
It's not available out of the box. The technology is well-known - do a Google search and create a parallel routine.

Posted: Fri Feb 10, 2006 3:00 pm
by somu_june
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

Posted: Fri Feb 10, 2006 3:08 pm
by ArndW
<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.

Posted: Fri Feb 10, 2006 3:34 pm
by shawn_ramsey
You can always ask IBM to develop it, assuming that you have a support contract with IBM.

Posted: Fri Feb 10, 2006 3:37 pm
by ray.wurlod
You could ask one of the professionals here to develop it, in exchange for money - probably for less than IBM would ask.

Posted: Fri Feb 10, 2006 4:24 pm
by shawn_ramsey
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. :)

Posted: Fri Feb 10, 2006 4:38 pm
by somu_june
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.

Posted: Fri Feb 10, 2006 9:22 pm
by sanjay
use change capture stage if change_code is 3 then rej +1 change_code is 1 then rej

Thanks
Sanjay