DSXchange

I am trying to use modify stage to replace null values in inpout by zero. Input column is integer. Can any one tell me syntax of specification property?


The following one is generating error:
PRODUCTID:Decimal = NullToValue(PRODUCTID,0)

Thanks

I have always used select queries on these tables but I dont want to use any insert/update/delete query unless I am absolutely sure... Also deleting job should be a compound process like when we delete any job: 1) Its entry from DS_JOBS etc tables should be removed. 2) Its log, control.... files sho...

Hey, I am looking for some way of deleting the job from command line. I have read this communication and I understand that a job is associated with many internal entries(like VOC, DS_JOBS etc)/files(Log, Control etc). But there should be some utility that takes care of all these things... I want to ...