perform until ws-flag = 'y' exec sql insert into table('a&

How to insert more than one record using insert?

Question Posted / harish

7 Answers
14295 Views
Atos Origin, IBM, I also Faced
E-Mail Answers

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 db2 bind?

1126

What are the uses of db2 optimizer?

1343

What is ibm db2 client?

999

What is precompiler in db2?

1071

How to test SQL -911 error while developing COB-DB2 program

7657

What are the two types of logging in the db2 database? Explain them.

1120

What is ibm db2 database?

1061

File not opened because library is *PROD and debug is UPDPROD(*NO). ? what may be the reason? how to solve it..?

2998

What is query_cache_limit?

1026

Explain the function of data manager.

1093

What is db2 look?

1073

What is image copy in db2?

1068

What is phantom read in db2?

1218

How do we specify index to include or not during bind process.

2167

How do I delete a table in db2?

1120