MOVE +100 TO HV-NUM-ROWS. INSERT INTO EMP (EMPNO, LASTNAME, FIRSTNME,

In db2, how do you insert multiple rows in 1 query using a.)
Cursors, b.) Normal query?? Give syntax for both.

Question Posted / adi

5 Answers
20194 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

Please Help Members By Posting Answers For Below Questions

What are bind parameters in db2?

1051

What is difference between alias and synonym in db2?

1149

How many databases can be created inside an instance in db2 ?

1042

List out the data types available.

1158

What db2 400?

1204

Mention the location where the output received from explain statement is stored.

1130

Mention the different locking levels that are available in db2.

1138

List some fields from sqlca?

1062

What is dbrm library?

1073

What is node in db2?

1049

Explain about open switch business continuity software?

1140

What does db2 stand for?

1033

Which isolation level provides highest data integrity?

1128

What is nvl in db2?

1104

Explain how can you do the explain of a dynamic sql statement?

1130