Press
CDB White Papers & Articles
- 1st Quarter
Ask For Only What You Need
As you write SQL statements to access DB2 data, there are certain very simple, yet important rules to follow to encourage efficient SQL.
Click here to read more »- 1st Quarter
Excluding Alphabetic Characters
This quarter’s DB2 tip offers up some useful SQL and should help to further convince you that you can accomplish many tasks using nothing but SQL!
Click here to read more »- 2nd Quarter
Find The Number of Commas
This quarter’s DB2 newsletter tip drives home the point that it is important to know DB2 functions. There are three types of built-in functions in DB2 that can be used to transform data in your tables: aggregate functions, scalar functions, and table functions.
Click here to read more »- 3rd Quarter
ORDER BY an Expression
Sometimes a program requires that the results of a query be returned in a specific sequence. We all know that the ORDER BY clause can be used to sort SQL results into a specific order.
Click here to read more »- 4th Quarter
The Perils of Bachelor Programming Syndrome
Every DB2 application program should issue COMMIT statements whenever the program modifies data. A COMMIT externalizes all modifications made by the program since it began or since the last COMMIT.
Click here to read more »- 1st Quarter
Removing Superfluous Spaces
Although data integrity is a pervasive problem, there are some data integrity issues that can be cleaned up using a touch of SQL.
Click here to read more »- 2nd Quarter
Reading Things That Aren’t There… and Missing Things That Are!
There are options that you can specify that may cause you to read data that is not really in the database. Alternately, you can set things up so that you miss reading data that is actually in the database.
Click here to read more »- 3rd Quarter
Selecting Every Other Row
One of the fun things about publishing is getting questions from readers that make you think. A recent question I received went something like this: “Can I get the odd and even number of rows from a DB2 table?”
Click here to read more »- 4th Quarter
Which is better? BETWEEN versus “<= AND >=”
As all good DB2 developers know, there is frequently more than one way to write a SQL statement to return the same results. But the performance… that is another issue. In this quarter’s tip, we take a look at BETWEEN and the equivalent combination of <= AND >=.
Click here to read more »
– CDB Newsletters –
2013
2012
2011
– White Papers –
Sign Up Now
Do you want to receive our quarterly newsletter? Click below and send us your information.