Do an Insert using select Insert into Table1(coltable1, coltable22)(select

How to insert more than one record using insert?

Question Posted / subi

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

Answer Posted / 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

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What action db2 takes when a program aborts in the middle of a transaction?

1192

What is the difference between drop table and delete table?

1281

While unloading huge amount of data from table. Suddenly job failed some error. Imagine 1M data unloading, In that 90% data unloaded only 10% left, So if want to unload the rest 10% what needs to be done? Whether do i need to start from top or anything ?

2381

Explain about rct.

1129

What is a db2 table?

1061

What are the rules for db2 programming?

1152

What is the use of db2?

1111

How to fetch the last row from the table in SQL (db2)?

1692

What is the maximum number of columns in a db2 table?

1342

What is db2 command?

1088

Mention data types used in db2 ?

1198

What are the bind parameters ibm db2?

1097

can we view the access paths created by dbrm ? how ? thx

7196

How do I import data from excel to db2?

1126

What is null value in db2?

1074