DSXchange

DataStage implements "real real-time" as well - by means of continuously running jobs listening (via the RTI Input stage). Such jobs must be published as web services. This site has a separate forum where you might post any questions specific to the RTI (real time interface) components, now sold und...

Curious. Have you tried checking the other options, to have QualityStage return the report(s) to the QualityStage Designer machine?

The rest of the answer is "whatever you feel comfortable to maintain". The actual GUI is rather irrelevant. Did you plan to leverage DataStage in the background (using the real-time components), or to update the table(s) directly?

And what makes them think maintaining Java to manage 370 fields will be any easier?

Just copy the relevant lines from one DSParams file to the other. DSParams is a text file.

... or simply use as the constraint expression

Why even bother to use an ETL tool? This is a database change.

If there are two parameter markers in the SQL there must be two columns in the Columns grid. Could someone accidentally have created a column called " "? Columns that are to appear in the WHERE clause of an UPDATE statement must be marked as key, columns that are to appear in the SET clause are not ...

Thanks for the reply. However, the client does not want to use the 'after job' option. Just had something similar with the new flight security rules. After taking the ink from my fountain pen (because it's liquid, all 1.5ml of it) they wanted me to fill out some forms. What's wrong with this pictur...

Monitor memory usage using Task Manager. Maybe they're running Powerpoint, IE or some other memory hog.

1. Lots. 5000+
2. Today is the first full day. Quiet in the pre-show expo Sunday night, but that's true of the whole Sunday night thing.
3. Doubt it but, if you do hear of anyone, please let Dennis know.

If that's all the transformation you need to do, prefer a Modify stage (it's far more light weight). Use the substring function in that stage.

You can achieve this by truncating it earlier in the job, using probably a Modify stage or a Transformer stage.

Do you mean the rules in the rule sets? Check them out in the Pattern Action Language Guide (We don't have postal certification in Australia, where I do most of my work.)

Your assertion that you have to re-install DataStage is probably based upon an erroneous premise. Perhaps what you do need to do is to install the DataStage components properly. If you have done so, you can shut down and re-start the server as frequently as you wish. You just need to ensure that the...