Alter datatyes of a column in a table

Madhu Reddy · New User Joined: 28 Sep 2006 Posts: 56

Hi,

I need to alter the datatype for a colmn in a table is it possible if yes
how ?

Please reply as early as possible

Thanks in advance !
Madhu

MFRASHEED · Active User Joined: 14 Jun 2005 Posts: 186 Location: USA

It is possible with limitations and considerations between compatibale data types.

publibz.boulder.ibm.com/cgi-bin/bookmgr_OS390/handheld/Connected/BOOKS/dsnsqj10/5.11?ACTION=MATCHES&REQUEST=alter+column&TYPE=FUZZY&SHELF=&DT=20040216135741&CASE=&searchTopic=TOPIC&searchText=TEXT&searchIndex=INDEX&rank=RANK&ScrollTOP=FIRSTHIT#FIRSTHIT

See:
ALTER TABLE ALTER COLUMN SET DATA TYPES

Also note DB2 allows data coversions at load time, so if conversion is between compatible data types, then down load data, alter table, and load data with conversion.

If data types are not compatible

- Download data.
- Drop Table
- Create table with new definitions
- Modify data if required or set new data
- Load data.