DSXchange

To configure a Range lookup on the other input, use the drop-down list of Lookup type and choose Range. The Key Expression field then becomes enabled. Double click in the Key Expression field to open the expression builder for range specification.

The second record may have failed because it has mismatched quote characters.

We can build a database. We always build a database.

It's not a bug - it's an alert. As the metadata are specified there exists a potential danger that you would lose data through truncation, so an alert (warning) message to this effect is logged.

You need a combination of StringToDate() and DateToString() functions each with an appropriate format string.

There IS a BASIC function (Ereplace()). But you can only use BASIC functions in the BASIC Transformer stage in parallel jobs.

So the issue here is your predilection to post on DSXchange before attempting diagnosis yourself?

Welcome aboard.

Your question is just a little too vague - I assume you're referring to the component that invokes a QualityStage job from DataStage. Is that correct?

BLOB is not supported for most stages. In Connector stages you can specify to use references to LOB data types.

Dare we ask why these runs have to be consecutive? If you allocate two readers per node to the Sequential File stage (and I'm making a big assumption about the source there) you will have the division that you desire. They will execute concurrently, but load into the target on what are effectively s...

Well, date/time modified is displayable and, indeed, searchable (Advanced Find) so presumably it's in XMETA somewhere!

That's a challenge, but one that I think has a solution.

(But it's probably posted in the incorrect forum.)

They have stopped using DS_AUDIT. Definitely.

chulett wrote:Quite simple to substring instead, as already suggested.

... only with the internal looping feature in version 8.5, since there are multiple occurrences.

To use pxEreplace() - assuming you've installed and compiled it, etc. -

Of course, it might be a server job, since the question was posted in the Server forum...