DSXchange

Well, all of the ones I found searching all say basically the same thing and are exactly what you'd need to do. Here are three example posts pulled from the search results: http://www.dsxchange.com/viewtopic.php?t=138041 http://www.dsxchange.com/viewtopic.php?t=143310 http://www.dsxchange.com/viewto...

Yes, you can use Convert() for this but you pass the decimal value to the CHAR() function. So just convert your hex values to decimal and use them there.

Trying to recall... isn't that information in the job's log?

It has been discussed here quite a bit. An exact search for "email body" should help.

As long as you are "downstream" from the Execute Command stage, you should see all of the various options it supports when you use the Parameter Helper. Matter of fact, you should see that for everything "upstream" from where you invoked the helper. Hope that makes sense. Unfortu...

Again, not junk just EBCDIC.

Glad you got it sorted out.

Sure, that should be one of the options that the stage will return. Off the top of my head, one of your choices if you use the External Parameter helper (...) will be $CommandOutput.

The input to the job is a sequential pipe delimited file, which i can read properly in UNIX prompt. So this rules out the possibility of having ebcdic data. No, it really doesn't. You can easily read in ASCII data and output it as EBCDIC, which the View Data utility understands and will translate p...

<lf> means line feed which on UNIX is the same as a "newline" I suppose. What have you specified as the record delimiter in the stage?

Pffffttt... even better!

"If you want the comparison performed on this column to ignore case, then select the Caseless check box."

Of course he does, should have checked there first.

Thanks for the update Vincent & John.

I think so, that would be part of the "repeat the notification" path that I mentioned... as long as you could craft each trigger to be aware of which job just completed and I'm not sure that's feasible.

Arnd - one. Your design will always only ever send one email, the Sequencer will determine if it happens when the first job finishes or the last job finishes. You'll need to repeat the notification for each one you want to send, that or loop through the jobs and send one on each iteration. Triggers ...

Server jobs work the exact same way and no, there's no such option. Do verify with your DBA that your issue is in fact an idle timeout issue and not something else.

Doesn't Data Stage establish connection only when it reaches respective stage to process records or Does Data Stage establishes connection across all the stages like ODBC or Oracle at the start itself? All connections are established when the job starts and the stages "open" or initialize...