DSXchange

Close but no cigar.

I was almost going to get into a long discussion on the same topic, but decided not to. I've never needed to worry about getting dsjob components installed elsewhere, but I guess it could be a consideration in a situation where there's no way someone will be allowed remote access to the DataStage se...

No.

Honestly, never tried as I haven't needed them. If you 'Include job status in email' for Notification, you get everything I've ever needed. [shrug]

I would assume they could be used in any 'downstream' stage, have you tried using them in the body of a Notification email?

How many times are you going to post this question?

I've answered it in this thread:

http://www.dsxchange.com/viewtopic.php?t=118675

If you've got a simple count in a text file, you can easily build a routine to 'cat' the file and then capture the result. You can then branch based on that result.

Double-check the Oracle client versions on each server that you are leveraging for DataStage, that's usually what bites people.

Which it will then use to write an anonymous block.

What's different between the two environments? Are they on different servers? If so, what is different in the Oracle environments?

Any such messages will already be in the log, so it depends on what you mean by 'capture'. Email? Then a Notification Activity should be fine, I would think.

Since everything is in the proper order, I wouldn't bother with the Conv brothers or stage variables, just cat the pieces together and remove the delimiters: Convert(":-","",Arg1[1,10]:Arg1[12,5]:Arg2) Assuming the seq_no is passed in as Arg2.

Sure, but you'd need to remove the quotes around the DSJS values for it to work properly.

No clue as we're a Server only shop. You'd need to ask Chuck or see if he wanders by here and sees the question.

OK means OK, finished without warnings. There's another trigger for that.

You mean where they are documented? I'm sure it's out there somewhere but I check $DSHOME/include/dsapi.h instead.