Versions Compared

Version Old Version 12 New Version 13
Changes made by

Former user

Former user

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Element nameElement typeDescription
typeString

There are the following types available in Profound.js

  • packed decimal
  • decimal
  • integer
  • unsigned integer
  • char
  • boolean
  • date
  • time
  • timestamp
  • pointer
  • data-structure

Some config elements only apply to certain types.

lengthNumber

Required on all types other than

  • date
  • time
  • timestamp
  • pointer
decimalsNumber

Required on types

  • Packed decimal
  • Decimal
varyingBooleanAvailable to char type.
initValueString/Number/BooleanAvailable to all data types.
dimNumberAvailable to all data types. Using dim makes your field into an array. Arrays are 1-indexed.
orderbyString

Available to all types when dim element is used. Either of these values are required:

  • "ASCEND"
  • "DESCEND"
elementsObjectRequired when using data-structure type. Read about data-structures below.
qualifiedBooleanAvailable when using data-structure type.
specialString

Available to data-structure subfields. Acceptable values are:

PSDS

  • "*status"
  • "*proc"
  • "*parm"
  • "*routine"

INFDS

  • "*file"
  • "*record"
  • "*opcode"
  • "*status"
  •  "*routine" 
nullableBoolean / String

Available to all data types, except from the data-structure type. Only use this attribute if you this field to be null-capable.

  • Pass in "true" to make the field null-capable. This option also allows you to assign 'null' to the field and allow null to be returned when referencing the field.
  • Pass in a "string" which references an Boolean variable to use that as the null-indicator and making the field null-capable.
Examples
Example 1: packed decimal

...

Code Block
languagejavascript
pjs.define("dsarr", { type: 'data structure', qualified: true, dim: 2, elements: {
  "field1": { type: 'char', length: 1 },
  "field2": { type: 'char', length: 1 }
}});
 
dsarr[1].field1 = '1';
dsarr[1].field2 = '2';
dsarr[2].field1 = '3';
dsarr[2].field2 = '4';
Example 7: Null-capable field with null assignment
Code Block
languagejavascript
pjs.define("myNumber", { 
  type: 'packed decimal',
  length: 10,
  decimals: 0,
  nullable: true 
});


//Set value to 5
myNumber = 5;

//Set null-indicator to true
myNumber = null;

//Set value to 10, sets the null-indicator to false
myNumber = 10;

//Set null-indicator to true
pjs.nullInd(myNumber, true);