DSXchange

RK72 wrote:Does IBM support server jobs with IS 8.7 version officially

Of course. Fully.

Not quite the same as Oracle, it would seem. See if this helps.

You would, I assume, need to do an explicit date conversion in the SQL itself via some kind of TO_DATE() function. The implicit conversion it is being forced to do is failing.

What about these? Are they set identically across environments?

APT_COMPILER
APT_COMPILEROPT
APT_LINKER
APR_LINKOPT

As long as you're sure.

The "other logic" you're looking for has been discussed here many times. Unfortunately, you'll need to trawl through all of the "please search" posts to find them but the wheat is there amongst all of the chaff.

Let's start with the standard questions first - what have you tried? What issues have you had? I'll also add that this looks to be (based on the example you posted) a very straight-forward vertical pivot... and there's a stage for that plus plenty of conversions here on the topic that an exact searc...

Awesome. :D

The issue with the "upsert" mechanism is that all columns that you need for the insert must also be used in the update. Typically there are columns that you do not want to change, such as the create date, and in order to do that you need to look up the current value and pass that along rat...

I'm curious. You say you have custom buildop stages (plural) from your old environment that are now in the new one. Do some of them 'generate' correctly and you only have an issue with some (or just this one) and the rest generate fine? Or do none of them generate? Seems like important information t...

ArndW wrote:I'd be surprised if that could be done.

It can't. As Arnd noted, you'll need to re-architect your approach.

Any chance you can elaborate on what "some DB connection issue" means?

It will help future searchers...

And... do you have it working now?

Then it seems to me that you should report this to your official support provider.

I disabled the smilie, might help. You can also look into the 's' option for dates which allow leading spaces and zeroes to be handled. For example:
Would handle a leading space or zero for the day and month segments.