In db2, how do you insert multiple rows in 1 query using a.)
Cursors, b.) Normal query?? Give syntax for both.
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
What is a Foreign Key?
Define predicate?
How do I import a csv file into db2?
have 3 tables table1, table2 and table3 which contains employee information. table1 is master table, table2 contains emp details like emp no and so on, table 3 contains emp salary. so if any emp leave company between 25th - 30th of every month it has to get updated in tables. but it is not getting updated. What is the reason.
List out the three types of page locks that can be held.
What are the uses of db2 optimizer?
What is the difference between cursor stability and repeatable read isolation levels?
When a COBOL-DB2 program in PRODUCTION is updating main tables and gone for long run, what have to do?
How do you find the maximum value in a column in db2?
what is the sqlcode -501
How to fetch the last row from the table in SQL (db2)?
Where do you specify them?
What is load replace in db2?
What's The Percentage Free Space ?
What is view db2?