DSXchange

Reset if required is needed to rerun an aborted job, a key need when building restartable Sequence jobs. If you simply say "Run" and the job is Aborted, the attempt to rerun the job will fail.

Your user does not have permissions to access the hashed file mentioned. Specifically, it looks like it is trying to delete / recreate it and cannot.

If by "stopped" you mean using the Stop button while the job is running, yes - that can happen. I only do that when the sql is actively delivering rows, if it is still "building the cursor" then you'll have issues, best to have a DBA kill the Oracle SID in that case.

OK... almost went into a discussion of transaction size and all that on the off chance you needed something along those lines, figured it would come out in the next postings if that was the case. Thanks Ray. :wink: And yes, always best to "explain in detail" right away rather than giving u...

If it does work great unchanged when the values are unique, then changing the repetition element probably won't help. I wonder if you can 'trick' it somehow, add an incrementing number perhaps that forces uniqueness at the proper level and then... remove it? [scratches head]

I would hope you've already done this, but for the record: did you try searching? An exact search for failed to authenticate the current user against the selected domain turned up 13 other posts, many of which were marked as Resolved. Did none of them help?

Why not just create a Server job to read it and do whatever you want with the data? Either a Hashed File or UniVerse stage can easily source from it.

[groan]

In that case, you need to mark the subject as Resolved using the button at the top of the screen.

That's fine, what I posted will still work. Did you try it?

If the requirement is "two adjacent fields from a space delimited string starting from the second field" then Field() will do the trick:

You don't need to do anything special as (basically) that is how a DataStage Server job works. Each record will make a complete trip from beginning to end, source to target, cradle to grave, individually in a serial fashion.

So... you're good.

To answer your other question, ID is the Key field. That's way too "high". To quote our dear friend Ernie: As for repetition element, I generally refer to it as "an element at the lowest level node in the document that I am interested in." It's the node that you expect will &quo...

Hmmm... do you have a Repetition Element (key) marked?

ps. You really should start a new post for new / unrelated questions.

All true - and welcome, btw - but the OP specifically asked "How can i redirect output of dsjob command to LOG", so that was the question that was answered. We'll soon see, I hope, if there's more to the question than that.