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.
My introduction to DB2 and SQL occurred over 30 years ago. It changed my life. Now big data tools have SQL as well.
There are numerous enhancements to SQL in DB2 12 for z/OS. There is also a significant amount of SQL performance enhancements in DB2 12 for z/OS which contribute to the “out of the box” savings realized when migrating from DB2 11 for z/OS. The IDUG team explored some of the most significant new SQL