DSXchange

First 'source' your dsenv file to set the environment:


Then run your job.

Inside DataStage, that is The Way. Outside, you have your free choice of XML Parsers.

Sure.

That's pretty darn old. As noted, I've seen similar things. Ask your DBA to install a more recent release, 9.2.0.6 or 9.2.0.8 seem to be stable for us. No guarantees but it just may do the trick.

If you do it in the Filter, there is no filename. You cat them to standard out and the stage reads it as a stream. However, since it requires a value, I would put something like '/dev/null' as the 'Filename'.

So... you've noticed that -logsum gives a 'summary' of the log and not the 'detail' from each log entry? Isn't the difference between the two obvious and exactly what you posted?

You could also try looking both options up in the documentation.

Yes, that can work - as long as your job runs in isolation and no other process is inserting rows to the target table at the same time.

Yes, I would think you should be able to use the Incomplete Column option set to a none 'warning or error' option (like Replace) and then constrain your Transformer to only pass a row on where a 'key' field (say the first) is not null. Pretty sure I've done that in the past. Dont' worry about the ca...

Disaster when the partition fills and your projects are corrupted.

Rather than wait, try searching the forums instead. Very few problems are new problems, the vast majority have been seen and discussed here already.

I would still cat them. You could pass them thru something like 'sed' at the same time to strip the unwanted lines at the same time or simply skip processing them inside the job.

Before someone replies to the other post, you can delete it. The document you read and listed numbered questions from must have been written from a much lower level standpoint than DataStage - i.e. directly leveraging the ODBC or OCI protocols in C++, for instance so is not valid in this context. A...

What exact version of DataStage? I seem to recall earlier implementations didn't support encrypted environment variables.

No errors with no output means your expressions are 'valid' but don't match what is coming in from the xml. Can you post a sample of the xml you are processing and your corresponding xpath expressions?

Why not check with your official Support provider?