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 and Reformat Sequential Dataset

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DFSORT/ICETOOL
View previous topic :: :: View next topic  
Author Message
joelacs0710

New User


Joined: 30 Oct 2007
Posts: 10
Location: China

PostPosted: Wed Dec 26, 2007 12:08 pm    Post subject: Sort and Reformat Sequential Dataset
Reply with quote

HI
Is there a way we can reformat the dataset using the Sort Utility

INPUT FILE:
12345678901234567890123456789012345678901234567890

REV11000SUDHIR0000RAMESH00000000TOM 00
REV11000AADHIR0000RAMESH00000000TOM 00
REV110001ARRY 0000CHRIS 00000000SUDHIR00
REV11000HARRY 0000CHRIS 00000000SUDHIR00
REV12000CHRIS 0000TOM 00000000NICK 00
COS120001HRIS 0000TOM 00000000NICK 00
COS120002HRIS 0000TOM 00000000NICK 00
COS120003HRIS 0000TOM 00000000NICK 00
COS120004HRIS 0000TOM 00000000NICK 00

CONDITION:
IF COLUMN 1-4 = "REV1" then reformat the dataset
1-4,
6-9,
10,C' ',
11-80
Else
No Changes

OUTPUT FILE:
INPUT FILE:
12345678901234567890123456789012345678901234567890

REV1000S UDHIR0000RAMESH00000000TOM 00
REV1000A ADHIR0000RAMESH00000000TOM 00
REV10001 ARRY 0000CHRIS 00000000SUDHIR00
REV1000H ARRY 0000CHRIS 00000000SUDHIR00
REV1000C HRIS 0000TOM 00000000NICK 00
COS120001HRIS 0000TOM 00000000NICK 00
COS120002HRIS 0000TOM 00000000NICK 00
COS120003HRIS 0000TOM 00000000NICK 00
COS120004HRIS 0000TOM 00000000NICK 00
Back to top
View user's profile Send private message

abhishekmdwivedi

New User


Joined: 22 Aug 2006
Posts: 95
Location: india

PostPosted: Wed Dec 26, 2007 12:21 pm    Post subject: Reply to: Sort and Reformat Sequential Dataset
Reply with quote

This would help :


http://ibmmainframes.com/viewtopic.php?t=26782&highlight=dfsort+reformat
Back to top
View user's profile Send private message
joelacs0710

New User


Joined: 30 Oct 2007
Posts: 10
Location: China

PostPosted: Wed Dec 26, 2007 3:30 pm    Post subject:
Reply with quote

Thank you very much for the help.. the job is now working as expected..
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 -> DFSORT/ICETOOL All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Unable to catalog a gdg dataset resid... Shovan JCL & VSAM 7 Fri Mar 24, 2017 2:24 pm
No new posts Want to pull the job log into a Mainf... Jishu Mukherjee Compuware & Other Tools 9 Tue Mar 21, 2017 4:48 pm
No new posts Innovations in Your Mainframe Sort Arun Raj PC Guides & IT News 4 Wed Mar 15, 2017 10:38 pm
No new posts SORT VSAM file with each field one by... maxsubrat DFSORT/ICETOOL 6 Tue Mar 14, 2017 1:07 pm
No new posts SORT requirement sjiraga COBOL Programming 6 Thu Mar 09, 2017 9:11 pm


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