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
- 19934 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 to check table size in db2 sap?
What is the difference between plan and package in db2?
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 are host variables in db2?
What does runstats do in db2?
Why do we use cursor?
Define buffer pool.
What is the difference between cursor stability and repeatable read isolation levels?
What is universal database?
Explain dclgen.
What is a system catalog table in db2?
Is db2 a programming language?
How to take backup of table in db2?
What is nvl in db2?
What is the use of runstats in db2?
