Hi,

To increase the size you need to drop the table and recreate it again with the new field size...
there is no direct way to do it unless the column you wish to modify is a var char.

however before you drop the table...unload the data and after creating the new table..,load the data...by modifying the syspunch dataset...

correct me if I am wrong

Cheers,
Santosh.
-----Original Message-----
From: Tarun Kumar1
[mailto:db2udbdba-ezmlmshield-x56135004.[Email address protected]
Sent: Friday, April 29, 2005 1:03 PM
To: LazyDBA Discussion
Subject: How do I alter column/field size of a table


I want to increase field size of a decimal field from 5 to 10. What will
be the command for this


Thanks for helps iin advance
Tarun Kumar


---------------------------------------------------------------------
PLEASE CLICK REPLY-ALL TO SEND A REPLY TO EVERYONE
website: http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html


DB2 & UDB email list listserv db2-l LazyDBA home page