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?
Answer Posted / narayana reddy
delete current(cursor) from table
| Is This Answer Correct ? | 0 Yes | 3 No |
Post New Answer View All Answers
How do I add a column 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 .....
How do I add a column to an existing table in db2?
What is buffer pool in the db2 database?
Which command is used to connect to a database in DB2 ? Give the Syntax.
How to retrieve rows from a db2 table in embedded sql?
What is host variable in db2 cobol?
What do you mean by storage group (stogroup)?
B37 abend during spufi?
Explain the function done by data manager?
Is db2 a mainframe?
How to run db2 command in windows?
Mention some fields that are a part of sqlca.
What is the information associated with sysibm.syslinks table?
What is the maximum size of varchar data type in db2?