IBM Support

Querying an Empty field for an SQL Select command

Troubleshooting


Problem

Filtering a select statement filter on an empty, null, or blank field.

Cause

Looking for situations where a value in a field has not been set. For example, when looking for all volumes that don't have a location.

Resolving The Problem

The syntax used to filter on empty/null fields for Tivoli Storage Manager (TSM) server select statement is "{field} is null".

To locate and identify all volumes that don't have a value for LOCATION, the following select statement could be used:


select volume_name,location,access from volumes where location is null

[{"Product":{"code":"SSGSG7","label":"Tivoli Storage Manager"},"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Component":"Server","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"All Supported Versions","Edition":"","Line of Business":{"code":"LOB26","label":"Storage"}}]

Product Synonym

TSM

Document Information

More support for:
Tivoli Storage Manager

Software version:
All Supported Versions

Document number:
71699

Modified date:
17 June 2018

UID

swg21111774