DSXchange

Right, my answer was predicated on the fact that you specifically said you did not want to reject it. As noted, all you need is a constraint.

It also depends on concurrency needs - will the target table be loaded by more than one process simulateously?

As noted, though, there are more... 'elegant'... ways to solve the problem rather than bouncing the server.

What O/S? Talk to your SysAdmins, have them monitor the I/O on the system. Perhaps you can move your target to faster drives or they can 'adjust' some filesystem journalling options, etc.

How are you handling the nulls in your source? You'll need to either explicitly convert them to something less troublesome or use an appropriate "Null Value" string for the target column.

First you have to decide what exactly it is you want in the DATE field when it is null in the source - some kind of in-band "null" value like 12/31/9999 perhaps?

Any kind of Windows 'automation error' like that would probably require a re-installation of the client to resolve. That would be the first thing I would try in your shoes.

Why not use one of their NVL functions?

vskr72 wrote:I am sorry for posting it in the wrong section. It is a parallel job.

No worries, we're here now.

That's not a date, that's some flavor of a timestamp. Strip the date from the time before doing the conversion, me I would use the Field() function for that. Then you get to decide how to handle the time portion when it has been provided to you.

Search here for your actual error message, both the cause and the solution have been posted here in the past and it's got nothing to do with your VOC "changing".

D'oh! I fixed my typo, the one I introduced when I went back to capitalize things the way I like. Sorry about that.

That "D" format mask is special and can recognize most "Date" formats without any help from us.

Both format masks are wrong. Try:

Your host name has a space in it?

Post your SQL. Unfortunately, I don't know beans about DB2 - what is the equivalent to Oracle's NVL / "null value" function, something which allows you to specify what to convert a null value to in your SQL?

After googling around it looks like the answer is NVL or NVL2.