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
How do you simulate the explain of an embedded sql statement in spufi/qmf?
What are the rules for db2 programming?
What are the bind parameters ibm db2?
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 is the latest version of ibm db2?
What is schema in db2?
Explain how can you do the explain of a dynamic sql statement?
How do I import data from excel to db2?
How can you classify the locks in db2?
Explain about rct.
What is difference between isnull and coalesce?
Suppose pgm A calling Pgm B .Pgm B has some Db2 program. at the time of compilation should plan and package will be created for both A and B or only B? What is the concept?
What is the connection string to connect to the DB2 Database ?
What language is db2 written in?
Explain about mirror activator disk mirroring?