A multiple value field that occurs within a periodic group may be specified with its name or by specifying the periodic group name. If you specifies a name of a periodic group that contains multiple values, the record buffer definition will be as for a regular periodic group with occurrences for the multiple values, as well. For example:

The record buffer definition is:

If you specify the name of the multiple value field, Adabas Pre-Compiler takes the occurrence number of both the multiple value and the periodic group from Predict. The multiple value field will be declared with level 3, while in level 2 the same field name will be declared having a prefix of "A-." For example:

The record buffer definition is:

If you wish to specify a certain range of the multiple value or a certain occurrence, add it to the field name with parenthesis. In this case, if the range does not start from the first occurrence, the field name in the record buffer will have an additional suffix of the range or the occurrence and the field in level 2 will have the same suffix.

If you wish to specify a certain range of the periodic group or a certain occurrence, specify the occurrences of the multiple value, as well.

The valid formats of using multiple value fields within a periodic group are:

MP specifies range of occurrences of the multiple value within each of a range of occurrences of the periodic group. The occurrences of both multiple value and periodic group are taken from Predict as in the above examples.

MP(i) specifies a single occurrence of the multiple value within each of a range of occurrences of the periodic group. The occurrence number is represented by "I" and the range of occurrences of the periodic group is taken from Predict. The field name in the record buffer will have an additional suffix of "-" and the occurrence number. The same additional suffix will apply to the field in level 2. For example:

The record buffer definition is:

MP(i-j) specifies a range of occurrences of the multiple value within each of a range of occurrences of the periodic group. The range of the multiple value is represented by "i"-"j" and the range of the periodic group is taken from Predict. If the range of the multiple value does not start from the first occurrence, the field name in the record buffer will have an additional suffix of "-" followed by the range. The same additional suffix will apply to the field in level 2. For example:

The record buffer definition is:

MP(var) specifies a single occurrence of the multiple value within each of a range of occurrences of the periodic group.

The occurrence number is not fixed and is represented by a user-variable name, that should contain a numeric value at execution time. The range of the periodic group is taken from Predict.

The field name in the record buffer will not have any additional suffix and it may appear only once in a declaration. For example:

The record buffer definition is:

The MCINDEX user-variable should contain the occurrence number before the read or update command.

MP(LAST) specifies the last occurrence of the multiple value within each of a range of occurrences of the periodic group. The range of occurrences of the periodic group is taken from Predict. Adabas returns the last occurrence of the multiple value for each occurrence of the periodic group in every record. The field name in the Record buffer will not have any additional suffix. This format is valid only for retrieval commands. For example:

The record buffer definition is:

MP(i(k)) specifies a single occurrence of the multiple value within a single occurrence of the periodic group. The occurrence of the multiple value is represented by "k". The field name in the record buffer representing the multiple value will have an additional suffix of "-" followed by the occurrence number "k". In level 2. the additional suffix will be "-" followed by the periodic group occurrence "i." For example:

The record buffer definition is:

MP(i(k-1)) specifies a range of occurrences of the multiple value within the "i-"position occurrence of the periodic group. The range of occurrences of the multiple value is represented by "k"-"l."

The field name in the record buffer representing the periodic group (level 2) will have an additional suffix of "-" followed by "i." If the range of occurrences of the multiple value does not start from the first occurrence, the field name in the record buffer will have an additional suffix of "-" followed by the range. For example:

The record buffer definition is:

MP(i(var)) specifies a single occurrence of the multiple value within the "i-"position occurrence of the periodic group. The occurrence number is not fixed and is represented by a user-variable name, that should contain a numeric value at execution time.

The field name in the record buffer representing the periodic group (level 2) will have an additional suffix of "-" followed by "i" and the multiple value name will have the same additional suffix. For example:

The record buffer definition is:

The MCINDEX user-variable should contain the occurrence number before the read or update command.

MP(i(LAST)) specifies the last occurrence of the multiple value within the "i-"position occurrence of the periodic group. Adabas returns the last occurrence of the multiple value in the "i-"position occurrence of the periodic group for every record.

