IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

How can I reverse the records in a file - lst rec 1st
IBM Mainframe Forums -> DFSORT/ICETOOL
Post new topic   Reply to topic Quick References
View previous topic :: View next topic  
Author Message
manugeorge2004

New User


Joined: 17 Jun 2009
Posts: 38
Location: Denver
PostPosted: Tue Nov 03, 2009 5:06 am
 Reply with quote
Hi

I have a flat file with a bunch of records.
I just need to reverse the order of records.
The last record should come first and first record should come last.
I dont have any specific condition for sort

Your help is appreciated

Manu
Back to top
View user's profile Send private message
Skolusu

Senior Member


Joined: 07 Dec 2007
Posts: 2205
Location: San Jose
PostPosted: Tue Nov 03, 2009 5:11 am
 Reply with quote
manugeorge2004,

Try this DFSORT JCL

Code:

//STEP0100 EXEC PGM=SORT               
//SYSOUT   DD SYSOUT=*                 
//SORTIN   DD *                       
RECORD # 01                           
RECORD # 02                           
RECORD # 03                           
RECORD # 04                           
RECORD # 05                           
RECORD # 06                           
RECORD # 07                           
RECORD # 08                           
RECORD # 09                           
RECORD # 10                           
//SORTOUT  DD SYSOUT=*                 
//SYSIN    DD *                       
  INREC OVERLAY=(81:SEQNUM,8,ZD)       
  SORT FIELDS=(81,8,CH,D)             
  OUTREC BUILD=(1,80)                 
/*
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic View Bookmarks
All times are GMT + 6 Hours
Forum Index -> DFSORT/ICETOOL

 

Similar Topics
Topic Forum Replies
No new posts Extract the file name from another fi... DFSORT/ICETOOL 6
No new posts How to split large record length file... DFSORT/ICETOOL 10
No new posts Extracting Variable decimal numbers f... DFSORT/ICETOOL 17
No new posts SFTP Issue - destination file record ... All Other Mainframe Topics 2
No new posts Access to non cataloged VSAM file JCL & VSAM 18
Search our Forums:

Back to Top
IBMMainframes.com is not an official and/or affiliated with IBM® in anyway
Board Rules | FAQ | Downloads | Wiki | SiteMap | Contact Us