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 buffer pool and list some of them?
How would the varchar column remarks defined?
List out the three types of page locks that can be held.
What do you mean by between and in? Is between inclusive of specified range values?
Explain how can you do the explain of a dynamic sql statement?
What is load replace in db2?
How do you concatenate the firstname and lastname from emp table to give a complete name?
What is meant by union and union all?
How do you simulate the explain of an embedded sql statement in spufi/qmf?
How can you find out the # of rows updated after an update statement?
What r the comman abends in db2, jcl and cobol???????
What are packages in db2?
What is the maximum size of varchar data type in db2?
What is reorg?
What is a buffer in memory?