DSXchange

All of the stages like that come with a pdf "Connectivity Guide" which includes the prerequisites / configuration steps you'll need. Dig that up for Oracle and go through it. High level, you'll need an Oracle client on the ETL server with DataStage configured so it knows where to find it. ...

Confused? No. And I don't see any kind of 'problem' here. Just... do it. You'll be fine.

What exactly do you think is "not quite efficient" about doing a lookup? If you really think so then perhaps a join of the two sources in is order. Compare the two. Hard to say much else since we don't know anything about your data or the source or the volumes involved. And you need to mak...

Start by doing an exact search here for "Chinese", I just did and got 154 matches - you're not the first person to have this question.

Post the error.

Ha! There was no intent to discipline, I was just amused to keep finding your post as I worked my way through all the new posts that morning.

Sure... but you only used them on data that the 'normal' functions couldn't handle.

You really decided to spread the love around, eh?

It has been mentioned a number of times over the years, I got 40+ hits when searching for "preserve type" just now. Up by four from yesterday.

And... the Awk Clinic is back in session.

ps. What you "need" seems to have changed.

The link I posted is about doing it in Java and you can certainly leverage the Java Integration stage in DataStage to do that.

There's a number of factors since many UNIX processes can leverage the /tmp space. If you've moved it elsewhere and still have the issue you could be seeing a problem with the connector itself. Unfortunately all the "32" means is "broken pipe" which doesn't really tell us anythin...

Should have enough space != does have enough space. Necessarily. Monitor the space during the load to be certain. Then we can move on to other possible causes.

The named pipe is used to transport the data through the ETL server.

Those functions are documented in the BASIC manual and from what I recall are just for basic math: SADD, SSUB, SMUL and SDIV off the top of my aging head. I was just wondering if there is anything remotely similar on the PX side...

The Server side of the world has "string" functions to do things like math on large numbers, is there any equivalent here?

You are going to have to roll your own, I would imagine. A quick search of the digital world shows lots of people have asked this question for many tools, so you should be able to find examples out there for C++ or Java rather easily. Both would be appropriate to be part of a DataStage job. Heck, Ra...