bneidhardt
Programmer
Hi all
When I try to drop an index I've got Error 9985. I tried when I was logged in as SYSADM and SYSREP. What can I do to drop the index?
In SQL-Talk I would like to change the length of column mit_ident_nr to dec(6,0).
With the add and update of the column I had no problems.
I have the following commands:
drop index x_index;
alter table x_table add mit_ident_nr2 dec (6,0);
update x_table set mit_ident_nr2 = mit_ident_nr;
alter table x_table drop mit_ident_nr;
alter table x_table rename mit_ident_nr2 mit_ident_nr;
CREATE INDEX x_index ON x_table
(MIT_IDENT_NR, MDT_IDENT_NR, MDT_GJAHR);
Thanks for your help!
When I try to drop an index I've got Error 9985. I tried when I was logged in as SYSADM and SYSREP. What can I do to drop the index?
In SQL-Talk I would like to change the length of column mit_ident_nr to dec(6,0).
With the add and update of the column I had no problems.
I have the following commands:
drop index x_index;
alter table x_table add mit_ident_nr2 dec (6,0);
update x_table set mit_ident_nr2 = mit_ident_nr;
alter table x_table drop mit_ident_nr;
alter table x_table rename mit_ident_nr2 mit_ident_nr;
CREATE INDEX x_index ON x_table
(MIT_IDENT_NR, MDT_IDENT_NR, MDT_GJAHR);
Thanks for your help!