DSXchange

... only if the jobs run in a serial fashion, I assume.

Ah... should have pushed earlier on the @FM possibility but those usually end up throwing a "code=-4 [ParamValue/Limitvalue is not appropriate]" error message. I also thought when Julio first mentioned them and you said you "already tried that option" that you meant you'd already...

Welcome. Let's get you off into your own post so it can its own discussion and resolution. I had to randomly pick your Release and OS so feel free to correct those by editing your post. As to your issue, we'd need a better understanding of your job design as the Sequencer ANY thought isn't the probl...

How about a response to my last post?

Just make sure you understand it is removing all individual CR and LF characters in the field - not just where they are there as a pair of characters. While this may be perfectly fine, for the record to handle eliminating pairs of them, use the EReplace function rather than Convert.

I think we need to call in their Explain More marker.

I have no idea right now what exactly "Parameter 2" might be. Can you copy / paste the complete, unedited error message from the log here? I'd also be curious if your mechanism works at all with a single email address being passed.

But of course! Stick with the original suggestion.

And yet passing that space separated list as a parameter may be problematic, hence my suggestion. Seems to me it's worth a shot, then you can come back here and tell me I was full of crap if it still doesn't work.

I believe the email addresses need to be comma separated with no space.

Another possibility, again from a transformer, would be to leverage the DSLogFatal function based on your triggering condition. Bonus is you can also log the reason why you are aborting it.

Or is that not possible from a Parallel transformer?

Have you ever noticed how DataStage behave with such gaps? There is an unique constraint of course. Let's say they have for example 1,2,3,4...,100 and then 1000,1001,1002,...,1999 Datastate is creating 5,6,..,99 and what next? 100 or 2000? If it overwrites 100, i think that this old overwriten reco...

I do think they have a problem, although I don't understand how they came to be in this predicament. From what I'm reading, while they have a gap in the sequence numbers, DataStage is "filling this gap" which would imply the numbers were set back somehow? If that's true then when the gap i...

Time in internal format is the number of seconds past midnight. When you subtract 18000 seconds from it, it may go negative which is what I meant by 'underflow'. When that happens, you need to decrement the day by 1 and then adjust the time accordingly... add back 86400 seconds... something I'm sure...