Interested to Buy Any Domain ? << Click Here >> for more details...
How to update more then one record using update?
- 5 Answers
- 11578 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / pratap singh
For this concern you can use or oprator along with where
clause, Example
WHERE DEPT_ID='D110' OR 'D001' OR 'D105'
| Is This Answer Correct ? | 7 Yes | 0 No |
Post New Answer View All Answers
What is package in cobol db2?
How do I start db2 in windows?
Can you tell me how can you find out the # of rows updated after an update statement?
What is buffer pool and list some of them?
What is explain in 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?
How to find the number of rows in a db2 table?
Explain about mirror activator disk mirroring?
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 is check constraint. Explain with example.
Which are the db2 tools to protect integrity of the database?
What is load replace in db2?
How do you stop a db2 database in linux?
What are the full forms of spufi and dclgen and why are they used?
What is meant by union and union all?
