DSXchange

Hi, In my sequence job I have a job activity stage that Runs Job1. Job1 in its job control calls Job2. I need to have Custom trigger on this Activity stage to say if status of Job2 is failed or warnings then go to Email Notification stage. I was successful in extracting the status of this activity, ...

Hi, All of a sudden when I open a project in Designer I get a DataStage Repository Interface message: Cannot open file &UFD&. When I click Ok (I have to click Ok a couple times since the error message box doesn't close), the project opens but has the word (Protected) next to its name on the ...

Hi, I am having a problem where Job Fails and Aborts if Data source is empty. I read in one of other posts that I should run the below routine in after-job to get some more info. Since I am pretty new to DS and not too familiar with BASIC and routine execution. Where would I place this routine to ge...

Hi, I am pretty new to DS and not too familiar with BASIC and routine execution. I am having the same problem as described here: Job Fails and Aborts if Data source is empty. (I am running on Windows). Where would I place this routine to get row count as described here? DSGetLinkInfo(DSJ.ME, "s...

Hi, I have a pretty straight forward job that reads data out of source DRS (SQL server) based on some criteria and inserts records into two target DRS (SQL server) at the same time. As an error handler, I have a reject sequential files one with each target DRS. If for example there are duplicate rec...