DB2 Altering an integer to character type

arun1151

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

saviop

Hi Arun,

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

HTH.
Savio

Mar 1 '06 #2