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
- 19982 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
Explain various types of locks in db2?
What does runstats do in db2?
What is blu acceleration in db2?
Is ibm db2 open source?
What is page size in db2?
Define data page.
Is ibm db2 free?
What is cascading rollback?
Define check constraint.
In an sql table that is embedded, what is the procedure to retrieve rows that are part of a db2 table?
Can one database have multiple instances?
What is the difference between bind and rebind in db2?
List some fields from sqlca?
what is the responsibility of the construction superintendent
What is data manager?
