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
 
Replace last name by first name

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

Active User


Joined: 20 May 2010
Posts: 121
Location: canada

PostPosted: Thu Mar 15, 2018 3:43 pm    Post subject: Replace last name by first name
Reply with quote

Hello,
I have file with users Last name ( position 1-10) First name ( position 11-21)
and second file, where in field positions 40 - 200 may be user Last name in any of this field position. Could you please give me idea to create output file where Last name from second file changed to the user first name. Output file should have only records from second file that was changed.
Back to top
View user's profile Send private message

sergeyken

Active User


Joined: 29 Apr 2008
Posts: 388
Location: Maryland

PostPosted: Thu Mar 15, 2018 7:43 pm    Post subject:
Reply with quote

Try to do something YOURSELF, then ask here for any advice.

This forum is not supposed to MAKE YOUR JOB instead of you.
Back to top
View user's profile Send private message
sergeyken

Active User


Joined: 29 Apr 2008
Posts: 388
Location: Maryland

PostPosted: Thu Mar 15, 2018 7:52 pm    Post subject: Re: Replace last name by first name
Reply with quote

anatol wrote:
Could you please give me idea to create output file where Last name from second file changed to the user first name.

The idea is, using the parameters PARSE=, and BUILD=
Another thing is - using SS to perform string comparison within varying positions.
Back to top
View user's profile Send private message
enrico-sorichetti

Senior Member


Joined: 14 Mar 2007
Posts: 10545
Location: italy

PostPosted: Thu Mar 15, 2018 9:48 pm    Post subject: Reply to: Replace last name by first name
Reply with quote

changing data in some dataset based on the content of another dataset
can be done easily enough with a JOINKEY operation

but JOINKEY needs the keys in a fixed position
since one of the keys is not in a FIXED position, the approach is impossible
Back to top
View user's profile Send private message
anatol

Active User


Joined: 20 May 2010
Posts: 121
Location: canada

PostPosted: Thu Mar 15, 2018 9:59 pm    Post subject: Reply to: Replace last name by first name
Reply with quote

Thank you all.
Back to top
View user's profile Send private message
Rohit Umarjikar

Senior Member


Joined: 21 Sep 2010
Posts: 2064
Location: NY,USA

PostPosted: Thu Mar 15, 2018 11:38 pm    Post subject:
Reply with quote

You haven't told us clearly at first place as to what exactly is expected with sample data.
Do you need to match two DS and if last name from second ds= first name from first ds then write else skip?
Back to top
View user's profile Send private message
enrico-sorichetti

Senior Member


Joined: 14 Mar 2007
Posts: 10545
Location: italy

PostPosted: Fri Mar 16, 2018 1:39 am    Post subject: Reply to: Replace last name by first name
Reply with quote

no need for any detailed description of the data

Quote:
... where in field positions 40 - 200 may be user Last name in any of this field position. ...



that' s the show stopper for a joinkey solution
Back to top
View user's profile Send private message
sergeyken

Active User


Joined: 29 Apr 2008
Posts: 388
Location: Maryland

PostPosted: Fri Mar 16, 2018 2:13 am    Post subject: Re: Reply to: Replace last name by first name
Reply with quote

enrico-sorichetti wrote:
but JOINKEY needs the keys in a fixed position
since one of the keys is not in a FIXED position, the approach is impossible

Using PARSE=, and BUILD= before JOINKEYS may help with this approach, too.
Also other approaches are available.
Back to top
View user's profile Send private message
enrico-sorichetti

Senior Member


Joined: 14 Mar 2007
Posts: 10545
Location: italy

PostPosted: Fri Mar 16, 2018 2:40 am    Post subject: Reply to: Replace last name by first name
Reply with quote

parse on what ?
Back to top
View user's profile Send private message
sergeyken

Active User


Joined: 29 Apr 2008
Posts: 388
Location: Maryland

PostPosted: Fri Mar 16, 2018 9:30 pm    Post subject: Re: Reply to: Replace last name by first name
Reply with quote

enrico-sorichetti wrote:
parse on what ?

in field positions 40 - 200, using INREC for one of joined files before joining them
Back to top
View user's profile Send private message
anatol

Active User


Joined: 20 May 2010
Posts: 121
Location: canada

PostPosted: Fri Mar 16, 2018 10:58 pm    Post subject: Reply to: Replace last name by first name
Reply with quote

I've went other way ... from file1 ( Lastname Firstname) I've generated sort statements with FINDREP .... lastname to firstname name using
sqz, left, lead, trail,mid...
then for file2 I use those statements
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 Silly question maybe - REPLACE member... Cloink TSO/ISPF 15 Thu Oct 25, 2018 6:38 pm
No new posts Replace comp-3 field value to comp-3 ... dharmaraok DFSORT/ICETOOL 5 Fri Sep 14, 2018 3:46 pm
No new posts USS: Find and replace string within a... vasanthz All Other Mainframe Topics 5 Thu Aug 02, 2018 4:01 am
No new posts Find & Replace string in CA-SORT mrgnndhmk CA Products 1 Fri Mar 30, 2018 12:58 am
No new posts help to replace columns by rows Vikas Maharnawar DFSORT/ICETOOL 8 Tue Mar 06, 2018 3:27 pm

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