DSXchange

In other words, you'd need to purchase an ODBC driver for this - it doesn't come with DataStage on UNIX.

if is it possible to do this? if yes please give some idea regarding this. Pretty sure that's exactly what I gave you. In my example, your A = my X, with X getting assigned the status code from the dsjob run. If that's not enough then you'll need to explain your problem a little better... like exac...

"dsx cutter" from what I recall. Oh wait, that was Wolfgang's. You're right, I believe, I seem to recall seeing a goodly amount of Perl posted here somewhere.

Them's the two ways I know.

What do you mean 'assign that Status code into a variable'? Do you mean have the script return that code as its exit status? Or just use it internally? How are you running a 'DS job in unix shell programming' if your server is on Windows? Perhaps: dsjob -run blah-blah-blah X=$? exit $X For whatever ...

Is that a question or a statement? I can't imagine they would "have" to be populated to different tables, per se. Seems to me it would depend on the design of these target tables and how well that lined up with what you are getting. Having 'separate output links' like Ernie mentions doesn't mean the...

The OP doesn't want to clear the logs, but rather the various Invocation ID instances from the Director's display... which is why Kim suggested a script [cough] hack [cough] to remove the appropriate RT_STATUSnnn records.

Yes, DOS record terminators are different from UNIX ones. UNIX uses a single LF character while DODS uses a combination of CR/LF, so I'd suggest you look for the a CR - a CHAR(13) - in your derivation. Yes, the data has to load into the Transformer first to use the Field or any other functions on th...

Umm.. did I leave out that part?

NullToEmpty would be the proper choice in this case:


No need for it on a field you know will never be null, but if there is any doubt...

What 7.x version of DataStage are you running?

Oh... it's not all that bad. [nudge, nudge]

I've done it for both HR and GL 'pack free' and lived to tell the tale.

I would try:

You don't "need" the PACKs, they just make your life easier.

Pass that error message along to your Sys Admins...