I'm using the load statement and noticed that if one row in the file has a problem (e.g., one of the fields contains too many digits ) I get a message saying that the number was pruned, but the load is not completed.
I believe that if I would use the load from the command line, it will be completed, but since I use it from my Java program, it throws an exception that the program catches but doesn't continue with the load.

What's the best way to tell it to continue and complete the load even when it throws exceptions?

Thanks!
Ravivg