Page 1 of 1

Remove comma separator from data and left justify

PostPosted: Wed Mar 28, 2012 6:43 pm
by trilochan_p
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

Re: Remove comma separator from data and left justify

PostPosted: Wed Mar 28, 2012 9:07 pm
by enrico-sorichetti
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 ;)

Re: Remove comma separator from data and left justify

PostPosted: Thu Mar 29, 2012 12:21 am
by dick scherrer
Hello,

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

To uise the newer features, you system needs to be updated. . .

Re: Remove comma separator from data and left justify

PostPosted: Mon Oct 15, 2012 5:15 am
by c62ap90
This may work:

//SYSIN    DD *                           
   OPTION COPY                           
   INREC FIELDS=(1,133,TRAN=ALTSEQ)       
   ALTSEQ CODE=(6B40)                     
   OUTREC BUILD=(1,133,SQZ=(SHIFT=LEFT)) 

Re: Remove comma separator from data and left justify

PostPosted: Mon Oct 15, 2012 7:50 am
by dick scherrer
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