DSXchange

Change the update action so that the table IS cleared, if that's what you need.

But you can use more than one Modify stage. You should explicitly or implicitly put a Copy stage between two adjacent Modify stages.

Show us the precise expression that you used. This will enable our assistance to be more exactly targeted.

Stay tuned to IBM for much more coming around Hadoop and processing unstructured data generally, particularly using InfoSphere Streams. One of the two big themes for the coming year for Big Blue is handling the 80% of data that are unstructured.

Gosh, does that mean you can use dsjob when you can't access the production system with Director? How does dsjob access the production system that's different?

The default value (\0) is very convenient for reading "just the data" with C functions.

Check again that it's not hard-coded (maybe for testing purposes) anywhere in the job design.

Aquilis wrote:Our Client has come up with the requirement having metadata definition parameterized and very much configurable one.

This is not always a good idea. Demand to know why.

Why?

That's what the Director client is for.

What does your official support provider have to say?

It looks like something to do with registering the stored procedure stage or the help information for that stage, but the message itself is rather sparse.

DataStage jobs run as background processes, so colour is not a sensible thing to want. If you feel you must persist with this, you will need to flag your values by introducing the correct escape sequence for "green on" and terminating it with "green off" - noting, of course, that...

I suspect the usual caveats about support will continue to apply, but it does work OK. Some of the machines in the Demo Room at IOD 2010 were running 8.5 on VMware images.

IsValid() is for data types, not for formats.

You'd really like the Matches operator here - you could use it in a BASIC Transformer stage, of course. Otherwise you're up for some ugly-looking (but still simple expressions)

Or why not use QualityStage address verification?

You can get version 8.5 that does handle very large XML files using a totally redesigned technique that uses streams rather than trying to store the entire XML file in memory. This new stage is only available in parallel jobs, however.