SET NULLVALUE
Welcome to our Knowledge Base
Documentation | Blog | Demos | Support
< All Topics
Print
SET NULLVALUE
0 out of 5 stars
| 5 Stars | 0% | |
| 4 Stars | 0% | |
| 3 Stars | 0% | |
| 2 Stars | 0% | |
| 1 Stars | 0% |
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
Updated
ByJason Lee
Was this article helpful?
0 out of 5 stars
| 5 Stars | 0% | |
| 4 Stars | 0% | |
| 3 Stars | 0% | |
| 2 Stars | 0% | |
| 1 Stars | 0% |
5
Portuguese 
English