View previous topic :: View next topic
|
Author |
Message |
premkumar82
New User
Joined: 24 Feb 2006 Posts: 8 Location: chennai
|
|
|
|
my requirement is
increase decimal (7,2) to decimal (11,2) IN DB2
i ve used both
1)ALTER TABLE DSN8810.EMP ALTER COLUMN EDLEVEL SET DATATYPE DECIMAL(11,2); does't work
2)ALTER TABLE DSN8810.EMP MODIFY EDLEVEL DECIMAL(11,2); does't work
ANYBODY HELP ME
ANY CORRECT QUERY |
|
Back to top |
|
|
vicky10001 Warnings : 1 Active User
Joined: 13 Jul 2005 Posts: 136
|
|
|
|
In Alter command only used to add columns.
I think,It is not possible in db2
Thanks,
vy |
|
Back to top |
|
|
vicky10001 Warnings : 1 Active User
Joined: 13 Jul 2005 Posts: 136
|
|
|
|
Please try this
Syntax
ALTER TABLE <tablename>
ALTER COLUMN <columnname>
SET DATATYPE <newdatatype> ;
Ex:
ALTER TABLE CUSTOMER COLUMN ADDRESS SET DATA TYPE CHAR (55) |
|
Back to top |
|
|
|