Hi,
We were in need of altering a DB2 table in which one of the column has been changed from VARCHAR(256) to INTEGER. I have extracted the table data into a tape before alters. After the alters was done, I am reloading the data back into the table using IBM load utility. I changed the load card from VARCHAR to INTEGER and loaded the table. After loading, I could find that the data was not correct in the table. The tape has a value of 3888537 where as the table has a value of 521208. When I try INTEGER EXTERNAL in the load card, all rows were getting discarded. Does any one have a solution for this?.
I am using DB2 version 6.1.
Thanks,
Balaji.
We were in need of altering a DB2 table in which one of the column has been changed from VARCHAR(256) to INTEGER. I have extracted the table data into a tape before alters. After the alters was done, I am reloading the data back into the table using IBM load utility. I changed the load card from VARCHAR to INTEGER and loaded the table. After loading, I could find that the data was not correct in the table. The tape has a value of 3888537 where as the table has a value of 521208. When I try INTEGER EXTERNAL in the load card, all rows were getting discarded. Does any one have a solution for this?.
I am using DB2 version 6.1.
Thanks,
Balaji.