Anthony Lucia
asked on
ALTER TABLE command
I have the following table:
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
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
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.