Interested to Buy Any Domain ? << Click Here >> for more details...
How to insert more than one record using insert?
- 7 Answers
- 14316 Views
- Atos Origin, IBM, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / subi
Do an Insert using select
Insert into Table1(coltable1, coltable22)(select coltab21,
tab2col2 from Tab2 where <condn>)
| Is This Answer Correct ? | 9 Yes | 2 No |
Answer / 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 |
Answer / harish
perform until ws-flag = 'y'
exec sql
insert into table('a','b','c','d','e')
values(a,b,c,d,e)
end-exec
evaluate sqlcode
when 000
continue
when 100
move 'y' to ws-flag
according to me ,pls let me any other remedy
| Is This Answer Correct ? | 3 Yes | 2 No |
Answer / nahid gorji
using insert into table1 (column-list or *) 479 select
column-list or * from another table
| Is This Answer Correct ? | 1 Yes | 1 No |
Answer / sandeep kumar
insert into tablename(col1, col2)
values(valu1, valu2)
values(valu1, valu2)
values(valu1, valu2)
values(valu1, valu2)
values(valu1, valu2)
values(valu1, valu2)
values(valu1, valu2)
values(valu1, valu2)
....................
....................
| Is This Answer Correct ? | 7 Yes | 8 No |
U could probably go for a bulk insert also.
try this option
insert into schema.table1
select * from schema.table2;
Cheers,
Ratheesh Nellikal
| Is This Answer Correct ? | 0 Yes | 1 No |
Answer / kalone
If we want to insert more than 1 row into a table , we
should go for SUBQUERIES rather than VALUES clause.
| Is This Answer Correct ? | 0 Yes | 1 No |
Explain the contents that are a part of dclgen.
What is commit in db2?
What is a db2 package?
What is a NULL value? What are the pros and cons of using NULLS?
What is a page in db2?
What is bind plan?
What is the result of open cursor statement?
What do you do to keep the cursor from closing after a commit?
What does runstats do in db2?
what is different three logs in DB2?
what is db2 restart?
What's The Error Code For Unique Index Voilation?
COBOL 
