How to insert more than one record using insert?

Answer Posted / harish

perform until ws-flag = 'y'
exec sql
insert into table('a','b','c','d','e')
values(a,b,c,d,e)
end-exec
evaluate sqlcode
when 000
continue
when 100
move 'y' to ws-flag

according to me ,pls let me any other remedy

Is This Answer Correct ?    3 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is isolation level in db2?

755


What is consistency token in db2?

871


What is db2 and what is the use of db2 optimizer?

835


What is a buffer in memory?

799


Is db2 a database?

739


What is a collection in db2?

770


What is drop table?

776


What is copy pending status in db2?

870


define clustering index.

802


What is the picture clause of null indicator variable?

881


What is iseries database?

781


Explain the function done by data manager?

1035


What is the syntax for seeing the columns and data types of a table in the db2 database?

806


What is alias in db2?

798


Is db2 a mainframe?

788