IBM Mainframe Forum

by **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

by **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.

by **college2c** » Sat Aug 27, 2016 12:46 pm

thank you,

Regards,
[Advetising removed]

IBM Mainframe Forum

-750 Error solution ?

-750 Error solution ?

Re: -750 Error solution ?

Re: -750 Error solution ?