DSXchange

Do what you're doing, then pass the results through an Aggregator stage selecting the Last record for each key.

I do not think so, other than as part of a whole project export.

Derive field0 as InLink.field0

Probably. DB2 stores dates as datetime data types. Change the format in the tool to a date-only format if that's what you require. But it makes no difference to how the dates are stored.

You're welcome, though "instant reply" was simply a matter of luck (time zone of my current location, lunch break). Craig, of course, never sleeps.

If you don't mind all the errors that are generated when you send rows that already exist in the table, yes.

Make sure that you don't send these rows.

"Displayed" using what utility?

What character did you trim? New lines are usually converted to field marks, so that you need to trim @FM characters.

Call DSSendMail in an after-job subroutine, or use a Notification activity following the Job activity in a job sequence.

Customize a copy of the UtilityHashLookup routine so that it uses OpenPath rather than Open.

You are not right because your fundamental assumption is incorrect. They are completely different products, and completely different Transformer stages. One (server) generates DataStage BASIC code while the other (parallel) generates C++ code. Therefore they use completely different compilers (DataS...

Cool.

There isn't one. Stop thinking like a server job developer. Start envisaging virtual Data Sets, and learn how an index to a virtual Data Set is built "on the fly" on a reference input link to a Lookup stage, except when that link is serviced by a Lookup File Set or when sparse lookup is specified.

LIST.DICT is not SQL so does not take a terminating ";" character.