Page Comparison

The 'nullInd' method will allow pjs.nullInd() API allows you to get or set the value of a null - indicator.

Since variables in Profound.js cannot technically be 'null', we can use For strongly typed fields with the 'nullable' configuration option, a null indicator can be used to differenciate differentiate when a variable is and isn't null.

Parameters

1. Null-capable variable.field
2. Set value (OptionalBoolean, optional) Boolean. True to set the indicator to null and false vice-versa. If this parameter is passed, the Null indicator is set (true for null, false for not null); otherwise, the null indicator is simply retrieved and returned.

Return Value

...

Boolean value indicating whether the field is null

...

Examples

Example 1: Nullable field with internal null-indicator.

  pjs.define("data", { type: 'char', length: 50, varying: true });
 
pjs.define("myNumber", {  
   type: 'packed decimal',
    length: 10,
    decimals: 0,
    nullable: true 
 
});

  pjs.nullInd(myNumber, true);
 
data = pjs.nullInd(myNumber).toString();

...

  pjs.define("data", { type: 'char', length: 50, varying: true });
 
pjs.define("myBoolean", { type: 'boolean', initValue: true });
 
pjs.define("myNumber", { 
    type: 'packed decimal',
    length: 10,
    decimals: 0,

   nullable: 'myBoolean' 
  });



myBoolean = false;  // Changes %nullind(myNumber) to *Off
 
pjs.nullInd(myNumber, true);  // Changes myBoolean to *On
 
data += pjs.nullInd(myNumber).toString() + myBoolean.toString();  // data is now '11'

...