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 ibm db2 client?

688


Mention the location where the output received from explain statement is stored.

849


How to run db2 command in windows?

874


How do I create a view in db2?

786


SQLCODE = -199, ERROR: ILLEGAL USE OF KEYWORD CHAR, TOKEN KEY was expected

11374


How can tablespace be moved to another dasd volume that is allocated for that tablespace?

967


What is bind in db2?

791


What is cloudant database?

837


Explain about mirror activator disk mirroring?

758


What is a buffer in memory?

797


Highlight all the advantages that are attached to a package.

873


Name the lockable units in DB2?

894


When reorg is used?

850


What is a storage group (stogroup)?

988


How would the varchar column remarks defined?

839