DSXchange

gpatton wrote:Make sure the tag is fully qualified.

You should probably explain what that means, g.

Why post this twice? Please see the answers in your previous version of this question.

No, it doesn't... or at least I haven't seen that returned anywhere from an OCI stage. Give it a shot and let us know. Typically I believe you will find that you have to farm that, post job, from the job logs.

Glad to be proven wrong!

You could have had a more robust script, that only generated an exit status of 0 if absolutely everything was OK. This *is* the answer - you need a better script, one that properly communicates what happened in sqlplus back to DataStage. Most times, when people have this issue it's because they hav...

Not an XML expert by any stretch, but that XPath information it imported looks wrong. Try a couple of things. Change the XPath bits in the Description field from #PCDATA to just text() and see if that works. Also, only select a field as a Key if it is a repeating element, if you always just get simp...

Where does DS store job logs? Are they in a text file that can be edited? David seems to have thrown you straight into the Advanced Placement class when it doesn't even seem like you've taken the 101 version yet. In addition to all that, the simple answer is 'no' - they are not text files. You'll s...

We have imported all the jobs from 6.x to 7.5. Tell us what this means. You have a new, clean install of 7.5 that you imported 6.0.3 jobs from another server into - or did you upgrade 'in place' from 6.0.3 to 7.5? What was your upgrade procedure? If you searched the forum, you would have seen many ...

Please have a go at searching the forum as this topic has been discussed ad nauseum here. Specially, search for the dsjob command - that and read the Server Jobs Developer's Guide the Command Line Interface chapter in particular.

Sure. It's basically a 'switch' managed from the Administrator client.

Can't be done as far as I know. Protect the project.

You need to make the project a 'Protected' project. And yes, via the Administrator.

The is no builtin mechanism in DataStage that can handle this type of scenario. There is no builtin mechanism is any database that can handle this type of scenario. Well, unless Ray pops up and tells me that Redbrick can handle it. Just want to make sure this doesn't come across as some kind of Dat...

The only confusing part might be the missing 'number of rows' that were actually returned. All you are seeing is the place-holder %d for a decimal number that is not being populated and is a bug in the stage, I would think. In the long run it doesn't really matter, however - Arnd nailed the gist of ...

That's a new one on me... I take it there is no "next Oracle message"?

Never tried that way. We've taken two different approaches: One is to rebuild the hashed file such that the deleted rows are automagically removed. Another approach is to add a 'deleted' column and mark them as logically deleted by updating that indicator during the delete process. Your jobs then ne...