How to insert more than one record using insert?

Categories >> Software >> MainFrame >> IBM MainFrame >> DB2
Suggest New Category

Question Posted / sriramu.t

7 Answers
14031 Views
Atos Origin, IBM, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

How to insert more than one record using insert? ..

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

How to insert more than one record using insert? ..

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

How to insert more than one record using insert? ..

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

How to insert more than one record using insert? ..

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

How to insert more than one record using insert? ..

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

How to insert more than one record using insert? ..

Answer / ratheesh nellikal

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

How to insert more than one record using insert? ..

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

Post New Answer