DSXchange

So... DB2?

Other thread. While this one may be "reframed" the original post has important details germain to the issue.

Again, next time restate the problem in a reply to the original post, please don't start another one.

Seems to me you'll need to avoid any bulk loading options as they typically want all columns to be handled. For Oracle, that specifically means a DIRECT=TRUE 'direct path' load. You should be able to switch to a conventional load which essentially does 'normal' insert/update DML, or just go for plai...

OK, Server job it seems. Rather than attack this piecemeal, how about details like target database & stage you are using? Custom or generated SQL? All affect the answer.

No need to post the same question again just because you haven't gotten an answer yet. Next time, simply reply to the original post to 'bump' it back up to the top.

viewtopic.php?p=310236

Not to mention:

chulett wrote:Please search the forums for "Controller problem: Unhandled failure", this question has been asked and answered quite a number of times.

Server job as marked or Parallel job per the forum you posted in?

May help to share the reason why you needed to restart.

Try do an exact search for "Internal Error (39202)" and see if any of those discussions help.

Probably. Change "select count" to "select *" to check. Add a "not" before the "between" as an additional check of what is being excluded.

Stage? Database?

What changed? Why did the engine need to be restarted and did you change any values in the uvconfig file before restarting?

'0D' is a carriage return, usually a record terminator mismatch DOS to UNIX. Use Convert to remove them:
If they are in data fields. If it is only at the end of the last field, change from UNIX to DOS terminators in the stage reading the file.

Do we have to guess what database?

I would assume your "+7" needs to be "-7".

Good Lord. YES, you can.

Regardless, you need to let us know what the actual value of the "box" is, then people can help. Maybe saying it three times will be the charm.

Not that I know of, but you may be able to get that information from your UNIX SysAdmins.