The field name in the record buffer representing the periodic group (level 2) will have an additional suffix of "-" followed by "I" and the multiple value name will have the same additional suffix. This format is valid only for retrieval commands. For example:

The record buffer definition is:

MP(i-j(k)) specifies a single occurrence "k" of the multiple value within each of a range of occurrences "i"-"j" of the periodic group.

The multiple value field name in the record buffer will have an additional suffix of "-" followed by "k." If the range of occurrences of the periodic group does not start from the first occurrence, the field name in the record buffer representing the periodic group (level 2) will have an additional suffix of "-" followed by the range. For example:

The record buffer definition is:

MP(i-j(k-1)) specifies a range of occurrences "k" - "l" of the multiple value within each of a range of occurrences "i" - "j" of the periodic group.

If the range of occurrence of the multiple value does not start from the first occurrence, the field name in the record buffer representing the multiple value will have an additional suffix of "-" followed by the range "k"-"l".

If the range of occurrences of the periodic group does not start from the first occurrence, the field name in the record buffer representing the periodic group will have an additional suffix of "-" followed by the range "i"-"j". For example:

The record buffer definition is:

MP(i-j(var)) specifies a single occurrence of the multiple value within each of a range of occurrences "i"-"j" of the periodic group. The multiple value occurrence number is not fixed and is represented by a user-variable name, that should contain a numeric value at execution time.

If the range of occurrences of the periodic group does not start from the first occurrence, the field name in the record buffer representing both the periodic group and the multiple value will have an additional suffix of "-" followed by the range "i"-"j". For example:

The record buffer definition is:

The MINDEX user variable should contain the occurrence number before the read or update command.

