The 'nullInd' method will allow you to get or set the value of a null-indicator.
Since variables in Profound.js cannot technically be 'null', we can use a null indicator to differenciate when a variable is and isn't null.
Parameters
- Null-capable variable.
- (Optional) Boolean. True to set the indicator to null and false vice-versa.
Return Value
- True or false, true indicator that the variable 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();
Example 2: Nullable field with variable null-indicator.
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'