DSXchange

What's different between the two environments, particularly how the connection to DB2 is configured?

The command CLEAN.ACCOUNT will interactively delete VOC entries that point to files that can not be opened. By interactively I mean that it will ask you whether or not it is OK to do so. This is a "green screen" utility, so there is no "yes to all".

There is a vague logic to the choice of forum - the OP requires dynamic design in real time. Some parts of it can be done (for example by specifying entire expressions as parameters) but, as a general observation, I'd have to agree with Craig that it does not sit well as something one would expect t...

Check that you have read and execute permission on /home/release/Vality/IPE/dvlp/7/5/1/7/lib/libicui18n24.so and all its parent directories.

In version 7 there is a limit of five passes. I don't know, however, whether this limit still applies in version 8. If it does, it might explain a fatal error on the sixth pass.

Welcome aboard.

Unfortunately you usually get vague statements that "the data need to be cleaned up" or "we need a single source of the truth", and end up being guided by the results of your Investigations.

Routines are created in the DataStage repository (New -> Server Routine) and can either be transformation functions (executed for each row processed) or before/after subroutines (executed once per job). You can do whatever you like - whatever your coding skills permit, anyway - within routines, but ...

Domain controller is only relevant where the DataStage server is on a Windows platform. It is one way that Windows authentication can be performed. I included it for completeness, and forgot completely about LDAP servers (Active Directory servers) which can also be overwhelmed by demand for resources.

DS.CHECKER has no command line arguments. It is used to delete orphaned repository tables where deletion of a job has failed to complete successfully.

Yes. Use proper metadata. This will require two separate jobs in your case, the decision about which one to use being made in a job sequence that tests the file name.

We have another thread current on HELP. It is blocked from the client. Please read the other thread.

There is no HELP for DS.TOOLS or DS.CHECKER commands.

True in versions 6.0 through 7.1, no longer true. Keep it in.

DataStage is perfectly happy with that date, and even accepts BCE (before Christian era) dates.