Specifying Field-to-Field Standard Comparisons for Non-date Fields - 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
The format of a data field determines whether or not it can be compared to another data field. This table illustrates which field-to-field comparisons are permitted.
Table 1. Permissible Field-to-Field Comparisons for Non-year Data Formats
  BI CH CSF

FS

 CSL

LS

 CST

TS

 FI PD SFF UFF ASF AUF ZD
BI X X                    
CH X X                    
CSF     X X X     X X X X  
FS                        
CSL     X X X     X X X X  
LS                        
CST     X X X     X X X X  
TS                        
FI           X            
PD             X         X
SFF     X X X     X X X X  
UFF     X X X     X X X X  
ASF     X X X     X X X X  
AUF     X X X     X X X X  
ZD             X         X
  AC AQ ASL AST CLO

OL

 CTO

OT

 PD0
AC X            
AQ   X          
ASL     X X      
AST     X X      
CLO         X X  
OL              
CTO         X X  
OT              
PD0             X