Solved

ALTER TABLE command

Posted on 2014-07-20
1
305 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:
Kdo earned 500 total points
ID: 40208024
Hi Anthony,


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


Kent
0

Featured Post

Enabling OSINT in Activity Based Intelligence

Activity based intelligence (ABI) requires access to all available sources of data. Recorded Future allows analysts to observe structured data on the open, deep, and dark web.

Join & Write a Comment

November 2009 Recently, a question came up in the DB2 forum regarding the date format in DB2 UDB for AS/400.  Apparently in UDB LUW (Linux/Unix/Windows), the date format is a system-wide setting, and is not controlled at the session level.  I'm n…
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…
Illustrator's Shape Builder tool will let you combine shapes visually and interactively. This video shows the Mac version, but the tool works the same way in Windows. To follow along with this video, you can draw your own shapes or download the file…
You have products, that come in variants and want to set different prices for them? Watch this micro tutorial that describes how to configure prices for Magento super attributes. Assigning simple products to configurable: We assigned simple products…

758 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

Need Help in Real-Time?

Connect with top rated Experts

22 Experts available now in Live!

Get 1:1 Help Now