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

How to insert more than one record using insert?

Question Posted / subi

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

Please Help Members By Posting Answers For Below Questions

What is bufferpool in db2?

794

What is the physical storage length of time data type?

879

What is bind in db2?

779

What is difference between alias and synonym in db2?

840

Define check constraint.

828

What is null value in db2?

744

what is the role of the cursor in db2?

808

What r the comman abends in db2, jcl and cobol???????

2015

can all users have the privilage to use the sql statement select * (dml)?

835

Name the various locking levels available?

816

i want to maintain uniqueness on pdf without make lf??????????

1884

What is the difference between drop table and delete table?

766

What is a system catalog table in db2?

807

What is the difference between using bind () and rebind () methods of naming class?

1054

How to get the ddl of a table in db2?

856