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


Chapter 11 Null Processing : TIBCO Object Service Broker Nulls

TIBCO Object Service Broker Nulls
What is a Null Value?
A null represents data of no value. A null value occurs because no data exists in a field, or data of no value is explicitly assigned to a field. In TIBCO Object Service Broker, null has a value less than any other value.
Syntax and Behavior of Nulls
As with all other types of data, a null can assume either a character or numeric syntax. A field that is defined with a syntax of C, UN, V, or W holds a character null. A field that is defined with a syntax of B, P, or F holds a numeric null. The behavior of nulls is determined by their syntax and whether the data is character or numeric. A null field of syntax RD can act as either one.
The syntax within which a null is being used determines how the null value is processed:
When an RD null is used as a character syntax, it acts as a character null; when it is used as a number syntax, it acts as a numeric null.
In TIBCO Object Service Broker, the keyword NULL represents a null value of syntax B.
How Can A Field Contain Null Values?
There are three ways that a field can contain a null value:
An occurrence is inserted or replaced into a table and the field is assigned the keyword NULL or an empty string ('') and no default value is specified.

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