Let's have some fun with date logic in our SQL statements.
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.