Joined: 01 Mar 2006 Posts: 287 Location: Basel, Switzerland
if this is your table definition
and you have not the columns like in oracle,
how db2 can determine the right row for deletion???
it is not possible...
try to make any unique key or read the table with cursor for update
and delete the second row where duplicates exist.
First thing is in the table which you gave an example there is one column and it doesnt make any sense whether we delete teh fisrt row or second row in the rdbms..Right??.. Second thing if you have any second column in the table then using that coulmn you can delete the row specifying the second column in the where clause.
In DB2 the Rowid(Are hexa decimal) are purely for OS usage to get the rows and the details of the Row ID's are maintained by the system Only..
Mail: ***EMail ID REMOVED... Read Forum Rules***