DSXchange

Yes, Itanium. You got a 10g client because there's no 9i one for them. Change your shared library path in dsenv to point to the 32bit Oracle libraries rather than the 64bit ones, see if that helps.

Please repost this question in the proper forum, the "Enterprise Edition" forum a.k.a. the "PX" one. This one is specfically for Information Analyzer / ProfileStage questions.

I'm curious why you're landing the data, why not load it directly? You will have a problem with that flat file as it will only be flushed once the WISD job completes.

This might help:

http://www.lmgtfy.com/?q=kernel+parameters

Actually, what you need to search for is DEFFUN.

:idea: 1. I did not want to quote my previous msg again.. but, I did not see any link other than "Reply with Quote" and I clicked on this link on my msg. Look closer. There is a big orange Reply to topic link at the bottom of the page that starts you off clean. Still amazed by how many peo...

Or take the tutorial for a spin.

Or perhaps run the job with a (very) low warning limit.

Yes, the 10g client can work fine. Need to know what HPUX server you are running, though... Itanium or PA-RISC? Running a 32bit or a 64bit client? And you shouldn't need to set TNS_ADMIN unless your tnsnames file is in a non-standard location, is it?

And they will 'accidentally' mess it up. Repeatedly.

Even better... no need to reverse polarity and risk imploding the Universe.

It *is* the standard and any validator worth its salt would complain finding that character in there untranslated... i.e. not 'safe'. Perhaps it's an issue with using a dtd rather than the more standard xsd for this. [shrug] Depending on your job design, you can set the 'Data Type' for that field to...

Not to stir anything up here as I've never worked with MySQL in any capacity, let alone with DataStage. But as a serious musing on my part, do you really think there would be much call for support for the "community" version of MySQL amongst companies that would invest in a tool like DataS...

Still... it wouldn't be in the log.

Not sure what an Aggregator has to do with anything. Why not simply add a new field in a Transformer and subtract the two there? Or do that in your source sql.