View previous topic :: View next topic
Author
Message
Kumar Saraboji New User Joined: 15 Sep 2009Posts: 8 Location: India
I have the following in input file (LRECL=20,RECFM=FB)
Acct No(1-8) Sequence No(10-12,Format Type=ZD)
AAAAAAAA 001
AAAAAAAB 002
AAAAAAAC 003
AAAAAAAD 004
AAAAAAAE 005
I need an output like below (LRECL=20,RECFM=FB) using DFSORT/ICETOOL
Acct No(1-8) Sequence No(10-12) Type(14-17)
AAAAAAAA 001 ODD
AAAAAAAB 002 EVEN
AAAAAAAC 003 ODD
AAAAAAAD 004 EVEN
AAAAAAAE 005 ODD
I have achieved the above output with the help of FILEAID bach,
(
$$DD01 COPY IF=(12,EQ,B'01'),MOVE=(C'ODD',14)
COPY IF=(12,EQ,B'00'),MOVE=(C'EVEN',14)
)
but not sure how to get it done with DFSORT/ICETOOL. Can any one of you help me out. Many thanks in advance
Back to top
gcicchet Senior Member Joined: 28 Jul 2006Posts: 1702 Location: Australia
Hi,
this might assist
Code:
//STEP0100 EXEC PGM=SORT
//SYSOUT DD SYSOUT=*
//SORTIN DD *
AAAAAAAA 001
AAAAAAAB 002
AAAAAAAC 003
AAAAAAAD 004
AAAAAAAE 005
//SORTOUT DD SYSOUT=*
//SYSIN DD *
SORT FIELDS=COPY
INREC IFTHEN=(WHEN=(12,1,CH,EQ,C'1'),OVERLAY=(14:C'ODD ')),
IFTHEN=(WHEN=(12,1,CH,EQ,C'3'),OVERLAY=(14:C'ODD ')),
IFTHEN=(WHEN=(12,1,CH,EQ,C'5'),OVERLAY=(14:C'ODD ')),
IFTHEN=(WHEN=(12,1,CH,EQ,C'7'),OVERLAY=(14:C'ODD ')),
IFTHEN=(WHEN=(12,1,CH,EQ,C'9'),OVERLAY=(14:C'ODD ')),
IFTHEN=(WHEN=NONE,OVERLAY=(14:C'EVEN'))
/*
Gerry
Back to top
gcicchet Senior Member Joined: 28 Jul 2006Posts: 1702 Location: Australia
Hi,
or like this
Code:
SORT FIELDS=COPY
INREC IFTHEN=(WHEN=(12,1,SS,EQ,C'1,3,5,7,9'),
OVERLAY=(14:C'ODD ')),
IFTHEN=(WHEN=NONE,OVERLAY=(14:C'EVEN'))
Gerry
Back to top
Kumar Saraboji New User Joined: 15 Sep 2009Posts: 8 Location: India
Hi Gerry,
Woov.....! Thanks a lot for the solution.
Regards,
Kumar
Back to top
Frank Yaeger DFSORT Developer Joined: 15 Feb 2005Posts: 7129 Location: San Jose, CA
Kumar,
You can use a bit test with DFSORT as you did with FileAid.
Code:
OPTION COPY
INREC IFTHEN=(WHEN=(12,1,BI,EQ,B'.......1'),OVERLAY=(14:C'ODD')),
IFTHEN=(WHEN=NONE,OVERLAY=(14:C'EVEN'))
Back to top
Kumar Saraboji New User Joined: 15 Sep 2009Posts: 8 Location: India
Thanks a lot Frank for the solution, from bit wise point of view. It is simply great! replying to the developer of DFSORT/ICETOOL
Back to top
Please enable JavaScript!