Specifying Format (f) in Field_name Dictionary Statements - 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
Topic type
How Do I
Copyright
2024
First publish date
2010
Last edition
2024-08-27
Last publish date
2024-08-27T08:14:56.318001

Following are the rules for specifying format (f) in field_name dictionary statements:

  • f can be any of the following formats:

AC, AQ, ASL, AST, BI, CH, CLO, CSF, CSL, CST, CTO, D1, D2, DC1, DC2, DC3, DE1, DE2, DE3, DT1, DT2, DT3, FI, FL, FS, LS, OL, OT, PD, PD0, SFF, SS, TC1, TC2, TC3, TC4, TE1, TE2, TE3, TE4, TM1, TM2, TM3, TM4, TS, UFF, Y2B, Y2C, Y2D, Y2DP, Y2P, Y2PP, Y2S, Y2T, Y2TP, Y2U, Y2UP, Y2V, Y2VP, Y2W, Y2WP, Y2X, Y2XP, Y2Y, Y2YP, Y2Z, ZD

Formats can be specified using uppercase, lowercase, or mixed case letters.

When either p or l is specified in the bit form (m.n) and the bit number is not zero (n ≠ 0), then the only valid format is BI.

  • f can be an equal sign (=) which indicates that the previous format should be assigned to f. If the previous format has not yet been determined when an = sign is used for f, MFX generates an error message.

    Note that use of = for f can result in incorrect format values if fields are inserted at some later date.

If the dictionary table is printed, it will display the actual formats MFX substituted for =. For example, consider the following dictionary statements:

Figure 1. Sample Dictionary Statements

After processing, the following substitutions will be reflected in the dictionary table:

Figure 2. Sample Dictionary Table