Toad World Blog

Db2 12 for z/OS SQL Enhancements: Result Set Pagination

Jul 21, 2017 4:08:00 PM by Robert Catterall

In this second of a series of entries on my favorite SQL-related enhancements provided via Db2 12 for z/OS (and "Db2," versus "DB2," is officially the new form of the product name), I will describe useful functionality pertaining to result set pagination (my first post in this series covered piece-wise DELETE ). "Result set pagination" refers to retrieval of a query result set in "pages," with each page including a sub-set of the result set's rows. A typical ...read more

 

Tags: Toad for IBM DB2 IBM DB2 DB2 z/OS SQL

Robert Catterall

Written by Robert Catterall