DSXchange

GBAREA rule set knows both formats of UK postal codes and how to handle them. You can verify this by inspecting the Pattern Action Language for this rule set. Just try it. You'll be pleasantly surprised. As for unhandled patterns or data, investigate these with a view to tweaking how the rules are w...

Are you using WebSphere Transformation Extender (formerly DataStage TX)? Because that's what this forum covers.

If not, please post in the appropriate forum, so that we understand better whether this is a parallel job, a server job or whatever it is.

You can sometimes see the same thing with the Copy stage. The answer is in the score - the stage is actually taken out by the optimizer. In the case of a Modify stage, it can be made a property of the input link of its downstream stage.

Can you show your prototypes/definitions?

Welcome aboard. The short answer is "yes". You still need to know how to access the service. For example you might use some of DataStage's Java processing capability to use a class that consumes the service. There are other ways - that was just an example. You could do worse than to search...

Moderator: please move to parallel forum

Problems with libraries are usually attributable to the shared library search list not being set correctly.

It can not be done with any of the tools you are using.

Even with istool (version 8.1) there's no documented way to do it.

You might like to enable server side tracing, perform an export of just a shared container, then examine the trace file to learn how DataStage does it.

Let's be clear here.

Is this the Change Data Capture product (which typically identifies changes from transaction logs in databases), or is this the Change Capture stage?

All processes can be seen in Task Manager on the server. If you telnet in to the server to the DS account, you can execute the command PORT.STATUS to see all processes. In any project account the DS.TOOLS menu gives access to similar functionality. And, of course, you can use the Cleanup Resources t...

Poovalingam wrote:When I use DSExecute to do delete, the command ReturnCode variable is showing Zero for both success and failure of the command.

How did you determine success/failure?

Can't you replicate that in your script?

Define "performance" in an ETL context and we might be able to provide a better answer.

As a general rule server jobs will take the same time or slightly longer to complete in version 8.1 than they did in verion 7.x.

No, because the detail will depend completely on just how the data are "mixed up". Do the QualityStage Essentials class to learn about using the xxPREP rule set (among other things). That said, my suggested approach will work "out of the box" - at least with those countries for w...

That's very naughty of them!

Anyway, you can still use conditional lookup as I indicated.

Are there any rejected rows? Are there likely to be any?