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

DB2 Altering an integer to character type

P: 2
Hi all,
I need to alter some 50 tables with one column that has integer data type to character because of request from app developers. There is atleast 500000 rows in each of them. After brainstorming, my team put out the plan of exporting, dropping, recreating wiht only the column's datatype changed and then loading the data. I think it wil be a very tedious process and not completable within the give time frame of 10 days.
Is there any other easy way to do this?

Please advise.
Arun
Feb 27 '06 #1
Share this Question
Share on Google+
1 Reply


P: 1
Hi Arun,

Have you looked at casting between datatypes :
http://publib.boulder.ibm.com/infoce...n/r0008478.htm

HTH.
Savio
Mar 1 '06 #2

Post your reply

Sign in to post your reply or Sign up for a free account.