Blog

2 min read

SQL Statements: Replacing UNION with CASE

CASE statements are very powerful and you should use them when you can to create elegant and optimal SQL in your DB2 applications.

7 min read

Data Types: The Importance of Choosing the Correct Data Type

Most DBAs have struggled with the pros and cons of choosing one data type over another. This blog post discusses different situations.

13 min read

Db2 Isolation Levels: Know Your ISOLATION Levels

It is important for DB2 DBAs and application programmers to know the four isolation levels and their impact on SQL in order to control concurrency and locking.

4 min read

The Most Common Types of DBAs

There are many types of DBAs and varying job descriptions. Which ones are the most common? Find out here.

2 min read

Using INTERSECT and EXCEPT in DB2

They both are similar to UNION in the way in which they work and are coded. But there a differences, this blog explores the differences.

11 min read

Using Nulls in DB2

Nulls are clearly one of the most misunderstood features of DB2. Here are some examples, tips & guidelines from Craig Mullins to demystify the use of nulls.

4 min read

DSNTEP2 aka Batch SPUFI

DSNTEP2 is an application program that can be used to issue DB2 dynamic SQL statements.