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
What is db2 bind process?
How to find primary key of a table in db2?
What is the difference between nvl and coalesce?
What is precompiler in db2?
When a COBOL-DB2 program in PRODUCTION is updating main tables and gone for long run, what have to do?
What is catalog database in db2?
What is dbrm? What it contains? When it will be created?
What is check constraint. Explain with example.
What is db2 plan table?
Is db2 a mainframe?
How do you pull up a query which was previously saved in qmf?
What are the contents of dclgen?
What parameters are used to control the free space in DB2?
What is sqlca’s maximum length?
How to test SQL -911 error while developing COB-DB2 program