OK now that I have graduated from iseries SQL encryption 101 (OK the first hour of class anyways):

Is it possible to encrypt a 10 byte character field in place? (Lets assume it was created with FOR BIT DATA).

For example,

TaxFile contains 9 digit SSN.

Is it possible in SQL to:

update TaxFile set SSN=Encrypt_RC2(SSN) to provide an encrypted SSN?

It doesn't seem possible since the receiving field is larger than the source field.

Any ideas or other methods that can encrypt a field in place (without expansion)?

It doesn't seem theoretically impossible (although maybe less secure).

This outbound email has been scanned for all viruses by the MessageLabs Skyscan service.
For more information please visit http://www.symanteccloud.com

This thread ...


Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2019 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].