DSXchange

Good catch! :D

You need a script to call sqlplus, one that can check for errors and pass them back. All you are getting now is the exit code of sqlplus and would only fail if it couldn't find sqlplus itself.

How did you 'join' it? If you did something else, run links from all Notification stages to a Sequencer set to 'Any' and then one to the Terminator.

I was going to challenge that too, but held back seeing the version number. We are talking 7.x here, not 8.x are we not? That was the impression I was under and speaking to, the long standing 7.x release. We're still on 7.5.1A and may go to 7.5.3 but the product is reaching the end of its life cycl...

What's "not working" about it? You'd need to be in the $DSHOME/bin directory or have that in your path to run dsjob, is your issue the fact that it is not found?

Pfffttt... I guess so. There's actually very few times I've used the DRS stage, not having any need to suddenly change from one RDMBS to another, I pretty much stick with the OCI stage. I know and understand that the server edition is really unstable but each day we learn of another defect Really un...

My 'IsNull' advice was generic, strictly meant as an example of how to test for null and not meant to be applied directly to this problem. It seemed pretty obvious to me that one would need to 'not' it in this context. Ah, well... c'est la guerre.

Looks like KBA code. To whit, a snippet from the Batch::UTILCompileJobs job: CompileJob: Key = DSR.SUB.JOB.RESERVE Arg2 = JobName Call @SUBR(Key, Arg2) Call DSD.Init(MyJobNo, Dummy2) If Key <> "" Then JobsNotCompiled<-1> = JobName:" ":"Cannot attach to job&qu...

Could you expand on the nature of this bug with 7.x and Oracle and the DRS stage? I'm sure there's plenty of people using this combination without issue, I know I am.

Didn't think so, but sure seems to me that's what the OP wants and you said "Sure, do it like this" so was a little confused. Never mind the fact it was fairly early on a hectic morning, what with two new puppies chewing on my cords and cables.

Have you checked with DataDirect?

http://www.datadirect.com

They supply the licensed drivers for DataStage.

AND not OR. And you can't check if something is equal to or not equal to NULL as that value is unknown. Use IsNull() instead.

Sure, a 'blink' is a 'backwards link' and you can search the forums for that term to find some previous conversations on this topic. Basically, the log has become corrupt, undoubtedly due to the high volume of writes causing it to run smack into the 32bit addressing barrier of 2.2GB. At this point y...

First suggestion would be to do an Exact Match search for your error:

The directory you are connecting to either is not a UV account or does not exist (39125)

There were 12 matches when I checked, see if any of them help you out.

You need to define what 'process it' means. That and answer Ernie's questions.