Guyz,
I need to encrypt the data coming from source(Database table) and load in to another Database table. The data is 'SSN'.The source has all the 9 digits displayed.The transformation is, I need to mask the first 5 digits and display the last four only....any advices.......
Thanks,
Encrypt Data
Moderators: chulett, rschirm, roy
Re: Encrypt Data
Unless you decide to write Basic code for AES, DES or the like, I would suggest you look at the possibility of calling these written as functions in languages like C/C++. You should find FIP compliant codes for the same in different languages. However, I don't know if they still have certain rules on some cryptographic codes if they are to be used outside of the USA.
gateleys
Mask <> encrypt. If all you need to do is mask the first five digits so it looks something like this:
***-**-1234
Then just substring off the last four digits and concatenate that with the 'mask' for the first 5. Just don't expect to be able to 'unmask' it later.
***-**-1234
Then just substring off the last four digits and concatenate that with the 'mask' for the first 5. Just don't expect to be able to 'unmask' it later.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
You can easily mask with the Fmt() function.
Code: Select all
Fmt(InLink.SSN, "9R***-**-####")
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
You can easily mask with the Fmt() function.
Code: Select all
Fmt(InLink.SSN, "9R***-**-####")
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
-
- Participant
- Posts: 76
- Joined: Wed Jan 25, 2006 6:42 pm