DSXchange

I think you can use a jobparameter for doing this.

How about using Index Function??

Or the Usage Analysis from the Manager Client..

What is the DB stage you are using? In the DRS stage, we got this error , and we had applied a patch to resolve this.

Seems, the OP is in windows. and for windows , you are having lot of freewares, where you can compare two files.

I am using EXAMDIFF.

Thanks for the Inputs, Marking the Thread as Resoved.

Thanks for the inputs, Yes, "INPUT VAL" is the actual parameters passed. As mentioned earlier, i dont have any problems in writing User Defined SQL, but if possible i want to update the rows , with the generated sql (Update Existing Rows only). i have converted the Target Update action as ...

I can mark the second nonkey column as Key , in the DRS stage, so that it will be a part of where condition, but the problem is , i cannot enter the same column names twice, that is the issue.

I have a situation like, i want to update the target table with the values present in the Hashed file. I am having all the keycolumns of the target table present in the hashed file also. The job design is Hashfile ---> Transformer --> Target(DRS). But the issue is, I want to update a non key column ...

make sure, the input data is sorted , before applying the above said logic.

For getting the JobCount, you can use Select Count(*) FROM DS_JOBS where NAME NOT LIKE '\\%'; Select NAME FMT'50L' FROM DS_JOBS where NAME NOT LIKE '\\%'; And for routines, Select Count(*) FROM DS_ROUTINES where DSRID NOT LIKE '\\%' ; SELECT DSRID FMT'50L' FROM DS_ROUTINES WHERE DSRID NOT LIKE '\\%'...

We are waiting for it, Let us Know the details of your next trip.

Use the basic transformer and call the server routines there.

What do you mean by Error in 5th record?

Is it a Lookup fail or Something which the job doesnt abort?

Try to abort the Job if you find any error, then only the Transaction Size=0 will work.

But, Wait for the experts reply.

Try Setting the Transaction Size to 0, it means either all records will be commited, Else Nothing will be commited.

May be this wont be Suitable for Large Volume of records.