DSXchange

The answer is yes and an example is in Ray's post.

I would make sure you have all of the available fixpacks installed. From what I recall, there were quite a number for the connector stages.

I'm curious... how many times are you going to post this rather nebulous "business requirement"?

Bicchu wrote:Can anybody please tell me what is NLS?
And how to check whether it is installed or not in a system?

You can check the NLSMODE setting in the uvconfig file. If NLSMODE is 0 then NLS has not been installed. As to what it is, Google is your friend.

Best to take advantage of that 'Copy to Clipboard' checkbox then post the text here rather than link to an image. Have you tried doing an exact search here for a small portion of that message, say the "failed to authenticate" part?

I stand corrected.

In other words, treat the disease and not the symptom.

dsx is dsx, so exactly the same regardless of source. And from what I recall, there is no command line import in the 7.x release. GUI only.

First suggestion would be an exact search here for "scientific notation".

No problem. DataStage doesn't have an "Immediate If" function like Informatica so just stick with classic if-then-else syntax.

Sorry, but why would anyone even use an ETL tool if you could do everything in PL/SQL? Sounds like someone who didn't really understand the arcitecture built an extremely sub-optimal job for something that could be accomplished via sql joins and simple inserts - in an ETL tool or otherwise. All I me...

So, clarify for us - was the status of the Sequence job "Aborted/Restartable", simply "Aborted" or something else?

Apples and oranges. Heck, apples and something not even a fruit.

So, saying that your job was "getting failed" was completely wrong. It completed successfully but logged at least one warning.