Interested to Buy Any Domain ? << Click Here >> for more details...
In my table having 100 Rec. How can I delete the 7th row??
(we don't know what is data inside the table)
- 9 Answers
- 15810 Views
- IBM, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / harsha
Use DELETE FROM TabName
The above command will delete all rows of the table with
out deleting the table.
Now if we want to delete 7th row and we don't know the
actual data in that row, then in that case we need to
create a new temporary result table, that contains only one
desired record which you want to delete.
Here are the steps.
1 Select only 7 row data.
2 Sort it in descending order(ORDER BY calue)
3 Select only first row
4 Now you have a result table with only 1 and desired record
| Is This Answer Correct ? | 4 Yes | 1 No |
Answer / mdv
DELETE FROM TABLE_NAME
WHERE RID(TABLE_NAME) = 7 ;
Works DB2 (V9 Onwards)
| Is This Answer Correct ? | 2 Yes | 0 No |
Answer / giri reddy
use cursor to find out the primary key column value in that
row, then delete tha row using the primary key
| Is This Answer Correct ? | 1 Yes | 1 No |
Answer / rajeev
In this scenario RRN will be useful.
DELETE FROM <FILENAME> F1 WHERE RRN(F1) = 7
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / tim v
Are we talking the 7th row as sorted by key or 7th physical row? Since the rows aren't normally physically stored in order, I'd have to go with the latter.
Everyone seems to assume there is a PK on the table, but yet we don't know anything about the data... Again, this points to 7th physical row.
I'd go with the delete where RID(table) = 7 option since this assumes the 7th row inserted based on position and not value.
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / m sharib
delete from table1 where policy_no =(select policy_no from table1 limit 6,1);
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / ajay
we need to know atleast 1 column data, else we can not delete data from table.
| Is This Answer Correct ? | 2 Yes | 4 No |
Answer / sherman_li
Actually, you don't need to delete this data, just move
foward the remaining data(from 8th to 100th), for example,
8th -> 7th
9th -> 8th
...
100th -> 99th
hope this is what you want
| Is This Answer Correct ? | 0 Yes | 11 No |
In a DB2-CICS program which is acts as co-ordinator and which is participant?
we can code COPY DCLGEN or INCLUDE DCLGEN, At which stage of the precompilation , dclgen get expanded if we write 1) copy 2) include one question about dclgen.. Is it mandatory to use declare table in dclgen.. I think no...but it will be used by the precompiler to validate the table name,column name etc.., can one clear my doubt ..is it necessary to include declare table or not?
What is dbrm? What it contains? When it will be created?
What are the functions of Bind?
How to resolve SQL Code -310. The db table feild is declared as Decimal(7,2).
What is the SQL query to select, delete and get count of duplicate rows in DB2?
what is a plan and how do you refer the plan in the program?
can I alter a table (e.g. adding a column) when other user is selecting some columns or updating some columns from the same table?
If anyone has IBM Certification Dumps pls forward to me & also let me know what are the Certification Codes that are available in DB2
How can we define a table? How can we apply SEARCH ALL on it ?
DB2 is a A) data base/data communication system B) data base C) RDBMS D) Programming language
How do I copy a table in db2?
COBOL 
