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

What is iseries database?

593


What is bind plan?

604


Differentiate between cs and rr isolation levels? Where do you specify them?

578


Explain in brief how does db2 determine what lock-size to use?

589


What is ibm db2 used for?

598






When a COBOL-DB2 program in PRODUCTION is updating main tables and gone for long run, what have to do?

3114


How do I connect my db2 database to ibm?

600


Can you tell me how can you find out the # of rows updated after an update statement?

604


What is precompiler in db2?

585


What is the connection string to connect to the DB2 Database ?

612


What is the use of dclgen in db2?

586


what is the responsibility of the construction superintendent

1660


Which command is used to remove all rows from a table?

551


How will you return the number of records in table?

514


What is release/acquire in bind?

650