DSXchange

If you're prepared to use a BASIC Transformer stage this is a very easy task - convert each X into a sharp sign (#) and use that as the mask in a Fmt() function.

There's probably a solution using the parallel Transformer stage. What have you attempted thus far?

Can you export/import successfully using Designer client? If so, then there's something wrong with the way you are using dssh or DS_IMPORTDSX but, without more information, there's no help we can give you on that - you need to let us know precisely what you did and what error messages obtained.

Use the expression perhaps in a User Variables activity so that you only have to execute the expression once.

Open Admintrator client, select project, click Command button to open command window. There is no single command to check all indexes but, if you have exclusive access to the project, you could simply rebuild them anyway using the command DS.REINDEX ALL. Otherwise you need to execute each of the fol...

Why?

20 jobs will make it easy to maintain into the future.

It's not necessary. The Funnel stage is a parallel stage. Anything it does is done on each node on which it executes. Separately. Partitioning is preserved.

A sequencer works very simply.
Its output fires if any/all of its inputs are triggered.

Canada also has RCMP

A Routine activity is a sequence component that invokes a routine. The routine (which you would need to create) calculates the required date, which can be passed back as its return argument or through a user-definable system variable.

Something - perhaps invalid indexes - is preventing a SELECT from completing successfully. Check that your repository indexes are intact and up to date.

Use the transaction isolation level property.

Then you might prefer the !EXIST routine, which you will find documented in the DataStage BASIC manual.

Another possibility is that DSCheckRoutine() is OK, but your routine has not successfully been compiled yet.

If you track back far enough in history, there's a song called "Little Sir Echo".

It's easy enough to select "only one" record from the table. For example you can constrain on ROWNUM = 1.

It is a fundamental tenet of database design and usage that it is the database server, not the user, that determines order of storage. Therefore, unless every record is timestamped somehow with the date/time it was inserted (so that you can specify the oldest), there is no such thing as the first re...