DSXchange

It happens because NLS is enabled. You can't disable it if NLS is enabled.

Can't you send 6 and 5 along separate links into a Funnel?

In that case you need to understand the (undocumented) structures in tables like DS_JOBOBJECTS or RT_CONFIGnnn. At anotheritco there's a utility for determining what hashed files are used; perhaps you could adapt that.

What data type is the result of subtracting two timestamps?

Depends what the producer stage for the output rows is. If it's a Transformer, use that. Otherwise use a Column Generator or Surrogate Key Generator stage.

Sequential means "running on one node". Which node is determined as part of a resource allocation algorithm when the score is composed.

Is DB2 really on a mainframe, or have you misconfigured the DSN?

However Time() - 3600 is correct. If that result is negative you have to subtract 1 from the date. If @TIME < 3600 Then Oconv(@DATE - 1, "D-YMD[4,2,2]") : " " : Oconv(@TIME + 86400 - 3600, "MTS") ElseOconv(@DATE, "D-YMD{4,2,2]") : " " : Oconv(@TIME -...

No idea without a lot more information about your choices of blocking fields and match rules!

Agreed. My last site had more than 64,000 users in Active Directory.
Filter first. How hard could it be?

It has already been given, even in this thread.

Welcome aboard.

It's already there.

But it's not in the Palette (they prefer that you don't use it). You need to find it in the Stage Types branch of the Repository.

Did you click on the "What's this?" button?

Not one function, but you can build it up from more than one, including Date() or @DATE (date in internal format), Time() or @TIME (time in internal format) and doing the time arithmetic for the one hour offset. You could do all that in a server routine, too.

Go to the Information Center (http://publib.boulder.ibm.com/infocente ... /index.jsp) and search there for "DataStage NLS". The first hit should be the topic about configuring NLS.