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

How to connect to db2 database from windows command line?

567

What is the use of db2 optimizer?

616

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

2386

What is a trigger in the db2 database?

602

Is schema the same as database?

636

How to get the ddl of a table in db2?

683

Explain the benefits you can get from mainframe connect?

524

Name the lockable units in DB2?

669

What is universal database?

623

Give a brief description of db2 isolation levels?

608

Explain about dbrm.

610

What is sqlca’s maximum length?

678

What is db2 catalog database?

588

Describe major components of db2?

643

What is release/acquire in bind?

656