When you are loading data from external sources, there may be errors in the data. For example, there may be dates that are not valid dates and numbers that are not valid numbers. The CONVERSION_ERROR database option allows you to ignore conversion errors by converting them to NULL values.
For information on setting dbisql database options, see SET OPTION statement in Chapter 1, “SQL Statements,” in Reference: Statements and Options.