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
- 20174 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
What is the advantage in De-normalizing tables in DB2?
Mention a credible reason why select* is never given preference in an sql program that has been embedded.
What do you mean by cursor?
What is a page in db2?
What is db2 plan table?
What is the meaning concurrency in the db2 database?
I understand Join always perform better than subqueries. Then what is the advantage/use of Subqueries/correlated subqueries etc.,in DB2 programming.Please explain.
What is the use of dclgen in db2?
How do I copy a table in db2?
What action db2 takes when a program aborts in the middle of a transaction?
If the cursor is kept open followed the issuing of commit, what is the procedure to leave the cursor that way?
What is the connection string to connect to the DB2 Database ?
What is package in cobol db2?
What is host variable in db2 cobol?
What is db2 and what is the use of db2 optimizer?
