DSXchange

praveenala wrote:This is sever only.

Umm... it's red because it's a Parallel function. As Modify is a Parallel stage. Neither apply here.

Stick with the 'Conv' brothers - IConv and OConv.

Change your code to include whatever is coming back in the Output variable when it logs the results.

And by 'aborted' you mean... what? An actual error message would help track down the problem.

I told you to stop picking on me or I would tell!

Or the Mother of All Posts on the subject here.

Not really what they're after, Vince. It's a matter of both insert and update, not one or the other. Or at least the possibility of both. Sai, look into combining your two jobs - literally. Two links from one transformer into one database stage will do the trick. You've hashed up your current keys s...

Nope. Same messages.

You need to look in the log of the Sequencer job to see what happened with the Execute Command Stage. Usually you need to double-click on it to see all of the gory details. The job won't error when there is a problem running your command... well unless you have triggers to handle that and the comman...

You'd need to combine what you are doing with the batch file into a routine if you want to go the 'read the results file' route. Use 'DSExecute' to run the bat file and then the sequential file operators to read the file. If the sql session echoes anything usable to the screen, it can be captured by...

Hmmm... he does say "Get to a DOS prompt" and "can perform a treewalk in a directory structure, much like find does in UNIX".

Agreed.

sainath wrote:I JUST WANT TO KNOW WHETHER WE CAN DO THIS IN SAME ONE JOB.

Sure.

That depends on how you script is written, so I would venture to say that the answer is 'no' right now. All DataStage knows is the exit status of your wrapper script. If the script runs fine but there are problems in the sql, DataStage won't know unless you pass that failure out. Meaning, you'll nee...

If you expect some help, you might want to explain what 'not working for me' means.

What you've tried, what error message you've gotten, that sort of stuff.

(I wonder, how many posts in a row can we get with rolly eyes in it?)

Server != Parallel.