mailsaurabh.tripathi
New User
Joined: 22 May 2008 Posts: 56 Location: hyderabad
|
|
|
|
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.
( edited to change the case ) e.s. |
|
enrico-sorichetti
Superior Member
Joined: 14 Mar 2007 Posts: 10873 Location: italy
|
|
|
|
please avoid using all caps,
at first sight You are trying to load a table, without giving data for all the columns of the table
You can do that only if when defining a column You also define a default value for the columns that You do not want to fill every time |
|