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: 118
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: 309
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: 309
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: 10478
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: 118
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: 1904
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: 10478
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: 309
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: 10478
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: 309
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: 118
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 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
No new posts How to replace the below query? pkmurali DB2 12 Tue Feb 27, 2018 9:51 pm
No new posts Do we have any Modern tools to replac... NajeebKR Compuware & Other Tools 4 Sat Jan 27, 2018 1:22 pm
No new posts Fileaid Update Replace with null string descann Compuware & Other Tools 4 Mon May 15, 2017 3:00 pm

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