How to insert more than one record using insert?
- 7 Answers
- 12992 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 |
What is meant by AUTO COMMIT?
If a table has a column "dept" (declared to have nulls) and there are 10 rows in the table of which 3 have a null value in the dept column, what will select count(*) and select count(distinct dept) return?
How do I handle -911 (deadlock) error in a db2 program so that the program will never abend?
Mention the way of highlighting as well as putting a cursor to use in a cobol program.
Explain what a plan is?
how to u check the query is executing or not ?where will u check for sqlcode ?
What is IMAGECOPY ?
How many buffer pools are there in DB2?
What is the SQL Communications Area and what are some of its key fields?
Mention the location where the output received from explain statement is stored.
How do I start db2 in windows?
What is the use of commit in db2?
COBOL 
