Sort & Extract from variable length file

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

I have a variable length file - length = 6229.
I need to
(a) SORT the 7 bytes from 9th position(for VB added 4 hence 13,7)
(b) Include condition is also correct (all positions have 4 added to them)

Problem: Since the file has many records with length < 400, hence my INCLUDE statement gives error. I am able to do this is 2 steps by breaking the include conditions into two parts.
Can it be done in a single step?

SORT FIELDS=(13,7,CH,A)
SUM FIELDS=NONE
INCLUDE COND=((176,10,CH,EQ,C'ABCDEFGHIJ'),AND,
(476,1,CH,EQ,C'W'),AND,
(230,1,CH,NE,C' '))

William Thompson · Posted: Tue Feb 20, 2007 1:43 am

What would the condition be for records that are shorter than the 479 cond? Will the record get shorter than the 230 cond? The 176 cond?

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

no only the 476 condition is failing

Frank Yaeger · Posted: Tue Feb 20, 2007 2:12 am

You need to use DFSORT's VLSCMP option to handle the "short records" INCLUDE fields:

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

Thanks Frank...it is working now.