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 Profile Log in to check your private messages Log in
 
How to change numeric to character after only a specific wrd

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> COBOL Programming
View previous topic :: :: View next topic  
Author Message
ssprabhu

New User


Joined: 25 Apr 2005
Posts: 67
Location: pune

PostPosted: Thu Aug 21, 2008 3:08 pm    Post subject: How to change numeric to character after only a specific wrd
Reply with quote

Hi,

customer opted for e-account account no: 123456 cust-id : 22222 and
opted on 13/08/08 at 12:13.

customer opted for e-account opted on 13/08/08 at 12:13, Account no: 123456 cust-id : 22222 and


I want to change this above stmt as's below..

customer opted for e-account account no: XXXXXX cust-id : XXXXXX and
opted on 13/08/08 at 12:13.

customer opted for e-account opted on 13/08/08 at 12:13, Acc no: XXXXXX cusid : XXXXXX

But this text is nott constant the account no and cust-id details can appear at any place in the sentence ..so what all i need todo is i have to sweep all the text in the database and to find is there any accout details or cust-id details in the text then i have to replace the next 6 bytes as "X"

Is there any cobol statement available for this or any least and efficient method can u please suggest ??
Back to top
View user's profile Send private message

Aaru

Senior Member


Joined: 03 Jul 2007
Posts: 1288
Location: Chennai, India

PostPosted: Thu Aug 21, 2008 3:19 pm    Post subject: Reply to: How to change numeric to character after only a sp
Reply with quote

ssprabhu,

Quote:
or any least and efficient method can u please suggest ??


I would probably go for REXX as the customer ID value is not a constant and is not in a specific position.

If you know rexx, read the file, check for account no: and cust id: Acc no: cusid : and then overlay the data XXXXXX.
Back to top
View user's profile Send private message
ssprabhu

New User


Joined: 25 Apr 2005
Posts: 67
Location: pune

PostPosted: Thu Aug 21, 2008 4:00 pm    Post subject:
Reply with quote

AAru yes but...u know we need to sweep millions of customers and their text ..we hae to keep restart both internal and external tahtz not possible in REXX so we heve to do it in cobol...
Back to top
View user's profile Send private message
ssprabhu

New User


Joined: 25 Apr 2005
Posts: 67
Location: pune

PostPosted: Thu Aug 21, 2008 6:46 pm    Post subject:
Reply with quote

Experts view please...
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: Thu Aug 21, 2008 9:12 pm    Post subject:
Reply with quote

ssprabhu,

Since you posted in the DFSORT Forum, I assume a DFSORT solution would be desirable. Right?

If you want to do this in COBOL, why did you post in the DFSORT Forum?

You can use DFSORT's new FINDREP function to do this kind of thing. FINDREP is available with z/OS DFSORT V1R5 PTF UK90013 (July, 2008).
If you clarify what you want, I can show you how to do it:

It isn't clear which keywords you are looking for. Your input and output records have all of these variations:

'account no:'
'cust-id :'
'Account no:'
'Acc no:'
'cusid :'

Please give a complete, accurate list of the keywords you are actually looking for.

Also, the customer ids you show are 5 bytes, but you say you want to replace them with 6 bytes. Are the customer ids really 6 bytes?

A better example of input and output would help.
Back to top
View user's profile Send private message
ssprabhu

New User


Joined: 25 Apr 2005
Posts: 67
Location: pune

PostPosted: Tue Aug 26, 2008 1:27 pm    Post subject:
Reply with quote

Iam sorry Frank Yaeger for postinf tis thread in DF SORT forum..
Back to top
View user's profile Send private message
enrico-sorichetti

Global Moderator


Joined: 14 Mar 2007
Posts: 10308
Location: italy

PostPosted: Tue Aug 26, 2008 2:26 pm    Post subject: Reply to: How to change numeric to character after only a sp
Reply with quote

looks like You are trying to implement some form of data masking ( for sensitive info )

Your organization should define better the long term requirements,
if it is once in a while it might be ok to go for an in house solution,

for continuous use I feel that it would be wiser to go for a full solution product

if You google for "sensitive data masking sanitization" You will find lots of documents and pointers on different ways of doing it
( also some product pointers )
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 -> COBOL Programming All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
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
No new posts How to change a string containing the... chong.zhou TSO/ISPF 6 Tue Aug 29, 2017 4:54 pm
No new posts Select numeric portion from CHAR data... balaji81_k DB2 6 Sat Aug 19, 2017 1:51 am
No new posts change string before sertan string anatol DFSORT/ICETOOL 8 Tue Aug 15, 2017 5:43 pm

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