insert into table1 select * from table2 where cond this query will in

In db2, how do you insert multiple rows in 1 query using a.)
Cursors, b.) Normal query?? Give syntax for both.

Question Posted / shekhar

5 Answers
20139 Views
CTS, I also Faced
E-Mail Answers

Answer Posted / shekhar

insert into table1
select * from table2
where cond

this query will insert multiple rows at once.

there is load utility of DB2 can help in inserting bulk data from data file.

Plz correct me if i m wrong.

Is This Answer Correct ?

2 Yes

2 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is role in db2?

1101

What is drop table?

1002

What does db2 plan contain?

1013

What is the advantage in De-normalizing tables in DB2?

1163

What do you mean by storage group (stogroup)?

1032

List out the buffer pools in db2

1068

What is explain in db2?

1009

Explain package in db2 and its advantages?

1201

If anyone has IBM Certification Dumps pls forward to me & also let me know what are the Certification Codes that are available in DB2

2037

What is the max length of sqlca?

1211

Explain correlated sub-queries.

1024

In case if at some point of time db2 is down, would that impact the pre-compilation process of a db2-cobol program?

1036

Comment whether dclgen is mandatorily used. If not, then what is the point of using it?

1048

What is multi row fetch in db2?

1041

What is runstats utility in db2?

1016