RE: DB2 Field Encryption

["Walden H. Leverich" <WaldenL@xxxxxxxxxxxxxxx>]

Do you need ever get back the unencrypted value? Something like a
password you don't need the plaintext again, you just need to encrypt
the password they supply and compare to the original encrypted value.

Either way, check Scott's page:
http://www.scottklement.com/rpg/cipher/index.html

-Walden 


------------
Walden H Leverich III
President & CEO
Tech Software
(516) 627-3800 x11
WaldenL@xxxxxxxxxxxxxxx
http://www.TechSoftInc.com 

Quiquid latine dictum sit altum viditur.
(Whatever is said in Latin seems profound.)
 
-----Original Message-----
From: rpg400-l-bounces@xxxxxxxxxxxx
[mailto:rpg400-l-bounces@xxxxxxxxxxxx] On Behalf Of Burke, Joel
Sent: Monday, July 12, 2004 2:32 PM
To: 'RPG400-L@xxxxxxxxxxxx'
Subject: DB2 Field Encryption

Can anybody recommend a method for encrypting a field in DB2?  We do not
want users to be able to view this field through query or by any other
means
unless we specifically allow them.

Currently, the field is numeric but can be converted to alpha if the
encryption method requires it.

Thanks for your help.

Joel Burke
Marywood University
--
This is the RPG programming on the AS400 / iSeries (RPG400-L) mailing
list
To post a message email: RPG400-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/rpg400-l.