DSXchange

In the past, yes. For 8.x however, you can have one version installed at any given time, plus as many 7.x versions as you can stand.

satyayandra wrote:we would try to install MQ server on unix server, BTW do you have the link that has unix version of MQ server

You'd get that from IBM after you purchase the software.

Doesn't answer my question at all, but fine. Connectors are new and still... buggy. Ping your official support provider and see if there is a patch.

Guessing it is the fact that "CDL_INSTALMENT_BOOKOUTERCDL_LND" is 31 characters... could have sworn the limit was 30. What version of Oracle is this - server and client?

Prove that it's a "problem", rather than "the way it works". And when you do, please do so in your own new post. I sincerely doubt you have the exact same problem with the exact same versions and components in play, so please start over and post all the gory details of your vers...

ray.wurlod wrote:Before/after subroutines are, however, written in DataStage BASIC.

As noted.

It just means there's some difference between the platforms that you haven't identified yet, could be with the C++ runtime / compiler, O/S patches, etc etc. I would never promote PX executables across platforms, especially if a Transformer is in the job design. Unless my brain is complete cheese thi...

A search would turn up all the various techniques people have tried, what does (and doesn't) work. First thing to try - a "backslash" before each one.

Well, it is certainly *an* answer but I wouldn't consider "debug" information something anyone would want to have turned on by default. As noted in the linked thread (and just as an FYI) turn it on if you are having a problem and want to see if the additional information helps, but don't s...

Hmmm... the 'Monitor option' and viewing the logs are two completely different things. :? There's nothing you can do to get any more detail into a job's log, what's there is what is going to be there based on the job design and the stages used. Now, you may be having an issue with getting the data b...

Hmmm... ok. I have no idea what "parameter 63" would be but I doubt it would be as simple as the 63rd field in the record. And I don't think it's going to complain about an invalid precision value for a varchar field, should be one of your numeric fields. With everything else being the sam...

You already have all the same documents we do, I would wager. Before/After subroutines are all in BASIC regardless of job type. PX-specific custom routines/buildops are written in C++. How are your C coding skillz?

And here I thought maybe you would patch it yourself with a hex editor and some spare ones and zeroes.

"In Director" means in the job's logs or in what you are seeing via the Monitor option in the Director?

I'm assuming these are two separate servers, yes? I was going to ask you to verify that the Oracle client installed on each was identical, but since you're using ODBC and the wire drivers, that doesn't come into play. So, check that the ODBC versions are identical and that your connections are defin...