Link to home
Start Free TrialLog in
Avatar of Anthony Lucia
Anthony Lucia

asked on

ALTER TABLE command

I have the following table:

db2 => describe table account

                                Data type                     Column
Column name                     schema    Data type name      Length     Scale N
ulls
------------------------------- --------- ------------------- ---------- ----- -
-----
ACCT                            SYSIBM    CHARACTER                   10     0 N
o
BALANCE                         SYSIBM    DECIMAL                      5     0 N
o

Open in new window


What command would I use to alter that table such that the BALANCE value has a length of 5 and a scale of 2 ?

Thanks
ASKER CERTIFIED SOLUTION
Avatar of Kent Olsen
Kent Olsen
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial