DSXchange

qt_ky wrote:Help... It may be too late now, but this really needs to be a new topic of its own.

It's never too late.

Splitted.

I had to switch to Chrome before I could see all of the shenanigans.

Assuming it contains only the count, cat the file. One trigger would use "$CommandOutput = 0" and the other "$CommandOutput > 0" or "Otherwise". Make sure you build them using the expression builder so the syntax is correct (my example is close but not exact).

Not sure where a 'bulk' load ever got mentioned... I've been assuming (perhaps incorrectly) that he meant 'insert' whenever loading was mentioned.

Don't guess.

By default? I don't know, that would depend on several factors I would assume. Best to leave nothing to chance, I would take whatever steps were necessary to ensure they only happen at the end.

Very true... always multiple ways to skin the DataStage cat.

Argh... next time check your artwork via the 'Preview' option, save me from having to edit them to make everything line up properly.

And that would be the 'simultaneously with the load' option I mentioned.

... if you are going to go that route, consider swapping out the first UtilityRunJob for a call to DSSendMail, if that's literally all you need to do.

vinodclv - please start your own post rather than jumping into someone else's. When you do, provide the details of your issue rather than saying you have 'the same' issue.

So the link to update the source happens... 'last'. And because I assume you only need a single record to perform the update.

You've given us absolutely no information to work with, just "it works here" and "doesn't work there". Help us help you, post the actual error that you are getting, please. Unedited.

vinnz wrote:This question should probably go in the "General" forum.

And... here we are.

New problem = new post. Split from your attempted 'self hijack'.

'After anything subroutines' are another one of those invisible places that I tend to avoid if at all possible. Make sure you have an annotation stating that it is there and what it is doing. Me, I would split a new link off with a hard-coded zero in it and send it to an Aggregator where it is group...