DSXchange

From what I recall, 7.5x2 is the only 7.x Parallel version that supports running jobs on Windows. All others would give a "not runnable on this platform" error. BTW, what Windows version are you running this on? Normally we'd suggest going to your official support provider for help, but th...

What kind of help do you need?

Are you on "8.7 onwards" as noted?

Your stage in the DSGetLinkInfo() call should be a transformer in a Server job, an active stage. More than likely you can get both source (incoming) and target (outgoing) counts from it.

So this really has nothing to do with a hashed file lookup per se? But rather an error when attempting to write to a Sequential file? Sounds like your output file path is either invalid or your running user doesn't have permissions to write to it.

Hi, I am new to this forum...don't know whether am posting to the correct link or not Welcome. And... you're not. :wink: You needed to start a new post but instead you replied to an old one. I've split this out for you so now we're better but I had to guess on your O/S and version. Please let me kn...

Three year old post, so probably not much "sharing" going to happen at this point.

OK... then it's not supported and it would seem you'll need to rewrite it so it doesn't use those inline views. They're not really needed and just add an unnecessary level of complexity since all you are doing is: SELECT C.COL1, C.COL2, C.COL3, D.COL1, D.COL2, D.COL3 FROM C, D WHERE C.COL1 = D.COL1 ...

So... "subqueries are currently not supported as tables" came from you as what you think might be the issue or was that actually reported by the connector? If your entire error is "invalid property value" then I would wager it has nothing to do with the SQL itself but rather some...

Hmmm.... looks like naughty stuff, the kind of thing that doesn't survive across major releases, and there have been two since it was created. Gonna have to defer this one to Ray or Kim.

And now you've edited it down to almost nothing.

Can you post the routine code, please?

"Goes for a toss"? Is that a new technical term? I'm going to assume you weren't talking about definition #3.

And if you remove the call to that routine does it compile ok? Please detail your job design.

Rather than these 'sed' shenanigans, have you tried using a Server job? Or the Server Sequential File stage in a Server Shared Container? Much more... forgiving.

Ray, for what it's worth I noted that in my first reply. And as you said it does mean they are connecting but not that there's a setup issue on the database side but rather simply the instance connected to is down. So a client / tool setup issue I believe since they can successfully connect to it fr...

Well then send the same rows to two Filters, one that passes only India and another than passes all not India. Or just do that in a Transformer via output link constraints.