How to insert more than one record using insert?
Answer Posted / flando
Sandeep Kumar had it close. I found the answer here:
http://publib.boulder.ibm.com/infocenter/db2luw/v8/index.jsp
?topic=/com.ibm.db2.udb.doc/admin/r0000970.htm
insert into tablename (col1, col2)
values (valu1, valu2), (valu1, valu2), (valu1, valu2)
Is This Answer Correct ? | 6 Yes | 1 No |
Post New Answer View All Answers
What is iseries database?
What is bind plan?
Differentiate between cs and rr isolation levels? Where do you specify them?
Explain in brief how does db2 determine what lock-size to use?
What is ibm db2 used for?
When a COBOL-DB2 program in PRODUCTION is updating main tables and gone for long run, what have to do?
How do I connect my db2 database to ibm?
Can you tell me how can you find out the # of rows updated after an update statement?
What is precompiler in db2?
What is the connection string to connect to the DB2 Database ?
What is the use of dclgen in db2?
what is the responsibility of the construction superintendent
Which command is used to remove all rows from a table?
How will you return the number of records in table?
What is release/acquire in bind?