In my table having 100 Rec. How can I delete the 7th row??
(we don't know what is data inside the table)
Answer Posted / 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 |
Post New Answer View All Answers
What is a buffer in memory?
What is null indicator in cobol db2?
What is null value in db2?
Hi Everyone... Under the Logical files, when am working on multiple rec format logical file, I have joined two pf's using the multiple record format logical file concept, but when i run queried the LF only the first mentioned pf records are reflecting and I am not able to see any of the field records specified under the second pf. Kindly let me know whats the reason behind this. Below is the str of LF., R rec PFILE(LOGICAA) CUSTNO CUSTNAME BILL K CUSTNO R rec1 PFILE(LOGICAA1) CUSTNO ADD K CUSTNO .....
What are the two types of logging in the db2 database? Explain them.
How to compare data between two tables in db2?
How can we read records for specific member in CL? AND rpg?
What is the default page size of buffer pools?
What is the maximum size of varchar data type in db2?
Explain packages.
What is package in cobol db2?
by using cursors , we can access particular records from the table based on some condition, i want to delete those selected records, how can we write a query for this in the program?
have 3 tables table1, table2 and table3 which contains employee information. table1 is master table, table2 contains emp details like emp no and so on, table 3 contains emp salary. so if any emp leave company between 25th - 30th of every month it has to get updated in tables. but it is not getting updated. What is the reason.
Which isolation level provides maximum concurrency?
Why do chiropractors use drop table?