DSXchange

Filter stage can do that. WHERE clause supports LIKE operator.

I am also in the dark about "Engine node". Who coined this term? In grid configurations we use "head node" and "compute node" and, as Arnd noted, the term "resource node" is used variously to specify a node on which some particular resource is located/executes.

Templates are written to the client machine. My guess is that you lack write permission to the Templates folder or sufficient permission to one of its parent folders.

Welcome aboard. Hola!

You can change the NLS locale setting to whatever is appropriate to handle whatever data you have.

If you use a sequence you can very easily compare the (internal formats of) the dates in a Nested Condition activity (or in a Routine if you must).

YOUR routine GetParameterArray has not been imported into the project or, if it has, has not been compiled there.

DataStage is an ETL tool pure and simple. It is not about producing reports, protecting data, or anything else. There are other tools for this. DataStage outputs data. End of story.

The default is that it's always set if NLS is enabled. You can override this at various times, such as when importing table definitions.

A more general solution would have regard for the length of the inbound string. I'd use something like Left(InLink.TheString : Str("A",10), 10) If InLink.TheString is likely to contain more than ten characters this expression will return only the leftmost 10 of them. If this is not the req...

Why? XML is, by definition, free format.

There are XML formatting tools out there. Use one of those if you must. Formatting XML is not an ETL task.

Upstream of the Sequential File stage set the "preserve partitioning" flag to "Clear". A Search would have found this answer faster than waiting for someone to reply.

Andy is correct. This is provable, or you can just trust us.

lindatgeorge wrote:This is one of the requirements that, we have to use routine to call the job. I have used dssetparam and configured the parameters.

<rant>Resist stupid requirements!</rant>

Don't bother to hold them. Use a downstream Remove Duplicates stage to transfer only the last row of each group.

You've got me. The fixtool utility is supposed to operate in read-only mode - that is, it is not supposed to change the hashed file structure at all (except for updating certain counters and pointers - call them "the statistics" if you like). It may be that these were out of date and gener...