DSXchange

As noted, you are always going to get the "startup" and "shutdown" phases executed, regardless of constraints on the link or your desire to control everything with a parameter. So while not necessarily meaning you "need" two jobs, you could use two for this or simply bu...

1. No, that "7.5x2" was a special, one time only magical release of the 7.5 (.2 I assume) parallel engine on Windows and was the only time the "x" was used. 2. No, separate media/download for each O/S and for UNIX that means for each "flavor" as well - so Windows has on...

I see... gotcha. Should have realized that.

Yes, that's how it works - the truncate is issued when the stage initializes just after connecting but before any rows flow, much like anything in the "before sql" tab. It doesn't wait for the first row, so if you "truncate and insert" and send it no rows to insert, you end up wi...

And if that still wasn't clear - crucifix combined with leg triangle!

Fair enough... mine, too.

So... concatenate the new value on the front of the current string and take the leftmost 11 characters. Left(X : XXX, 11) in other words.

Regardless, build a looping structure. Use 'dsjob' to get a list of the jobs in the project and then iterate through that list and get whatever it is you need from each one in that fashion.

Me happy most of all, as I was the "keeper" of this particular copy and finally ask Kim if he could host it so I didn't end up emailing it around for eternity.

Interesting... I guess there must be branded ODBC "Universe" drivers out there. I don't have any kind of DataStage access at the moment, so couldn't check what you might be using in the stage for this.

Now I'm curious, does that fact help you at all? Solve your problem?

Because it's there?

Wanted to start a thread where, for those of you who attended the webinar Tuesday, you could come and ask any questions specific to the topic. So, any questions you had that didn't get asked or perhaps were not answered to your satisfaction? Something that came up afterwards? Hopefully, the webinar ...

So... use that same code in a routine if it's working for you as you need. Does it?

I don't believe so, from what I recall you'll probably need to update to a 7.x version first and then from there go to 8.

Sounds like a bug and something you'd need to contact your official support provider for to see if there is a patch available.