Data Conversion Error while loading DB2 table.

[Balaji Neelakantan Pooruli]

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.

[Rhino]

What platform are you using, Windows? OS/390?

Rhino

"Balaji Neelakantan Pooruli" <pn******@yahoo.com> wrote in message
news:bd**************************@posting.google.c om...

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.