-750 Error solution ?

IBM's flagship relational database management system

-750 Error solution ?

Postby MFDEV » Thu Aug 04, 2016 9:58 am

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
Posts: 15
Joined: Mon Dec 01, 2014 3:25 pm
Has thanked: 2 times
Been thanked: 0 time

Re: -750 Error solution ?

Postby Robert Sample » Thu Aug 04, 2016 6:23 pm

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.

These users thanked the author Robert Sample for the post:
MFDEV (Sun Aug 07, 2016 5:48 pm)
Robert Sample
Global moderator
Posts: 3720
Joined: Sat Dec 19, 2009 8:32 pm
Location: Dubuque, Iowa, USA
Has thanked: 1 time
Been thanked: 279 times

Re: -750 Error solution ?

Postby college2c » Sat Aug 27, 2016 12:46 pm

thank you,

[Advetising removed]
Posts: 1
Joined: Mon Apr 04, 2016 10:48 am
Has thanked: 0 time
Been thanked: 0 time

Return to DB2


  • Related topics
    Last post