Nadya,

Typically, an on error routine can handle problems like this, but not in your case. As you pointed out, you can't handle it because you don't know which field caused the problem. The only other thing I can think of is to preprocess the source file and "fix" all of the problems while noting them in your error log. In the event that you can't change the source data, you may have to make a copy before you preprocess it.

I haven't been able to find any command that turns this off. But, if you run across one, I would love to know.

BTW, how was "The House That Jack Built"?


>Hi everybody,
>
>When I'm running insert command (or replace, of some alike commands), if Source file has data, which are greater than the numerical field length in the Destination file, I have an error "Numerical overflow" and program stops its execution. My question is: is it possible to automatically clear the field, which is giving the error (the field in unknown) and process the file silently (may be note the error in error log, but don't stop)?
>
>What would be your suggestions about this, I think, common problem?
>
>Thanks in advance.