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
How can we read records for specific member in CL? AND rpg?
Explain various types of locks in db2?
Why do we use cursor?
What is ibm db2 used for?
What is database manager in db2?
What is difference between alias and synonym in db2?
What is dbrm? When it will be created?
What is the difference between bind and rebind in db2?
What are db2 tables?
What is phantom read in db2?
What is ibm db2 connect?
What is the use of dclgen in db2?
What is table space in db2?
What is universal database?
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 .....