Changing the Data Type of a Column(From SmallInt to Decmial)
This is a discussion on Changing the Data Type of a Column(From SmallInt to Decmial) within the DB2 forums, part of the Database Server Software category; --> Hi All, Can anyone tell me how to change the date type of a column from smallint to decimal ...
| |||||||
| FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
02-27-2008, 07:56 AM
| |||
| |||
 Re: Changing the Data Type of a Column(From SmallInt to Decmial) siujean@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      |
|
02-27-2008, 07:56 AM
| ||||
| ||||
| Re: Changing the Data Type of a Column(From SmallInt to Decmial) 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: > siujean@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 |
Linear Mode
