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

Align the data with SYNCSORT


IBM Mainframe Forums -> JCL & VSAM
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
NAGARJUN CARALAPATI

New User


Joined: 09 Oct 2007
Posts: 22
Location: chennai.India

PostPosted: Tue Oct 09, 2007 6:47 pm
Reply with quote

I want to align the data present in the input as output.

Find my data details below.

Code:
                 
  ASDF ASDFS COPY SDFSGWER         
  ASDF COPY SDFSGWSD               
  ASDF COPY SDFSGWAC               
  COPY SDFSGWSE                   
  SDFSSDF COPY SDFSGWSD           
  SDF COPY SDFSGWAR               


My desired output:

Code:

SDFSGWER
SDFSGWSD
SDFSGWAC
SDFSGWSE
SDFSGWSD
SDFSGWAR
Back to top
View user's profile Send private message
Frank Yaeger

DFSORT Developer


Joined: 15 Feb 2005
Posts: 7129
Location: San Jose, CA

PostPosted: Tue Oct 09, 2007 8:59 pm
Reply with quote

If you happen to have access to DFSORT, you can use the following DFSORT job to do what you asked for:

Code:

//S1    EXEC  PGM=ICEMAN
//SYSOUT    DD  SYSOUT=*
//SORTIN DD DSN=...  input file
//SORTOUT DD DSN=...  output file
//SYSIN    DD    *
  OPTION COPY
  INREC PARSE=(%01=(STARTAFT=C'COPY ',FIXLEN=8)),
    BUILD=(%01)
/*
Back to top
View user's profile Send private message
CICS Guy

Senior Member


Joined: 18 Jul 2007
Posts: 2146
Location: At my coffee table

PostPosted: Tue Oct 09, 2007 9:00 pm
Reply with quote

You will have to explain the "rules" for the conversion a little better...
The CHANGE subparameter might be what you need.
Back to top
View user's profile Send private message
Anuj Dhawan

Superior Member


Joined: 22 Apr 2006
Posts: 6250
Location: Mumbai, India

PostPosted: Wed Oct 10, 2007 10:51 am
Reply with quote

I think, Franks' solution will not work for TS requirement. PARSE is not available in SyncSort (I tried to use it some time back, didn't work for me).
Back to top
View user's profile Send private message
Aaru

Senior Member


Joined: 03 Jul 2007
Posts: 1287
Location: Chennai, India

PostPosted: Wed Oct 10, 2007 11:46 am
Reply with quote

Anuj,

Quote:
think, Franks' solution will not work for TS requirement


What is TS and why do u think so? Frank had posted a DFSORT job.

Quote:
PARSE is not available in SyncSort (I tried to use it some time back, didn't work for me).


A similar topic involviing PARSE/SYNCSORT was discussed few days ago.

http://ibmmainframes.com/viewtopic.php?t=24948
Back to top
View user's profile Send private message
Anuj Dhawan

Superior Member


Joined: 22 Apr 2006
Posts: 6250
Location: Mumbai, India

PostPosted: Wed Oct 10, 2007 2:49 pm
Reply with quote

Yeah ..I'm aware of that thread. My motive was to make the TS aware about the gist of that thread, as subject line asks about SyncSort. I might have used
Quote:
I think, Franks' solution may/may not not work for TS requirement, if his/her shop uses SyncSort

then it would been be rather clear.
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 -> JCL & VSAM

 


Similar Topics
Topic Forum Replies
No new posts How to save SYSLOG as text data via P... All Other Mainframe Topics 4
No new posts Store the data for fixed length COBOL Programming 1
No new posts Compare only first records of the fil... SYNCSORT 7
No new posts Data set Rec-Cnt and Byte-Cnt Testing & Performance 2
No new posts SCOPE PENDING option -check data DB2 2
Search our Forums:

Back to Top