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?
- 4 Answers
- 7522 Views
- Mphasis, I also Faced
- E-Mail Answers
Answer Posted / vaneesh khurana
Hi Satty
Can you please let us know what command you will use for
delete.
Vaneesh
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
B37 abend during spufi?
What is load utility in db2?
What is runstats utility in db2?
Is db2 a mainframe?
What is buffer pool in the db2 database?
List some fields from sqlca?
What is ibm db2 database?
What is the maximum No of rows per page?
what is diffrence b/w file-aid tool and file-aid utility???
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 .....
Which command is used to remove all rows from a table?
What are the two types of logging in the db2 database? Explain them.
How does db2 sample database connect?
What is database manager in db2?
How to execute stored procedure in db2 command editor?
