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
13760 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 is cascading rollback?

1130

Give a brief description of db2 isolation levels?

1012

What is collection in db2 bind?

956

What is the role of schema in the db2 database?

1177

I HAVE 500 ROW TO UPDATE I WOULD LIKE TO USE ROLLBACK ALONG WITH COMMIT.WHAT IS THE SYNTAX TO CODE COMMIT AND ROLLBACK FOR EVERY 100 ROWS.AND HOW THE CURSOR ROLLBACK TO THE LAST COMMITTING POINT.

3142

What is blu acceleration in db2?

1013

What is a collection in db2?

979

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

1087

What is schema in db2?

959

How can deadlocks be resolved?

888

What is dbrm library?

995

What is a trigger in the db2 database?

1013

How to execute stored procedures?

1055

What are foreign keys in db2?

1031

What is runstats and reorg in db2?

1236