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
- 20195 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 db2 connect?
How to access db2 tables in mainframe?
can any one provide me the link for the db2 v7 & db2 v8 manual for Z/os? i need to know about the syntax of REORG in both versions & need to know the difference as well
What is sqlca’s maximum length?
What is meant by dclgen?
What is commit in db2?
What is the difference between cursor and select statement?
How do I start db2 in windows?
How do I create a view in db2?
What is db2 bind?
What's The Error Code For Unique Index Voilation?
How to fetch the last row from the table in SQL (db2)?
What is explain in db2?
What is the information associated with sysibm.syslinks table?
What are the bind parameters ibm db2?
