Articles & Content
Topic: 2009 NA
Subtopic: DB2 for z/OS
DATE: 2009-5-13 (01:30 PM - 02:30 PM)
SPEAKERS: Anthony Tichonoff (Florida Hospital)
Multi-row FETCH in V8 provided a significant perfomance boost, but what about multi-row INSERT? It can significantly boost INSERTing perfomance and reduce CPU usage. Converting existing programs involves some serious structural changes to both SQL and program logic. Learn from those who have gone before into the world of multi-row INSERT. Attend this session if you want to understand the power and pitfalls of multi-row INSERT.
EXP. LEVEL: Intermediate,Advanced
Explain the concept of how multi-row INSERT works
Describe some of the reasons and implications of using multi-row INSERT
Specify the changes required to implement multi-row insert in your COBOL programs
Identify potentical pitfalls with; unit of work, error handling, array processing, backout processing
Describe the way this has been successfully implemented in one business
Click Here to Download
NOTE: These are only open to members of IDUG. If you are not a member, please CLICK HERE for more information.