Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

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

How can we read records for specific member in CL? AND rpg?

757


Explain various types of locks in db2?

1204


Why do we use cursor?

1162


What is ibm db2 used for?

1129


What is database manager in db2?

1061


What is difference between alias and synonym in db2?

1195


What is dbrm? When it will be created?

1084


What is the difference between bind and rebind in db2?

1506


What are db2 tables?

1164


What is phantom read in db2?

1223


What is ibm db2 connect?

1054


What is the use of dclgen in db2?

1135


What is table space in db2?

1071


What is universal database?

1118


Hi Everyone... Under the Logical files, when am working on multiple rec format logical file, I have joined two pf's using the multiple record format logical file concept, but when i run queried the LF only the first mentioned pf records are reflecting and I am not able to see any of the field records specified under the second pf. Kindly let me know whats the reason behind this. Below is the str of LF., R rec PFILE(LOGICAA) CUSTNO CUSTNAME BILL K CUSTNO R rec1 PFILE(LOGICAA1) CUSTNO ADD K CUSTNO .....

2410