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

Why do we use cursor?

1106

What is the difference between spufi and qmf?

1135

What are packages in db2?

1024

What do you mean by storage group (stogroup)?

1041

What is scrollable cursor in db2?

1059

What does a deadlock mean in DB2?

1169

How to execute stored procedure in db2 command editor?

1052

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

1104

How to connect to db2 database from windows command line?

1067

Explain the benefits you can get from mainframe connect?

974

What is db2 purescale?

1011

What is cursor in dbms?

1073

What is sqlca?

1081

What are the uses of db2 optimizer?

1299

Which components manage deadlocks in db2?

1073