Db2 SQL for the DBA - Using Modern SQL for DBA Tasks Recent releases of Db2 have introduced new SQL functionality that improves the functionality and productivity of application developers. But the DBA can also take advantage of some of the “new” Db2 SQL to improve their own productivity. ...
Beginning in DB2 9, IBM introduced support for On-Line Analytical Processing (OLAP) built-in functions. The first three functions introduced may be used to rank and number rows in a result table. This article will explore these three functions which are available on both DB2 for z/OS and DB2...
Chances are that your business applications and the DB2 LUW databases that power them were built before IBM released DB2 10.1 in April 2012. While it’s no secret that the last two DB2 LUW releases delivered substantial performance gains that make upgrading to DB2 10.1 or even 10.5 a no-brainer,...
The new SQL Reference for Cross-Platform Development has arrived In May of this year, IBM published the newest version of The SQL Reference for Cross-Platform Development. This document, known also as the Cross-Platform SQL Reference, or CP SQL Reference, is intended for developers who...
MERGE Some time ago, I began discussing several features of various relational database management systems with my friends. One of the discussed topics was the MERGE SQL statement and the alternatives. MERGE is common in the popular commercial DBMS like DB2, Microsoft SQL Server, or Oracle....
2015 April eBulletin
IDUGAprileBulletin_2015.pdf
In this comprehensive overview of DB2 10 for z/OS, Lori Ann Galluzzo goes through the features of DB2 10 in great detail. Each feature is discussed, along with how and when to take advantage of the feature, as well as some pitfalls and things to watch out for. This IDUG Tech talk video (as...
SQL is way more than a data access language. It is a full-fledged programming language. What this means is that any business or scientific question that can be asked can be answered using SQL. There are no longer any limits to the capabilities of the SQL language. By utilizing some built-in...
DATE: 2011-5-6 (10:30 AM - 11:30 AM) SPEAKERS: Serge Rielau (IBM Canada ) SQL is a powerful language and in it's latest iteration DB2 9.7 has added more SQL and SQL PL features than ever before.In this presentation we'll run competing solutions against each other and see who comes out ahead and...
NA11D15.pdf
DATE: 2010-5-14 (11:00 AM - 12:00 PM) SPEAKERS: Herb Vogel (JB HUNT Transportation) Discuss and show where to begin in developing SQL PL Stored Procs, Triggers, and UDF's.. From basic syntax and creation to more advanced topics...(including temp tables , emailing, MQ, and new features in 9.7......
NA10E15.pdf