Toad World Blog

DB2 12 for z/OS SQL Enhancements: Piece-Wise DELETE

Jun 30, 2017 5:38:00 PM by Robert Catterall

DB2 12 for z/OS, which became generally available in October of 2016, delivered a number of key enhancements pertaining to SQL statements. Over the course of a few blog entries, I'll describe some of my favorites among these enhancements. This first post in the series will cover piece-wise DELETE. First, the backdrop: suppose you have a need to remove a large number of rows from a table, using SQL (I say, "using SQL," because a utility-based alternative, REORG with DISCARD, is not always ...read more

 

Tags: IBM DB2 DB2 z/OS

Robert Catterall

Written by Robert Catterall