By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
454,278 Members | 1,502 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 454,278 IT Pros & Developers. It's quick & easy.

Changing the Data Type of a Column(From SmallInt to Decmial)

P: n/a
Hi All,

Can anyone tell me how to change the date type of a column from
smallint to decimal in db2?
Thanks

Regards
Siujean

Aug 18 '06 #1
Share this Question
Share on Google+
2 Replies


P: n/a
si*****@gmail.com wrote:
Hi All,

Can anyone tell me how to change the date type of a column from
smallint to decimal in db2?
In V8: recreate the table
In V9: ALTER TABLE ... ALTER COLUMN ... SET DATA TYPE ... + REORG

--
Knut Stolze
DB2 Information Integration Development
IBM Germany
Aug 18 '06 #2

P: n/a
In addition to the above options, it might be worth your while to
investigate the ALTOBJ stored procedure.

http://www.gatago.com/comp/databases.../24027879.html

--Jeff

Knut Stolze wrote:
si*****@gmail.com wrote:
Hi All,

Can anyone tell me how to change the date type of a column from
smallint to decimal in db2?

In V8: recreate the table
In V9: ALTER TABLE ... ALTER COLUMN ... SET DATA TYPE ... + REORG

--
Knut Stolze
DB2 Information Integration Development
IBM Germany
Aug 20 '06 #3

This discussion thread is closed

Replies have been disabled for this discussion.