DFSORT: difference in comp-3 field format

kalukakkad · New User Joined: 10 Mar 2005 Posts: 81

in DFSORT is there any difference between the two formats. I am trying to remove records with packed decimal field <= 10.00

Comp-3 Field : position=508, length=6 defined as S9(09)V9(02) COMP-3

SORT FIELDS=COPY
OMIT COND=(508,6,PD,LE,10,AND,
36,2,CH,EQ,C'15')

and

SORT FIELDS=COPY
OMIT COND=(508,6,PD,LE,+10.00,AND,
36,2,CH,EQ,C'15')

Frank Yaeger · Posted: Thu Nov 23, 2006 3:16 am

508,6,PD,LE,10 won't work and 508,PD,LE,+10.00 is invalid. What you need is this DFSORT OMIT statement:

kalukakkad · New User Joined: 10 Mar 2005 Posts: 81

Thanks Frank for the quick reply. It works now. Thanks for your help.