467,154 Members | 901 Online
Bytes | Developer Community
Ask Question

Home New Posts Topics Members FAQ

Post your question to a community of 467,154 developers. It's quick & easy.

DB2 Altering an integer to character type

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
  • viewed: 5939
Share:
1 Reply
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.

Similar topics

12 posts views Thread by Prabu Subroto | last post: by
1 post views Thread by Prabu Subroto | last post: by
17 posts views Thread by Yogi_Bear_79 | last post: by
9 posts views Thread by JimmyKoolPantz | last post: by
232 posts views Thread by robert maas, see http://tinyurl.com/uh3t | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.