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
 
Overlaying specific characters using SYNCSORT

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> JCL & VSAM
View previous topic :: :: View next topic  
Author Message
raam_kumar

New User


Joined: 25 Apr 2007
Posts: 44
Location: chennai, India

PostPosted: Fri May 25, 2007 10:04 am    Post subject: Overlaying specific characters using SYNCSORT
Reply with quote

Hi
I have the following requirement

Input:

100B1 20
100B1F20
100B1 20
100B1 20
100B1F20
100B2 30
200B1G10
300B2 10
300B2H10
300B2 10
300B2 10
..
..
..
Output:

100B1F20
100B1F20
100B1F20
100B1F20
100B1F20
100B2F30
200B1G10
300B2H10
300B2H10
300B2H10
300B2H10
..
..
Can this be achieved using SYNCSORT?
Back to top
View user's profile Send private message

murmohk1

Senior Member


Joined: 29 Jun 2006
Posts: 1439
Location: Bangalore,India

PostPosted: Fri May 25, 2007 10:20 am    Post subject:
Reply with quote

Raam,

Elobrate your requirement as your example doesn't convey anything (except change in few records with value F or G or H).
Back to top
View user's profile Send private message
raam_kumar

New User


Joined: 25 Apr 2007
Posts: 44
Location: chennai, India

PostPosted: Fri May 25, 2007 10:34 am    Post subject:
Reply with quote

Hi
I have to compare position's 1-3 and 6. The input file will contain different values in position's 1-3. each value at position 1-3 will contain either a alphabet or spaces at position 6. (the alphabet is constant for that particular value). I have to replace the spaces with that alphabet .

For Eg: if value of Pos 1-3 is 100. it may contain either 'F' or spaces at position 6. The requirement is i have to replace all the spaces at position 6 for value 100 by 'F'
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: Sat May 26, 2007 4:28 am    Post subject:
Reply with quote

Hello,

You might consider ignoring the spaces.

If i understand, when pos 1-3 is 100, pos 6 must always become an F - if 200 pos 6 must always become a G - and so on.

If you only check for the 100, 200, etc and move the appropriate letter, you should get the desired result.

Again, this is only true if i understand the requirement.
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 line 52: Name or string > 250 char... Ashishpanpaliya CLIST & REXX 5 Sat Oct 14, 2017 2:29 am
No new posts How to insert a value on specific pos... Poha Eater DFSORT/ICETOOL 9 Sun Oct 01, 2017 3:04 am
No new posts Binary to display characters Roy Ware SYNCSORT 3 Tue Sep 19, 2017 8:46 pm
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 How to write Specific Fields from Mul... Padhu SYNCSORT 6 Thu Jul 06, 2017 10:26 am

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