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

Answer Posted / uma

We can't insert multiple row in single query for the we
have to use cursor.

Is This Answer Correct ?    5 Yes 5 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is ibm db2 used for?

596


What is table space in db2?

571


What is null indicator in cobol db2?

575


What is the use of predicate?

577


Explain db2.

605






How to test SQL -911 error while developing COB-DB2 program

6697


Where can you declare a cursor in a cobol-db2 program?

598


what is the sqlcode -501

11260


What is db2 purescale?

537


How would the varchar column remarks defined?

625


Explain various types of locks in db2?

680


What is a db2 collection?

599


Which isolation level provides highest data integrity?

587


How many databases are there?

585


Following a db2 update statement, what is the quickest way to compute the total number of updated rows?

616