DB2 12 introduces a number of new SQL and SQL PL related enhancements. In the first of this two-part article, we will discuss the new DELETE syntax that enables customers to delete large numbers of rows from a table without severely impacting the system.
This article discusses the new enhanced MERGE in DB2 12 from the user perspective.
Did you know that you can issue SQL statement to Db2 for z/OS using File Transfer Protocol (FTP)? If not, make sure you read this new brand article!
DB2 11.1 for LUW introduced built-in SQL functions for regular expressions, a long-awaited enhancement that effectively supersedes a couple of popular workarounds for regex processing in DB2 SQL. This article describes the REGEXP functions and explains what makes them better than older workarounds.
I’ve spent the last 17 years teaching SQL Performance & Tuning on DB2 for z/OS. I’ve been trying to get SQL developers to think about the predicates they write from DB2’s perspective instead of what makes sense to humans.