Hi, when i try to alter table db2 would not let, because there are functions and procedures refering table. I have to drop the procedures/ functions and alter table and then redeploy procedures/ functions.
My procedures/ functions have specific name.

Is there a better way ?

Thanks in Advance

It depends. How are you trying to alter the table? Also include your DB2 version and OS.

Andy

DB2 9.7 and OS is Windows, i am trying to alter table from Control Center.

What are you trying to alter? Maybe if you supply the statement you are trying to perform....

Andy

i am try to change column from Character 6 to charcter 10 this column is used in function and removing one column this column is not used any procedure or function

In light of what you are trying to do, this is the only way to do it.

Andy

Thanks
one more question
i have column that is character type i want to convert it decimal
select CAST(mycol AS DECIMAL(8,4) ) from Admin.mytable
it gives error if column has character value like 'NONE', 'NA' etc, Is there a function to check if column is Not a number

No built in function. You could make a UDF though.

Andy