Interested to Buy Any Domain ? << Click Here >> for more details...
In db2, how do you insert multiple rows in 1 query using a.)
Cursors, b.) Normal query?? Give syntax for both.
- 5 Answers
- 19992 Views
- CTS, I also Faced
- E-Mail Answers
Answer Posted / uma
We can't insert multiple row in single query for the we
have to use cursor.
| Is This Answer Correct ? | 5 Yes | 5 No |
Post New Answer View All Answers
Which component is used to execute the sql statements?
Explain the contention situations caused by locks?
What is precompiler in db2?
Explain package in db2 and its advantages?
What is phantom read in db2?
File not opened because library is *PROD and debug is UPDPROD(*NO). ? what may be the reason? how to solve it..?
I HAVE 500 ROW TO UPDATE I WOULD LIKE TO USE ROLLBACK ALONG WITH COMMIT.WHAT IS THE SYNTAX TO CODE COMMIT AND ROLLBACK FOR EVERY 100 ROWS.AND HOW THE CURSOR ROLLBACK TO THE LAST COMMITTING POINT.
What is view db2?
What is database alias db2?
B37 abend during spufi?
How to take backup of table in db2?
what is utility for parm lib
While unloading huge amount of data from table. Suddenly job failed some error. Imagine 1M data unloading, In that 90% data unloaded only 10% left, So if want to unload the rest 10% what needs to be done? Whether do i need to start from top or anything ?
What is load replace in db2?
How do I start db2 in windows?
