DSXchange

I'm assuming they are but wanted some clarification as to how they work on the Server side.

Right. I don't recall where it is stored (uvconfig?) but the default maximum precision is 15 so that is probably coming into play here. Not something you just want to increase without making sure you know all the ramifications of doing so. You can also look into the "string math" functions...

That's an option for ODBC (and UV), there is a "Return multi-row result set" checkbox on the link, from what I recall.

Okay... still more questions but high level you just need to concatenate the two strings and the operator is ":" in DataStage so "String_A : String_B" does the dirty deed. But then I assume you already know that and the issue is bringing the two rows together. Yes? Since we're st...

Any chance you can explain your output requirements in words? And this input... is it all one string and you need to parse it? Separate fields? For the latter, which bits are the fields? Better to have too many details than too few, then we can stop all this back-and-forth and get on with the helpin...

Let me see if I can help on the subject of the subject.

:? Unfortunately, that's not really enough information for anyone to help without guessing. What does 'concatenate two rows data into one row' mean, exactly, in this context? I have no idea what your expected output would look like, what you've tried in a transformer nor what 'not working' means. So...

A null pointer exception? Involve support.

Right, you need to find out what's under the covers of that "POS system"... we're assuming a database but you need to find out which one. And as noted, let us know what "system" we are talking about as that could also drive the access method - ODBC, a dedicated API, etc.

Right, my understanding is both invoke the exact same tsort operator 'under the covers'. I had the same preference as Arnd noted for the same reasons.

And he has to guess because we don't have the score to examine. But then Ray is a pretty good guesser.

No worries, it happens. Next time just delete one of them. Not this time, however, I've already done that.

On the question of how they are calculated, have you been through the documentation on the subject?

From a private message that should have been here: The above mentioned points are in prod server and i am keeping this post from my local machine. So cannot post. :( or else just explain how the processes are calculated. In my opinion, it's always best to look at things like this 'together' so we ca...

Post it.