There is a way to turn off constraint checking for a table. Look at SET INTEGRITY.
That being said, there is no way to change the datatype of a column, with the exception of making a varchar longer (and you do not have to turn off constraint checking unless there is a constraint on that column). The only way to get this accomplished is to:
1) export the data
2) drop the table
3) recreate the table the desired way
4) import the data
5) reinstute the constraints on the table.
The triggers will become invalid. They will need to be dropped and recreated before they become operable again.
Stored Procedures depend on the version (I believe). Under V7 (UDB-LUW), I do not think there is anything you have to do (except maybe do some rewrite if the columns need different processing). In V8, you may have to recreate the SP, this is something I have not tried yet.
Originally posted by synap1974
We hav done that Andy...
thanks for the responce .. one more question .
if there is a trigger or a procedure assosiated with that how do we accomplish this problem...