Articles & Content


Multirow SQL - What’s In It For Me ? (E16)

Topic: 2007 EU

Subtopic: DB2 for z/OS

DATE: 2007-11-8 (11:45 - 12:45)
SPEAKERS: Frank Petersen (Bankdata)

This presentation will look at the V8 multirow functionality from different angles. It will show how to code/use it from both the Z/os side from Cobol as well from the distributed side. There will be included measurements of the performance benefits achieved and there will be a walk-through of locking and accounting impacts.

EXP. LEVEL: Beginner,Intermediate


Understand the basic coding impacts of multirow SQL.

Understand the limitation of multirow SQL.

Be able to understand where and if multirow SQL can be used at the distributed side.

Be able to deal with multirow SQL in tracing, accounting and locking.

Understand where and if it will be beneficially to recode existing applications to use multirow SQL.

This file is being provided by IDUG. We would encourage you to join IDUG to get full access to all of our files and resources. Joining IDUG is FREE and signing up is simple. Click here to join! or login!

Download File
Click to Download

NOTE: These are only open to members of IDUG. If you are not a member, please CLICK HERE for more information.