MP(i-j(LAST) specifies the last occurrences of the multiple value within each of a range of occurrences "i"-"j" of the periodic group. Adabas returns the last occurrence for every element of the periodic group in every record. This format is valid only for retrieval statements.

If the range of occurrences of the periodic group does not start from the first occurrence, the field name in the record buffer representing the periodic group (level 2) will have an additional suffix of "-" followed by the range "i"- "j". The field name in the record buffer representing the multiple value will have the same additional suffix. For example:

The record buffer definition is:

MP(var(k)) specifies a single occurrence of the multiple value within a singe occurrence of the periodic group.

The multiple value occurrence is fixed and is represented by "k." The periodic group occurrence is not fixed and is represented by a user variable name that should contain a numeric value at execution time. The field name in the record buffer representing the multiple value will have an additional suffix of "-" followed by the occurrence, while the field name representing the periodic group (level 2) will not have any additional suffix. For example:

The record buffer definition is:

The PINDEX user variable should contain the occurrence number before the read or update command.

MP(var(k-l) specifies a range of occurrences "k"-"l" of the multiple value within a single occurrence of the periodic group. The periodic group occurrence is not fixed and is represented by a user-variable name that should contain a numeric value at execution time.

If the range of occurrences of the multiple value does not start from the first occurrence, the field name in the record buffer representing the multiple value will have an additional suffix of "-" followed by the range "k"-"l". The field name representing the periodic group (level 2) will not have any additional suffix. For example:

The record buffer definition is:

The ICINDEX user variable should contain the occurrence number before the read or update command.

MP(var1(var2)) specifies a single occurrence of the multiple value within a single occurrence of the periodic group. Both occurrences are not fixed and are to be different for every record according to the user variables var1 (the periodic group) and var2 (the multiple value). Those variables should contain a numeric value at execution time. The field names in the record buffer do not have any additional suffix. For example:

The record buffer definition is:

The PINDEX and MINDEX user variables should contain the occurrence number before the read or update command.

MP(var(LAST)) specifies the last occurrence of the multiple value within a single occurrence of the periodic group. The occurrence of the periodic group is not fixed and is represented by a user variable name that should contain a numeric value at execution time. The field names in the record buffer do not have any additional suffix. This format is valid only for retrieval statements. For example:

The record buffer definition is:

The PINDEX user variable should contain the occurrence number before the read or update command.

MP(LAST(k)) specifies a single occurrence of the multiple value within the last occurrence of the periodic group. The multiple value occurrence is fixed and is represented by "k". The field name in the record buffer representing the multiple value will have an additional suffix of "-" followed by "k". The field name is the record buffer representing the periodic group will not have any additional suffix. This format is valid only for retrieval statements. For example:

The record buffer definition is:

MP(LAST(k-l)) specifies a range of occurrences of the multiple value "k"-"l" in the last occurrence of the periodic group. Adabas returns the last occurrence in every record. This format is valid only for retrieval statements.

If the range of occurrences of the multiple value does not start from the first occurrence, then the field name in the record buffer representing the multiple value will have an additional suffix of "-" followed by the range. For example:

The record buffer definition is:

MP(LAST(var)) specifies a single occurrence of the multiple value within the last occurrence of the periodic group. The occurrence of the multiple value is not fixed and is represented by a user variable name, that should contain a numeric value at execution time. The field names in the record buffer will not have any additional suffix.

This format is valid only for retrieval statements. For example:

The record buffer definition is:

The MINDEX user variable should contain the occurrence number before the read or update command.

MP(LAST(LAST)) specifies the last occurrence of the multiple value within the last occurrence of the periodic group in every record. This format is valid only for retrieval statements. The field names in the record buffer will not have any additional suffix. For example:

The record buffer definition is:

MP(i(k-LAST)) specifies a range occurrences from "k" till the last occurrence of the multiple value within the "i-"position occurrence of the periodic group.

This format is valid only as the last item in the field expressions and only for retrieval statements. Actually Adabas Pre-Compiler will generate the range of occurrences until the 191st occurrence but Adabas will fill it only until the last occurrence exists for that occurrence of the periodic group.

The field name in the record buffer representing the periodic group (level 2) will have an additional suffix of "-" followed by "i". If the range of occurrences of the multiple value does not start from the first occurrence then the field name in the record buffer representing the multiple value will have an additional suffix of "-" followed by "k" followed by "-191". For example:

The record buffer definition is:

MP(var(k-LAST)) specifies a range of occurrences from "k" till the last occurrence of the multiple value within a single occurrence of the periodic group. The occurrence of the periodic group is not fixed and is represented by a user variable name that should contain a numeric value at execution time. This format is valid only as the last item in the field expressions and only for retrieval statements.

Adabas Pre-Compiler will generate the range of occurrences until the 191st occurrence but ADABAS will fill it only until the last occurrence exists for that occurrence of the periodic group. The field name in the record buffer representing the periodic group will not have any additional suffix. If the range of occurrences of the multiple value does not start from the first occurrence, then the field name in the record buffer representing the multiple value will have an additional suffix of "-" followed by "k" followed by "-191 ". For example:

The record buffer definition is:

The ICINDEX user variable should contain the occurrence number before the read or update command.

MP(LAST(k-LAST)) specifies a range of occurrences from "k" to the last occurrence of the multiple value within the last occurrence of the periodic group. This format is valid only as the last item in the field expression and only for retrieval statements.

Actually Adabas Pre-Compiler will generate the range of occurrences until the 191st but ADABAS will fill it only until the last occurrence exists for the last occurrence of the periodic group. The field name in the record buffer representing the periodic group will not have any additional suffix. If the range of occurrences of the multiple value does not start from the first occurrence, then the field name in the record buffer representing the multiple value will have an additional suffix of "-" followed by "k" followed by "-191". For example:

The record buffer definition is:

MP(COUNTi), MP(COUNTi-j) specify the count of the multiple value within a specific occurrence of the periodic group or a range of occurrences of the periodic group. For every occurrence of the periodic group there is a count of the multiple value and the user may request the count of a specific occurrence or a range of occurrences. Adabas Pre-Compiler will generate a separate field for every count requested. In case of a range of counts, Adabas Pre-Compiler will generate a list of separate fields.

The field name in the record buffer will be the multiple value name with a prefix of "C- " and an additional suffix of "-" followed by the periodic group occurrence number. Forexample:

The record buffer definition is:

MP(COUNTLAST) specifies the count of the multiple value within the last occurrence of the periodic group. The field name in the record buffer will not have any additional suffix. For example:

The record buffer definition is: