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
- 20372 Views
- CTS, I also Faced
- E-Mail Answers
Answer Posted / shekhar
insert into table1
select * from table2
where cond
this query will insert multiple rows at once.
there is load utility of DB2 can help in inserting bulk data from data file.
Plz correct me if i m wrong.
| Is This Answer Correct ? | 2 Yes | 2 No |
Post New Answer View All Answers
How do you stop a db2 database in linux?
Define db2.
What is the function of logging in the db2 database?
How do you pull up a query which was previously saved in qmf?
List out the buffer pools in db2
What is the role of schema in the db2 database?
What is the meaning concurrency in the db2 database?
List down the data types in the db2 database.
How is the value function used?
Explain the benefits you can get from mainframe connect?
Is db2 relational database?
What is the use of reorg in db2?
What is meant by union and union all?
Mention the various locks that are available in db2.
What is view db2?
