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

Removing spaces in syncsort


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

New User


Joined: 14 Jul 2006
Posts: 14
Location: Dallas, Texas

PostPosted: Sat Jan 17, 2009 3:24 am
Reply with quote

Question...

I have an input file (TESTFILE.ALL.G0001V00). Is there a way to remove the spaces using syncsort from positions 07:7,63
Code:

DEL 'TEST0112.FILE                      '
DEL 'TEST02334.FILE                    '
DEL 'TEST055677.FILE                  '
DEL 'TEST04.FILE                         '
DEL 'TEST0345.FILE                     '


Here's the desired output
Code:

DEL 'TEST0112.FILE'
DEL 'TEST02334.FILE'
DEL 'TEST055677.FILE'
DEL 'TEST04.FILE'
DEL 'TEST0345.FILE'


Code:

//JS010    EXEC PGM=SORT                       
//SORTIN   DD   DSN=&&LISTCA3,                 
//         DISP=(OLD,PASS,DELETE)             
//SYSIN    DD   *                             
 OPTION COPY                                   
 OUTREC FIELDS=(01:1,6,                       
                07:7,63,                       
                CHANGE=(1,C' ',C''),           
                NOMATCH=(7,63))               
//SORTOUT  DD   DSN=TEST.LISTING,           
//         DISP=(NEW,CATLG,DELETE),           
//         SPACE=(CYL,(2,1),RLSE),             
//         DCB=(RECFM=FB,LRECL=80,BLKSIZE=0)   
//OUTFIL01 DD   SYSOUT=*                       
//SYSUDUMP DD   SYSOUT=*                       
//SORTMSG  DD   SYSOUT=*                       
//SYSOUT   DD   SYSOUT=*
Back to top
View user's profile Send private message
superk

Global Moderator


Joined: 26 Apr 2004
Posts: 4652
Location: Raleigh, NC, USA

PostPosted: Sat Jan 17, 2009 3:31 am
Reply with quote

This is a response from Alissa on another similar topic:

raak wrote:
Is there any command in SYNCSORT which corresponds to the SQZ command in DFsort??

SyncSort for z/OS 1.3 supports the SQZ function.
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 Compare only first records of the fil... SYNCSORT 7
No new posts leading spaces can be removed in trai... DFSORT/ICETOOL 1
No new posts Cobol program with sequence number ra... COBOL Programming 5
No new posts To Remove spaces (which is in hex for... JCL & VSAM 10
No new posts How to remove spaces in between. SYNCSORT 12
Search our Forums:

Back to Top