DSXchange

Well then, the first suggestion would be to enable Read Caching in the lookup and let us know what kind of effect that has on your job speed.

What was the resolution? Best practice is to note the actual resolution to your issue, in case anyone comes searching with the same problem. That and please mark your topic as 'Resolved'.

Hi ray, yes i replied upon what i see in the director the job is still in running state. That wasn't the question. Specifically, the Director status (like 'Running') is just a flag. If the job in question dies in such a manner that it cannot update its status, the Director will show 'Running' forev...

You can't via Oracle, seeing as they're not Oracle tables. You could, however, source from them using the Universe or Hashed File stages and load their data into Oracle if you like. Please explain what you mean by 'DataStage Universe' tables. Hopefully you mean an actual honest-to-goodness Universe ...

Odd. Are you selecting from more than one table by chance? Can you post your SQL?

Sorry, what? Please explain what you mean by 'tabs' and how, exactly, they are not working.

And to help with that, as with most commands, you can execute dsjob without any arguments to get the 'usage' statement. That and read the Server Job Developer's Guide pdf, down near the end there is a chapter on the Command Line Interface which rather thoroughly explains all of the various options -...

Shouldn't be too hard. Well, in the sense that I know a number of people here don't need much of an excuse to 'sink a few beers'.

If it wasn't for the UK part, I'd be there.

Then between what Narasimha wrote and the 'Automatically handle activities that fail' option, you're all set. Just wanted to double-check as this functionality wasn't available in early versions.

As long as no-one has replied to it, yes that's all it takes. However, now we get to wait for the Moderator.

Best to ignore the duplicates, people - if Whale had, the OP could have deleted this one.

What 7x version of DataStage, exactly?

I left that part for you, Ken.

(ding)

Not sure if you can get this information from dsjob -paraminfo. No, you can't. Oddly enough, you need to go back to Ray's first reply to this whole Charley Foxtrot for the answer - it's all in the logs. That is where you need to go to find what you are looking for. The first log entry lists the par...

Just to allay confusion before it starts: I meant to say that the delimiter is the pipe symbol ( | ) and the quote character would be three zeroes ( 000 ). And just to further allay confusion for anyone who's never played with those settings before - setting the quote character to three zeroes does...

Actually, he could so his PATH must be setup correctly. You can tell because it complained about the INVALID/UNKNOWN PRIMARY COMMAND SWITCH, not the fact that it couldn't find the executable. And you don't need to be 'in the path where the Projects are found' for it to find things properly - you jus...