DELETE FROM TABLE_NAME WHERE RID(TABLE_NAME) = 7 ; Works DB2 (V9 Onwa

In my table having 100 Rec. How can I delete the 7th row??
(we don't know what is data inside the table)

Question Posted / mdv

Answer Posted / mdv

DELETE FROM TABLE_NAME
WHERE RID(TABLE_NAME) = 7 ;

Works DB2 (V9 Onwards)

Is This Answer Correct ?

2 Yes

0 No

Please Help Members By Posting Answers For Below Questions

Where do you specify them?

1159

What is nvl in db2?

1036

What is the role of the data page in the db2 database?

971

What is the difference between using bind () and rebind () methods of naming class?

1323

How do you eliminate duplicate values in db2?

1107

can all users have the privilage to use the sql statement select * (dml)?

1102

Define check constraint.

1023

List some fields from sqlca?

1000

Why do chiropractors use drop table?

1043

Is ibm db2 open source?

1010

Explain in brief how does db2 determine what lock-size to use?

958

What is ibm db2 client?

876

define clustering index.

973

What is the maximum number of columns in a db2 table?

1209

What is the role of data manager in the db2 database?

1050