DSXchange

I know there is that stage in job sequencer that sends an email, but I was wondering if there is somewhere to set up email notification if the job fails?

I need to know of an alternate way to read in one record and write out multiple records. Currently, I read in the record and write out to 10 dirfferent sequential files, merge the files, and then load my table. I have to do this for over 1000 records. Any ideas.

I have a job sequence that needs to run continuously throughout the day. Basically, the sequence waits for a file to appear and when it sees this file kicks off a number of jobs within the sequence. At the end of the sequence, I delete the file. I somehow need to restart the job again so it will the...

I have two Sequential files that with all the same colums but different data and I want to merge them into one sequential file. How can I do this is DataStage. The Merge Stage looks to be the obvious choice at first but it does not take streaming data inputs from a Seq file. Any ideas.

I'm trying to use the DSJobStartDate function to populate an updata date on my table. I'm getting the error, "Value treated as NULL
Attempt to convert String value "2003-12-02" to Date type unsuccessful". Why am I getting this error? How can I fix this.

Is there a way to restart a job sequence you just ran at the end of the sequence? I basically want this job sequence to run all day, continuously.

I'm trying to load a table with a particular acct_nbr and I need to find(lookup) the acct number in a table that has a range of numbers. The table actually has begin and end range columns and the acc_nbr I have will fall in a range. I tried using an IF statement to do my join(lookup) in the transfor...

Thanks for the Job Control suggestion, it worked!

I'm not trying to run a job by waiting for another job, I have created a job and am merely waiting for a file to be FTP to my server, than I want my job to kick off every time it sees that file(or a new version of that file). That is what I was trying to set up the DWWaitForFile for.

Aside from proper syntax, is there anything else needed to get the DWWaitForFile before-job subroutine such as scheduling the job or anything else. I have the correct path in the DSWaitForFile test box and I also have the correct path in for my SrcDir....do I need to add a parameter for DSWaitForFil...

Can you execute a stored procedure (from DB2) in a DS job....if so, how?

I wanted to know if and how DS can execute a shell script on a seperate database server other than the one DataStage actually sits on.