DSXchange

How? Not sure how many other questions we can ask. This kind of thing typically takes 'boots on the ground', is there anyone else there with you who can look at it? Well, maybe... Are you sorting the data properly to support the Remove Duplicates stage? If running on multiple nodes are you using Has...

Hmmm... was hoping someone would wander along and throw us a bone. Have you had any luck with this in the interim?

Right... hadn't gotten down into the weeds yet since that's usually Ernie territory. :wink: 1. Meaning you can have many instances of the service running and from what I remember they can increase dynamically based on need until you hit a configured limit. Each will support a queue of requests up to...

Thousands of individual requests per minute?

Don't be sorry, just use Post new topic rather than jumping on the end of someone else's problem.

Split out to your own topic

Sure, the Index function could be used if you just need to check to see if there is at least one, it's actually a more appropriate approach in that case so not really sure why the eye roll. You'll still need to verify the decimal value of the character as I assume you'll need to use the CHAR() funct...

Your image isn't working with the tags. FYI, the command is:
What is the actual "access problem" error you get?

We've seen it before here and I saw it back in the day. One such example is here and there were two or three others I could find.

Huh... was wondering why I could find one for a lower-case y but not for an upper-case one. Also wondering if it had three dots on top would that be a triaeresis?

mandyli wrote:I hope all datastage code will compile on higher version of C++ 12.1 compiler.

Your hopes may be dashed seeing as how experience has taught us that one must use only supported compilers (make & model) for your DataStage version and Operating System.

I don't think the Ranged Lookup is quite as limiting as you think, mostly because what you are needing is not a range.

So basically you are looking for a way to do "<" check in a lookup rather than an equality check?

As already noted, you replace the lookups the transformer is doing with Lookup stages. Seems to me there's no need to replace the transformer itself unless the only purpose it is serving in your Server job is to perform the lookups. As to the why, PX is a different philosophy and was developed by a ...

You should have an "Installation and Configuration Guide" in pdf format. Worst case you can download it from IBM. I'd start there. If you have that and still didn't get "the info you want" let us know what that specific information is.

Are we really talking about a Server job here? The join stage there isn't anything like the Parallel version.

Saying that it "is simple" doesn't help us help you. Detail the design for us if you want us to be able to help. And what does "no hard code values for any parameter" mean - are they being passed to it by the Sequence? If so, do one or more of the parameters control the file's na...