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
 

 

Adabas Masking Capability

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> Java & MQSeries
View previous topic :: :: View next topic  
Author Message
atulbagewadikar

New User


Joined: 15 Jun 2006
Posts: 26

PostPosted: Tue May 18, 2010 1:12 pm    Post subject: Adabas Masking Capability
Reply with quote

Hi All,

We unload/load Adabas files using ADAULD/ADALOD utilities. During this process is ADABAS capable of masking a particular field for all records?

e.g.
1. Unload EMPLOYEE file from production
2. Mask employee_no field (e.g. 12345 to 1XXX5), all the records with some masking criteria
3. Update and load EMPLOYEE file with new file number to QA

Curious if ADABAS supports this or any clause available with any ADABAS utility.

Your views are welcome!
Back to top
View user's profile Send private message

Ralph Zbrog

New User


Joined: 21 Nov 2009
Posts: 58
Location: California

PostPosted: Tue May 18, 2010 9:22 pm    Post subject: Reply to: Adabas Masking Capability
Reply with quote

ADACMP's FORMAT cards could be used to insert a constant, but this wouldn't give you the flexibility that you need. To keep the process entirely within Adabas, look at the user exits. To code in Natural, consider stored procedures. Or decompress the file and write a Natural program to hash the data fields.
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 -> Java & MQSeries All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Release of Adabas Cursor mohitsethi All Other Mainframe Topics 1 Mon Feb 06, 2017 8:36 pm
This topic is locked: you cannot edit posts or make replies. Natural ADABAS Opening with CTS enikhilk Mainframe Jobs 0 Wed Nov 30, 2016 5:37 pm
No new posts Masking Db2 data kishpra DB2 3 Fri Sep 02, 2016 9:23 pm
No new posts Casting a Binary Number to Numeric in... Bob Steinkraus Java & MQSeries 6 Tue Aug 09, 2016 5:58 pm
No new posts How Adabas works in Mainframe ranujn Java & MQSeries 5 Sat Jun 04, 2016 11:20 am


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