DSXchange

Use the Aggregator stage, perhaps in a fork-join model as you indicate. It will work, and it's the easiest mechanism.

Why not upgrade to version 8.5? Far fewer bugs and a much easier installation than 8.1 and, yes, Enterprise stage types are automatically converted to Connector stage types.

Looks like you have a field on the input link that is not transferred to the output link. Do you really need this field?

I believe, but have not checked, that the ".isx" file is compressed.

DataStage export generates ".dsx". Information Server Manager export generates ".isx". The former can include only DataStage components. The latter can include components from other products, such as Business Glossary and FastTrack.

What's the value of the WHERE Clause property?

Assming you're assigning a job parameter value in a job activity in a sequence job, then you need to obtain the system date (either as the system variable @DATE or function Date()) and convert it to your required format. Oconv(@DATE, "D-YMD[4,2,2]") If you require a timestamp format, then ...

Three admonishments: 1. Always post in the correct forum. The one you chose is to suggest ideas for formal FAQ articles. If this is a DataStage question, post either in the Server job forum or the Enterprise Edition (parallel job) forum or, if you are not sure of the job type, in the General forum....

A job can not attach to itself. Do not call DSAttachJob() at all. Use DSJ.ME for the job handle in the other functions.

When the field delimiter is something else.

This is precisely what the new looping construct in the Transformer stage (version 8.5) is intended to do.

This is a useful technique: it has been posted previously. Convert(InLink.TheField, Convert(InLink.TheField, "0123456789", ""), "") The inner Convert() function returns a string of all non-numeric characters in the field; the outer Convert() function removes all of thos...

U is one of our posters. Ur was a city in Ancient Babylonia. The second person pronoun in English is spelled "you" where nominative and "your" where possessive. Please strive for a professional standard of written English on DSXchange. You can create an empty file in an after-jo...

The Surrogate Key state file should be created using a job that has the Surrogate Key Generator stage with no links whatsoever.

The Surrogate Key state file can then be initialized, if required, using a job that has a Surrogate Key Generator stage with an input link.

If you're reading a string containing a timestamp, just use substring technique. InLink.TheString[6,2] If you want to remove leading zero, just use this in an arithmetic expression. InLink.TheString[6,2] + 0 Since server edition does not have an internal timestamp representation that's all the discu...