DSXchange

So would we. However, the onus of figuring that out is going to fall squarely on your shoulders I'm afraid, as you're the only one with access to the actual job in question and all of the dirty little secrets it may contain. :wink: ps. I've done this before so it's certainly possible and I don't rec...

That doesn't sound all that 'random' and a tablespace issue can certainly mess you up big time. What about other occurances? Were there times with no obvious triggering db or data issue?

Sure, you can always dump the score to get all kinds of gory details that you wouldn't get otherwise. And correct, the OE stage does not include the source SQL in the log either. So I think it's safe to say that's not something that is available from the Enterprise stages.

Not really sure what you mean by "get to the results from a DataStage job"... can you elaborate a little on that, please?

Hmmm... thinking about this, I'm thinking Server stages not PX EE stages, so perhaps this is a issue particular to the "Enterprise" stages. I won't be able to check on my end for a few hours, however, but I can check Oracle and perhaps ODBC on my end as well. To me, either they echo the SQ...

Welcome. These seemingly random errors are some of the hardest errors to track down and the fact that it 'works' in Toad doesn't really tell us much other than to let us know that it is syntactically correct. You'll probably need to take this to your offiical support provider who'll be able to dig d...

Then talk to your DBA. A direct path (DIRECT=TRUE) load generally isn't restartable, however there is a SKIP parameter available for a conventional (DIRECT=FALSE) load.

I'm kind of surprised by this, every other db stage I've seen logs the SQL being run so I don't see why the ODBC stage wouldn't do so. Are you saying that's always the case or does it depend on a particular option that you've chosen?

Hmmm... I believe there is a hidden project called the 'Template' project and that is what 'seeds' any new project creation. However, I don't know how to change the default NLS setting there, if indeed that is what is controlling it. Sorry.

It would propbably help if we knew what database you're targeting. And the first person I would take an error like that to is my DBA.

You would need to join those two tables in the query and then filter on the CATEGORY field in DS_JOBS. You can join them by job name, I believe.

Luckily, the Acrobat Reader has an 'advanced search function' where one can tell it to search in all pdf documents in a certain directory, cuts down on the amount of eyeballing required. When searching for "command line interface" didn't really help, I checked for "dsjob" and the...

I don't think it (the syntax) changes. Just the values you pass.

"wondering if we can read the same dataset from a different job which is using a config file ( may be less or may be more number of nodes)." It is perfectly valid to read a dataset created on X nodes by a job that is running on a different number of nodes. That's what I was "yes'ing&...

I'm sorry, but how is this different from the last time you asked this question?

viewtopic.php?t=128809