In db2, how do you insert multiple rows in 1 query using a.)
Cursors, b.) Normal query?? Give syntax for both.
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
Mention the downsides of page level lock.
What is plan in cobol db2?
Is db2 free?
What is db2 instance?
What is page size in db2?
How do you stop a db2 database in linux?
List out the three types of page locks that can be held.
Highlight all the advantages that are attached to a package.
by using cursors , we can access particular records from the table based on some condition, i want to delete those selected records, how can we write a query for this in the program?
What parameters are used to control the free space in DB2?
What is db2 optimizer?
When do you specify the isolation level?
How to create backup table in db2?
What is dbrm library?
What is the reason behind not using select * in embedded sql programs?