Close

Lessons on SQL Pagination in Db2 for z/OS

(1R)

Stream: Virtual Room 1
Time: 16:30 - 17:30


Presentation

SQL pagination or scrolling is a common technique used in many applications (such as CICS, web, mobile) that need to fetch the next n rows to be displayed on the screen. There are multiple ways to achieve this goal, which often do not use the latest enhancements in recent Db2 versions. In this session we will take a look at the traditional pagination approaches and compare them to the latest possibilities.

Objectives

Attachments

1R Attachments

Speakers


  • Emil Kotrc at Broadcom Mainframe Software
  • Emil is an experienced Principal Software Architect with a demonstrated history of working in the computer software industry. Skilled in IBM Db2, Agile Methodologies, Databases, and IBM Mainframe. Strong engineering professional with a Ph.D. focused in Mathematical engineering from Czech Technical University in Prague. Emil is also an active member of the International Db2 User Group (IDUG), member of IDUG content committee, speaker at international conferences, and an IBM Champion since 2015.


    Email: emil.kotrc@broadcom.com

  • Emil Kotrc at Broadcom Mainframe Software
  • Emil is an experienced Principal Software Architect with a demonstrated history of working in the computer software industry. Skilled in IBM Db2, Agile Methodologies, Databases, and IBM Mainframe. Strong engineering professional with a Ph.D. focused in Mathematical engineering from Czech Technical University in Prague. Emil is also an active member of the International Db2 User Group (IDUG), member of IDUG content committee, speaker at international conferences, and an IBM Champion since 2015.


    Email: emil.kotrc@broadcom.com

    Feedback

    Click here to give some Feedback so we can make it even better next year!