In that case FIELD2 would be intialized with SPACE since that is the DEFAULT for CHARACTER, correct?
But what I really want for example is to initialize FIELD2 uncondititonally always with the literal 'ABC' (which is not in the Load-File because FIELD2 did not exist in the unloaded table!).
Is it possible to initialize the new fields directly during the LOAD with specific literals as a default value? If so what is the correct syntax?
I already know that an update of all the new columns after the load with the standard DEFAULT using DEFAULTIF and a condition that is always true could be used as an ugly workaround, but that is not what I really want.