constriant error

bobby · Post by **bobby** » Sat Aug 28, 2004 2:15 pm

hi,
I just download CRC example and was trying to implement in my Job,
i have an error in CRC variable not define but the job which i load its not showing any error
CRC <> lkup_hashfile.CRC or IsNull( lkup_CRC.CRC)
by
plz advice.
Thanks
Bob

ketfos · Post by **ketfos** » Mon Aug 30, 2004 10:39 am

Hi,
What is CRC example? Pl dive clear details of your problem

Ketfos

mhester · Post by **mhester** » Mon Aug 30, 2004 11:57 am

Since I developed that job sequence and uploaded this to ADN I guess I should answer.

The var CRC is implemented as a stage variable that holds the return from CRC32. You'll notice that you need to pass some of or all of the record to CRC32 to generate a CRC value.

Regards,

bobby · Post by **bobby** » Tue Aug 31, 2004 7:06 am

Hi ,
Thats exactly is did , but same error when i look hash file CRC32 have
created values too.
Thanks,
Bobby

mhester · Post by **mhester** » Tue Aug 31, 2004 7:23 am

The premise behind the example would be for use during SCD processing although any change data processing is fair game. You read (ref) from the same hash that you write to. Also, there would likely be some pre process that would extract (from the DB) those rows that you will be processing during the current run and builds the hash table that is used.

Regards,