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
What is image copy in db2?
What is meant by explain?
Why cursor is used in db2?
How to test SQL -911 error while developing COB-DB2 program
How do I start db2 in windows?
What is buffer pool in the db2 database?
what is the responsibility of the construction superintendent
Before you give the explain statement, what are the prerogatives?
Can we update view in db2?
What does db2 stand for?
what is diffrence b/w file-aid tool and file-aid utility???
what is a corelated subquerry?
What is view db2?
have 3 tables table1, table2 and table3 which contains employee information. table1 is master table, table2 contains emp details like emp no and so on, table 3 contains emp salary. so if any emp leave company between 25th - 30th of every month it has to get updated in tables. but it is not getting updated. What is the reason.
How does db2 sample database connect?