You'll have to drop the table and recreate. SET DATA type either works
to increase the width of a VARCHAR. You cannot even convert a CHAR to
VARCHAR using ALTER TABLE


Regards,

Anand

-----Original Message-----
From: Singh Diktesh
[mailto:db2udbdba-ezmlmshield-x44145748.[Email address protected]
Sent: Tuesday, August 28, 2007 5:24 PM
To: LazyDBA Discussion
Subject: How to change character 24 to character 48 in v8.2---urgent--



Hi Guru's ,

Can any body tell me the syntax to change column data type from
character 24 to character 48 in v8.2 ?


Alter table alter column set data type character(48) -----not working
Thanks, Diktesh
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
- - - - - - - -

This message is intended only for the personal and confidential use of
the designated recipient(s) named above. If you are not the intended
recipient of this message you are hereby notified that any review,
dissemination, distribution or copying of this message is strictly
prohibited. This communication is for information purposes only and
should not be regarded as an offer to sell or as a solicitation of an
offer to buy any financial product, an official confirmation of any
transaction, or as an official statement of Lehman Brothers. Email
transmission cannot be guaranteed to be secure or error-free.
Therefore, we do not represent that this information is complete or
accurate and it should not be relied upon as such. All information is
subject to change without notice.





---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY To post a
dba job: http://jobs.lazydba.com To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html




DB2 & UDB email list listserv db2-l LazyDBA home page