Remove comma separator from data and left justify



Support for NetApp SyncSort for z/OS, Visual SyncSort, SYNCINIT, SYNCLIST and SYNCTOOL

Remove comma separator from data and left justify

Postby trilochan_p » Wed Mar 28, 2012 6:43 pm

Hi,
Input file having FB 133 byte and i wants to delete comma from any position and do the left allignment.
For Ex: In the input file, if value is (10,164.44-) then out put should come as 10164.44-, means comma to be delete and squeeze to left allignment.

I have tried this code but getting syntax error, If i use only INREC syntax then it is working fine as replacing space (10 164.44-) but i wants to squeeze this part. please help me on this.

//SORTSTEP EXEC PGM=SORT
.
.
//SYSIN DD *                                 
 OPTION COPY                                 
 ALTSEQ CODE=(6B40)                         
 INREC FIELDS=(1,133,TRAN=ALTSEQ)           
 OUTREC OVERLAY=(1,133,SQZ=(SHIFT=LEFT))     
//                                           


Error:
SYSIN :                                       
 OPTION COPY                                 
 ALTSEQ CODE=(6B40)                           
 INREC FIELDS=(1,133,TRAN=ALTSEQ)             
 OUTREC OVERLAY=(1,133,SQZ=(SHIFT=LEFT))     
                                         *                     
WER268A  OUTREC STATEMENT  : SYNTAX ERROR     
WER211B  SYNCSMF  CALLED BY SYNCSORT; RC=0000
WER449I  SYNCSORT GLOBAL DSM SUBSYSTEM ACTIVE



I am using SyncSort For z/OS 1.2.1

Code'd
trilochan_p
 
Posts: 15
Joined: Tue Dec 06, 2011 2:37 pm
Has thanked: 0 time
Been thanked: 0 time

Re: Remove comma separator from data and left justify

Postby enrico-sorichetti » Wed Mar 28, 2012 9:07 pm

I am using SyncSort For z/OS 1.2.1

since You are aware that You are using SYNCSORT...
why in heaven did You post in the IBM DFSORT/ICETOOL/... section of the forum

most of the answers here are provided by DFSORT developers,
so it is improper to expect a reply on a question dealing with a competitor product.

a Moderator is kindly asked to move the topic where it belongs ;)
cheers
enrico
When I tell somebody to RTFM or STFW I usually have the page open in another tab/window of my browser,
so that I am sure that the information requested can be reached with a very small effort
enrico-sorichetti
Global moderator
 
Posts: 2994
Joined: Fri Apr 18, 2008 11:25 pm
Has thanked: 0 time
Been thanked: 164 times

Re: Remove comma separator from data and left justify

Postby dick scherrer » Thu Mar 29, 2012 12:21 am

Hello,

The release of Syncsort you are using is quite out of date.

To uise the newer features, you system needs to be updated. . .
Hope this helps,
d.sch.
User avatar
dick scherrer
Global moderator
 
Posts: 6268
Joined: Sat Jun 09, 2007 8:58 am
Has thanked: 3 times
Been thanked: 93 times

Re: Remove comma separator from data and left justify

Postby c62ap90 » Mon Oct 15, 2012 5:15 am

This may work:

//SYSIN    DD *                           
   OPTION COPY                           
   INREC FIELDS=(1,133,TRAN=ALTSEQ)       
   ALTSEQ CODE=(6B40)                     
   OUTREC BUILD=(1,133,SQZ=(SHIFT=LEFT)) 
c62ap90
 
Posts: 125
Joined: Thu Oct 11, 2012 10:24 pm
Has thanked: 1 time
Been thanked: 7 times

Re: Remove comma separator from data and left justify

Postby dick scherrer » Mon Oct 15, 2012 7:50 am

Hello,

You simply MUST start reading the topics before you reply . . .

You paid NO attention to the fact the release of Syncsort being used is Very old and many of the new features are not valid.

Next time, we just quietly delete :|

d
Hope this helps,
d.sch.
User avatar
dick scherrer
Global moderator
 
Posts: 6268
Joined: Sat Jun 09, 2007 8:58 am
Has thanked: 3 times
Been thanked: 93 times


Return to Syncsort/Synctool

 


  • Related topics
    Replies
    Views
    Last post