DSXchange

Hi... I observed this peculiar behaviour in one of my jobs... I have a DB2 stage in which row leakage is happening. To capture this, I have used a COPY stage and enabled RCP so as to catch the sqlcode and sqlstate of the rows being rejected. The o/p of copy stage is a sequential file. Everything wor...

Hi,

Just give the extension to the file as .csv, chk tht the Record Delimiter is Comma (thats by default), and final Delimiter is "end" (also by default).

This serves your purpose.

Hi Sreeni,

Can you pls. elaborate on your suggestion.

When UNIX triggers a DS Job, the control shifts to DataStage, how do I keep sending any Status Codes to UNIX before the Job Running is successful/aborts.

Dear all, We are using Unix Shell Scripts as the Wrapper for all our parallel jobs (around 20-25 jobs). Once we trigger the script, when the load is too heavy, it takes around 3 hours for the entire process to finish. We have observed that in such scenarios, after about 2 hours, even though the job ...

Dear all, Thanks for all the valuable suggestions, result of which I have found out the solution for the problem. :D In our process, once the XML is generated, we are using a Server Job to load the counts into the Database Table used to store these statistics. The link count was sometimes being capt...

Dear all, I am facing an issue while collecting the job Statistics for a set of jobs. The scenario is like this. When I run a single job, and later generate a XML file for the same job, all the link counts are correct. We are using Unix Shell Scripts as the Wrapper for all our parallel jobs (around ...