DSXchange

Several ways. There are "DSGet" functions for log information that you can use in a Server job to farm that information from other jobs. You could also hand-code some job control code in BASIC using them so you'd have complete control of the how and what. Their equivalents also exist as 'dsjob' opti...

That could be *a* solution. However, from what I recall the Server MERGE stage uses hashed structures under the covers to perform that operation so I doubt it will work much more better. Me, more than likely I'd bulk load the source file into my database and let it do the work from there. As to the ...

There's no 'automatic' override at work here, which it sounds to me like you are expecting - you either pass the Sequence parameters to any called job via the Job Activity stage or... you don't. How are you handling things in your Sequence job?

Umm... that will delete a wee bit more than just the executable.

flat file, not hashed file.

DYMD[4,2,2] should work fine, I would think.

Ok, seeing as you now know it *is* installed, seems to me it would be best to follow Ken's advice and use the more explicit format he noted in his post.

Not positive, but pretty sure one way to check is to see if you have an entry for NLSMODE in your $DSHOME/uvconfig file. No mention = not installed. If it is there, then seeing it set to 1 shows it as enabled, while 0 is disabled. If you do have it installed and enabled and can afford to experiment ...

More information, please. What are you selecting - CLOB data? Details, man!

Out of curiosity, what exact version of Oracle? Any idea 'how much' of the LONG data you actually need?

LONGs are evil, btw. They should be converted to some other type at your earliest convenience, like the slightly more well-behaved CLOB for example.

I would think the solution would involve a call to your official Support provider. I was only able to check 7.5.1A here and it returned the expected value.

Interesting... just saw Ken's question between previews. Curious to see if that will affect the answer.

Welcome aboard.

Simply put... none. Should be quite painless.

Excelllent.

Welcome.

How would you call an Oracle function outside of DataStage? The same answer applies inside a job.

This? I don't recall seeing any posts from '4friends' that hasn't sounded like someone farming interview questions for their friends. And this from someone who has ranked themselves at the Teacher Level.