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
 
ALTSEQ replacing numeric charcter to some special characters

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DFSORT/ICETOOL
View previous topic :: :: View next topic  
Author Message
ponam.jkjain

New User


Joined: 24 Nov 2007
Posts: 2
Location: Mumbai

PostPosted: Wed Mar 24, 2010 9:18 am    Post subject: ALTSEQ replacing numeric charcter to some special characters
Reply with quote

Hi,

I have a file of length 400 in which I have to replace all comma ',' with space ' '.
I am using below control. This control is replacing comma with space but also replacing all numeric fields to some special characters.

Code:

   SORT FIELDS=COPY                     
   ALTSEQ CODE=(6B40)                     
   OUTREC BUILD=(1,400,TRAN=ALTSEQ)   
   OUTFIL FNAMES=SORTO01               


Please guide me to avoid the unwanted conversion.

Input
Code:
0501OGC-MFG,MKTG,DLR RELS, ENV     
1580TALENT MANAGEMENT & DIVERSITY   
1540ELECTRONIC SALES INFO.         
0520PATENT OFFICE                   
0530WARRANTY LITIGATION             
1758ITM S.H.A.P. OPERATIONS         
0532GENERAL  LITIGATION             
0501OGC-MFG,MKTG,DLR RELS, ENV     


Input in hex
Code:

      1723ITM SALES OPERATIONS SYSTEMS   
    44FFFFCED4ECDCE4DDCDCECDDE4EEEECDE444
    0017239340213520675913965202823542000
--------------------------------------
      0501OGC-MFG,MKTG,DLR RELS, ENV     
    44FFFFDCC6DCC6DDEC6CDD4DCDE64CDE44444
    0005016730467B4237B43909532B055500000
--------------------------------------
      1580TALENT MANAGEMENT & DIVERSITY 
    44FFFFECDCDE4DCDCCCDCDE454CCECDECEE44
    0015803135530415175455300049559293800
--------------------------------------
      1540ELECTRONIC SALES INFO.         
    44FFFFCDCCEDDDCC4ECDCE4CDCD4444444444
    001540535339659302135209566B000000000

Output

Code:
^§^£OGC-MFG MKTG DLR RELS  ENV     
£§½^TALENT MANAGEMENT & DIVERSITY 
£§©^ELECTRONIC SALES INFO.         
^§¥^PATENT OFFICE                 
^§·^WARRANTY LITIGATION           
£¼§½ITM S.H.A.P. OPERATIONS       
^§·¥GENERAL  LITIGATION           
^§^£OGC-MFG MKTG DLR RELS  ENV 


Output in hex

Code:
^§^£OGC-MFG MKTG DLR RELS  ENV     
BBBBDCC6DCC4DDEC4CDD4DCDE44CDE44444
05016730467042370439095320055500000
-----------------------------------
£§½^TALENT MANAGEMENT & DIVERSITY 
BBBBECDCDE4DCDCCCDCDE454CCECDECEE44
15803135530415175455300049559293800
-----------------------------------
£§©^ELECTRONIC SALES INFO.         
BBBBCDCCEDDDCC4ECDCE4CDCD4444444444
1540535339659302135209566B000000000
-----------------------------------
^§¥^PATENT OFFICE                 
BBBBDCECDE4DCCCCC444444444444444444
05207135530666935000000000000000000
Back to top
View user's profile Send private message

dick scherrer

Site Director


Joined: 23 Nov 2006
Posts: 19270
Location: Inside the Matrix

PostPosted: Wed Mar 24, 2010 9:46 am    Post subject:
Reply with quote

Hello,

It will help if you post the complete jcl and control statements along with all of the informational messages (including the messgae ids) generated by the run.

When posting data it is best to have the same records included throughout. . .

In the output data the first 4 bytes appear to be VB length info rather than "your" data.

Also note, that your data has been "Code"ed which improves readability and preserves alignment.
Back to top
View user's profile Send private message
guptae

Moderator


Joined: 14 Oct 2005
Posts: 1187
Location: Bangalore,India

PostPosted: Wed Mar 24, 2010 12:11 pm    Post subject:
Reply with quote

Hello Poonam,

You code looks ok to me . It Should replaced all the comma's with Space.
Please provide full jcl with input & output .
Back to top
View user's profile Send private message
Frank Yaeger

DFSORT Moderator


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

PostPosted: Wed Mar 24, 2010 10:22 pm    Post subject:
Reply with quote

Ponam,

The DFSORT control statements you show would NOT do what you say it does. When I run those DFSORT control statements with your input, I get the following for output:

Code:

0501OGC-MFG MKTG DLR RELS  ENV             
1580TALENT MANAGEMENT & DIVERSITY         
1540ELECTRONIC SALES INFO.                 
0520PATENT OFFICE                         
0530WARRANTY LITIGATION                   
1758ITM S.H.A.P. OPERATIONS               
0532GENERAL  LITIGATION                   
0501OGC-MFG MKTG DLR RELS  ENV             


So either you're not doing what you show or you're not showing something you're doing.

Please show your complete JES log.
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 -> DFSORT/ICETOOL All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts line 52: Name or string > 250 char... Ashishpanpaliya CLIST & REXX 5 Sat Oct 14, 2017 2:29 am
No new posts File Aid tool to compare numeric data balaji81_k Compuware & Other Tools 2 Tue Sep 26, 2017 3:35 am
No new posts Binary to display characters Roy Ware SYNCSORT 3 Tue Sep 19, 2017 8:46 pm
No new posts Remove leading spaces from numeric field rexx77 SYNCSORT 6 Wed Sep 06, 2017 2:15 am
No new posts Return a Non Numeric value from REXX Learncoholic CLIST & REXX 3 Fri Sep 01, 2017 8:33 pm

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