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

Explain about dbrm.

1035

What is the difference between dbm cfg and db cfg file in db2 ?

1526

Comment whether the cursor is closed during commit or not.

1092

What is deadlock in db2?

1061

When reorg is used?

1122

What is database manager in db2?

1009

How to get the ddl of a table in db2?

1125

What is the maximum size of varchar data type in db2?

1123

How is the value function used?

1146

What is sqlca’s maximum length?

1174

What os does db2 run on?

969

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

2250

What is db2 connect?

1059

Where do you specify them?

1263

What is the result of open cursor statement?

1074