DSXchange

Hi All

I have job in Production which will compare the previous day and current day files in CDC stage then generating sequence numbers in transfer stage (running in sequence mode ) for every new record.

Transformer logic. if lnklkptotfp.change_code =1 then @NUMPARTITIONS+svCntr else svCntr

Now the job is generating negative numbers
Can you please suggest what could be the issue

Thanks,

What is the derivation of svCntr?

Every time i am passing MAX(Val) from the target table.

What is the datatype and intial value for the stage variable svCntr.
Could be a reason that, garbale value is going due to data type mismatch?
Did you check the Target table? No chance of getting negative value as the Max?
Is the Negative value going incremental or reverse?

buffer overflow?
what are the values when you pass 0 to svCntr? also check the datatypes as mentioned by Kumar.

The dattype of svCntr is BigInt . I am passing initial values as 0.
and target DB2 table column as BigInt .