DSXchange

This file has been in place for years..it is not changed at all..

Do a Lookup with same table and map the column if the values only if found and then write the output to a hash file. If you really care for the order of the columns then you may have to do a sort later and then write to the output hash file.

You have to give the full path of the S driver. otherwise it won't recognize.

we have observed a strange behavior where a hash file is not updated properly. Is there a reason why a hash file is not updated properly ? Ex: we have a row with a key and the other atribute in the row is changed but for some reason, it is not updated in the hash file..does any body have any idea wh...

Thnaks ray..I wish notification activity has more features in it.
anyways, I wrote a DOS script to handle this without notification activity..

Hello - We curently using Notification Activity in Job Sequencer, and attaching a report. however, we need the content send out in the email body but not as an attachment..
any ideas, please suggest. Thanks

100% positive on that. like i said the same job has been running differently in 2 environments. same input data.

I have seen a weired scenario. In test environment, it writes 8 rows and reads 8 rows from hash file. but in prod, it writes 8 but reads 9 (which we think is from previous run and file was not flushed properly).. Is that possible ?? just curious to know as the job was runn ing for years and it never...

Hello Experts - I have used in one of my previous projects a DOS script that will split one dsx file into the folders and jobs as in the Project structure. And also a similar script which merges all jobs in folders into one dsx. I am hoping most of the experts here aware of it. If you hvae can you p...

any advise, How can I fix it ?

I am getting following error: Can somebody please shed some light as to what is this error about.. The Job reads data from Oracle(ODBC), does a lookup at transformer 1 and another lookup at tarnsformer2 and writes to SQLServer. DataStage Job 1424 Phantom 4504 Program "JOB.1148172060.DT.15370577...

Yes we are scheduling thru DataStage Director.

Yes.
we didnt force it to 'No Limit' using
DSSetLimitJob and I belive thats why, even we set the limit to 'No Limit' in director, it is not picking that up.

I have a Job Control Batch which runs 10 jobs sequentially. I set the warning limit to 'No Limit' in director and I also made sure, It is 'no Limit'whil running the Batch job. However while running, the individual job gets 50 limit somehow and aborts after 50 warnings. Can somebody tell me where do ...

ohh I got it ..it's a bug, If i got it installed from server, it was imported properly. There is a patch for this to be applied