Hi,
The following testcase will fail with SQL0750N:
create table jmbt1 (f1 int, f2 varchar(20));
create index ixjmbt1 on jmbt1 (upper(f2));
rename table jmbt1 to jmbt1_old;
SQL0750N The statement failed because the table or column cannot be renamed. SQLSTATE=42986
db2 ? SQL0750N will not mention the case "an index with expression exists on table". It took me some time to figure this out.
Maybe adding a line to this SQL0750N message would be easy to fix in a coming fixpack ?
Best regards, JMB
#Db2#Db2EarlyAccessProgram(EAP)Forum