DSXchange

Did the file system on which your project exists ever become full? If so, some of the repository tables (which are hashed files) may have become corrupted. Search the (server) forum for ways to check the integrity of hashed files in the project. To check a single file you can run a query against it ...

Windows process IDs are allocated by the Windows login process. You can see the process IDs on the Processes tab in Task Manager. You can NOT allocated process IDs yourself; they are the operating system's mechanism for uniquely identifying each process that may be requesting system resources.

1. To delete all the content from the repository (make sure you have an export or two and a backup) go to the Administrator client, delete the project and create the project anew. 2. To remove orphaned files execute the command DS.CHECKER in your project, either via the Administrator client Command ...

I don't have access to DataStage right now, but I am fairly sure that there is another function to decode the return value from UtilityRunJob.

Can you search your routines for it? It's probably in the same category as UtilityRunJob.

Use the key management routine when initializing a stage variable, and do not overwrite that value with a stage variable derivation. That way, the function is only evaluated and the number is only allocated once.

Jagan,

Can you please be more specific? Note from your other posts that there are different kinds of rejected rows. About which kind do you wish to ask?

Hey, I've learned something new today! Now all I have to figure out is to whom to spruik it.

Performance tip: this design

will run faster than this design:

because of the assistance of gravity.

0x80 (or 128 in decimal) as a single byte that represents NULL in DataStage, but the Euro symbol in Windows. Did you have code page 1252 set when performing the export?

Our beloved moderator is extremely busy at the moment. How about you post in the parallel forum? Just copy your post above into the new one.

Can you try running the SQR using START, so that it runs in a separate Window?

You can take advantage of shared connections by starting one client from the Tools menu of another. For example, if you start Director from the Tools menu of Designer, it still counts as only one connection for client licensing purposes. Up to ten connections are supported from any one client machin...

I doubt that "commit" relates to reading messages, but would need to read further to be sure. You can, too; there is a manual for the MQ plug-in stage.

DataStage TX 8.0 has been GA for some time already.

I guess the whole point of CASS is that there ought not to be anything unclassified (if it promises total coverage)!

Make sure you have a process in place for getting regular updates - folks demolish and build, which does change the data!

IBM is SO much larger a company than Ascential, you've got to expect SOME more bureaucracy. My personal opinion is that they overdo it, and it has cost them some business on occasions, but it's their company and they can run it as they like. The support folks are largely still the same ones you used...