Portal | Manuals | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist 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 Copy 4 byte of data from the last rec... arunsoods DFSORT/ICETOOL 9 Fri Oct 06, 2017 12:15 pm
No new posts sort records based on length exceeds ... maxsubrat DFSORT/ICETOOL 7 Wed Oct 04, 2017 4:48 pm
No new posts opening a dataset after reading it fr... arunsoods DFSORT/ICETOOL 5 Wed Oct 04, 2017 3:54 pm
No new posts JOINKEYS Paired and Unpaired Sort MFwhiz DFSORT/ICETOOL 4 Fri Sep 29, 2017 1:48 am
No new posts Difference in SORT & ICETOOL Mohan Kothakota DFSORT/ICETOOL 5 Fri Sep 22, 2017 4:56 pm

Facebook
Back to Top
 
Job Vacancies | Forum Rules | Bookmarks | Subscriptions | FAQ | Polls | Contact Us