Portal | IBM Manuals | Downloads | Products | Refer | Info | Programs | JCLs | Forum Rules*| Site Map | Mainframe CD 
IBMMAINFRAMES.com - IBM Mainframe Support Forums Index
 
Register
 
IBMMAINFRAMES.com - IBM Mainframe Support Forums Index FAQ Search Memberlist Usergroups Profile Log in to check your private messages Log in
 
reformatting using DFSORT

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DFSORT/ICETOOL
Author Message
pjnithin

Active User


Joined: 22 Dec 2005
Posts: 99
PostPosted: Mon May 12, 2008 12:45 pm    Post subject: reformatting using DFSORT
 Reply with quote
I have a file like this.

Code:

Emp Id    Seq No.      Status      Sorid
1              1            a         AB
1              2            r         BC
1              3            a         CD
1              4            r         DE
2              1            a         AB
2              2            r         BC
2              3            a         CD
2              4            a         DE



I need the output like

Code:

1              3            a         CD
2              4            a         DE


That means I need the employee id records with status 'a' and of maximum sequence number. Can this be achieved using DFSORT.
Back to top
View user's profile Send private message
References
PostPosted: Mon May 12, 2008 12:45 pm    Post subject: Re: reformatting using DFSORT Reply with quote
Frank Yaeger

DFSORT Moderator


Joined: 15 Feb 2005
Posts: 3972
Location: San Jose, CA
PostPosted: Mon May 12, 2008 9:07 pm    Post subject:
Reply with quote
You can use a DFSORT/ICETOOL job like the following to do what you asked for:

Code:

//S1    EXEC  PGM=ICETOOL
//TOOLMSG DD SYSOUT=*
//DFSMSG  DD SYSOUT=*
//IN DD *
1              1            a         AB
1              2            r         BC
1              3            a         CD
1              4            r         DE
2              1            a         AB
2              2            r         BC
2              3            a         CD
2              4            a         DE
/*
//OUT DD SYSOUT=*
//TOOLIN DD *
SELECT FROM(IN) TO(OUT) ON(1,1,CH) FIRST USING(CTL1)
/*
//CTL1CNTL DD *
  INCLUDE COND=(29,1,CH,EQ,C'a')
  SORT FIELDS=(1,1,CH,A,16,1,ZD,D)
/*
Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DFSORT/ICETOOL All times are GMT + 6 Hours
Page 1 of 1