Jun 30, 2017 4: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
Written by Robert Catterall
We use cookies to improve your experience with our site. By continuing to use this site, you consent to our use of cookies. Learn more.