SET NULLVALUE

Specifies the characters to be displayed for $Null values.

Syntax

SET NULLVALUE constant

Parameters

constant

A character string, or an expression that evaluates to a character string.

Comments

The NULLVALUE option is set to a space character by default.

When a value to be output is $Null, the specified constant is displayed.

Example

To specify that the character constant NA is to be displayed for $Null expressions, use

> set nullvalue "NA"

As a result, a LIST command looks like this:

> list 3 Employees
 
LastName    FirstName    Salary
Smith      John        25000
Jones      NA         35000
Johnson     Janet        NA

 

Related Topics