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 to find primary key of a table in db2?
What is a plan and package in db2?
How to rename a table in DB2 ?
How do I delete a table in database?
I have a subprogram B calling from mainprogram A.I have opened a cursor in A ,Can i fetch the same cursor in subprogram B , If yes , Please explain the reason?
Is it possible using max on a char column?
How to check last update on table in db2?
run jcl for cobol+db2 pgm?.. //jobcard //step001 exec pgm=ikjeft01 //systin dd * DSNSYSTEM(--------) RUN PROGRAM(MYPGMNAME) PLAN(-----), LIB(-------), PARMS(------) /* WHAT WILL U GIVE INSIDE THE BRACKETS... WHAT IS PLAN,PACKAGE,BIND?..PLAN N PACAKGES ARE GENERATED BY ?...
While unloading huge amount of data from table. Suddenly job failed some error. Imagine 1M data unloading, In that 90% data unloaded only 10% left, So if want to unload the rest 10% what needs to be done? Whether do i need to start from top or anything ?
What is the physical storage length of time data type?
Highlight all the advantages that are attached to a package.
Can one database have multiple instances?
What is dbrm library?
What is a system catalog table in db2?
Why db2 is called db2?