Content Committee member Ben Anderson has written a very informative article on using the XQuery function fn:matches to provide regular expression pattern matching in SQL on the DB2 for LUW platform.
Access the article from the following link -
As DB2 reaches its 30th anniversary and IDUG reaches its 25th anniversary, I’ve thought about many DB2 tips and best practices that have been incorporated by companies, projects and applications that have led to great successes. The ones that have been most common and have had the greatest impact a
Terry Purcell of the IBM SVL Optimization Team recorded his IDUG presentation introducing the query optimization enhancements that were delivered with DB2 10 for z/OS. Terry goes into detail of each enhancement and explains when each optimization improvement can and will be applied.
This is the second of three presentations donated to IDUG by Sheryl Larsen. This presentation is from her Tuning SQL for Performance seminar, and contains information about advanced SQL programming and performance.
This is the first of three presentations donated to IDUG by Sheryl Larsen. This presentation is from her Advanced SQL Coding seminar, and contains information about advanced SQL programming and performance.