DSXchange

bgs_vb wrote:...is there any system variable available.

Check the online Help index for System Variables - they are there. You'll find things like @DATE and @TIME plus references to functions like Date(), Time() and TimeDate() off the top of my head. See which would work best for you.

Talk to one of your UNIX or scripting gurus there and have them help you. It's a 'stream editor' that supports regular expressions so you would basically tell it to replace all line-feed characters with an empty string, ie remove them.

You'll need three - Ok and Warn to a Sequencer set to 'Any' to trigger your second job and then a third trigger of Warn type that goes to the reject Notification Activity stage. Ok just runs Job2, Warnings runs Job2 and sends the email.

You should be able to attach your Notification Activity for reporting success to your second job with an 'Ok' trigger. The Exception Handler will need to report out any failures in the Sequence. Now it gets a little more complicated if you want the Job2 to run even if Job1 had warnings, but you want...

Not being all that familiar with MQ - if all segments are read as a single message, why segment? When you write out the results to a file, do you get one single file that contains all the segments in the proper order? Is the problem the fact that there are extra 'new lines' in the file between segme...

Which part of the process took that long? If it is the inner join, look to optimizing your hashed file build query...

Depends on how you are handling the rejects. If having rejects means the job finishes with warnings, then no - you can't take that route. You can do the checkpointing and exception handling but you'll still need either two triggers or a compound trigger so that either 'Ok' and 'Warning' results go f...

Order your DB2 query by 'col2 descending'.

You are gzipping it and then 'segmenting'? If so, do you know when you have all the pieces? You'll need to put the segments back together and then gunzip the file before you can parse the XML in DataStage. And it seems like the 'putting back together' part could simply be concatenation done by your ...

Wasn't aware of that... I'll keep it in mind.

I've got the RTI Agent successfully installed on my development Server machine. However, the extra special 'RTI Enable' checkbox does not show up in my job properties yet. I understand that I need to license the installation. My question is related to the ability to manage Client and Server licenses...

In the past, I would combine it with an 'Ok' trigger such that a job that ran ok would continue on and anything else - warnings, aborted, crashed, anything - would go down the 'Otherwise' link. Still perfectly good in a situation like that. However, with the new Checkpointing and the ability to 'aut...

Well... keep in mind the fact that 'Otherwise' triggers catch anything that didn't go down another link. When you pair it up with a 'Failed' trigger, don't assume that the only thing it will catch are 'Ok' and 'Warning' events. Any other result will go down the Otherwise link - included things like ...

Why do you need three triggers? There are different ways to solve this, one way involves two triggers, another a compound trigger. Use an 'Ok' and a 'Warning' trigger and run them to a Sequencer stage set to 'Any', then link the Sequencer to the second job. Use one trigger with a Custom condition an...

Welcome! This usually happens when you don't include JOBCONTROL.H in your custom routine. However, you are talking about Sequence jobs and I don't recall 5.x having Sequence jobs.

You might want to give more details about exactly what you are doing...