How to insert more than one record using insert?

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

More DB2 Interview Questions

What is meant by AUTO COMMIT?

3 Answers  


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?

6 Answers  


How do I handle -911 (deadlock) error in a db2 program so that the program will never abend?

3 Answers   CTS, IBM,


Mention the way of highlighting as well as putting a cursor to use in a cobol program.

0 Answers  


Explain what a plan is?

3 Answers   CTS,


how to u check the query is executing or not ?where will u check for sqlcode ?

6 Answers   Infosys,


What is IMAGECOPY ?

6 Answers  


How many buffer pools are there in DB2?

2 Answers  


What is the SQL Communications Area and what are some of its key fields?

1 Answers  


Mention the location where the output received from explain statement is stored.

0 Answers  


How do I start db2 in windows?

0 Answers  


What is the use of commit in db2?

0 Answers  


Categories