Does fragmneted table contain rowids?
If not, how to find the duplicate rows in a table?
I am trying all my ways and nothing is working.
All the rows continene rowid and is not repeated.
In fragmented tables, if it can be repeated, single rowid, not it row. In order to look for duplicated rows rowid executes:
for example select rowid, (primary key),count(*)
group by 1,2
having count(*) > 1
Warning: Informix recommends not to use rowid in fragmented tables.