Mm Subparameter (Editing Masks) - mfx - 3.1

Syncsort™ MFX Programmers Guide

Product type
Software
Portfolio
Integrate
Product family
Syncsort™ Software
Product
Syncsort™ MFX > MFX
Version
3.1
Language
English
Content type
Programmer’s Guide
Product name
Syncsort™ MFX
Title
Syncsort™ MFX Programmers Guide
Copyright
2024
First publish date
2010
Last updated
2024-08-27
Published on
2024-08-27T08:14:56.318001

MFX provides editing masks to simplify the more common editing operations.

Table 1. Editing Masks

Mask

Pattern

Signs

Length

M0

IIIIIIIIIIIIIITS

(,,' ',-)

d+1

M1

TTTTTTTTTTTTTTTS

(,,' ',-)

d+1

M2

I,III,III,III,IIT.TTS

(,,' ',-)

d+1 + [d/3]

M3

I,III,III,III,IIT.TTCR

 

d+2 + [d/3]

M4

SI,III,III,III,IIT.TT

(+,-)

d+1 + [d/3]

M5

SI,III,III,III,IIT.TTS

(' ',(,' ',))

d+2 + [d/3]

M6

III-TTT-TTTT

 

12

M7

TTT-TT-TTTT

 

11

M8

IT:TT:TT

 

8

M9

IT/TT/TT

 

8

M10

IIIIIIIIIIIIIIT

 

d

M11

TTTTTTTTTTTTTTT

 

d

M12

SIII,III,III,III,IIT

(' ',-)

d+1 + [(d-1)/3]

M13

SIII.III.III.III.IIT

(' ',-)

d+1 + [(d-1)/3]

M14

SIII III III III IITS

(' ',(,' ',))

d+2 + [(d-1)/3]

M15

III III III III IITS

(,,' ',-)

d+1 + [(d-1)/3]

M16

SIII III III III IIT

(' ',-)

d+1 + [(d-1)/3]

M17

SIII'III'III'III'IIT

(' ',-)

d+1 + [(d-1)/3]

M18

SI,III,III,III,IIT.TT

(' ',-)

d+1 + [d/3]

M19

SI.III.III.III.IIT,TT

(' ',-)

d+1 + [d/3]

M20

SI III III III IIT,TTS

(' ',(,' ',))

d+2 + [d/3]

M21

I III III III IIT,TTS

(,,' ',-)

d+1 + [d/3]

M22

SI III III III IIT,TT

(' ',-)

d+1 + [d/3]

M23

SI'III'III'III'IIT.TT

(' ',-)

d+1 + [d/3]

M24

SI'III'III'III'IIT,TT

(' ',-)

d+1 + [d/3]

M25

SIIIIIIIIIIIIIIT

(' ',-)

d+1

M26

STTTTTTTTTTTTTTT

(+,-)

d+1

Notes:

  • If neither Mm nor EDIT is specified, M0 is used to edit BI, FI, FL, PD, PD0, ZD, and CSF/FS fields and M11 is used to edit DTn, DCn, DEn, TMn, TCn, and TEn fields.

  • The letter d represents the number of resulting digits after data conversion. The mask patterns in the Pattern column shows the resulting digits when the number of digits is 15. (See the table Data Conversion Table ). When the number of digits to be displayed is greater than 15, the masks will be extended on the left with the required digit selectors and constant characters.

  • The bracket symbols indicate that only the integer part of this division should be retained.

The table Editing Masks illustrates the following for each of the available masks.

  • Edit pattern.

  • Leading or trailing signs, where appropriate.

  • Length. If an MFX editing mask is used for totaled or subtotaled data, the length of the output field is determined from the length of the field and by using the table Output Display Lengths for TOTAL and SUBTOTAL, not by the specified length of the input field. The subparameter LENGTH can be used to override the length of the output field.

The edit patterns use the same symbolic letters used in the EDIT subparameter. Leading insignificant digits are represented by the letter I; significant digits are represented by the letter T. Leading or trailing sign replacement characters are represented by the letter S. All other characters print as they appear in the pattern.

The SIGNS illustrated for each mask follow the format requirements of the SIGNS subparameter. You can specify the SIGNS subparameter to selectively override the signs for a particular mask. For example, if you specify mask M4 and also specify SIGNS=(' '), a leading blank will print instead of a plus sign if the number is positive. However, a leading minus sign will print if the number is negative because the leading negative sign specified in the editing mask has not been overridden.

The lengths in the table represent the length, in bytes, of the mask. The lengths of masks M0-M5 and M10-M26 are determined, in part, by the number of digits d. See the table Data Conversion Table to determine the number of digits for each type of numeric field.