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
- 19973 Views
- CTS, I also Faced
- E-Mail Answers
Answer Posted / vaibhav
We can insert by using the following command:-
Insert into tablename
(col1,col2,col3,....)
values(&emp-no, '&emp-name', .....)
| Is This Answer Correct ? | 7 Yes | 5 No |
Post New Answer View All Answers
What is node in db2?
Is it possible using max on a char column?
What are the different types of base tables?
List out the buffer pools in db2
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 a db2 cursor?
What is load utility in db2?
How does cobol compile db2 program?
What is the difference between plan and package in db2?
Explain about open switch business continuity software?
Explain the function of data manager.
Give the name of some fields form sqlca.
What are the two types of logging in the db2 database? Explain them.
What are sqlcodes –803,-805, -811, -818,-904,-911,-913,-101, +100?
How to find primary key of a table in db2?
