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 db2 bind process?

763


How to find primary key of a table in db2?

619


What is the difference between nvl and coalesce?

607


What is precompiler in db2?

590


When a COBOL-DB2 program in PRODUCTION is updating main tables and gone for long run, what have to do?

3124






What is catalog database in db2?

646


What is dbrm? What it contains? When it will be created?

595


What is check constraint. Explain with example.

650


What is db2 plan table?

624


Is db2 a mainframe?

594


How do you pull up a query which was previously saved in qmf?

680


What are the contents of dclgen?

661


What parameters are used to control the free space in DB2?

646


What is sqlca’s maximum length?

678


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

6723