Versions Compared

Version Old Version 26 New Version 27
Changes made by

Alex Roytman

Alex Roytman

Saved on

Key

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

...

Property nameProperty typeDescription
typeString

The following data types can be specified:

  • "packed decimal" or "packed" (both variations have the same meaning)
  • "decimal" or "zoned" or "zoned decimal" or "numeric" (all variations have the same meaning)
  • "integer"
  • "unsigned integer"
  • "char"
  • "boolean"
  • "date"
  • "time"
  • "timestamp"
  • "pointer"
  • "data structure"

Some config properties only apply to certain types.

lengthNumber

Specifies the field length. It is required for most data types; exceptions are:

  • date
  • time
  • timestamp
  • pointer
  • data structure
decimalsNumber

Specifies the number of decimal positions. It required for packed and zoned fields.

varyingBooleanSpecifies that a character field is of varying length; otherwise, the field will be a fixed length field padded with spaces.
initValueString/Number/Boolean/ArraySpecified the field's initial value.
dimNumberAvailable to all data types. Using dim makes your field into an array. Arrays are 1-indexed.
orderbyorderByString

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

Use this property to create null-capable fields.

  • Pass in true to make the field null-capable. This option also allows you to assign a null value to the field.
  • Pass in a string, which references a Boolean field to use as the null-indicator and makes the field null-capable.
likeRecObject

Available when using a data structure type. This object requires two elements.

  • intrecname - String, name of record format from previously defined table.
  • fields - optional String value of "*key". If "*key" is specified, only key fields will be defined.

When likerec is specified, the data structure becomes qualified automatically.

likedslikeDSStringOnly available to the data-structure type. Provide Used on a data structure to specify the name of the another data - structure from which will be copied into the current definitionthe configuration is derived.
dataAreaString

Available to all data types, except from the pointer type. String pointing to data-area object. Example values:

  • MYDTAARA
  • PRODLIB/DTAATA
statusDSBoolean Identifies a Status Data Structure. A Status Data Structure is automatically populated with information about the current Profound.js module and job. It is an easy way to retrieve information, such as the IBM i job name, user id, etc.
Examples
Example 1: packed decimal

...