This property sets the summation field of the sort processing and merge processing.
Syntax
object.SumCmdStr = string
object
This specifies object expressions that define references to objects.
string
This specifies the summation field according to the format.
Format
pos.len typ [ pos.len typ ...]
pos
This specifies positions of the summation fields. The data is calculated making the head of the record to be 0. When the input is based in text files, the floating field or a fixed field is specified according to the value specified in the FieldDefinition property. When the input is based in files other than text files, fixed field is always specified. The field number is specified for the floating field and the column position is specified for the fixed field.
len
This specifies the length of the summation field after period (.).
When the data is processed in the text file as the floating field, the summation result is processed in the specified field length. If a longer field than the specified field length appears, the portion of the specified field length from the left end in the number is valid. On the contrary, when the actual field length is shorter than the specified field length, the portion of the actual field length is valid.
typ
This specifies the data format of the summation field after len. For more information, refer to the 1.6.4.2 Data formats that can be specified in the summation field.
Description
The summation fields with 2 or more records that have the same key fields are added and summated into 1 record.
When the record summation option is used, it is necessary to specify SumCmdStr property, and to set 3 (record summation) to HandlingSameKey property.
When you specify 2 or more summation fields, specify the summation fields successively or delimit them by comma (,).
Specify the record in the input record when you specify the summation field. Specify positions and length to make them less than the minimum record length in the file for the text file and the file of the variable-length record format.
Example
The field in 10 bytes from 20th byte of the input record of external decimal number is summated.
19.10zdl
The field in external decimal number in 10 bytes from the 10th byte of the input record and fixed point binary number in 8 bytes from the 30th byte are summated.
9.10zdl29.8fbi
