DSXchange

No, it will help you find the string but does nothing to replace it. How are you planning on doing the actual replacement?

They're not junk. How are you viewing the data "in unix prompt" and what exactly are you seeing? Best to identify the characters you are having an issue with before you decide what (if anything) needs to be done about them.

I know I'm right in a general sense, can you confirm or deny if that applies to your specific case? I was asking if your servers differ in their "bitness"... do they?

The advise to use CAPITAL also specifically said to use it in a BASIC transformer as it is a Server transform. If you're not fluent in C++ don't even start down that path as it is dangerous and full of pitfalls. If you are trying to match two strings regardless of case, best advice has always been t...

IBM wrote:Version 9.1 includes a series of advancements that would increase organization's productivity, optimize the integration execution, and accelerate the data governance agenda.

How delightfully non-specific!

Hopefully someone will have some gory details they can post.

Weird... not sure where this one came from as we answered this question on the day it was posted:

viewtopic.php?p=431155

ArndW wrote:Have you checked what you've set the value to?

Please check and let us know.

You need to provide the credentials of whichever userid you want the job to run under.

Now you need to add the credentials to access the project - userid, password, domain.

atul9806 wrote:Thanks Ray for valuable comments.
I did as you suggested the things to change the server job to parallel job.
and wow it works...
Thanks , Thanks a lot

Are you sure you just marked the right post as Resolved?

D'oh! Didn't notice that.

Ah... thanks. Wasn't aware of that little nuance.

Sorry but I'm not current on their HA offerings. I've done something similar in the long past on a Compaq Tru64 clustered system with 7.5 but there was nothing 'transparent' in the failover we were able to handle... and the new 8.x architecture will complicate that. Automated, sure, fail over, yes b...

Don't forget the product ships with a full documentation suite so you could also check the Connectivity Guide for Oracle Databases pdf you have.

Hmmm... the Server version of the stage includes an option to "ignore truncation errors" which allows a short read like that but I wasn't aware that the PX stage had any such capability. I'll be curious what comes of this.