DSXchange

We have a SQLServer procedure that runs for about 40 minutes every evening when executed by a batch job. We would like to run the procedure via a DataStage job for special table reloads during the day. When we call it from the after sql routine in DRS it runs for about 10 minutes then ends with no e...

I suggest you set a default value for Ans before you start. My guess is that you are getting values other than the ones you have programed for. CN Here is the code I am using in the routine: I couldn't see anything wrong in here. deffun CheckVal(Arg1,Arg2) if Arg2 = "1" then if Arg1="...

Another way is to create a variable to hold the last key value and then compare the old and new key variables to set a flag to be evaluated by the constraint part of a transform, the duplicate row could be sent to a flat file for reporting.
CN