Page 1 of 1

-750 Error solution ?

PostPosted: Thu Aug 04, 2016 9:58 am
by MFDEV
Hi ,

The requirement is to change data type of one column to another data type as from Integer to Character.
In order to do this, tried by Alter column with data type and it is not allowing because of incompatibility.
Now, I like to rename existing column and then create new column with same name and when trying to do this then getting -750 error.
I have dropped associated 'View' with table before trying to rename column.

Please suggest.
Many Thanks

Re: -750 Error solution ?

PostPosted: Thu Aug 04, 2016 6:23 pm
by Robert Sample
The error manual for the -750 code lists several programmer responses that may apply yet you only listed one you've tried. I suspect one of the others needs to be done:
Programmer response


Change the source name to the name of an object that can be renamed or altered, and reissue the statement.

Drop any triggers defined on the table before issuing the RENAME statement. To find these triggers, query the system catalog.

Drop any view that reference the table before issuing the RENAME statement. To find these views, query the system catalog.

If there is a clone defined on the table, drop the clone table before issuing the RENAME statement.

Re: -750 Error solution ?

PostPosted: Sat Aug 27, 2016 12:46 pm
by college2c
thank you,

Regards,
[Advetising removed]