In db2, how do you insert multiple rows in 1 query using a.)
Cursors, b.) Normal query?? Give syntax for both.
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
Is ibm db2 free?
What is copy pending status in db2?
Which components manage deadlocks in db2?
What language is db2 written in?
Cursors can be declared in both working-storage & procedure division, agreed. But is there any difference? If could you please suggest what is the difference
How would you find out the total number of rows in a db2 table?
What is ibm db2 client?
What is the purpose of rollback and commit?
What is the maximum length of sqlca?
What is bind in db2?
What is db2 look?
Describe major components of db2?
In an sql table that is embedded, what is the procedure to retrieve rows that are part of a db2 table?
What is a db2 collection?
what is db2 restart?