By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,082 Members | 2,135 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,082 IT Pros & Developers. It's quick & easy.

Data Conversion Error while loading DB2 table.

P: n/a
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.
Nov 12 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
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.

Nov 12 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.