Currently, the 'NullNumberWrite' preference can be set only to a single value. If you have multiple values that are not native database data types such as NaN and Inf in your data, you cannot have both values written as NULL's to the database. If you use setdbprefs('NullNumberWrite','NaN'), you will encounter an error such as
??? Java exception occurred:
java.sql.SQLException: 'Infinity' is not a valid numeric or
approximate numeric value
The error will vary depending on the database.
To work around this issue, convert the NaN's, Inf's or other non native database data type to a value recognized by the database.
