Converting SMF Date and Time Formats - 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

You can convert SMF date and time formats to standard date and time formats. The following table shows the SMF formats and the converted output:

Table 1. SMF Formats and Converted Output

SMF Format 

Converted Output

DT1

   Z'yyyymmdd'

DT2

Z'yyyymm'

DT3

Z'yyyyddd'

TM1

Z'hhmmss'

TM2

   Z'hhmm'

TM3

   Z'hh'

TM4

   Z'hhmmssxx'

For DTn, the source is the 4-byte packed SMF date value (P'cyyddd'). For TMn, the source is a 4-byte binary SMF time value.

The c in the date source P'cyyddd' represents the century. It is converted as follows: 0 is converted to 19, 1 is converted to 20, and 2 or greater is converted to 21.

The converted output is a zoned decimal field, where each character in the table represents a single byte. For TM4, xx represents hundredths of a second.

The MFX predefined edit masks (M0-M26) or specified edit patterns can be used to edit the converted date and time. The default mask is M11.

Note: A data exception (0C7 ABEND) or an inaccurate ZD date can occur if an SMF date is not valid. An inaccurate ZD time can occur if an SMF time is not valid. SMF dates and times are processed as positive values.

For an example of an OUTREC control statement that converts SMF formats, see figure Sample OUTREC Control Statement.