I have the following situation:
db2 v7.2 on windows
one table without primary key and without unique index
some indentical rows.
how can i delete only one row which matches a where condition?
that means i search for something like:
delete from tab where row in (select * from tab where col=value fetch
only 1 row)
In version 8 the following statement works:
delete from tab where col1 in (select col1 from tab where col1=value
fetch only 1 row)
but in version 7 i get an error SQL0104N.
how can this be done in version 7.2 for windows?