DSXchange

Just copy those rows from DSParams that you need in the new project, and make sure that they are emplaced in the correct section in that project's DSParams file. Ideally preserve alphabetical order. This is not essential, it just makes the drop-down lists cleaner when adding environment variables to...

Please copy/paste the exact error message logged by the job control. In particular I am interested in checking the spelling and casing of the job that it can not find.

Does the executing user ID have write permission to RT_SC2 directory?

The installation, as I said, is automated. You no longer need to enter any license code - the installer reads an XML file that IBM sends you. For certification what is really important to know is what components need to be visible on every processing node. Search in the manuals for a word such as "d...

Example:

After the job aborts, reset it using Director. Does a message "from previous run" appear in the job log? If so, what does it say? If nothing has changed in the system (and you are 100% certain of this) and your job has not changed, then the only thing left is that there is something different about ...

Disable operator combination so that a more precise diagnosis might be obtained, particuarly in relation to the actual source of the error. Also post what you believe the data should contain (and why there might be an 0xFFFD character therein).

My guess is that you have some empty or null dates and these are sorting to the beginning, leading you to believe that they are all coming out empty. Scroll down until you find a date.

Welcome aboard.

The answer is "no, changing the link type is the only way to create a reject link on a NZLoad stage that has an input link". And you probably have to emplace the output link first, then change it, then emplace the input link.

1. Yes. One at a time. 2. Shared containers are emplaced like any other stage. In addition, they may have parameters of their own, and you may need to resolve link names (there is a command button for this). 3. The only loop is the manual one when you're setting up the renaming. When DataStage execu...

Welcome aboard.

"Other error" means that DataStage can not figure out what the problem is.

Has job DWH450PRODQUALGROUP been compiled successfully?

Have you set the Decimal Output property of the Aggregator stage to the same precision and scale?

ASCII. To get a binary file you need to do explicit transformation.

You need to do some detective work to find out exactly what your "weird character" is, then maybe we can help you with that.

It would depend on the database server, on the type of index involved, and perhaps on the query optimizer. In general, however, if the two columns are the leading columns on a three-column index, then the index is likely to be used, if they are not the leading columns then the index is not likely to...