DSXchange

Shouldn't really matter, and there's no setting as any job can be added to the Schedule multiple times, MI or not. Not really sure why you are seeing what you are seeing.

Yes. Hopefully you're not using the default stage names as they wouldn't be all that helpful. To anyone.

You need to work out the instance name and add that to the main job name when attaching.

Designer.

Notification Activity. 'Include job status' option. Try it, see if it gets you what you want without all that extra who-ha.

I honestly don't believe that this is possible.

Be happy to be proven wrong, however.

Two values, not the value 2. Either return a delimited string and parse it or leverage the fact that the output will be in the form of a dynamic array and select each element individually.

I would have found that one, if true, to be a little hard to understand.

Are you aware that if you simply 'Include job status' in the email, the last message in the email will be from the failed job and the error will be in the email as well?

Sort descending then take the first five.

Blat. Or a group contact. Or talk to your admin to see why what you tried is not working.

ps. Some systems want a comma with no extra space: "fred,ethel" rather than "fred, ethel".

Instead use an External Source stage to pass the full XML filename to the XML Input stage and switch it to use the 'Filename/URL' option.

You should also be able to check the online help Index tab for the 'DSGet' section, where you'll find the various log retrieval functions you can use.

If you reply to the latest post from the OP, you'll see they changed the subject to "Re: A function equivalent to COALESCE() in datastage". That answer is still no. And a quick Google reveals that SQL Server does indeed support the ANSI standard coalesce function.

prasanna2883 wrote:Iam not able to identify any function which works similar to coalesce() in oracle.

Re-read Ray's first answer. You could always write your own as a build op, I suppose.