View previous topic :: View next topic
|
Author |
Message |
haimzeevi
New User
Joined: 01 Mar 2010 Posts: 27 Location: Israel
|
|
|
|
Here is my issue:
I altered a CHAR(200) row to VARCHAR(700), by an ALTER command, issued via BMC CATALOG MANAGER. It was successful.
When I tried to ALTER back to CHAR(200) I got an SQLCODE (don't remember) with explanation the column is not the right type.
Any suggestion how to restore column's old chracteristics without a DROP+CREATE?
Thanks in advance,
Haim Zeevi |
|
Back to top |
|
|
GuyC
Senior Member
Joined: 11 Aug 2009 Posts: 1281 Location: Belgium
|
|
|
|
V8,V9 manual wrote: |
In general, DB2® can alter a data type if the data can be converted from the old type to the new type without truncation or without losing arithmetic precision. |
|
|
Back to top |
|
|
haimzeevi
New User
Joined: 01 Mar 2010 Posts: 27 Location: Israel
|
|
|
|
Thanks Guy.
Then DROP/CREATE remained. |
|
Back to top |
|
|
|