Interested to Buy Any Domain ? << Click Here >> for more details...
In db2, how do you insert multiple rows in 1 query using a.)
Cursors, b.) Normal query?? Give syntax for both.
- 5 Answers
- 20130 Views
- CTS, I also Faced
- E-Mail Answers
Answer Posted / adi
MOVE +100 TO HV-NUM-ROWS.
INSERT INTO EMP
(EMPNO, LASTNAME, FIRSTNME,
MIDINIT, SALARY, BONUS)
VALUES (:HV-EMPNO-ARRAY,
:HV-LASTNAME-ARRAY,
:HV-SALARY-ARRAY,
:HV-BONUS-ARRAY)
FOR :HV-NUM-ROWS
ATOMIC
all array elements will have a 100 occur clause
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What is the meaning concurrency in the db2 database?
What is isolation level in db2?
what is diffrence b/w file-aid tool and file-aid utility???
How can you validate Sql errors during cursor operation in db2 pgms and where do you code?
What is runstats and reorg in db2?
What is catalog database in db2?
what is db2 restart?
Explain about cursor stability?
Is it possible to alter a table – for example adding a column, when another user is accessing or updating some columns?
My sql statement select avg(salary) from emp yields inaccurate results. Why?
Why do we bind in db2?
Why db2 is called db2?
When do you specify the isolation level?
How to compare data between two tables in db2?
B37 abend during spufi?
