613-518-1166 info@zimdatabases.com

ZIM Language Reference

SET NULLVALUE

< All Topics

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

 

See Also

$Null

Expressions and the $Null Property

Was this article helpful?
0 out Of 5 Stars
5 Stars 0%
4 Stars 0%
3 Stars 0%
2 Stars 0%
1 Stars 0%
How can we improve this article?
Table of Contents