Welcome to jBASE's new documentation site! Many answers to your questions can be found by searching the Knowledgebase or viewing the jBASE Documentation. We also have a Google Group for peer discussion about jBASE. If you are unable to find the information you are looking for, jBASE Support will be glad to assist in resolving your technical problems. Enjoy and please provide comments and feedback .

How can we help you?

N (Field Name) Operand

Description 

References another field defined by name in the same dictionary or found in one of the default dictionaries. It takes the general form: 

N(field-name){R{R}}

 where: 

  • field-name is the name of another field defined in the same dictionary or found in the list of default dictionaries (see the JBCDEFDICTS environment variable).
  • R specifies that the value obtained from this field is to be applied repeatedly for each multivalue not present in a corresponding part of the calculation.
  • RR specifies that the value obtained from this field is to be applied repeatedly for each subvalue not present in a corresponding part of the calculation.


Any pre-process conversion codes in the specified field-name, including any further N(field-name) constructs are processed as part of the conversion code. N(field-name) constructs can be nested to 30 levels. The number of levels is restricted to prevent infinite processing loops. For example:

TEST1
008 A;N(TEST2)
TEST2
008 A;N(TEST1)

 

Note:

If the data definition record of the specified field contains field 8 pre-process conversion codes, these are applied before the value(s) are returned.

 

EXAMPLES

A;N(S.CODE)

Returns the value stored in the field defined by S.CODE.


A;N(A.VALUE) + N(B.VALUE)R

For each multivalue in the field defined by A.VALUE the system also obtains the corresponding value in B.VALUE and adds it. If A.VALUE returns 1]7 and B.VALUE returns 5, the result would be two values of 6 and 12 respectively.


A;N(A.VALUE) + N(B.VALUE)RR

For each subvalue in the field defined by A.VALUE the system also obtains the corresponding value in B.VALUE and adds it. If A.VALUE returns 1\2\3]7 and B.VALUE returns 5 the result would be four values of 6, 7, 8 and 12 respectively.


Back to A-Corelatives

Was this article helpful?