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 Where to get sample for processing RM... vice_versa PL/I & Assembler 2 Tue Jan 16, 2018 2:03 pm
No new posts VSAM dataset not found abdulrafi JCL & VSAM 5 Fri Jan 12, 2018 11:19 am
No new posts SORT BUT RETAIN HIGHEST VALUE ON NON-... leondan22 DFSORT/ICETOOL 2 Thu Dec 14, 2017 8:13 pm
No new posts ISSUE IN copying Sequential file reco... thesumitk JCL & VSAM 2 Wed Dec 13, 2017 3:07 pm
No new posts File Tailoring -- Temporary dataset i... samzee71 CLIST & REXX 3 Fri Dec 01, 2017 3:12 am

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