when i'm loading my table uedbs02.emptest from empprod, i'm getting following error
" field ADDR2 is not DEFAULTABLE".
initially table emptest was having 3 columns and 3 values, and table empprod was same identical structure, exceopt one extra column addr2, the i altered table emptest to add column addr2. then unloaded empprod, and tried to load emptest, but got the error(mentioned above).
i had run runstat after altering the table.