Record Description - 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

Information about the record created by the query will be displayed in the MFX message data set. For each column selected, the report will display the start and end position within the record, the DB2 data type, the equivalent MFX data type, and whether null values are allowed. A data type whose length is not implied by the format will have a field length appended to its description. Note that the length displayed for a VARCHAR DB2 data type is two bytes shorter than would be indicated by the field start and end positions. The extra two bytes described in the start and end positions are for the field length descriptor, which is contained in the first two bytes of the field.