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
- 20367 Views
- CTS, I also Faced
- E-Mail Answers
Answer Posted / siri
insert into tableName
(col1, col2, col3, col4, col5)
values
(val1, val2, val3, val4, val5),
(val1, val2, val3, val4, val5),
(val1, val2, val3, val4, val5),
(val1, val2, val3, val4, val5);
| Is This Answer Correct ? | 4 Yes | 5 No |
Post New Answer View All Answers
What is deadlock in db2?
Where can you declare a cursor in a cobol-db2 program?
What is a db2 package?
What are the full forms of spufi and dclgen and why are they used?
What db2 400?
When do you specify the isolation level?
What is the clustering index in the db2 database?
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 the difference between using bind () and rebind () methods of naming class?
What do you mean by between and in? Is between inclusive of specified range values?
What are iseries servers?
My sql statement select avg(salary) from emp yields inaccurate results. Why?
Explain about cursor stability?
How does coalesce work?
What is the use of dclgen in db2?
