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 package in db2 mainframe?

1036

What is a dbrm in db2?

1077

What are the different types of base tables?

1163

Explain about rct.

1130

Is it possible using max on a char column?

1192

Explain the function of data manager.

1097

What is scrollable cursor in db2?

1124

What is the physical storage length of date data type?

1305

What is a db2 table?

1065

How do you concatenate the firstname and lastname from emp table to give a complete name?

1119

What are foreign keys in db2?

1170

What is the picture clause of null indicator variable?

1181

What is the physical storage length of the data types: date, time, timestamp in the db2 database?

1216

How can deadlocks be resolved?

991

Which isolation level provides maximum concurrency?

1203