To get around this I use a data structure to define a named indicator variable for each array element.
If the former is true, then the indicator variable for that column is set to -1 which results in the column being updated with the null value.
If the latter is true, then the indicator variable for that column is set to -5 which will set the column to the default value for that column.
