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
Is schema the same as database?
What is the difference between drop table and delete table?
What is an instance in db2?
What is null indicator in db2?
What is the use of reorg in db2?
Mention data types used in db2 ?
Suppose pgm A calling Pgm B .Pgm B has some Db2 program. at the time of compilation should plan and package will be created for both A and B or only B? What is the concept?
What db2 400?
What are host variables in db2?
Which isolation level provides highest data integrity?
How do you simulate the explain of an embedded sql statement in spufi/qmf?
What does sqlcabc has?
How can we retrieve the total number of records in RPG & CLLE?
What is cursor in dbms?
How to restart a DB2 program?