We can insert by using the following command:- Insert into tablename (

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

Question Posted / vaibhav

Answer Posted / vaibhav

We can insert by using the following command:-

Insert into tablename
(col1,col2,col3,....)
values(&emp-no, '&emp-name', .....)

Is This Answer Correct ?

7 Yes

5 No

Please Help Members By Posting Answers For Below Questions

What is the clustering index in the db2 database?

586

What do you mean by storage group (stogroup)?

583

What is declare cursor?

613

How to find the number of rows in a db2 table?

644

what is a corelated subquerry?

660

Define sqlca.

651

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

6262

Can one database have multiple instances?

583

How to find the number of rows in db2 tables?

617

If the cursor is kept open followed the issuing of commit, what is the procedure to leave the cursor that way?

706

Is ibm db2 free?

577

Define declaration generator (dclgen).

667

What is a db2 collection?

608

How to take backup of table in db2?

601

What is the difference between nvl and coalesce?

604