Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

Scrubbing the output file for names and addresses

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

New User


Joined: 25 Mar 2008
Posts: 3
Location: Hyderabad, India

PostPosted: Tue Oct 15, 2013 9:51 pm    Post subject: Scrubbing the output file for names and addresses
Reply with quote

I have a file in which there is client name and Address. I would like to change name and addresses to something that is un recognizable. I would like sort to be used when the record has "Social Security" on it, at position 186. The data looks as below.

Code:
               First Name starts at 220 column
                                    \/
Y                                                               
                                                             
DTarget Date - 2005            100%                         
TTotal                         100%                         
Y..............................                             
Social Security Number:XXX-XX-XXXX FIRST NAME1            LAST NAME 2
                                                             
Y                                                           
                                                             
DTarget Date - 2010            100%                         
TTotal                         100%                         
Y..............................                             
Social Security Number:XXX-XX-XXXX FIRST NAME2            LAST NAME 2
                                                       


I have seen ALTSEQ and IFTHEN but not sure how to use those in this case. Any help would be much appreciated.
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: Tue Oct 15, 2013 10:02 pm    Post subject:
Reply with quote

Hello and welcome to the forum,

Your topic is about names & addresses but you don't show them. . .

What you want to do will probably not be done with ALTSEQ or IFTHEN. . .

How big is the dataset you want to "scrub"? How many different names & addresses?

This has been asked before and there should be some topics in the forum.
Back to top
View user's profile Send private message
Bill Woodger

DFSORT Moderator


Joined: 09 Mar 2011
Posts: 7223

PostPosted: Tue Oct 15, 2013 10:03 pm    Post subject: Reply to: Scrubbing the output file for names and addresses
Reply with quote

You identify the lines to change with IFTHEN. You blat the name and address. How you want to blat them, you haven't said. Remember, if it is reversible, it is no use at all. Why are you not treating the SSN in the same way?
Back to top
View user's profile Send private message
sundeepthota

New User


Joined: 25 Mar 2008
Posts: 3
Location: Hyderabad, India

PostPosted: Tue Oct 15, 2013 11:22 pm    Post subject: Scrubbing the output file for names and addresses
Reply with quote

The name and address are on the same line one after the other.

The file has close to 3 million records overall its a VB file.

I need to scrub SSN, Name and Address file so that the Name is not recognizable. I need to do the same with SSN and adress as well, but figured that if someone can give me a solution for Name, i can extrapolate that to other fields. I dont have to trace it back.

I am wondering if the below code might work.

Code:
SORT FIELDS=COPY                         
ALTSEQ CODE=(C1E9,D3E9)                 
INREC IFTHEN=(WHEN=(186,6,CH,EQ,C'SOCIAL'),
BUILD=(1,219,220,30,TRAN=ALTSEQ,250,30))   
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: Tue Oct 15, 2013 11:37 pm    Post subject:
Reply with quote

Hello,

Quote:
The file has close to 3 million records overall its a VB file.
Which is why i believe IFTHEN will not work for you. . .

Quote:
I am wondering if the below code might work.
I do not believe the code will do what you want.

Please explain just how much you want the name scrambled. Show a few sample names and how you want them to be after your process.
Back to top
View user's profile Send private message
sundeepthota

New User


Joined: 25 Mar 2008
Posts: 3
Location: Hyderabad, India

PostPosted: Wed Oct 16, 2013 12:37 am    Post subject: Scrubbing the output file for names
Reply with quote

Hello,

Thanks for your response
I am good with scrambling the name few characters. i.e
Replacing A with Z
Replacing E with Y
Replacing I with X
Replacing O with V

Sandy Marcelas - > Szndy Mzrcylzs
Ingrid bergman - > XngrXd ByrgmzN

Can you help me out on this?
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 Oct 16, 2013 1:45 am    Post subject:
Reply with quote

Hello,

If that little amount of scrambling is acceptable, the ALTSEQ might suffice. Your people understand that all of the names will be easily readable this way. . .

What about addresses and social security numbers?

Will there be data from other sources that need to "match" with these jumbled values?
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 Add PD field from 2nd file to PD in 1st Sushant Garje DFSORT/ICETOOL 6 Thu Dec 01, 2016 4:32 pm
No new posts File Aid to File Manager conversion murali3955 IBM Tools 4 Thu Nov 24, 2016 3:41 pm
No new posts How to convert the VBM file to VB or... Sulabh Agrawal JCL & VSAM 4 Fri Nov 18, 2016 1:04 pm
No new posts CICS Roll back partially - Need to re... dwijadas CICS 4 Wed Nov 16, 2016 4:30 pm
No new posts Problem in writing Output file vickey_dw COBOL Programming 5 Mon Nov 14, 2016 11:14 pm


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us