DSXchange

When the job aborts and you Reset it, do you get a 'From previous run...' message generated into the log? If so, post it.

This would do exactly what I want, if I could coax the generated code to be: UPDATE Source.Account SET AccountOptedInOut=? WHERE SourceSystem=? AND EffectiveDate>=? AND AccountNumber=? I'm pretty sure I can't use the "?" syntax in user written SQL code. Of course you can! Switch the stage...

Get rid of the RETURN statements, those are only for subroutine calls, then use your function in an assignment statement. Also, you can't "define" it with two arguments and then call it with three, which is it?

przytulaguy wrote:we received a new license now with this option.

Did not whomever gave you the new license file instruct you what to do with it? If not, they certainly should.

First try it with a single address and see if that works, then go from there. What you need between them depends on your mail server, so experiment - comma, space, comma space, semicolon, who knows?

Research the "DSGet" functions or their 'dsjob' command line equivalents, depending on where you want to do this. You can get "audit" information directly from each of the load jobs anytime after they complete without necessarily needing any special fields in the target table. Cr...

Then there are no parameters involved and you need to use $CommandOutput as noted above.

You're welcome and don't worry about the 64bit libraries as DataStage cannot use them.

Sure, all that is possible but you need to forget the whole 'wave number' part. Forget that and concentrate on just what you need to accomplish without fixating on wave numbers.

But are you certain that you need to provide a packed field? "They" should be able to pack it during their load easier than you can provide it that way... and from what I've seen in the past it is much more typical that they handle that aspect of this.

Very nice, thank you Uncle Andy for taking point on that trail.

Just to make sure that we're on the same page, are you doing the 'cat' outside of the Sequence job that does the Notification? So you can then pass those values in a Job Parameters to the Sequence job and then use those job parameters in the notification stage? If you are doing this all in the same ...

No problem. Can you please mark your post as Resolved using the button at the top of the page? Thanks!

You'll need to retrieve it and pass it as a Job Parameter to the Sequence job with the Notification Activity stage in it, is that what you are trying to do?

You certainly should be able to do this. Can you explain what exactly you've tried so far?