Articles & Content


Null and Void? Dealing with Nulls in DB2 (G12)

Topic: 2006 NA

Subtopic: DB2 for z/OS

DATE: 2006-05-11 (08:30 AM - 09:40 AM)
SPEAKERS: Craig Mullins (Neon Enterprise Software, Inc.)

Nulls are one of the most controversial aspects of SQL database systems. On the one hand they seem to be useful as means to record missing information; on the other hand, they introduce three-valued logic and other difficulties into our applications. This presentation will delve into the various aspects of nulls, show some of the problems presented by nulls, and give advice on how best to use/avoid them.

EXP. LEVEL: Intermediate


What is a Null?

How DB2 Implements Nulls

Nulls in General Practice

Some of the Problems with Nulls

How to Use/Avoid Nulls

This file is being provided by IDUG. We would encourage you to join IDUG to get full access to all of our files and resources. Joining IDUG is FREE and signing up is simple. Click here to join! or login!

Download File
Click to Download

NOTE: These are only open to members of IDUG. If you are not a member, please CLICK HERE for more information.