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
 
Removing spaces in syncsort

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> JCL & VSAM
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    Post subject: Removing spaces in syncsort
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

Moderator Team Head


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

PostPosted: Sat Jan 17, 2009 3:31 am    Post subject: Reply to: Removing spaces in syncsort
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    IBMMAINFRAMES.com Support Forums -> JCL & VSAM All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Split 1 file into 10 output Files - S... Prasanth Kumar SYNCSORT 5 Sat Sep 16, 2017 12:02 am
No new posts Remove leading spaces from numeric field rexx77 SYNCSORT 6 Wed Sep 06, 2017 2:15 am
No new posts Count Trailing Spaces in variable str... Virendra Shambharkar SYNCSORT 10 Thu Feb 02, 2017 12:23 pm
No new posts SYNCSORT SEQNUM and FI fields. nartcr SYNCSORT 7 Sat Jan 21, 2017 4:02 am
No new posts Syncsort Help to group fields sudhakarraju SYNCSORT 6 Thu Dec 29, 2016 1:38 am

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