Hey Singh Diktesh,
Using the "ALTER TABLE" statement has limitations. Check it out!
Hehe.
http://webdocs.caspur.it/ibm/udb-6.1/db2s0/sqls0604.htm
Please take a few minutes to provide feedback on the quality of service you received from our staff. The Department of Education values your feedback as a customer. Commissioner of Education Jeanine Blomberg is committed to continuously assessing and improving the level and quality of services provided to you.Simply use the link below. Thank you in advance for completing the survey.
http://data.fldoe.org/cs/default.cfm?staff=Ed.[Email address protected]
-----Original Message-----
From: Singh Diktesh
[mailto:db2udbdba-ezmlmshield-x9328762.[Email address protected]
Sent: Friday, August 03, 2007 8:20 AM
To: LazyDBA Discussion
Subject: Error
Hi ,
I have given a command to increase column from decimal(16) to
decima(16,4)
ALTER TABLE ARSPM.APMFUNDMGTFEE ALTER COLUMN MIN_MGT_AMT SET DATA TYPE
DECIMAL(16,4)
It gave me error SQLSTATE 42601, -401.
Could any one tell me what can be the problem
Thanks,
Dikky
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
- - - - - - - -
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