Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

Sort records by keeping order intact.

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> JCL & VSAM
View previous topic :: :: View next topic  
Author Message
ramsri

Active User


Joined: 18 Oct 2008
Posts: 380
Location: India

PostPosted: Sun Jan 17, 2010 7:51 pm    Post subject: Sort records by keeping order intact.
Reply with quote

Hi

My input (RECFM=FB, LRECL=34) appears as shown below:

Code:

----+----1----+----2----+----3----+
0187               XONTROP
0187               ZBASEON+BASETO+
0159               XONYLKM
0159               ZBASEZK+BASEMO+
0112               XONFAIL
0112               ZBASEFA+BASEFA+
0159               XONFALL
0159               ZBASEFL+BASEFL+
0187               XONFREE
0187               ZBASEFR+BASE11+


I need the output to be like shown below:

Code:

0112               XONFAIL
0112               ZBASEFA+BASEFA+
0159               XONYLKM
0159               ZBASEZK+BASEMO+
0159               XONFALL
0159               ZBASEFL+BASEFL+
0187               XONTROP
0187               ZBASEON+BASETO+
0187               XONFREE
0187               ZBASEFR+BASE11+


Please help.

Thanks.
Back to top
View user's profile Send private message

ramsri

Active User


Joined: 18 Oct 2008
Posts: 380
Location: India

PostPosted: Sun Jan 17, 2010 7:52 pm    Post subject: We are @Syncsort v1.3.2
Reply with quote

Sorry I missed out this.... icon_smile.gif
We are at Syncsort v1.3.2.

Thanks.
Back to top
View user's profile Send private message
sril.krishy

Active User


Joined: 30 Jul 2005
Posts: 183
Location: hyderabad

PostPosted: Sun Jan 17, 2010 11:35 pm    Post subject: Reply to: Sort records by keeping order intact.
Reply with quote

ramsri,
try this sort card.

Code:

 SORT FIELDS=(1,4,CH,A),EQUALS

 


Thanks
Krishy
Back to top
View user's profile Send private message
ramsri

Active User


Joined: 18 Oct 2008
Posts: 380
Location: India

PostPosted: Mon Jan 18, 2010 9:37 pm    Post subject: Reply to: Sort records by keeping order intact.
Reply with quote

Hi,

Thanks.

How to change sort card if the i/p data has headers and trailers?

Input:
Code:

----+----1----+----2----+----3----+
HDR
0187               XONTROP
0187               ZBASEON+BASETO+
0159               XONYLKM
0159               ZBASEZK+BASEMO+
TLR
HDR
0112               XONFAIL
0112               ZBASEFA+BASEFA+
0159               XONFALL
0159               ZBASEFL+BASEFL+
0187               XONFREE
0187               ZBASEFR+BASE11+
TLR


Output:
Code:

----+----1----+----2----+----3----+
HDR
0159               XONYLKM
0159               ZBASEZK+BASEMO+
0187               XONTROP
0187               ZBASEON+BASETO+
TLR
HDR
0112               XONFAIL
0112               ZBASEFA+BASEFA+
0159               XONFALL
0159               ZBASEFL+BASEFL+
0187               XONFREE
0187               ZBASEFR+BASE11+
TLR


Thanks.
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> JCL & VSAM All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts SORT to unpack a feild shr_amar DFSORT/ICETOOL 7 Fri Jul 07, 2017 4:32 am
No new posts How to write Specific Fields from Mul... Padhu SYNCSORT 6 Thu Jul 06, 2017 10:26 am
No new posts Optimize sort inrec parse vishwakotin DFSORT/ICETOOL 6 Mon Jun 26, 2017 11:15 pm
No new posts Reduce CPU Times for Join Sort santoshn SYNCSORT 12 Sat Jun 10, 2017 1:40 pm
No new posts Db2 load job abending in SORT mistah kurtz DB2 4 Mon Jun 05, 2017 3:58 pm


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us