Jan, remove the computation form the second database (not the column, just the expression so it is not a computed column) then load your data in, then replace the computation.
Or you can unload the data from the first database, naming all the columns except the computed column. Then your load into the second database will work. Bernie Lis ----- Original Message ----- From: "Jan Johansen" <[EMAIL PROTECTED]> To: "RBG7-L Mailing List" <[EMAIL PROTECTED]> Sent: Wednesday, October 13, 2004 4:05 PM Subject: [RBG7-L] - Unload & Load > Group, > > I don't know if this is normal or not. > > I have a table that I am moving from one database to another. > It has 24 columns, one of which is a computed column. > > I have already set up a table in the new database with the same definition > (including the computed column) > > The help file says to use the unload as ascii syntax if you have a computed > column. > The other says to use the load as ascii to bring it in. > > If I use the above method in the new database I receive a message > WARNING - Excess data values ignored ( 125) > > But if I look at the file generated by the unload command, I have 24 columns > which is correct but the value for the computed column is missing which is > what I believe is causing the error. > > If I use the 'unload all' command on the first database and then run the > resulting file into the new database it does work properly. > > Jan >
