DSXchange

You need to have purchased licensing for the total number of processors that will be involved, sold by IBM in "processor value units". What you are using them for is immaterial.

Your understanding is incorrect. SC in this case is "source code" - it contains the C++ source generated by compiling Transformer stages, it may contain C++ code from Build stages, it contains the compiled versions thereof, and it contains osh scripts that are interludes to them. There's n...

Yes and no. I believe that the user executing the command does not have permission to write the object file(s) into the directory (current directory?). That, of course, has nothing at all to do with DataStage. However, if this routine is eventually to be called from DataStage then DataStage, too, ma...

Welcome aboard.

From what you posted it seems that you have not completely uninstalled DB2.

There could be as many as eight: RT_BPnnn - source code from BASIC components RT_BPnnn.O - compiled BASIC components RT_CONFIGnnn - run-time configuration RT_LOGnnn - job logs RT_SCnnn - osh and C++ components RT_STATUSnnn - run-time status of jobs and resources DS_TEMPnnn - transient components dur...

There is no JOBS or ROUTINES options for the DS.REINDEX commands. This is primarily because there are no tables of either name. The DS.REINDEX command is actually a script (or "paragraph") that re-indexes one of the repository tables that has indexes - all such tables have names beginning ...

Search IBM and other web sites for terms like "information agenda" and "information management". Data integration is one small piece of a much large picture. From the IBM suite, I'd include all of the Foundation Tools in addition to DataStage and QualityStage under "data int...

Use a Transformer or Filter stage to pass only lines with a trimmed length greater than 1.

What are T1 and T2? Are there more of them? What determines which rows go into which group? Do you have a specification (in English, not in code or pseudo-code)?

So your job doesn't have shared containers, routines or other dependencies, and is not invoked from sequences or routines? Your "solution" does not generalize.

Please clarify which stage type you are using. In your first post you said Change Capture stage, later you said Difference.

Because this stage type gives you the "after" record on the output.

Are you using an ODBC Connector stage? If so you can cause the schema mismatch to throw a warning rather than a fatal error, to determine whether it actually affects the data in the job. Ideally, of course, you need to resolve the metadata mismatch.

Is it the case that you're trying to pass the Change Code to the database table which does not have a column for it?

Sort with "null position" set to First then use a Remove Duplicates stage to preserve the last in each group.