1 to 10 of 261
Sort by

Blog Entry
Db2 SQL for the DBA

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. ...

Brian Laube's profile image

Blog Entry
Ranking and Numbering with SQL

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...

David Simpson's profile image

Blog Entry
DB2 SQL Enhancements You May Have Missed

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,...

Fred Sobotka's profile image

Blog Entry
The new SQL Reference for Cross-Platform Development has arrived

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...

Archive User's profile image

Blog Entry
Merge - by Emil Kotrc

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....

Emil Kotrc's profile image

Blog Entry
New IDUG Tech Talk: Taking Advantage of DB2's Advanced SQL Features by Dan Luksetich

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...

Library Entry
Versus - Many SQL roads lead to Rome.. But which is best? (D15)

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...


Library Entry
Lessons Learned from SQL Performance Reviews (F14)

DATE: 2010-5-14 (09:45 AM - 10:45 AM) SPEAKERS: Sheryl Larsen (Sheryl M. Larsen, Inc.) This session divulges discoveries and solutions from various SQL performance review assignments. Come see if you have similar SQL performance issues and get the instructions on how to fix them. Issues...