Variable Data Fields › User-Defined Data Field Names

User-Defined Data Field Names

Purpose

User-defined data field names specify variable data fields in subschema records, map work records, or dialog work records.

User-defined data fields can be used as both source and target fields in process commands.

Syntax

►►──────┬─ + ◄ ┬─── data-field-name ──────────────────────────────────────────►
        └─ - ──┘

 ►─┬──────────────────────────────────────────────────────┬───────────────────►
   └┬─ OF ─┬───┬─ sql-table-name ───────────────────────┬─┘
    └─ IN ─┘   ├─ lr-name ────────────────────────────┬─┘
               └┬─ record-name ─┬─┬───────────────────┤
                └─ role-name ───┘ └┬─ OF ─┬─ lr-name ─┘
                                   └─ IN ─┘

 ►──────┬────────────────────────────┬────────────────────────────────────────►◄
        │      ┌────── , ───────┐    │
        └── (-─▼─── subscript ──┴─)-─┘

Parameters

+/–

Specifies the unary operator to precede a numeric data field.

A plus sign (+) does not change the sign of the data field.

A minus sign (-) multiplies the data field by -1.

+ is the default when neither + or - is specified.

A unary operator can be used when the data field is specified as part of an arithmetic expression.

data-field-name

Specifies the 1- to 32-character name of a variable data field.

Data-field-name must begin with an alphabetic, national (@, #, and $), or numeric character. This field can specify a record or role name where logically appropriate. The named record or role is treated as a group field.

OF

Introduces record-name, role-name, or lr-name.

IN can be used in place of OF.

sql-table-name

Specifies the name of the SQL table that contains the fields referenced by data-field-name, when the SQL schema name has been entered in the ADSC Records and Tables screen.

record-name

Specifies the name of the record that contains the fields referenced by data-field-name.

role-name

Specifies the name of the role that contains the fields referenced by data-field-name.

lr-name

Specifies the name of the logical record that contains the fields referenced by data-field-name.

Record-name, role-name, or lr-name is required if the named field is not unique among the records and roles known to the dialog. The reference to the data field must be unambiguous. For example, if the named field participates in a role, then reference to the field always requires qualification by record or role name. Further qualification of record-name or role-name with lr-name may also be necessary.

subscript

Specifies an arithmetic expression, variable data field, or numeric literal that indicates the value of each subscript required to reference a specific occurrence of the field that is referenced by data-field-name.

Subscript applies only if the named field is defined as a multiply-occurring field.

Example

The following example illustrates a data field name used with a MOVE command to specify a nonunique subscripted field:

MOVE CUSTOMER-NUMBER OF CUST-ACC-REC (3) TO CUSTORDR.

More information:

Records and Tables Screen