DSXchange

You might want to start here.

... or checked about firewalls.

I didn't think it was about the keys, necessarily, was curious if marking multiples would cause an issue. In the old days I recall the job failing if you'd done that, is it allowed now and actually works? Or does it pick one of the multiples to use?

Unless something has changed, only one "key" column was supported. [shrug] And the new Assembly doesn't support splitting directly from what I've read here but there is a 'trick' you can do with End Of Wave markers or some such to do the same thing. I'll see if I can find the post where Er...

Wish I could help, just trying to make sure there's enough information here when someone with more XML smarts wanders by so they can help properly. Thankfully, it's been far too long since I had to worry about stuff like this. :wink: One clarification - when you say "key columns" as in plu...

Excellent.

I wasn't suggesting you use the new one, simply asking if it was the one you were using since you are running the 11.x version. And you're right, it does add a level of complexity to the process. It shouldn't be a problem to stick with the XMLOutput stage. Can you post the XPath Expressions you are ...

Yah, should have thrown that question out there as well as it is the 'go to' question in situations like this. Guess the 'clustered' part threw me off a bit, just went and read up on them and I don't think that plays a role. Using the proper hash partitioning should keep the four updates from throwi...

SwathiCh wrote:Can we update a non partitioned table with non partitioned Index in parallel using multiple nodes from Datastage??

Can you do it outside of DataStage? I suspect the answer is no.

This looks like the 7.x code (and table/column names) that I knew back in the day, did you actually mean it won't work with versions after 7.x? Sorry, just trying to understand your statement.

the dot sepator was just an example And yet in your post all you mentioned was "I am trying to remove dots following initials and combine them" so that's why you got the answer you did. Always best to lead with a full example / explanation of what you need so you don't have people waste t...

Hence the 'grey' I mentioned.

Hmmm... what about the code is not applicable to the 7.x version? And you are getting picky about the "uv account" comment, he did say "once logged into your project" after that, so correct in spirit.

We also have a specific forum for site suggestions. Moved. :wink: Also note that I attempt to move topics of that nature over to that forum when it's obvious it should be there but sometimes the distinction is a little... grey. Then there's all the legacy stuff in the 'wrong' place from before I got...

Next time rather than "dots" just use the code tags, they preserve whitespace. Can you show us the XPath Expressions you are using? I'd also be curious what stage you are using, the new XML Assembly I believe it is called?