DSXchange

Thanks Craig! Is there a way within DataStage to share a value across subsequent jobs?

I know I write the value to a file but this job will be executed currently by others and the "ID" retunred will be specific to that job.

Version: DataStage Parrallel 8.1 Issue: I'm trying to build a set of parallel jobs that depends on the previous parallel jobs execution and result set. I am having trouble figuring out how to capture a single row/column result set and store it in a variable that is shared across the current executin...

Sorry Greg, you missed my point. My datastage server is running on Windows and we are using PowerShell to run the dsjob. The datastage jobs that I am executing is extracting data from various systems and not just SQL Server.

Hi Craig: I really appreciate the advice you've given thus far. Would you know the best place to research on Routine Activities? I've never used one so I don't know how to check the reject link. Or build a Sequence job. A Routine Activity can check to see if anything was written down the reject link...

Again bear with me because I'm a novice in DS. My issue is that I only want to send the email when there are rejected records. A lookup always recreates the reject file regardless if there are any rejected records. With the approach you mention below, the email would be sent all the time regardless ...

Since the job only "rejects" the rows that are not found in the lookup and the results are sent to a reject file via a reject link and the process continues then the status of the job is considered complete. What I want to do is to be able to send an email if there are rejects within that ...

Hi,
I'm a bit new to DataStage so please bear with me. I need to send an email notification when a lookup rejects a file. Does anyone know the easiest way to implement this?

Thanks!