In db2, how do you insert multiple rows in 1 query using a.) Cursors, b.) Norma

Categories >> Software >> MainFrame >> IBM MainFrame >> DB2
Suggest New Category

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

Question Posted / rakesh

5 Answers
18924 Views
CTS, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

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

Answer / vaibhav

We can insert by using the following command:-

Insert into tablename
(col1,col2,col3,....)
values(&emp-no, '&emp-name', .....)

Is This Answer Correct ?

7 Yes

5 No

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

Answer / 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

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

Answer / 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

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

Answer / shekhar

insert into table1
select * from table2
where cond

this query will insert multiple rows at once.

there is load utility of DB2 can help in inserting bulk data from data file.

Plz correct me if i m wrong.

Is This Answer Correct ?

2 Yes

2 No

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

Answer / siri

insert into tableName
(col1, col2, col3, col4, col5)
values
(val1, val2, val3, val4, val5),
(val1, val2, val3, val4, val5),
(val1, val2, val3, val4, val5),
(val1, val2, val3, val4, val5);

Is This Answer Correct ?

4 Yes

5 No

Post New Answer