Solved

ALTER TABLE command

Posted on 2014-07-20
1
308 Views
Last Modified: 2014-07-21
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
0
Comment
Question by:Anthony Lucia
1 Comment
 
LVL 45

Accepted Solution

by:
Kent Olsen earned 500 total points
ID: 40208024
Hi Anthony,


  ALTER TABLE ALTER COLUMN balance SET DATA TYPE DECIMAL (5,2)


Kent
0

Featured Post

DevOps Toolchain Recommendations

Read this Gartner Research Note and discover how your IT organization can automate and optimize DevOps processes using a toolchain architecture.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Recursive SQL in UDB/LUW (you can use 'recursive' and 'SQL' in the same sentence) A growing number of database queries lend themselves to recursive solutions.  It's not always easy to spot when recursion is called for, especially for people una…
Recursive SQL in UDB/LUW (it really isn't that hard to do) Recursive SQL is most often used to convert columns to rows or rows to columns.  A previous article described the process of converting rows to columns.  This article will build off of th…
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

828 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question