DSXchange

As a guess, I would say to true.

Interesting... hope it didn't take a year to figure that out!

I would imagine you could have put those same changes in your dsenv file so that any job with that particular stage would now work.

Too bad then that I'm not actually doing this in DataStage.

Yah... I wonder what that answer would have been?

Seems like you and highpoint have the same issue:

viewtopic.php?t=135740

Do you have multiple projects? Does it work in others but not in this one in particular?

Post. The. Script. Not one line from it or what you are putting in the stage but the entire contents of this "script" you are allegedly running. You have several problems here. Ray mentioned "ftp" because of this: Error: User logged in. Type set to A. ?Invalid command You have tr...

Yah, noted earlier that if this was a Server job, I'd have beeen done with it in two shakes.

Still pondering this and if it is really worth all the effort for a one job solution.

That sounds fine but does it really handle multiple changes to the same business key? It doesn't seem like I can save the inserts until last unless I know there will always only be one per key, otherwise those 'expiry' updates would be for inserts I haven't done yet. Yes?

I figured what was meant was a sort on a transformer link, which to me isn't "in" the transformer but that could just be semantics... or I could just be wrong.

Looking for some conceptual help on a particular Type2 SCD issue, regardless of the tool used. Technically, I have this with Informatica right now but it's not all that different and looking more for methodology than implementation specifics right now. Besides, the peoples are way more smarter here....

OK, took a drive through all of the 8.x documentation I have stashed away and came away mostly empty-handed. Here's what I found in Chapter 4 of the Server Job Developer Guide: dsjob Command You can use the dsjob command to call other WebSphere DataStage jobs from Command Stage. WebSphere DataStage ...

The join stage requires sorted input to work properly. Not sure how one would sort 'in a transformer', so make sure that either happens in your source selects (if from a database) or via explicit sort operations before the join. The hash partitioning should be good as long as you are partitioning on...

It took you less than an hour.

Give the full path to 'wc' in the script. If you still have problems, post the script and the exact, unedited error message(s) from the log.

You can certainly read it under a 2 node configuration, no conversion required.