DSXchange

Still...

It's a floor wax *and* a dessert topping! Seriously? A Designer doesn't develop, but a Developer could be a Designer as well. I suppose. Kind of a silly question, IMHO. You could always look up the definitions of those two words and decide for yourself. ps. You might want to revisit your Profile and...

Because it's just wrong. Hope Ray doesn't mind this... 4. In simple Server Edition is Code oriented sort of job where as Parallel edition is user friendly. That is complete tosh. Most good server jobs can be created without writing a single line of code. Expressions need to be built in both variants...

Do you have an Oracle client installed on your DataStage server?

Splendid.

anandkumarm wrote:I am still curious if I can do the same thing with out actually using the exec cmd and the user variable stage.

Nope, what you did is exactly what you should have done and is the correct solution in this case.

Left that one for you, Ray.

It would help if you actually asked a question.

There's no need to 'change the file', have your process that reads in those values and sets them in the Start Loop change the delimiter. For example, perhaps something like this would help:

EReplace(YourList,@FM,",")

Well, "RTI" is now "SOA" is now "WISD" depending on the release. And that is a different beastie from the "WS Pack", which are separate purchases. The PACK allows you to use web services as sources and targets in 'normal' Server jobs. There is also a Web Service Transformer if you need to call a ser...

From IBM. In exchange for money.

You can't use the exit status for this, you need to explicity abort the job - DSLogFatal() will do that for you.

In Server jobs, you would set the Contains Terminators property for any such columns to 'Yes'. Surely there must be an equivalent for PX jobs?

You might want to lookup the definition of fork in this context - and here, space means 'memory' not disk. And I don't see your DBA team being involved in the solution.

What kind of specifics? That's about as specific as I'm willing to get this early in the morning. Recognize that this is hardly a DataStage topic, this is something anyone doing pretty much any kind of data manipulation has to face and resolve. Suggest you Google for the topic, I can't imagine it w...

And here we were, doing just fine up until you said this: Please let me know ...ASAP [sigh] Please try to avoid demands in your posts, everyone here is posting when and how often they can or care to. Demand 'ASAP' from your Support Provider, you are paying them for that service after all. What preci...