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


Please Help Members By Posting Answers For Below Questions

Is schema the same as database?

718


What is the difference between drop table and delete table?

653


What is an instance in db2?

647


What is null indicator in db2?

716


What is the use of reorg in db2?

698






Mention data types used in db2 ?

766


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?

7100


What db2 400?

795


What are host variables in db2?

707


Which isolation level provides highest data integrity?

675


How do you simulate the explain of an embedded sql statement in spufi/qmf?

724


What does sqlcabc has?

705


How can we retrieve the total number of records in RPG & CLLE?

276


What is cursor in dbms?

700


How to restart a DB2 program?

1455