Copyright © TIBCO Software Inc. All Rights Reserved
Copyright © TIBCO Software Inc. All Rights Reserved


Chapter 11 Null Processing : Manipulation of Nulls

Manipulation of Nulls
Allowable Manipulation
Nulls can only be manipulated logically. They cannot be manipulated arithmetically. Attempts to add, subtract, multiply, divide, and so on, result in the NULLVALUE exception.
Logical Manipulation
Nulls can be manipulated through the use of the reserved word NULL, which represents a null value. The following table describes where the keyword NULL can be used and the syntax that each context requires:
Restrictions
The reserved word NULL cannot be used:

Copyright © TIBCO Software Inc. All Rights Reserved
Copyright © TIBCO Software Inc. All Rights Reserved