DSXchange

Have you tried searching here for the error message that comes with that code? It has been explained many many times.

No. While the table name can be a job parameter it cannot be dynamically supplied from the input data, if that's what you are trying to do. Now, that doesn't mean you couldn't build some kind of stored procedure to do that, I would think.

First try a simple reinstall and if that doesn't work - uninstall first and clean up everything it leaves behind, including registry entries. Reboot. Install clean.

Since the summations that you are doing are in your source SQL and not something you're doing in the job itself (say, in an Aggregator) then it seems to me that this is strictly an Oracle materialized view issue.

I'm not aware of the significance of the 'OEM' label here, I was meaning 7.5.1a versus 7.5.2 for example. Perhaps you simply need to reinstall your client software.

I've seen that when your Client version does not exactly match the Server version... do yours?

It's not a null any more. Did you check the link in my post?

That's not nearly enough information for anyone to be able to help you, other than to tell you to do an exact search for that message. There are 10 other posts besides yours that mention it, see if any of them help.

You need to find out what is corrupting your client. Your company may be doing something overnight to check installed software and replacing a critical ddl that DataStage is relying on. Or you may have an anti-virus issue and you need to exclude your client location from areas that it checks. Until ...

Your XPath Expressions don't match what's in the XML. How did you generate them? Can you post them and a representative snippet of the incoming XML as well?

Those 'junk' values are a SQLNULL and you need to intercept and convert them back to NULL in a transformer.

It looks to be having problems with the descriptor file rather than the data sets themselves. Is your ".ds" file accessable and complete?

This all really is dependant on exactly what 'different' means. The OP did say they needed to see if the contents of the two files are identical, not necessarily the two files themselves. I'd really like to see that nuance clarified.

This an important question that still really needs to be answered:

ray.wurlod wrote:Did the file system on which DataStage projects are installed become full at any point?

And if it doesn't, you'll need to post more details about the file itself and how you are trying to read it.