View previous topic :: View next topic
|
Author |
Message |
atulbagewadikar
New User
Joined: 15 Jun 2006 Posts: 26
|
|
|
|
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 |
|
|
Ralph Zbrog
New User
Joined: 21 Nov 2009 Posts: 58 Location: California
|
|
|
|
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 |
|
|
|