This property sets the method for processing the records with the equal key field.
Syntax
object.HandlingSameKey = integer
object
This specifies object expressions that define references to objects.
integer
This property sets the method for processing the records with the equal key field. As for values to be set, refer to the following setting value.
Setting value
Setting values of the HandlingSameKey property are as follows.
Setting value | Meaning |
|---|---|
0 | This processes the data in the irregular order. (Default value) |
1 | This decides the output order according to the first-in first-out option. |
2 | This deletes records by the suppression option. |
3 | This sets the record summation option. |
Description
This specifies method for outputting the record when 2 or more records with the equal key field exist.
When the specification is omitted or 0 is set, the order of outputting the records with the equal key field is irregular.
When 1 is set, 2 or more records with the equal key field are output in order of the input. It is effective in the sort option.
When 2 is set, only 1 record out of the 2 or more records with the equal key field is kept and others are deleted. The records that are output have the key field with the different value. Out of the 2 or more records with the equal key fields, the records that remain are irregular and cannot be specified. It is effective in the sort option or merge option.
When 3 is set, values of the summation field with 2 or more records with the equal key fields are added and make one record. In this case, it is necessary to specify the summation field in the SumCmdStr property. It is valid in the sort option or merge option.
Note
When the first-in first-out (FIFO) option is specified in the Micro Focus COBOL indexed file, the priority level is decided in physical order rather than in the order of the indexes.
