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 dbrm? What it contains? When it will be created?

1002

What is a cursor in programming?

1024

What is the use of db2?

1013

File not opened because library is *PROD and debug is UPDPROD(*NO). ? what may be the reason? how to solve it..?

2876

What is the function of logging in the db2 database?

1079

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

2112

What is dclgen (declaration generator)?

1016

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

2215

What is catalog database in db2?

1111

What is buffer pool and list some of them?

992

Which command is used to connect to a database in DB2 ? Give the Syntax.

1045

What is cursor stability in db2?

1293

What is rebind in db2?

1008

How can we read records for specific member in CL? AND rpg?

656

Is db2 a mainframe database?

954