You are correct....





"Santosh_Nambiar
"
<db2udbdba-ezmlms To
hield-x88394210.x "LazyDBA Discussion"
[Email Address Removed] <[Email address protected]
a.com> cc

04/29/2005 04:22 Subject
AM RE: How do I alter column/field
size of a table










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



---------------------------------------------------------------------
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